English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 77 lectures (8h 14m) | 6.20 GB
SQL Server: Key Techniques in Index Optimization, Data Integrity, Advanced SQL Programming, and Transaction Management.
Unlock your potential as a database professional with our in-depth MCSA SQL Server Certification course, focusing on Developing SQL Databases. Guided by a seasoned database development expert, this course is meticulously crafted to empower both beginners and experienced SQL users to master the essentials and advanced techniques of SQL Server.
In this comprehensive program, you will embark on a journey through both on-premise and cloud-based SQL database environments. With a clear, approachable teaching style, our expert instructor will ensure you not only understand theoretical concepts but also apply them practically in real-world scenarios.
What You Will Learn:
- Database Design Mastery: Learn to architect robust SQL databases that stand as the backbone of any enterprise. From the initial file creation to complex data types and structured tables, you will gain the confidence to design and operate databases efficiently.
- Index Optimization: Discover strategies for planning, creating, and optimizing indexes to enhance database performance and user experience.
- Data Integrity and Availability: Explore techniques to maintain and ensure data integrity and availability, crucial for the smooth operation of business applications.
- Advanced SQL Features: Gain hands-on experience with views, stored procedures, and functions to manage data effectively and streamline processes.
- Transaction and Lock Management: Understand the nuances of managing transactions and locks to maintain data consistency and avoid deadlocks in a multi-user environment.
- Practical Implementation: Through examples and detailed code walkthroughs, you will learn how to implement and troubleshoot SQL solutions effectively, preparing you for real-world challenges.
Course Curriculum Highlights:
- SQL Server Essentials: From installation to understanding SQL Server management and database structures.
- Table Design and Implementation: Dive into table creation, normalization, and utilizing SQL data types and schemas.
- Advanced Data Management: Learn about constraints, index management, and working with in-memory and temporal tables.
- Programming SQL Server: Master the art of creating stored procedures, triggers, and user-defined functions.
This course is not just about learning; it’s about transforming into a skilled database developer equipped with all the tools necessary to excel in the field of database management. Whether you’re aiming to pass the SQL Server certification or to enhance your professional abilities, this course will lay down the path to your success in the world of databases.
Table of Contents
Welcome
1 Introduction
2 Comprehensive Course Overview
Course Materials & Source Code
Fundamentals of SQL Server
3 Introduction to SQL Server Platform
4 Fundamental Concepts of Databases
5 Understanding Database Structures
6 Introduction to Transact-SQL
Installation and Setup of SQL Server
7 How to Obtain SQL Server
8 Step-by-Step Installation of SQL Server
9 Installing SQL Server Management Studio
10 Attaching a Sample Database
11 Verifying the SQL Server Installation
Database and Table Design
12 Creating and Configuring a New Database
13 Database Options and Settings
14 Fundamentals of SQL Server Tables
15 Data Types in SQL Server Best Practices
16 The Role of Data Types in SQL Design
17 Principles of Normalization
18 Designing Relationships Between Tables
19 Understanding and Utilizing Schemas
20 Table Design Fundamentals
21 Scripting Tables with T-SQL
22 Graphical Table Creation in SQL Server
23 Implementing Identity Columns Part 1
24 Implementing Identity Columns Part 2
25 Modifying Tables with T-SQL Part 1
26 Modifying Tables with T-SQL Part 2
Advanced Table Design Techniques
27 Ensuring Data Integrity in SQL Server
28 Using Constraints to Enforce Rules
29 Primary and Foreign Key Fundamentals
30 Adding Constraints to Tables Part 1
31 Adding Constraints to Tables Part 2
32 Utilizing Filegroups in Database Design
33 Implementing Table Partitions
34 Introduction to Temporal Tables
35 Managing Temporal Tables Part 1
36 Managing Temporal Tables Part 2
37 Utilizing In-Memory Tables Part 1
38 Utilizing In-Memory Tables Part 2
39 Script Generation Techniques
Indexing in SQL Server
40 Basics of SQL Server Indexes
41 Differentiating Clustered and Nonclustered Indexes Part 1
42 Differentiating Clustered and Nonclustered Indexes Part 2
43 Understanding Covered Indexes
44 Techniques for Creating Indexes
45 Working with Columnstore Indexes
46 Understanding Index Management
47 Index Management Rebuilding and Reorganizing
Implementing and Managing Views
48 Introduction to SQL Server Views
49 Creating Views in SQL Server
50 Principles of Updateable Views
51 Managing Indexed Views
Transaction Management
52 Understanding Transactions in SQL Server Part 1
53 Understanding Transactions in SQL Server Part 2
54 Overview of the Transaction Log
55 Working with Explicit Transactions
56 Using Savepoints in Transactions Part 1
57 Using Savepoints in Transactions Part 2
Stored Procedures in SQL Server
58 Introduction to Stored Procedures
59 Creating Stored Procedures
60 Employing Input Parameters
61 Employing Output Parameters
62 Working with Table-Valued Parameters Part 1
63 Working with Table-Valued Parameters Part 2
64 Managing Return Status in Procedures Part 1
65 Managing Return Status in Procedures Part 2
66 Utilizing Natively Compiled Stored Procedures
Triggers in SQL Server
67 Overview of Triggers
68 Implementing Instead Of Triggers
69 Configuring After Triggers
70 Working with Inserted and Deleted Tables
User-Defined Functions in SQL Server
71 Introduction to User-Defined Functions
72 Creating Scalar Functions
73 Implementing Table-Valued Functions
Course Conclusion
74 Course Wrap-Up and Final Thoughts
Resolve the captcha to access the links!