Development
QLS
Business
Healthcare
Health & Fitness
Technology
Teaching
Lifestyle
Design
About This Course
- Overview
Educational accomplishments and income are closely correlated. Education and skill with endorsed certificates from credible and renowned authorities typically lead to better jobs with attractive salaries. Educated and skilled workers also have lower rates of unemployment. Therefore, skills and endorsed certificates to showcase are essential for people early in their careers.
- Why Choose Imperial Academy?
Imperial Academy offers this premium SQL for Data Science, Data Analytics and Data Visualization course to ensure security in your career. In addition, this comprehensive SQL for Data Science, Data Analytics and Data Visualization course will assist you in building relevant skills that will help you find a job in the related sectors. Also, the Certificate you’ll get after completing the SQL for Data Science, Data Analytics and Data Visualization will put your head and shoulder above others in front of potential employers.
Become the person who would attract the results you seek. What you plant now, you will harvest later. So, grab this opportunity and start learning SQL for Data Science, Data Analytics and Data Visualization!
- What Imperial Academy Offers You
- QLS/ CPD/ CIQ Accredited
- 24/7 Assistance from our Support Team
- 100% Online
- Self-paced course
- Bite-sized Audio-visual Modules
- Rich Learning Materials
- Developed by Industry Specialists
- Career Guidance
- Course Design
Learn at your own pace from the comfort of your home, as the rich learning materials of this premium course is accessible from any place at any time. The advanced course curriculums are divided into tiny bite-sized audio-visual modules by industry specialists with years of experience behind them.
- Audio-visual Lessons
- Online Study Materials
Course Curriculum
-
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 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
-
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 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 Introduction
00:01:00
-
Insert statement
00:08:00
-
Update statement
00:05:00
-
Delete statement
00:03:00
-
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
-
Create Database user
00:04:00
-
GRANT permissions
00:06:00
-
REVOKE permissions
00:04:00
-
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
-
SELECT WHERE Clause – theory
00:04:00
-
SELECT WHERE Clause – practical
00:04:00
-
Sum()
00:08:00
-
Min()-Max()
00:06:00
-
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 Introduction
00:01:00
-
Group by – theory
00:03:00
-
Group by – practical
00:05:00
-
HAVING statement
00:04:00
-
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 introduction
00:01:00
-
Check constraint
00:07:00
-
NOT NULL constraint
00:08:00
-
UNIQUE constraint
00:05:00
-
Creating Views
00:04:00
-
Reporting with multiple tables
00:03:00
-
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
-
Create stored procedure
00:05:00
-
Stored procedure with parameter
00:04:00
-
Installing SandDance Extension
00:03:00
-
Visualization Charts
00:05:00
-
Multiple Table Data Charts
00:06:00
-
Type Decision for Data Analysis
00:13:00
-
Data Analysis with Case Statement and String Text
00:09:00
-
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 Introduction
00:01:00
-
Creating Database backup
00:04:00
-
Restoring Database backup
00:04:00
Subscribe to this course and 2,000+ top‑rated Training Express courses for your organization.
Try imperial academy business
Add to Cart
