SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER

Name: SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER
Rating: 4.5 (30 reviews)

The ultimate SQL course that will make you an SQL expert by learning through concept hands-on SQL coding

Created byMohammad Alam

Last updated 10/2022

English

What you'll learn

Learn SQL syntax from a beginner to a expert level
Learn about T-SQL (Transact SQL)
Install SQL Server 2019 on Windows 10
Install SQL Server Management Studio on Windows 10
Create a Virtual Machine in Oracle VirtualBox
Install SQL Server 2019 on Windows Server 2019 (Virtual Machine).
Learn to create databases
Learn to create relational tables and insert records into tables
Learn all types of SQL Joins (Inner Join, Left Join, Right Outer Join, Full Outer Join, Merge Join, Self-Join, Cross Join)
Analyze data using Union, Union All, IN Operator, Between Operator, Exists Operator, Not Exists Operator, Like Operator, Between Operator, and Sub Query
Learn all types of SQL constraints (Primary Key constraint, Foreign Key constraint, Not Null Constraint, Default Constraint, Unique Constraint,Check Constraint)
Understand the Composite Primary Key
Learn all types of aggregate functions(COUNT, SUM ,MIN ,MAX, AVG)
Analyzing data using Coalesce, NullIF, Case Statement, Group By, and Having Clause
Learn the DML Statement (Insert, Update, and Delete)
Learn and Implement the Data Definition Languages (Create, Alter, Drop, Truncate)
Learning and Implementing Data Control Language (DCL) (Grant, Revoke)
Learn Transaction Control Language (TCL) (Commit, Rollback, Savepoint)
Learn to create complex store procedures and alter store procedures
Learn and implement different types of triggers (DDL Trigger, DML Trigger)
Learn about both local and global temporary tables
Learn Common Table Expression (CTE)
Understanding the Ranking Functions (Row Number, Rank, and Dense Rank)
Learn Table Variable , Functions

Course content

7 sections • 110 lectures • 7h 6m total length

How to proceed with Module 12:19
1.1Download and Install SQL Server 2019 on Windows 10(Basic Installation)2:28
Download and Install SQL Server 2019 on Windows 10(Basic Installation)
1.2 Download and Install SQL Server Management Studio on Windows 102:29
Download and Install SQL Server Management Studio on Windows 10
1.3 What Is Virtualization Software ?1:03
Explore virtualization software and how it lets an operating system run on another. Learn about VirtualBox, an open-source virtualization tool under GPL v2, used to access multiple operating systems.
1.4 Download and Install Oracle VirtualBox3:21
Download and Install Oracle VirtualBox on Windows Host
1.5 Download Windows Server 2019 Evaluation Edition1:35
Download Windows Server 2019 Evaluation Edition from Microsoft
1.6 Create Virtual Machine and Install Windows Server 20195:11
Create new Virtual Machine and Install Windows Server 2019
1.7 Download and Install SQL Server 2019 ( Custom Installation ) on Windows Serv10:04
Download and Install SQL Server 2019 ( Custom Installation ) on Windows Server 2019 VM
1.8 Download and Install SQL Server Management Studio on Windows Server 2019 VM4:21
1.9 Connect SQL Server using SQL Server Management Studio and Change Authenticat4:33
Connect SQL Server using SQL Server Management Studio and Change Authentication Mode
1.10 Basics of SQL Server Configuration3:11
Learn about basics of SQL Server Configuration

2.0 What is Relational Database ?1:13
What is a Relational Database
2.0.1 What is SQL and T-SQL ?1:08
What is SQL and T-SQL
2.1 Create New Database6:19
Create New Database
2.2 How to Download and Restore Adventureworks2019 Database4:26
How to Download and Restore Adventureworks2019 Database
2.3 Write Simple Select Statement4:53
Write Simple Select Statement
2.4 Save Query as .sql File and Open Existing Query4:32
Save Query as .sql File and Open Existing Query
2.5 Create Table and Insert Records Into Table6:36
Create Table and Insert Records Into Table
2.6 Data Types7:36
Data Types in SQL Server
2.7 Drop Table4:11
Drop Table using Code and GUI option
2.8 CODE Challenge Create Database And Create Table1:09
CODE Challenge Create Database And Create Table
2.8 Solution CODE Challenge Create Database And Create Table3:28
Solution CODE Challenge Create Database And Create Table
2.9 CODE Challenge Select Statement0:47
CODE Challenge Select Statement
2.9 Solution CODE Challenge Select Statement1:59
Solution CODE Challenge Select Statement

