About This Course
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