SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER

SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER, available at $64.99, has an average rating of 4.25, with 110 lectures, based on 29 reviews, and has 89 subscribers.

You will learn about 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 This course is ideal for individuals who are If you are interested in learning SQL to help with your current job or to find a new role or If you are looking to pull data, analyze data from a database based on business requirements and create reports using data from the database or If you already know some SQL or TSQL and want to refresh your SQL or TSQL skills, this course is for you or If you are already working as an IT professional and you want to improve your SQL/TSQL skills, this course is for you It is particularly useful for If you are interested in learning SQL to help with your current job or to find a new role or If you are looking to pull data, analyze data from a database based on business requirements and create reports using data from the database or If you already know some SQL or TSQL and want to refresh your SQL or TSQL skills, this course is for you or If you are already working as an IT professional and you want to improve your SQL/TSQL skills, this course is for you.

Enroll now: SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER

Summary

Title: SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER

Price: $64.99

Average Rating: 4.25

Number of Lectures: 110

Number of Published Lectures: 110

Number of Curriculum Items: 110

Number of Published Curriculum Objects: 110

Original Price: $19.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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)

Course Curriculum

Chapter 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

Chapter 2: Module 2

Lecture 1: 2.0 What is Relational Database ?

Lecture 2: 2.0.1 What is SQL and T-SQL ?

Lecture 3: 2.1 Create New Database

Lecture 4: 2.2 How to Download and Restore Adventureworks2019 Database

Lecture 5: 2.3 Write Simple Select Statement

Lecture 6: 2.4 Save Query as .sql File and Open Existing Query

Lecture 7: 2.5 Create Table and Insert Records Into Table

Lecture 8: 2.6 Data Types

Lecture 9: 2.7 Drop Table

Lecture 10: 2.8 CODE Challenge Create Database And Create Table

Lecture 11: 2.8 Solution CODE Challenge Create Database And Create Table

Lecture 12: 2.9 CODE Challenge Select Statement

Lecture 13: 2.9 Solution CODE Challenge Select Statement

Chapter 3: Module 3

Lecture 1: 3.1 What is SQL Constraint?

Lecture 2: 3.2 Primary Key Constraint

Lecture 3: 3.3 Foreign Key Constraint

Lecture 4: 3.4 Default Constraint

Lecture 5: 3.5 Not NULL Constraint

Lecture 6: 3.6 Unique Constraint

Lecture 7: 3.7 Check Constraint

Lecture 8: 3.8 Composite Primary

Lecture 9: 3.9 CODE Challenge SQL Constraint

Lecture 10: 3.9 Solution CODE Challenge SQL Constraint

Lecture 11: 3.10 CODE Challenge Foreign Key Constraint

Lecture 12: 3.10 Solution CODE Challenge Foreign Key Constraint

Chapter 4: Module 4

Lecture 1: 4.1 Preparing Data for Join Demo

Lecture 2: 4.2 Inner Join

Lecture 3: 4.3 Left Outer Join

Lecture 4: 4.4 Right Outer Join

Lecture 5: 4.5 Full Outer Join

Lecture 6: 4.6 Self Join

Lecture 7: 4.7 Cross Join

Lecture 8: 4.8 Union

Lecture 9: 4.9 Union All

Lecture 10: 4.10 In Operator

Lecture 11: 4.11 Between Operator

Lecture 12: 4.12 Where Clause

Lecture 13: 4.13 Subquery

Lecture 14: 4.14 Exists Operator

Lecture 15: 4.15 Not Exists Operator

Lecture 16: 4.16 AND OR Operator

Lecture 17: 4.17 Merge Join

Lecture 18: 4.18 Like Operator

Lecture 19: 4.19 CODE Challenge IN BETWEEN Operator

Lecture 20: 4.19 Solution CODE Challenge IN BETWEEN Operator

Lecture 21: 4.20 CODE Challenge JOINS and Where Clause

Lecture 22: 4.20 Solution CODE Challenge JOINS and Where Clause

Chapter 5: Module 5

Lecture 1: 5.1 SUM

Lecture 2: 5.2 MAX

Lecture 3: 5.3 MIN

Lecture 4: 5.4 COUNT

Lecture 5: 5.5 AVG

Lecture 6: 5.6 GROUP BY

Lecture 7: 5.7 HAVING CLAUSE

Lecture 8: 5.8 IS NULL

Lecture 9: 5.9 Code Example SUM with Having Clause

Lecture 10: 5.10 COALESCE

Lecture 11: 5.11 NULLIF

Lecture 12: 5.12 CASE Statement

Lecture 13: 5.13 CODE Challenge Aggregate Function

Lecture 14: 5.13 Solution CODE Challenge Aggregate Function

Lecture 15: 5.14 CODE Challenge CASE Statement and COALESCE Function

Lecture 16: 5.14 Solution CODE Challenge CASE Statement and COALESCE Function

Chapter 6: Module 6

Lecture 1: 6.1 Data Manipulation Language(DML)

Lecture 2: 6.2 Select

Lecture 3: 6.3 Insert

Lecture 4: 6.4 Update

Lecture 5: 6.5 Delete

Lecture 6: 6.6 Data definition language(DDL)

Lecture 7: 6.7 Create

Lecture 8: 6.8 Alter

Lecture 9: 6.9 Drop

Lecture 10: 6.10 Truncate

Lecture 11: 6.11 Data Control Language (DCL)

Lecture 12: 6.12 Grant

Lecture 13: 6.13 Revoke

Lecture 14: 6.14 Transactional Control Language(TCL)

Lecture 15: 6.15 Commit

Lecture 16: 6.16 RollBack

Lecture 17: 6.17 Save Point

Lecture 18: 6.18 CODE Challenge DML and DDL

Lecture 19: 6.18 Solution CODE Challenge DML and DDL

Chapter 7: Module 7

Instructors

Mohammad Alam
Database Engineer and Developer

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 3 votes
4 stars: 10 votes
5 stars: 15 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu