Udemybeginnerpl

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!

4.1(22)
147students
18h 59m
Certificate
Olivier Thuillier Administracja, TSQL oraz wydajność serwera SQL.
Olivier Thuillier Administracja, TSQL oraz wydajność serwera SQL.Dołącz do kursu Masterclass SQL Server!

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, and DELETE data.
  • Advanced SQL Techniques: Master column aliases, LIKE operator nuances, TOP clause, DISTINCT for duplicate removal, comparison operators (!=), and SELECT INTO.
  • Data Sorting & Filtering: Utilize IN, NOT IN, IS, IS NOT, and ORDER BY for data sorting.
  • Aggregate Functions: Explore MIN, MAX, AVG, COUNT, and SUM along with GROUP BY, HAVING, and PRINT.
  • Joins: Understand and implement INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL 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, and RIGHT.
  • Data Type Conversion: Master CAST and CONVERT, TRY_CAST, and TRY_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, and NTILE.
  • 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 DBCC commands 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!

$ whoami — the devs behind tutorialsearch.io

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.