3.1 What is SQL Constraint?1:13
What is SQL Constraint?
3.2 Primary Key Constraint7:02
Primary Key Constraint
3.3 Foreign Key Constraint11:13
Foreign Key Constraint
3.4 Default Constraint6:43
Default Constraint
3.5 Not NULL Constraint4:16
Not NULL Constraint
3.6 Unique Constraint8:03
Unique Constraint
3.7 Check Constraint6:45
Check Constraint
3.8 Composite Primary5:13
Composite Primary
3.9 CODE Challenge SQL Constraint1:49
CODE Challenge SQL Constraint
3.9 Solution CODE Challenge SQL Constraint6:23
Solution CODE Challenge SQL Constraint
3.10 CODE Challenge Foreign Key Constraint1:23
CODE Challenge Foreign Key Constraint
3.10 Solution CODE Challenge Foreign Key Constraint5:35
Solution CODE Challenge Foreign Key Constraint

4.1 Preparing Data for Join Demo6:17
Preparing Data for Join Demo
4.2 Inner Join4:17
Inner Join
4.3 Left Outer Join4:42
Left Outer Join
4.4 Right Outer Join4:41
Right Outer Join
4.5 Full Outer Join2:20
Full Outer Join
4.6 Self Join3:31
Self Join
4.7 Cross Join3:36
Cross Join
4.8 Union4:47
Union
4.9 Union All6:10
Union All
4.10 In Operator3:27
In Operator
4.11 Between Operator3:43
Between Operator
4.12 Where Clause4:05
Where Clause
4.13 Subquery4:46
Subquery
4.14 Exists Operator3:29
Exists Operator
4.15 Not Exists Operator3:37
Not Exists Operator
4.16 AND OR Operator3:31
AND OR Operator
4.17 Merge Join6:57
Merge Join
4.18 Like Operator5:06
Like Operator
4.19 CODE Challenge IN BETWEEN Operator0:49
CODE Challenge IN BETWEEN Operator
4.19 Solution CODE Challenge IN BETWEEN Operator5:56
Solution CODE Challenge IN BETWEEN Operator
4.20 CODE Challenge JOINS and Where Clause1:16
CODE Challenge JOINS and Where Clause
4.20 Solution CODE Challenge JOINS and Where Clause6:29
Solution CODE Challenge JOINS and Where Clause

5.1 SUM2:21
SUM Function
5.2 MAX2:11
MAX Function
5.3 MIN2:05
MIN Function
5.4 COUNT2:53
COUNT Function
5.5 AVG1:48
AVG Function
5.6 GROUP BY2:52
GROUP BY
5.7 HAVING CLAUSE2:26
HAVING CLAUSE
5.8 IS NULL2:46
IS NULL
5.9 Code Example SUM with Having Clause1:17
Code Example SUM with Having Clause
5.10 COALESCE2:27
COALESCE Function
5.11 NULLIF3:05
NULLIF
5.12 CASE Statement4:04
CASE Statement
5.13 CODE Challenge Aggregate Function1:25
CODE Challenge Aggregate Function
5.13 Solution CODE Challenge Aggregate Function2:29
Solution CODE Challenge Aggregate Function
5.14 CODE Challenge CASE Statement and COALESCE Function0:50
CODE Challenge CASE Statement and COALESCE Function
5.14 Solution CODE Challenge CASE Statement and COALESCE Function2:24
5.14 Solution CODE Challenge CASE Statement and COALESCE Function

6.1 Data Manipulation Language(DML)0:41
Data Manipulation Language(DML)
6.2 Select1:59
Select Statement
6.3 Insert7:38
Insert Statement
6.4 Update6:43
Update
6.5 Delete5:51
Delete Statement
6.6 Data definition language(DDL)0:46
Data definition language(DDL)
6.7 Create1:27
Create Table Statement
6.8 Alter1:52
Alter Table Statement
6.9 Drop3:26
Drop Statement
6.10 Truncate3:04
Truncate Statement
6.11 Data Control Language (DCL)0:36
Data Control Language (DCL)
6.12 Grant7:59
Grant Command
6.13 Revoke7:26
Revoke Command
6.14 Transactional Control Language(TCL)0:53
Transactional Control Language(TCL)
6.15 Commit6:26
Commit
6.16 RollBack7:18
RollBack
6.17 Save Point4:07
Save Point
6.18 CODE Challenge DML and DDL1:14
CODE Challenge DML and DDL
6.18 Solution CODE Challenge DML and DDL3:54
Solution CODE Challenge DML and DDL

