Udemy - SQL Server Certification Developing SQL Databases (4.2024)

File Name

Size

1 - Welcome/1 -Introduction.mp4

9.5 MB

1 - Welcome/1 -Introduction.vtt

1.6 kB

1 - Welcome/2 -Comprehensive Course Overview.mp4

24 MB

1 - Welcome/2 -Comprehensive Course Overview.vtt

9.3 kB

10 - Stored Procedures in SQL Server/1 -Introduction to Stored Procedures.mp4

48 MB

10 - Stored Procedures in SQL Server/1 -Introduction to Stored Procedures.vtt

10 kB

10 - Stored Procedures in SQL Server/2 -Creating Stored Procedures.mp4

86 MB

10 - Stored Procedures in SQL Server/2 -Creating Stored Procedures.vtt

8.0 kB

10 - Stored Procedures in SQL Server/3 -Employing Input Parameters.mp4

77 MB

10 - Stored Procedures in SQL Server/3 -Employing Input Parameters.vtt

7.1 kB

10 - Stored Procedures in SQL Server/4 -Employing Output Parameters.mp4

90 MB

10 - Stored Procedures in SQL Server/4 -Employing Output Parameters.vtt

9.6 kB

10 - Stored Procedures in SQL Server/5 -Working with Table-Valued Parameters Part 1.mp4

57 MB

10 - Stored Procedures in SQL Server/5 -Working with Table-Valued Parameters Part 1.vtt

11 kB

10 - Stored Procedures in SQL Server/6 -Working with Table-Valued Parameters Part 2.mp4

72 MB

10 - Stored Procedures in SQL Server/6 -Working with Table-Valued Parameters Part 2.vtt

8.8 kB

10 - Stored Procedures in SQL Server/7 -Managing Return Status in Procedures Part 1.mp4

69 MB

10 - Stored Procedures in SQL Server/7 -Managing Return Status in Procedures Part 1.vtt

10 kB

10 - Stored Procedures in SQL Server/8 -Managing Return Status in Procedures Part 2.mp4

46 MB

10 - Stored Procedures in SQL Server/8 -Managing Return Status in Procedures Part 2.vtt

5.5 kB

10 - Stored Procedures in SQL Server/9 -Utilizing Natively Compiled Stored Procedures.mp4

58 MB

10 - Stored Procedures in SQL Server/9 -Utilizing Natively Compiled Stored Procedures.vtt

9.3 kB

11 - Triggers in SQL Server/1 -Overview of Triggers.mp4

34 MB

11 - Triggers in SQL Server/1 -Overview of Triggers.vtt

9.2 kB

11 - Triggers in SQL Server/2 -Implementing Instead Of Triggers.mp4

79 MB

11 - Triggers in SQL Server/2 -Implementing Instead Of Triggers.vtt

8.9 kB

11 - Triggers in SQL Server/3 -Configuring After Triggers.mp4

74 MB

11 - Triggers in SQL Server/3 -Configuring After Triggers.vtt

9.2 kB

11 - Triggers in SQL Server/4 -Working with Inserted and Deleted Tables.mp4

34 MB

11 - Triggers in SQL Server/4 -Working with Inserted and Deleted Tables.vtt

7.7 kB

12 - User-Defined Functions in SQL Server/1 -Introduction to User-Defined Functions.mp4

42 MB

12 - User-Defined Functions in SQL Server/1 -Introduction to User-Defined Functions.vtt

9.5 kB

12 - User-Defined Functions in SQL Server/2 -Creating Scalar Functions.mp4

86 MB

12 - User-Defined Functions in SQL Server/2 -Creating Scalar Functions.vtt

9.8 kB

12 - User-Defined Functions in SQL Server/3 -Implementing Table-Valued Functions.mp4

86 MB

12 - User-Defined Functions in SQL Server/3 -Implementing Table-Valued Functions.vtt

9.5 kB

