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

1. Module 1

1. How to proceed with Module 1

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

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

4. 1.3 What Is Virtualization Software

5. 1.4 Download and Install Oracle VirtualBox

6. 1.5 Download Windows Server 2019 Evaluation Edition

7.1 1.6 Create Virtual Machine and Install Windows Server 2019

7. 1.6 Create Virtual Machine and Install Windows Server 2019

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

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

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

11. 1.10 Basics of SQL Server Configuration

2. Module 2

1. 2.0 What is Relational Database

2. 2.0.1 What is SQL and T-SQL

3.1 2.1 create new database.zip

3. 2.1 Create New Database

4. 2.2 How to Download and Restore Adventureworks2019 Database

5.1 2.3 write simple select statement.zip

5. 2.3 Write Simple Select Statement

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

7.1 2.5 create table and insert record into table.zip

7. 2.5 Create Table and Insert Records Into Table

8.1 2.6 data types.zip

8. 2.6 Data Types

9.1 2.7 drop table.zip

9. 2.7 Drop Table

10.1 2.8 code challenge create database and create table.zip

10. 2.8 CODE Challenge Create Database And Create Table

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

11. 2.8 Solution CODE Challenge Create Database And Create Table

12.1 2.9 code challenge select statement.zip

12. 2.9 CODE Challenge Select Statement

13.1 2.9 solution code challenge select statement.zip

13. 2.9 Solution CODE Challenge Select Statement

3. Module 3

1. 3.1 What is SQL Constraint

2.1 3.2 primary key constraint.zip

2. 3.2 Primary Key Constraint

3.1 3.3 foreign key constraint.zip

3. 3.3 Foreign Key Constraint

4.1 3.4 default constraint.zip

4. 3.4 Default Constraint

5.1 3.5 not null constraint.zip

5. 3.5 Not NULL Constraint

6.1 3.6 unique constraint.zip

6. 3.6 Unique Constraint

7.1 3.7 check constraint.zip

7. 3.7 Check Constraint

8.1 3.8 composite primary.zip

8. 3.8 Composite Primary

9.1 3.9 code challenge sql constraint.zip

9. 3.9 CODE Challenge SQL Constraint

10.1 3.9 solution code chanllenge sql constraint.zip

10. 3.9 Solution CODE Challenge SQL Constraint

11.1 3.10 code challenge foreign key constraint.zip

11. 3.10 CODE Challenge Foreign Key Constraint

12.1 3.10 solution code challenge foreign key constraint.zip

12. 3.10 Solution CODE Challenge Foreign Key Constraint

4. Module 4

1.1 4.1 preparing data for join demo.zip

1. 4.1 Preparing Data for Join Demo

2.1 4.2 inner join.zip

2. 4.2 Inner Join

3.1 4.3 left outer join.zip

3. 4.3 Left Outer Join

4.1 4.4 right outer join.zip

4. 4.4 Right Outer Join

5.1 4.5 full outer join.zip

5. 4.5 Full Outer Join

6.1 4.6 self join.zip

6. 4.6 Self Join

7.1 4.7 cross join.zip

7. 4.7 Cross Join

8.1 4.8 union.zip

8. 4.8 Union

9.1 4.9 union all.zip

9. 4.9 Union All

10.1 4.10 in operator.zip

10. 4.10 In Operator

11.1 4.11 between operator.zip

11. 4.11 Between Operator

12.1 4.12 where clause.zip

12. 4.12 Where Clause

13.1 4.13 subquery.zip

13. 4.13 Subquery

14.1 4.14 exists operator.zip

14. 4.14 Exists Operator

15.1 4.15 not exists operator.zip

15. 4.15 Not Exists Operator

16.1 4.16 and or operator.zip

16. 4.16 AND OR Operator

17.1 4.17 merge join.zip

17. 4.17 Merge Join

18.1 4.18 like operator.zip

18. 4.18 Like Operator

19.1 4.19 solution code challenge in between operator.zip

19. 4.19 CODE Challenge IN BETWEEN Operator

20.1 4.19 solution code challenge in between operator.zip

20. 4.19 Solution CODE Challenge IN BETWEEN Operator

21.1 4.20 code challenge joins and where clause.zip

21. 4.20 CODE Challenge JOINS and Where Clause

22.1 4.20 solution code challenge joins and where clause.zip

22. 4.20 Solution CODE Challenge JOINS and Where Clause

5. Module 5

1.1 5.1 sum.zip

1. 5.1 SUM

2.1 5.2 max.zip

2. 5.2 MAX

3.1 5.3 min.zip

3. 5.3 MIN

4.1 5.4 count.zip

4. 5.4 COUNT

5.1 5.5 avg.zip

5. 5.5 AVG

6.1 5.6 group by.zip

6. 5.6 GROUP BY

7.1 5.7 having clause.zip

7. 5.7 HAVING CLAUSE

8.1 5.8 is null.zip

8. 5.8 IS NULL

9.1 5.9 code example sum with having clause.zip

9. 5.9 Code Example SUM with Having Clause

10.1 5.10 coalesce.zip

10. 5.10 COALESCE

11.1 5.11 nullif.zip

11. 5.11 NULLIF

12.1 5.12 case statement.zip

12. 5.12 CASE Statement

13.1 5.13 code challenge aggregate function.zip

13. 5.13 CODE Challenge Aggregate Function

14.1 5.13 solution code challenge aggregate function.zip

14. 5.13 Solution CODE Challenge Aggregate Function

15.1 5.14 code challenge case statement and coalesce function.zip

15. 5.14 CODE Challenge CASE Statement and COALESCE Function

16.1 5.14 solution code challenge case statement andcoalesce function.zip

16. 5.14 Solution CODE Challenge CASE Statement and COALESCE Function

6. Module 6

1. 6.1 Data Manipulation Language(DML)

2.1 6.2 select.zip

2. 6.2 Select

3.1 6.3 insert.zip

3. 6.3 Insert

4.1 6.4 update.zip

4. 6.4 Update

5.1 6.5 delete.zip

5. 6.5 Delete

6. 6.6 Data definition language(DDL)

7.1 6.7 create.zip

7. 6.7 Create

8.1 6.8 alter.zip

8. 6.8 Alter

9.1 6.9 drop.zip

9. 6.9 Drop

10.1 6.10 truncate.zip

10. 6.10 Truncate

11. 6.11 Data Control Language (DCL)

12.1 6.12 grant.zip

12. 6.12 Grant

13.1 6.13 revoke.zip

13. 6.13 Revoke

14. 6.14 Transactional Control Language(TCL)

15.1 6.15 commit.zip

15. 6.15 Commit

16.1 6.16 rollback.zip

16. 6.16 RollBack

17.1 6.17 save point.zip

17. 6.17 Save Point

18.1 6.18 code challenge dm and ddl.zip

18. 6.18 CODE Challenge DML and DDL

19.1 6.18 solution code challenge dml and ddl.zip

19. 6.18 Solution CODE Challenge DML and DDL

7. Module 7

1.1 7.1 store procedure.zip

1. 7.1 Store Procedure

2.1 7.2 store procedure with parameters.zip

2. 7.2 Store Procedure With Parameters

3.1 7.3 store procedure with default parameter.zip

3. 7.3 Store Procedure With Default Parameter

4.1 7.4 alter and drop store procedure.zip

4. 7.4 ALTER And Drop Store Procedure

5. 7.5 Function

6.1 7.6 scalar function.zip

6. 7.6 Scalar Function

7.1 7.7 table valued function.zip

7. 7.7 Table Valued Function

8.1 7.8 local temp table.zip

8. 7.8 Local Temporary Table

9.1 7.9 global temp table.zip

9. 7.9 Global Temporary Table

10.1 7.10 table variable.zip

10. 7.10 Table Variable

11.1 7.11 trigger.zip

11. 7.11a Trigger and DML Trigger

12.1 7.11 trigger.zip

12. 7.11b DDL Trigger ,Disable and Drop Trigger

13.1 7.12 merge statement.zip

13. 7.12 Merge Statement

14.1 7.13 common table expression.zip

14. 7.13 Common Table Expression

15. 7.14 Ranking Function

16.1 7.15 row number function.zip

16. 7.15 Row number function

17.1 7.16 rank & dense rank.zip

17. 7.16 Rank & Dense Rank

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training