When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER
The ultimate SQL course that will make you an SQL expert by learning through concept hands-on SQL coding
This Course Includes
udemy
5 (30 reviews )
7h 6m 
english
Online - Self Paced
professional certificate
Udemy
About SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER
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)
What You Will 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 Show moreShow less.