13 - Course Conclusion/1 -Course Wrap-Up and Final Thoughts.mp4

7.1 MB

13 - Course Conclusion/1 -Course Wrap-Up and Final Thoughts.vtt

2.6 kB

2 - Course Materials & Source Code/1 -Developing SQL Databases - Working Files.zip

40 MB

3 - Fundamentals of SQL Server/1 -Introduction to SQL Server Platform.mp4

44 MB

3 - Fundamentals of SQL Server/1 -Introduction to SQL Server Platform.vtt

11 kB

3 - Fundamentals of SQL Server/2 -Fundamental Concepts of Databases.mp4

32 MB

3 - Fundamentals of SQL Server/2 -Fundamental Concepts of Databases.vtt

7.6 kB

3 - Fundamentals of SQL Server/3 -Understanding Database Structures.mp4

40 MB

3 - Fundamentals of SQL Server/3 -Understanding Database Structures.vtt

8.8 kB

3 - Fundamentals of SQL Server/4 -Introduction to Transact-SQL.mp4

33 MB

3 - Fundamentals of SQL Server/4 -Introduction to Transact-SQL.vtt

7.8 kB

4 - Installation and Setup of SQL Server/1 -en_sql_server_2016_developer_x64_dvd.iso

2.5 GB

4 - Installation and Setup of SQL Server/1 -How to Obtain SQL Server.mp4

32 MB

4 - Installation and Setup of SQL Server/1 -How to Obtain SQL Server.vtt

8.9 kB

4 - Installation and Setup of SQL Server/2 -Step-by-Step Installation of SQL Server.mp4

53 MB

4 - Installation and Setup of SQL Server/2 -Step-by-Step Installation of SQL Server.vtt

13 kB

4 - Installation and Setup of SQL Server/3 -Installing SQL Server Management Studio.mp4

20 MB

4 - Installation and Setup of SQL Server/3 -Installing SQL Server Management Studio.vtt

4.8 kB

4 - Installation and Setup of SQL Server/4 -Attaching a Sample Database.mp4

47 MB

4 - Installation and Setup of SQL Server/4 -Attaching a Sample Database.vtt

8.3 kB

4 - Installation and Setup of SQL Server/5 -Verifying the SQL Server Installation.mp4

42 MB

4 - Installation and Setup of SQL Server/5 -Verifying the SQL Server Installation.vtt

7.4 kB

5 - Database and Table Design/1 -Creating and Configuring a New Database.mp4

58 MB

5 - Database and Table Design/1 -Creating and Configuring a New Database.vtt

12 kB

5 - Database and Table Design/10 -Scripting Tables with T-SQL.mp4

68 MB

5 - Database and Table Design/10 -Scripting Tables with T-SQL.vtt

11 kB

5 - Database and Table Design/11 -Graphical Table Creation in SQL Server.mp4

58 MB

5 - Database and Table Design/11 -Graphical Table Creation in SQL Server.vtt

9.5 kB

5 - Database and Table Design/12 -Implementing Identity Columns Part 1.mp4

65 MB

5 - Database and Table Design/12 -Implementing Identity Columns Part 1.vtt

8.3 kB

5 - Database and Table Design/13 -Implementing Identity Columns Part 2.mp4

53 MB

5 - Database and Table Design/13 -Implementing Identity Columns Part 2.vtt

5.9 kB

5 - Database and Table Design/14 -Modifying Tables with T-SQL Part 1.mp4

80 MB

5 - Database and Table Design/14 -Modifying Tables with T-SQL Part 1.vtt

12 kB

5 - Database and Table Design/15 -Modifying Tables with T-SQL Part 2.mp4

38 MB

5 - Database and Table Design/15 -Modifying Tables with T-SQL Part 2.vtt

4.7 kB

5 - Database and Table Design/2 -Database Options and Settings.mp4

44 MB

5 - Database and Table Design/2 -Database Options and Settings.vtt

13 kB

