SQL Bootcamp: Zero to Hero Using Microsoft SQL SERVER

Focused View

Mohammad Alam

7:12:06

152 View

1. Module 1

1. How to proceed with Module 1.mp4

02:19

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

02:28

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

02:29

4. 1.3 What Is Virtualization Software .mp4

01:03

5. 1.4 Download and Install Oracle VirtualBox.mp4

03:21

6. 1.5 Download Windows Server 2019 Evaluation Edition.mp4

01:35

7.1 1.6 Create Virtual Machine and Install Windows Server 2019.mp4

05:11

7. 1.6 Create Virtual Machine and Install Windows Server 2019.mp4

05:11

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

10:04

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

04:21

10. 1.9 Connect SQL Server using SQL Server Management Studio and Change Authenticat.mp4

04:33

11. 1.10 Basics of SQL Server Configuration.mp4

03:11

2. Module 2

1. 2.0 What is Relational Database .mp4

01:13

2. 2.0.1 What is SQL and T-SQL .mp4

01:08

3.1 2.1 create new database.zip

3. 2.1 Create New Database.mp4

06:19

4. 2.2 How to Download and Restore Adventureworks2019 Database.mp4

04:26

5.1 2.3 write simple select statement.zip

5. 2.3 Write Simple Select Statement.mp4

04:53

6.1 2.4 save query as file and open exitisting query.zip

6. 2.4 Save Query as .sql File and Open Existing Query.mp4

04:32

7.1 2.5 create table and insert record into table.zip

7. 2.5 Create Table and Insert Records Into Table.mp4

06:36

8.1 2.6 data types.zip

8. 2.6 Data Types.mp4

07:36

9.1 2.7 drop table.zip

9. 2.7 Drop Table.mp4

04:11

10.1 2.8 code challenge create database and create table.zip

10. 2.8 CODE Challenge Create Database And Create Table.mp4

01:09

11.1 2.8 solution code challenge create database and create table.zip

11. 2.8 Solution CODE Challenge Create Database And Create Table.mp4

03:28

12.1 2.9 code challenge select statement.zip

12. 2.9 CODE Challenge Select Statement.mp4

00:47

13.1 2.9 solution code challenge select statement.zip

13. 2.9 Solution CODE Challenge Select Statement.mp4

01:59

3. Module 3

1. 3.1 What is SQL Constraint.mp4

01:13

2.1 3.2 primary key constraint.zip

2. 3.2 Primary Key Constraint.mp4

07:02

3.1 3.3 foreign key constraint.zip

3. 3.3 Foreign Key Constraint.mp4

11:13

4.1 3.4 default constraint.zip

4. 3.4 Default Constraint.mp4

06:43

5.1 3.5 not null constraint.zip

5. 3.5 Not NULL Constraint.mp4

04:16

6.1 3.6 unique constraint.zip

6. 3.6 Unique Constraint.mp4

08:03

7.1 3.7 check constraint.zip

7. 3.7 Check Constraint.mp4

06:45

8.1 3.8 composite primary.zip

8. 3.8 Composite Primary.mp4

05:13

9.1 3.9 code challenge sql constraint.zip

9. 3.9 CODE Challenge SQL Constraint.mp4

01:49

10.1 3.9 solution code chanllenge sql constraint.zip

10. 3.9 Solution CODE Challenge SQL Constraint.mp4

06:23

11.1 3.10 code challenge foreign key constraint.zip

11. 3.10 CODE Challenge Foreign Key Constraint.mp4

01:23

12.1 3.10 solution code challenge foreign key constraint.zip

12. 3.10 Solution CODE Challenge Foreign Key Constraint.mp4

05:35

4. Module 4

1.1 4.1 preparing data for join demo.zip

1. 4.1 Preparing Data for Join Demo.mp4

06:17

2.1 4.2 inner join.zip

2. 4.2 Inner Join.mp4

04:17

3.1 4.3 left outer join.zip

3. 4.3 Left Outer Join.mp4

04:42

4.1 4.4 right outer join.zip

4. 4.4 Right Outer Join.mp4

04:41

5.1 4.5 full outer join.zip

5. 4.5 Full Outer Join.mp4

02:20

6.1 4.6 self join.zip

6. 4.6 Self Join.mp4

03:31

7.1 4.7 cross join.zip

7. 4.7 Cross Join.mp4

03:36

8.1 4.8 union.zip

8. 4.8 Union.mp4

04:47

9.1 4.9 union all.zip

9. 4.9 Union All.mp4

06:10

10.1 4.10 in operator.zip

10. 4.10 In Operator.mp4

03:27

11.1 4.11 between operator.zip

11. 4.11 Between Operator.mp4

03:43

12.1 4.12 where clause.zip

12. 4.12 Where Clause.mp4

04:05

13.1 4.13 subquery.zip

13. 4.13 Subquery.mp4

04:46

14.1 4.14 exists operator.zip

14. 4.14 Exists Operator.mp4

03:29

15.1 4.15 not exists operator.zip

15. 4.15 Not Exists Operator.mp4

03:37

16.1 4.16 and or operator.zip

16. 4.16 AND OR Operator.mp4

03:31

17.1 4.17 merge join.zip

17. 4.17 Merge Join.mp4

06:57

18.1 4.18 like operator.zip

18. 4.18 Like Operator.mp4

05:06

19.1 4.19 solution code challenge in between operator.zip

19. 4.19 CODE Challenge IN BETWEEN Operator.mp4

00:49

20.1 4.19 solution code challenge in between operator.zip

20. 4.19 Solution CODE Challenge IN BETWEEN Operator.mp4

05:56

21.1 4.20 code challenge joins and where clause.zip

