SQL Server Certification: Developing SQL Databases

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

SQL Server: Key Techniques in Index Optimization, Data Integrity, Advanced SQL Programming, and Transaction Management.

1 - Welcome

1 -Introduction

2 -Comprehensive Course Overview

2 - Course Materials & Source Code

1 -Developing SQL Databases - Working Files.zip

3 - Fundamentals of SQL Server

1 -Introduction to SQL Server Platform

2 -Fundamental Concepts of Databases

3 -Understanding Database Structures

4 -Introduction to Transact-SQL

4 - Installation and Setup of SQL Server

1 -How to Obtain SQL Server

1 -en sql server 2016 developer x64 dvd.zip

2 -Step-by-Step Installation of SQL Server

3 -Installing SQL Server Management Studio

4 -Attaching a Sample Database

5 -Verifying the SQL Server Installation

5 - Database and Table Design

1 -Creating and Configuring a New Database

2 -Database Options and Settings

3 -Fundamentals of SQL Server Tables

4 -Data Types in SQL Server Best Practices

5 -The Role of Data Types in SQL Design

6 -Principles of Normalization

7 -Designing Relationships Between Tables

8 -Understanding and Utilizing Schemas

9 -Table Design Fundamentals

10 -Scripting Tables with T-SQL

11 -Graphical Table Creation in SQL Server

12 -Implementing Identity Columns Part 1

13 -Implementing Identity Columns Part 2

14 -Modifying Tables with T-SQL Part 1

15 -Modifying Tables with T-SQL Part 2

6 - Advanced Table Design Techniques

1 -Ensuring Data Integrity in SQL Server

2 -Using Constraints to Enforce Rules

3 -Primary and Foreign Key Fundamentals

4 -Adding Constraints to Tables Part 1

5 -Adding Constraints to Tables Part 2

6 -Utilizing Filegroups in Database Design

7 -Implementing Table Partitions

8 -Introduction to Temporal Tables

9 -Managing Temporal Tables Part 1

10 -Managing Temporal Tables Part 2

11 -Utilizing In-Memory Tables Part 1

12 -Utilizing In-Memory Tables Part 2

13 -Script Generation Techniques

7 - Indexing in SQL Server

1 -Basics of SQL Server Indexes

2 -Differentiating Clustered and Nonclustered Indexes Part 1

3 -Differentiating Clustered and Nonclustered Indexes Part 2

4 -Understanding Covered Indexes

5 -Techniques for Creating Indexes

6 -Working with Columnstore Indexes

7 -Understanding Index Management

8 -Index Management Rebuilding and Reorganizing

8 - Implementing and Managing Views

1 -Introduction to SQL Server Views

2 -Creating Views in SQL Server

3 -Principles of Updateable Views

4 -Managing Indexed Views

9 - Transaction Management

1 -Understanding Transactions in SQL Server Part 1

2 -Understanding Transactions in SQL Server Part 2

3 -Overview of the Transaction Log

4 -Working with Explicit Transactions

5 -Using Savepoints in Transactions Part 1

6 -Using Savepoints in Transactions Part 2

10 - Stored Procedures in SQL Server

1 -Introduction to Stored Procedures

2 -Creating Stored Procedures

3 -Employing Input Parameters

4 -Employing Output Parameters

5 -Working with Table-Valued Parameters Part 1

6 -Working with Table-Valued Parameters Part 2

7 -Managing Return Status in Procedures Part 1

8 -Managing Return Status in Procedures Part 2

9 -Utilizing Natively Compiled Stored Procedures

11 - Triggers in SQL Server

1 -Overview of Triggers

2 -Implementing Instead Of Triggers

3 -Configuring After Triggers

4 -Working with Inserted and Deleted Tables

12 - User-Defined Functions in SQL Server

1 -Introduction to User-Defined Functions

2 -Creating Scalar Functions

3 -Implementing Table-Valued Functions

13 - Course Conclusion

1 -Course Wrap-Up and Final Thoughts

189,000 تومان

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

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

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

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