Master SQL Server: Advanced Query & Optimization Pro 2024
Focused View
5:41:24
1 - Course Introduction.mp4
01:21
2 - Section 1 Introduction to SQL.html
2 - Untitled-video-Made-with-Clipchamp-1.mp4
07:06
3 - Setting Up the Environment.mp4
05:00
4 - Understanding Databases.mp4
06:22
5 - Create Manual DB Table.mp4
11:36
6 - 1Introduction to SQL Syntax.mp4
08:14
6 - Data-examples.xlsx
7 - 2Working more SELECT Statements.mp4
07:02
8 - Insert Command.mp4
10:21
9 - More into Insert.mp4
13:15
10 - Update Command.mp4
10:01
11 - Delete Command.mp4
16:24
12 - String functions.mp4
16:28
12 - String-functions.txt
13 - Date Functions.mp4
15:22
14 - Aggregate functions.mp4
10:30
14 - aggregation-function.txt
15 - Mathematicla functions.mp4
06:44
15 - mathematioal-functions.txt
16 - Conditional Functions.mp4
11:39
17 - 1Joins and Relationships.mp4
14:49
17 - joins.txt
18 - Joins Practise Task.mp4
14:49
18 - Solutions.docx
18 - task-joins.txt
19 - 2Subqueries.mp4
13:47
19 - subquerries.txt
20 - Rank function.mp4
12:02
21 - View.mp4
06:08
22 - Error Handling.mp4
05:16
22 - error-handling.txt
23 - Window functions.mp4
13:29
23 - windows-functions.txt
24 - Unions.mp4
03:28
24 - Unions.txt
25 - 2Advanced Subqueries.mp4
22:17
25 - Subquerries.txt
26 - Temporary tables.mp4
05:52
26 - Temporary-tables.txt
27 - CTE.txt
27 - Common Table Expression CTE.mp4
05:27
28 - Functions UserDefined Functions.mp4
08:11
28 - User-defined-functions.txt
29 - TableValued Functions TVFs.mp4
14:53
29 - Table-valued-functions.txt
30 - Stored Procedure.mp4
20:37
30 - Stored-procedure.txt
31 - Normalization and Denormalization.mp4
06:03
32 - Creating and Managing Indexes.mp4
10:19
32 - Creating-and-Managing-Indexes.txt
33 - Query Optimization Techniques.mp4
06:32
33 - querry-optimization-consepts.txt
34 - 1Project 1 Building a Simple Ecommerce Database.html
35 - 2Project 2 Data Analysis with SQL.html
36 - Expressing Gratitude and Offering Support.html
More details
Course Overview
Transform from SQL beginner to expert with this comprehensive MSSQL course covering advanced queries, performance optimization, stored procedures, and real-world database projects.
What You'll Learn
- Master complex joins, subqueries, window functions and CTEs
- Optimize database performance with indexing and query tuning
- Implement stored procedures and user-defined functions
Who This Is For
- Data analysts wanting advanced SQL Server skills
- Developers needing database optimization expertise
- Career changers pursuing database administration
Key Benefits
- Hands-on projects including e-commerce database build
- Professional error handling and temporary data techniques
- Skills applicable to BI, analytics and application development
Curriculum Highlights
- Advanced query techniques with joins and subqueries
- SQL Server functions and stored procedures
- Performance tuning and real-world applications
Focused display
Category
- language english
- Training sessions 33
- duration 5:41:24
- Release Date 2025/04/15