21. 4.20 CODE Challenge JOINS and Where Clause.mp4

01:16

22.1 4.20 solution code challenge joins and where clause.zip

22. 4.20 Solution CODE Challenge JOINS and Where Clause.mp4

06:29

5. Module 5

1.1 5.1 sum.zip

1. 5.1 SUM.mp4

02:21

2.1 5.2 max.zip

2. 5.2 MAX.mp4

02:11

3.1 5.3 min.zip

3. 5.3 MIN.mp4

02:05

4.1 5.4 count.zip

4. 5.4 COUNT.mp4

02:53

5.1 5.5 avg.zip

5. 5.5 AVG.mp4

01:48

6.1 5.6 group by.zip

6. 5.6 GROUP BY.mp4

02:52

7.1 5.7 having clause.zip

7. 5.7 HAVING CLAUSE.mp4

02:26

8.1 5.8 is null.zip

8. 5.8 IS NULL.mp4

02:46

9.1 5.9 code example sum with having clause.zip

9. 5.9 Code Example SUM with Having Clause.mp4

01:17

10.1 5.10 coalesce.zip

10. 5.10 COALESCE.mp4

02:27

11.1 5.11 nullif.zip

11. 5.11 NULLIF.mp4

03:05

12.1 5.12 case statement.zip

12. 5.12 CASE Statement.mp4

04:04

13.1 5.13 code challenge aggregate function.zip

13. 5.13 CODE Challenge Aggregate Function.mp4

01:25

14.1 5.13 solution code challenge aggregate function.zip

14. 5.13 Solution CODE Challenge Aggregate Function.mp4

02:29

15.1 5.14 code challenge case statement and coalesce function.zip

15. 5.14 CODE Challenge CASE Statement and COALESCE Function.mp4

00:50

16.1 5.14 solution code challenge case statement andcoalesce function.zip

16. 5.14 Solution CODE Challenge CASE Statement and COALESCE Function.mp4

02:24

6. Module 6

1. 6.1 Data Manipulation Language(DML).mp4

00:41

2.1 6.2 select.zip

2. 6.2 Select.mp4

01:59

3.1 6.3 insert.zip

3. 6.3 Insert.mp4

07:38

4.1 6.4 update.zip

4. 6.4 Update.mp4

06:43

5.1 6.5 delete.zip

5. 6.5 Delete.mp4

05:51

6. 6.6 Data definition language(DDL).mp4

00:46

7.1 6.7 create.zip

7. 6.7 Create.mp4

01:27

8.1 6.8 alter.zip

8. 6.8 Alter.mp4

01:52

9.1 6.9 drop.zip

9. 6.9 Drop.mp4

03:26

10.1 6.10 truncate.zip

10. 6.10 Truncate.mp4

03:04

11. 6.11 Data Control Language (DCL).mp4

00:36

12.1 6.12 grant.zip

12. 6.12 Grant.mp4

07:59

13.1 6.13 revoke.zip

13. 6.13 Revoke.mp4

07:26

14. 6.14 Transactional Control Language(TCL).mp4

00:53

15.1 6.15 commit.zip

15. 6.15 Commit.mp4

06:26

16.1 6.16 rollback.zip

16. 6.16 RollBack.mp4

07:18

17.1 6.17 save point.zip

17. 6.17 Save Point.mp4

04:07

18.1 6.18 code challenge dm and ddl.zip

18. 6.18 CODE Challenge DML and DDL.mp4

01:14

19.1 6.18 solution code challenge dml and ddl.zip

19. 6.18 Solution CODE Challenge DML and DDL.mp4

03:54

7. Module 7

1.1 7.1 store procedure.zip

1. 7.1 Store Procedure.mp4

02:57

2.1 7.2 store procedure with parameters.zip

2. 7.2 Store Procedure With Parameters.mp4

03:03

3.1 7.3 store procedure with default parameter.zip

3. 7.3 Store Procedure With Default Parameter.mp4

02:33

4.1 7.4 alter and drop store procedure.zip

4. 7.4 ALTER And Drop Store Procedure.mp4

03:31

5. 7.5 Function.mp4

01:04

6.1 7.6 scalar function.zip

6. 7.6 Scalar Function.mp4

02:05

7.1 7.7 table valued function.zip

7. 7.7 Table Valued Function.mp4

02:57

8.1 7.8 local temp table.zip

8. 7.8 Local Temporary Table.mp4

07:17

9.1 7.9 global temp table.zip

9. 7.9 Global Temporary Table.mp4

04:58

10.1 7.10 table variable.zip

10. 7.10 Table Variable.mp4

04:24

11.1 7.11 trigger.zip

11. 7.11a Trigger and DML Trigger.mp4

09:50

12.1 7.11 trigger.zip

12. 7.11b DDL Trigger ,Disable and Drop Trigger.mp4

05:15

13.1 7.12 merge statement.zip

13. 7.12 Merge Statement.mp4

06:34

14.1 7.13 common table expression.zip

14. 7.13 Common Table Expression.mp4

03:06

15. 7.14 Ranking Function.mp4

00:35

16.1 7.15 row number function.zip

16. 7.15 Row number function.mp4

03:57

17.1 7.16 rank & dense rank.zip

17. 7.16 Rank & Dense Rank.mp4

04:04

Description

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

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

Who is this 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

What You Need to Know?

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

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Mohammad Alam has a Master's in information technology from Virginia Tech. He has been working as a SQL Developer and Database Administrator for over 10 years, including in government and private organizations. He has been given SQL training online for years.He has worked on various database projects such as database development, database performance tuning, SQL query tuning, database troubleshooting, and production support of various database management systems.He is passionate about working on database development and DBA work. He enjoys helping others.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.