Udemy - SQL Server Certification Developing SQL Databases (4.2024)

1 - Welcome/1 -Introduction.mp4

9.46 MB

1 - Welcome/1 -Introduction.vtt

1.55 KB

1 - Welcome/2 -Comprehensive Course Overview.mp4

24.08 MB

1 - Welcome/2 -Comprehensive Course Overview.vtt

9.26 KB

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

48.05 MB

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

10.52 KB

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

85.59 MB

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

7.97 KB

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

76.77 MB

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

7.09 KB

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

90.1 MB

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

9.58 KB

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

56.56 MB

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

10.65 KB

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

72.25 MB

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

8.83 KB

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

68.64 MB

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

10.16 KB

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

46.49 MB

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

5.52 KB

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

57.61 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

33.88 MB

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

9.22 KB

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

78.87 MB

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

8.86 KB

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

73.61 MB

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

9.22 KB

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

34.01 MB

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

7.69 KB

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

41.84 MB

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

9.53 KB

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

86.04 MB

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

9.79 KB

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

85.88 MB

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

9.52 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.64 KB

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

40.19 MB

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

44.27 MB

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

11.15 KB

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

31.69 MB

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

7.63 KB

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

39.69 MB

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

8.77 KB

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

32.58 MB

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

7.81 KB

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

2.53 GB

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

32.31 MB

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

8.87 KB

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

53.31 MB

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

13.32 KB

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

20.5 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.39 MB

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

8.27 KB

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

41.45 MB

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

7.42 KB

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

58.37 MB

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

11.96 KB

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

68.5 MB

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

10.71 KB

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

58.29 MB

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

9.51 KB

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

64.64 MB

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

8.33 KB

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

53.19 MB

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

5.95 KB

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

79.75 MB

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

12.26 KB

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

37.78 MB

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

4.69 KB

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

44.01 MB

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

13.05 KB

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

33.08 MB

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

7.66 KB

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

50.15 MB

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

12.28 KB

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

28.36 MB

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

7.32 KB

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

50.57 MB

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

13.78 KB

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

37.72 MB

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

9.09 KB

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

56.24 MB

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

12.39 KB

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

31.19 MB

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

8.93 KB

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

32.11 MB

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

9.58 KB

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

65.05 MB

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

5.96 KB

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

46.37 MB

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

11.22 KB

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

16.49 MB

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

4.51 KB

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

77.21 MB

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

10.58 KB

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

43.04 MB

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

12.55 KB

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

35.85 MB

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

7.83 KB

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

85.34 MB

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

9.91 KB

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

56.93 MB

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

6.85 KB

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

38.96 MB

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

10.38 KB

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

47.2 MB

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

11.6 KB

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

35.56 MB

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

11.08 KB

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

75.54 MB

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

10.61 KB

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

45.02 MB

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

11.17 KB

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

47.16 MB

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

11.54 KB

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

36.99 MB

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

6.28 KB

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

33.51 MB

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

6.81 KB

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

57.8 MB

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

7.64 KB

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

45.26 MB

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

10.51 KB

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

31.45 MB

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

7.53 KB

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

57.96 MB

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

6.79 KB

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

39.28 MB

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

11.57 KB

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

86.52 MB

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

8.94 KB

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

23.85 MB

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

5.64 KB

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

63.46 MB

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

8.93 KB

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

45.51 MB

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

12.57 KB

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

24.97 MB

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

6.38 KB

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

56.08 MB

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

13.14 KB

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

87.96 MB

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

8.64 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.95 KB

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

33.43 MB

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

3.76 KB

资源详情

免责声明