Sql Bootcamp: Zero To Hero Using Microsoft Sql Server

The complete course that walks you through each stage of writing SQL and TSQL queries with Microsoft SQL Server 2019

What you'll learn
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(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
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 VirtualBoxInstall 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 QueryLearn all types of SQL constraints (Primary Key constraint, Foreign Key constraint, Not Null Constraint, Default Constraint, Unique Constraint, Check Constraint)Understand the Composite Primary KeyLearn all types of aggregate functions.Analyzing data using Coalesce, NullIF, Case Statement, Group By, and Having ClauseLearn 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)

Overview

Section 1: Module 1

Lecture 1 How to proceed with Module 1

Lecture 2 1.1Download and Install SQL Server 2019 on Windows 10(Basic Installation)

Lecture 3 1.2 Download and Install SQL Server Management Studio on Windows 10

Lecture 4 1.3 What Is Virtualization Software ?

Lecture 5 1.4 Download and Install Oracle VirtualBox

Lecture 6 1.5 Download Windows Server 2019 Evaluation Edition

Lecture 7 1.6 Create Virtual Machine and Install Windows Server 2019

Lecture 8 1.7 Download and Install SQL Server 2019 ( Custom Installation ) on Windows Serv

Lecture 9 1.8 Download and Install SQL Server Management Studio on Windows Server 2019 VM

Lecture 10 1.9 Connect SQL Server using SQL Server Management Studio and Change Authenticat

Lecture 11 1.10 Basics of SQL Server Configuration

Section 2: Module 2

Lecture 12 2.0 What is Relational Database ?

Lecture 13 2.0.1 What is SQL and T-SQL ?

Lecture 14 2.1 Create New Database

Lecture 15 2.2 How to Download and Restore Adventureworks2019 Database

Lecture 16 2.3 Write Simple Select Statement

Lecture 17 2.4 Save Query as .sql File and Open Existing Query

Lecture 18 2.5 Create Table and Insert Records Into Table

Lecture 19 2.6 Data Types

Lecture 20 2.7 Drop Table

Lecture 21 2.8 CODE Challenge Create Database And Create Table

Lecture 22 2.8 Solution CODE Challenge Create Database And Create Table

Lecture 23 2.9 CODE Challenge Select Statement

Lecture 24 2.9 Solution CODE Challenge Select Statement

Section 3: Module 3

Lecture 25 3.1 What is SQL Constraint?

Lecture 26 3.2 Primary Key Constraint

Lecture 27 3.3 Foreign Key Constraint

Lecture 28 3.4 Default Constraint

Lecture 29 3.5 Not NULL Constraint

Lecture 30 3.6 Unique Constraint

Lecture 31 3.7 Check Constraint

Lecture 32 3.8 Composite Primary

Lecture 33 3.9 CODE Challenge SQL Constraint

Lecture 34 3.9 Solution CODE Challenge SQL Constraint

Lecture 35 3.10 CODE Challenge Foreign Key Constraint

Lecture 36 3.10 Solution CODE Challenge Foreign Key Constraint

Section 4: Module 4

Lecture 37 4.1 Preparing Data for Join Demo

Lecture 38 4.2 Inner Join

Lecture 39 4.3 Left Outer Join

Lecture 40 4.4 Right Outer Join

Lecture 41 4.5 Full Outer Join

Lecture 42 4.6 Self Join

Lecture 43 4.7 Cross Join

Lecture 44 4.8 Union

Lecture 45 4.9 Union All

Lecture 46 4.10 In Operator

Lecture 47 4.11 Between Operator

Lecture 48 4.12 Where Clause

Lecture 49 4.13 Subquery

Lecture 50 4.14 Exists Operator

Lecture 51 4.15 Not Exists Operator

Lecture 52 4.16 AND OR Operator

Lecture 53 4.17 Merge Join

Lecture 54 4.18 Like Operator

Lecture 55 4.19 CODE Challenge IN BETWEEN Operator

Lecture 56 4.19 Solution CODE Challenge IN BETWEEN Operator

Lecture 57 4.20 CODE Challenge JOINS and Where Clause

Lecture 58 4.20 Solution CODE Challenge JOINS and Where Clause

Section 5: Module 5

Lecture 59 5.1 SUM

Lecture 60 5.2 MAX

Lecture 61 5.3 MIN

Lecture 62 5.4 COUNT

Lecture 63 5.5 AVG

Lecture 64 5.6 GROUP BY

Lecture 65 5.7 HAVING CLAUSE

Lecture 66 5.8 IS NULL

Lecture 67 5.9 Code Example SUM with Having Clause

Lecture 68 5.10 COALESCE

Lecture 69 5.11 NULLIF

Lecture 70 5.12 CASE Statement

Lecture 71 5.13 CODE Challenge Aggregate Function

Lecture 72 5.13 Solution CODE Challenge Aggregate Function

Lecture 73 5.14 CODE Challenge CASE Statement and COALESCE Function

Lecture 74 5.14 Solution CODE Challenge CASE Statement and COALESCE Function

Section 6: Module 6

Lecture 75 6.1 Data Manipulation Language(DML)

Lecture 76 6.2 Select

Lecture 77 6.3 Insert

Lecture 78 6.4 Update

Lecture 79 6.5 Delete

Lecture 80 6.6 Data definition language(DDL)

Lecture 81 6.7 Create

Lecture 82 6.8 Alter

Lecture 83 6.9 Drop

Lecture 84 6.10 Truncate

Lecture 85 6.11 Data Control Language (DCL)

Lecture 86 6.12 Grant

Lecture 87 6.13 Revoke

Lecture 88 6.14 Transactional Control Language(TCL)

Lecture 89 6.15 Commit

Lecture 90 6.16 RollBack

Lecture 91 6.17 Save Point

Lecture 92 6.18 CODE Challenge DML and DDL

Lecture 93 6.18 Solution CODE Challenge DML and DDL

Section 7: Module 7

Lecture 94 7.1 Store Procedure

Lecture 95 7.2 Store Procedure With Parameters

Lecture 96 7.3 Store Procedure With Default Parameter

Lecture 97 7.4 ALTER And Drop Store Procedure

Lecture 98 7.5 Function

Lecture 99 7.6 Scalar Function

Lecture 100 7.7 Table Valued Function

Lecture 101 7.8 Local Temporary Table

Lecture 102 7.9 Global Temporary Table

Lecture 103 7.10 Table Variable

Lecture 104 7.11a Trigger and DML Trigger

Lecture 105 7.11b DDL Trigger ,Disable and Drop Trigger

Lecture 106 7.12 Merge Statement

Lecture 107 7.13 Common Table Expression

Lecture 108 7.14 Ranking Function

Lecture 109 7.15 Row number function

Lecture 110 7.16 Rank & Dense Rank

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