5 - Database and Table Design/3 -Fundamentals of SQL Server Tables.mp4

33 MB

5 - Database and Table Design/3 -Fundamentals of SQL Server Tables.vtt

7.7 kB

5 - Database and Table Design/4 -Data Types in SQL Server Best Practices.mp4

50 MB

5 - Database and Table Design/4 -Data Types in SQL Server Best Practices.vtt

12 kB

5 - Database and Table Design/5 -The Role of Data Types in SQL Design.mp4

28 MB

5 - Database and Table Design/5 -The Role of Data Types in SQL Design.vtt

7.3 kB

5 - Database and Table Design/6 -Principles of Normalization.mp4

51 MB

5 - Database and Table Design/6 -Principles of Normalization.vtt

14 kB

5 - Database and Table Design/7 -Designing Relationships Between Tables.mp4

38 MB

5 - Database and Table Design/7 -Designing Relationships Between Tables.vtt

9.1 kB

5 - Database and Table Design/8 -Understanding and Utilizing Schemas.mp4

56 MB

5 - Database and Table Design/8 -Understanding and Utilizing Schemas.vtt

12 kB

5 - Database and Table Design/9 -Table Design Fundamentals.mp4

31 MB

5 - Database and Table Design/9 -Table Design Fundamentals.vtt

8.9 kB

6 - Advanced Table Design Techniques/1 -Ensuring Data Integrity in SQL Server.mp4

32 MB

6 - Advanced Table Design Techniques/1 -Ensuring Data Integrity in SQL Server.vtt

9.6 kB

6 - Advanced Table Design Techniques/10 -Managing Temporal Tables Part 2.mp4

65 MB

6 - Advanced Table Design Techniques/10 -Managing Temporal Tables Part 2.vtt

6.0 kB

6 - Advanced Table Design Techniques/11 -Utilizing In-Memory Tables Part 1.mp4

46 MB

6 - Advanced Table Design Techniques/11 -Utilizing In-Memory Tables Part 1.vtt

11 kB

6 - Advanced Table Design Techniques/12 -Utilizing In-Memory Tables Part 2.mp4

16 MB

6 - Advanced Table Design Techniques/12 -Utilizing In-Memory Tables Part 2.vtt

4.5 kB

6 - Advanced Table Design Techniques/13 -Script Generation Techniques.mp4

77 MB

6 - Advanced Table Design Techniques/13 -Script Generation Techniques.vtt

11 kB

6 - Advanced Table Design Techniques/2 -Using Constraints to Enforce Rules.mp4

43 MB

6 - Advanced Table Design Techniques/2 -Using Constraints to Enforce Rules.vtt

12 kB

6 - Advanced Table Design Techniques/3 -Primary and Foreign Key Fundamentals.mp4

36 MB

6 - Advanced Table Design Techniques/3 -Primary and Foreign Key Fundamentals.vtt

7.8 kB

6 - Advanced Table Design Techniques/4 -Adding Constraints to Tables Part 1.mp4

85 MB

6 - Advanced Table Design Techniques/4 -Adding Constraints to Tables Part 1.vtt

9.9 kB

6 - Advanced Table Design Techniques/5 -Adding Constraints to Tables Part 2.mp4

57 MB

6 - Advanced Table Design Techniques/5 -Adding Constraints to Tables Part 2.vtt

6.9 kB

6 - Advanced Table Design Techniques/6 -Utilizing Filegroups in Database Design.mp4

39 MB

6 - Advanced Table Design Techniques/6 -Utilizing Filegroups in Database Design.vtt

10 kB

6 - Advanced Table Design Techniques/7 -Implementing Table Partitions.mp4

47 MB

6 - Advanced Table Design Techniques/7 -Implementing Table Partitions.vtt

12 kB

6 - Advanced Table Design Techniques/8 -Introduction to Temporal Tables.mp4

36 MB

6 - Advanced Table Design Techniques/8 -Introduction to Temporal Tables.vtt

11 kB

6 - Advanced Table Design Techniques/9 -Managing Temporal Tables Part 1.mp4

76 MB

6 - Advanced Table Design Techniques/9 -Managing Temporal Tables Part 1.vtt

11 kB

7 - Indexing in SQL Server/1 -Basics of SQL Server Indexes.mp4

45 MB

7 - Indexing in SQL Server/1 -Basics of SQL Server Indexes.vtt

11 kB

7 - Indexing in SQL Server/2 -Differentiating Clustered and Nonclustered Indexes Part 1.mp4

47 MB

7 - Indexing in SQL Server/2 -Differentiating Clustered and Nonclustered Indexes Part 1.vtt

12 kB

7 - Indexing in SQL Server/3 -Differentiating Clustered and Nonclustered Indexes Part 2.mp4

37 MB

7 - Indexing in SQL Server/3 -Differentiating Clustered and Nonclustered Indexes Part 2.vtt

6.3 kB

7 - Indexing in SQL Server/4 -Understanding Covered Indexes.mp4

34 MB

7 - Indexing in SQL Server/4 -Understanding Covered Indexes.vtt

6.8 kB

7 - Indexing in SQL Server/5 -Techniques for Creating Indexes.mp4

58 MB

7 - Indexing in SQL Server/5 -Techniques for Creating Indexes.vtt

7.6 kB

7 - Indexing in SQL Server/6 -Working with Columnstore Indexes.mp4

45 MB

7 - Indexing in SQL Server/6 -Working with Columnstore Indexes.vtt

10 kB

7 - Indexing in SQL Server/7 -Understanding Index Management.mp4

31 MB

7 - Indexing in SQL Server/7 -Understanding Index Management.vtt

7.5 kB

7 - Indexing in SQL Server/8 -Index Management Rebuilding and Reorganizing.mp4

58 MB

7 - Indexing in SQL Server/8 -Index Management Rebuilding and Reorganizing.vtt

6.8 kB

8 - Implementing and Managing Views/1 -Introduction to SQL Server Views.mp4

39 MB

8 - Implementing and Managing Views/1 -Introduction to SQL Server Views.vtt

12 kB

8 - Implementing and Managing Views/2 -Creating Views in SQL Server.mp4

86 MB

8 - Implementing and Managing Views/2 -Creating Views in SQL Server.vtt

8.9 kB

8 - Implementing and Managing Views/3 -Principles of Updateable Views.mp4

24 MB

8 - Implementing and Managing Views/3 -Principles of Updateable Views.vtt

5.6 kB

8 - Implementing and Managing Views/4 -Managing Indexed Views.mp4

64 MB

8 - Implementing and Managing Views/4 -Managing Indexed Views.vtt

8.9 kB

9 - Transaction Management/1 -Understanding Transactions in SQL Server Part 1.mp4

46 MB

9 - Transaction Management/1 -Understanding Transactions in SQL Server Part 1.vtt

13 kB

9 - Transaction Management/2 -Understanding Transactions in SQL Server Part 2.mp4

25 MB

9 - Transaction Management/2 -Understanding Transactions in SQL Server Part 2.vtt

6.4 kB

9 - Transaction Management/3 -Overview of the Transaction Log.mp4

56 MB

9 - Transaction Management/3 -Overview of the Transaction Log.vtt

13 kB

9 - Transaction Management/4 -Working with Explicit Transactions.mp4

88 MB

9 - Transaction Management/4 -Working with Explicit Transactions.vtt

8.6 kB

9 - Transaction Management/5 -Using Savepoints in Transactions Part 1.mp4

73 MB

9 - Transaction Management/5 -Using Savepoints in Transactions Part 1.vtt

9.9 kB

9 - Transaction Management/6 -Using Savepoints in Transactions Part 2.mp4

33 MB

9 - Transaction Management/6 -Using Savepoints in Transactions Part 2.vtt

3.8 kB