7.1 Store Procedure2:57
Store Procedure
7.2 Store Procedure With Parameters3:03
Store Procedure With Parameters
7.3 Store Procedure With Default Parameter2:33
Store Procedure With Default Parameter
7.4 ALTER And Drop Store Procedure3:31
ALTER And Drop Store Procedure
7.5 Function1:04
Function
7.6 Scalar Function2:05
Scalar Function
7.7 Table Valued Function2:57
Table Valued Function
7.8 Local Temporary Table7:17
Local Temporary Table
7.9 Global Temporary Table4:58
Global Temporary Table
7.10 Table Variable4:24
Table Variable
7.11a Trigger and DML Trigger9:50
Trigger and DML Trigger
7.11b DDL Trigger ,Disable and Drop Trigger5:15
Learn to create and manage DDL triggers in Microsoft SQL Server, including auditing with an audit log, and to disable and drop triggers at the database level.
7.12 Merge Statement6:34
Merge Statement
7.13 Common Table Expression3:06
Common Table Expression
7.14 Ranking Function0:35
Ranking Function
7.15 Row number function3:57
Row number function
7.16 Rank & Dense Rank4:04
Rank & Dense Rank

Requirements

Windows-based computer to run Microsoft SQL Server 2019
If you run Mac book pc or Linux you still can take this course using Oracle virtual box ( Virtual machine) similar example explained on the course ( prepare environment, Module 1 )
No prior knowledge or experience is required to take this

Description

In this course you will learn fowling topics:

Learn SQL syntax from a beginner to a pro level.
Learn about T-SQL (Transact SQL).
Install SQL Server 2019 on Windows 10.
Install SQL Server Management Studio on Windows 10.
Create a Virtual Machine in Oracle VirtualBox
Install SQL Server 2019 on Windows Server 2019 (Virtual Machine).
Learn to create databases.
Learn to create relational tables and insert records into tables.
Learn all types of SQL Joins (Inner Join, Left Join, Right Outer Join, Full Outer Join, Merge Join, Self-Join, Cross Join)
Analyze data using Union, Union All, IN Operator, Between Operator, Exists Operator, Not Exists Operator, Like Operator, Between Operator, and Sub Query
Learn all types of SQL constraints (Primary Key constraint, Foreign Key constraint, Not Null Constraint, Default Constraint, Unique Constraint, Check Constraint)
Understand the Composite Primary Key
Learn all types of aggregate functions.
Analyzing data using Coalesce, NullIF, Case Statement, Group By, and Having Clause
Learn the DML Statement (Insert, Update, and Delete).
Learn and Implement the Data Definition Languages (Create, Alter, Drop, Truncate)
Learning and Implementing Data Control Language (DCL) (Grant, Revoke)
Learn Transaction Control Language (TCL) (Commit, Rollback, Savepoint)
Learn to create complex store procedures and alter store procedures.
Learn and implement different types of triggers (DDL Trigger, DML Trigger).
Learn about both local and global temporary tables.
Learn Common Table Expression (CTE)
Understanding the Ranking Functions (Row Number, Rank, and Dense Rank)

Who this course is for:

If you are interested in learning SQL to help with your current job or to find a new role
If you are looking to pull data, analyze data from a database based on business requirements and create reports using data from the database
If you already know some SQL or TSQL and want to refresh your SQL or TSQL skills, this course is for you
If you are already working as an IT professional and you want to improve your SQL/TSQL skills, this course is for you

SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER

What you'll learn

Explore related topics

Course content

Module 111 lectures • 41min

Module 213 lectures • 48min

Module 312 lectures • 1hr 6min

Module 422 lectures • 1hr 34min

Module 516 lectures • 37min

Module 619 lectures • 1hr 13min

Module 717 lectures • 1hr 8min

Requirements

Description

Who this course is for: