The Complete Dummies Guide for SQL with Microsoft SQL Server

سرفصل های دوره

Beginner to Advanced Guide to Learn SQL with Microsoft SQL Server. Covering All Basics to Advanced with Examples

1. Course Introduction and Table of Contents

1. Course Introduction and Table of Contents

2. Introduction to Database and Database Management Systems

1. Introduction to Database and Database Management Systems

3. Introduction to RDBMS and NonRDBMS

1. Introduction to RDBMS and NonRDBMS

4. Types of SQL Commands

1. Types of SQL Commands

5. Installing MSSQL

1. Installing MSSQL

6. Basic DB Operations

1. Basic DB Operations - Part 1

2. Basic DB Operations - Part 2

7. Basic Table Operations

1. Basic Table Operations - Part 1

2. Basic Table Operations - Part 2

3. Basic Table Operations - Part 3

4. Basic Table Operations - Part 4

8. Sample Databases Import

1. Sample Databases Import

9. Aggregate Functions in MSSQL

1. Aggregate Functions in MSSQL - Part 1

2. Aggregate Functions in MSSQL - Part 2

10. Clauses in MSSQL

1. Clauses in MSSQL - Part 1

2. Clauses in MSSQL - Part 2

3. Clauses in MSSQL - Part 3

11. Grouping Sets Clause

1. Grouping Sets Clause - Part 1

2. Grouping Sets Clause - Part 2

12. SQL Basic Operators

1. SQL Basic Operators - Part 1

2. SQL Basic Operators - Part 2

13. Union and Intersect operators

1. Union and Intersect operators

14. Popular Datatypes Introduction

1. Popular Datatypes Introduction - Part 1

2. Popular Datatypes Introduction - Part 2

15. Popular Datatypes Example

1. Popular Datatypes Example

16. Constraints - Primary Key

1. Constraints - Primary Key - part 1

2. Constraints - Primary Key - part 2

17. Constraints - Foreign Key

1. Constraints - Foreign Key - Part 1

2. Constraints - Foreign Key - Part 2

18. NOT NULL and UNIQUE constraints

1. NOT NULL and UNIQUE constraints - Part 1

2. NOT NULL and UNIQUE constraints - Part 2

19. CHECK and DEFAULT constraints

1. CHECK and DEFAULT constraints - Part 1

2. CHECK and DEFAULT constraints - Part 2

20. ER Diagram Overview

1. ER Diagram Overview

21. SQL Popular String Functions

1. SQL Popular String Functions - Part 1

2. SQL Popular String Functions - Part 2

22. SQL Popular Date Functions

1. SQL Popular Date Functions - Part 1

2. SQL Popular Date Functions - Part 2

23. SQL Popular Mathematical Functions

1. SQL Popular Mathematical Functions

24. SQL Popular Convert Functions

1. SQL Popular Convert Functions

25. Joins - Introduction and Table Preparation

1. Joins - Introduction and Table Preparation - Part 1

2. Joins - Introduction and Table Preparation - Part 2

3. Joins - Introduction and Table Preparation - Part 3

26. Inner Join

1. Inner Join

27. Outer Join

1. Outer Join

28. Self Join

1. Self Join

29. Cross Join

1. Cross Join

30. Stored Procedure Basics

1. Stored Procedure Basics - Part 1

2. Stored Procedure Basics - Part 2

31. Stored Procedure Passing Params and Return

1. Stored Procedure Passing Params and Return

32. SQL SubQueries

1. SQL SubQueries

33. SQL Views

1. SQL Views

34. SQL Triggers - DDL Triggers

1. SQL Triggers - DDL Triggers

35. SQL Triggers - DML Trigger

1. SQL Triggers DML Trigger - Part 1

2. SQL Triggers DML Trigger - Part 2

36. SQL Transactions

1. SQL Transactions - Part 1

2. SQL Transactions - Part 2

37. Normalization

1. Normalization

38. DB Backup and Restore

1. DB Backup and Restore

39. Securing the Database

1. Securing the Database

139,000 تومان

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

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

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

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