Kurs SQL Server Masterclass 2022 (19 godzin)
Become a SQL Server expert! Learn development, DBA skills, and performance optimization for SQL Server 2019. Boost your career!
Course Content
Kurs SQL Server Masterclass 2022 (19 godzin) is a beginner-level Udemy course taught by Olivier Thuillier Administracja, TSQL oraz wydajność serwera SQL.. It runs 18h 59m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.1 out of 5 from 22 reviews, with 147 students enrolled. It is a paid course, last updated November 2022.
Become a SQL Server expert with this comprehensive Masterclass! This 16-hour course, featuring over 50 exercises, will equip you with the skills to ace your Microsoft SQL Server certifications: 70-462, 70-764, and 70-765 for SQL Server administration. Also covers 70-461 and 70-761 certifications focusing on Transact-SQL (T-SQL), from basic queries to advanced techniques. This course is perfect for SQL Server 2012, 2014, 2016, 2017, and 2019 exams.
The Masterclass is structured into three modules:
Module 1: Transact-SQL (T-SQL) Fundamentals (6 hours)
- SQL Server Setup: Install SQL Server and SQL Server Management Studio (SSMS).
- Database & Table Management: Create and define databases and tables.
- Data Manipulation (CRUD): Learn to
SELECT,INSERT,UPDATE, andDELETEdata. - Advanced SQL Techniques: Master column aliases,
LIKEoperator nuances,TOPclause,DISTINCTfor duplicate removal, comparison operators (!=), andSELECT INTO. - Data Sorting & Filtering: Utilize
IN,NOT IN,IS,IS NOT, andORDER BYfor data sorting. - Aggregate Functions: Explore
MIN,MAX,AVG,COUNT, andSUMalong withGROUP BY,HAVING, andPRINT. - Joins: Understand and implement
INNER JOIN,LEFT JOIN,RIGHT JOIN, andFULL OUTER JOIN. - String Manipulation: Use
CHOOSE,IIF,CASE WHEN,SUBSTRING,OFFSET FETCH NEXT ROWS. - String Functions: Learn
TRIM,LTRIM,RTRIM,COALESCE,UNION,UNION ALL,LEFT, andRIGHT. - Data Type Conversion: Master
CASTandCONVERT,TRY_CAST, andTRY_CONVERT. - Date & Time Functions: Utilize
DATEADD,DATEDIFF,GETDATE(),EOMONTH, and more. - Advanced T-SQL: Dive into
IF/ELSE,STRING SPLIT,STUFF,MERGE. - Database Objects: Create and define views, stored procedures, functions, schemas, and triggers.
- Window Functions: Deep dive into powerful ranking functions like
ROW_NUMBER,OVER,PARTITION BY,ROWS/RANGE UNBOUNDED PRECEDING,FIRST/LAST VALUES,LAG,LEAD,DENSE_RANK,RANK, andNTILE. - Common Table Expressions (CTEs): Unlock the power of CTEs and derived tables with a dedicated, in-depth module.
- Temporary Tables: Understand the differences between temporary, table variables, and global temporary tables.
Module 2: SQL Server Administration (5 hours)
- Backup & Restore: Master SQL Server backup and restore strategies, including TAIL LOG BACKUP.
- Database Corruption: Learn to detect and repair database corruption with practical techniques.
- Corruption Prevention: Understand the causes of database corruption and how to configure SQL Server for automatic error detection and consistency checks. Learn to use
DBCCcommands for consistency checks.
Module 3: SQL Server Performance Tuning (3 hours)
- Indexing: Learn the importance of indexing and how to optimize query performance with clustered and non-clustered indexes. Understand
FILLFACTOR.
New Content Added in 2021 (Free for Existing Customers):
- Database Configuration and Modification
- SQL Server Security Configuration
- SQL Server Administration with PowerShell
- Optimizing Stored Procedure Performance
- SQL Azure Overview
This course includes over 100 exercises and corrections. Estimated completion time: 30-40 hours. Start your journey to becoming a SQL Server expert today!
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.