All Courses for £49
Overview
By enroling in SQL for Data Science, Data Analytics and Data Visualization, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic.
The SQL for Data Science, Data Analytics and Data Visualization course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent SQL for Data Science, Data Analytics and Data Visualization course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our SQL for Data Science, Data Analytics and Data Visualization Program.
So enrol in our SQL for Data Science, Data Analytics and Data Visualization course right away if you’re keen to envision yourself in a rewarding career.
Description
Enroling in this SQL for Data Science, Data Analytics and Data Visualization course can improve your SQL for Data Science, Data Analytics and Data Visualization perspective, regardless of your skill levels in the SQL for Data Science, Data Analytics and Data Visualization topics you want to master. If you’re already a SQL for Data Science, Data Analytics and Data Visualization expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced SQL for Data Science, Data Analytics and Data Visualization insights that will help you make the most of your time. This SQL for Data Science, Data Analytics and Data Visualization course will act as a guide for you if you’ve ever wished to excel at SQL for Data Science, Data Analytics and Data Visualization.
Why Choose Us?
- This course is accredited by the CPD Quality Standards.
- Lifetime access to the whole collection of the learning materials.
- Online test with immediate results.
- Enroling in the course has no additional cost.
- You can study and complete the course at your own pace.
- Study for the course using any internet-connected device, such as a computer, tablet, or mobile device.
Certificate of Achievement
Upon successful completion, you will qualify for the UK and internationally-recognised CPD certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £4.99 and Hardcopy Certificate for £9.99.
Who Is This Course For?
This SQL for Data Science, Data Analytics and Data Visualization course is a great place to start if you’re looking to start a new career in SQL for Data Science, Data Analytics and Data Visualization field. This training is for anyone interested in gaining in-demand SQL for Data Science, Data Analytics and Data Visualization proficiency to help launch a career or their business aptitude.
Requirements
The SQL for Data Science, Data Analytics and Data Visualization course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of SQL for Data Science, Data Analytics and Data Visualization, without any fuss.
Career Path
This SQL for Data Science, Data Analytics and Data Visualization training will assist you develop your SQL for Data Science, Data Analytics and Data Visualization ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a SQL for Data Science, Data Analytics and Data Visualization professional story and personalise your path to a new career. Furthermore, developing this SQL for Data Science, Data Analytics and Data Visualization skillset can lead to numerous opportunities for high-paying jobs in a variety of fields.
Order Your Certificate
Course Curriculum
| SQL for Data Science, Data Analytics and Data Visualization | |||
| Section 01: Getting Started | |||
| Introduction | 00:03:00 | ||
| How to get course requirements | 00:03:00 | ||
| Getting started on Windows, Linux or Docker | 00:01:00 | ||
| How to ask great questions | 00:01:00 | ||
| FAQ’s | 00:01:00 | ||
| Section 02: SQL Server setting up | |||
| Section Introduction | 00:02:00 | ||
| Microsoft SQL Server Installation | 00:19:00 | ||
| SQL Server Management Studio (SSMS) Installation | 00:08:00 | ||
| How to connect MS SQL (Windows Authentication) | 00:04:00 | ||
| How to connect MS SQL (SQL Server Authentication) | 00:03:00 | ||
| Download and Restore Sample Database | 00:07:00 | ||
| Section 03: SQL Azure Data Studio | |||
| What is Azure Data Studio | 00:06:00 | ||
| Azure Data Studio Installation steps | 00:07:00 | ||
| Azure Data Studio to Connect SQL Server | 00:09:00 | ||
| Create a Database | 00:07:00 | ||
| Create a Table | 00:09:00 | ||
| Insert Data rows | 00:07:00 | ||
| View the Data returned by Query | 00:03:00 | ||
| Section 04: SQL Database basic SSMS | |||
| Section Introduction | 00:01:00 | ||
| Overview of Databases | 00:11:00 | ||
| Creating Database | 00:05:00 | ||
| SQL Data Types | 00:03:00 | ||
| Column Data Types on SSMS | 00:04:00 | ||
| Creating Table | 00:09:00 | ||
| Overview of Primary Key and Foreign Key | 00:04:00 | ||
| Primary Key | 00:04:00 | ||
| Foreign Key | 00:07:00 | ||
| Creating Temporary tables | 00:06:00 | ||
| Section 05: SQL Statements for DATA | |||
| Section Introduction | 00:01:00 | ||
| Insert statement | 00:08:00 | ||
| Update statement | 00:05:00 | ||
| Delete statement | 00:03:00 | ||
| Section 06: SQL Data Structure statements | |||
| Section Introduction | 00:01:00 | ||
| CREATE table statement | 00:03:00 | ||
| DROP statement | 00:02:00 | ||
| ALTER statement | 00:05:00 | ||
| TRUNCATE statement | 00:04:00 | ||
| COMMENT in query | 00:01:00 | ||
| RENAME | 00:02:00 | ||
| Section 07: SQL User Management | |||
| Create Database user | 00:04:00 | ||
| GRANT permissions | 00:06:00 | ||
| REVOKE permissions | 00:04:00 | ||
| Section 08: SQL Statement Basic | |||
| Section Introduction | 00:01:00 | ||
| SQL Statement basic | 00:03:00 | ||
| SELECT Statement | 00:07:00 | ||
| SELECT DISTINCT | 00:03:00 | ||
| SELECT with column headings | 00:03:00 | ||
| Column AS statement | 00:02:00 | ||
| Section 09: Filtering Data rows | |||
| SELECT WHERE Clause – theory | 00:04:00 | ||
| SELECT WHERE Clause – practical | 00:07:00 | ||
| Section 10: Aggregate functions | |||
| Sum() | 00:08:00 | ||
| Min()-Max() | 00:06:00 | ||
| Section 11: SQL Query statements | |||
| Order By statement | 00:05:00 | ||
| SELECT TOP clause in SQL | 00:04:00 | ||
| BETWEEN command | 00:08:00 | ||
| IN operator | 00:04:00 | ||
| Wildcard Characters and LIKE | 00:05:00 | ||
| Section 12: SQL Group by statement | |||
| Section Introduction | 00:01:00 | ||
| Group by – theory | 00:03:00 | ||
| Group by – practical | 00:05:00 | ||
| HAVING statement | 00:04:00 | ||
| Section 13: JOINS for Multiple table Data Analysis | |||
| Overview of Joins | 00:02:00 | ||
| What are Joins | 00:02:00 | ||
| Inner join | 00:08:00 | ||
| Left outer join | 00:03:00 | ||
| Right outer join | 00:02:00 | ||
| Full outer join | 00:01:00 | ||
| Union | 00:03:00 | ||
| Cartesian Product with the Cross Join | 00:03:00 | ||
| Query Exercise | 00:01:00 | ||
| Solution for Query Exercise | 00:01:00 | ||
| Section 14: SQL Constraints | |||
| Section introduction | 00:01:00 | ||
| Check constraint | 00:07:00 | ||
| NOT NULL constraint | 00:08:00 | ||
| UNIQUE constraint | 00:05:00 | ||
| Section 15: Views | |||
| Creating Views | 00:04:00 | ||
| Reporting with multiple tables | 00:03:00 | ||
| Section 16: Advanced SQL commands | |||
| Section Introduction | 00:01:00 | ||
| Timestamp | 00:04:00 | ||
| Extract from timestamp | 00:03:00 | ||
| Mathematical scalar functions | 00:04:00 | ||
| String functions | 00:05:00 | ||
| Sub Query | 00:03:00 | ||
| SELECT with calculations | 00:06:00 | ||
| Section 17: SQL Stored procedures | |||
| Create stored procedure | 00:05:00 | ||
| Stored procedure with parameter | 00:04:00 | ||
| Section 18: Azure Data Studio Visualization | |||
| Installing SandDance Extension | 00:03:00 | ||
| Visualization Charts | 00:05:00 | ||
| Multiple Table Data Charts | 00:06:00 | ||
| Section 19: Azure Studio SQL for Data Analysis | |||
| Type Decision for Data Analysis | 00:13:00 | ||
| Data Analysis with Case Statement and String Text | 00:09:00 | ||
| Section 20: Import & Export data | |||
| Section Introduction | 00:01:00 | ||
| Import Flat File | 00:05:00 | ||
| Import .csv or excel file | 00:03:00 | ||
| Export Data to Excel or any format | 00:06:00 | ||
| Section 21: Backup and Restore Database | |||
| Section Introduction | 00:01:00 | ||
| Creating Database backup | 00:04:00 | ||
| Restoring Database backup | 00:04:00 | ||
| Order Your Certificate | |||
| Order Your Certificate | 00:00:00 | ||
Related Courses
