SQL Server: Der Masterclass-Kurs 2022 (27 Stunden)

Master SQL Server: From Beginner to Performance Expert (German Subtitles)

This comprehensive SQL Server course, presented in English with German subtitles, is your ultimate resource for mastering this powerful database system. You won't find a more complete offering of these crucial topics on Udemy!

Chapter 1: Transact-SQL for Everyone (10 Hours)

• SQL Server & Management Studio Setup: Learn to install SQL Server and Management Studio on your system.
• Database & Table Creation: Master the fundamentals of creating and defining databases and tables.
• Essential T-SQL Commands: Get hands-on with SELECT, UPDATE, INSERT, and DELETE statements.
• Data Manipulation & Filtering: Explore column aliases, the nuances of LIKE operator, and the power of TOP.
• Data Cleaning & Comparison: Remove duplicates with DISTINCT, understand comparison operators (=, !=, etc.).
• Data Copying: Efficiently copy tables using SELECT INTO.
• Logical Operators: Become proficient with IN, NOT IN, IS, and IS NOT.
• Data Sorting: Learn to sort data effectively with ORDER BY.
• Aggregate Functions: Utilize MIN, MAX, AVG, COUNT, and SUM along with AND and OR operators.
• Data Range Filtering: Use BETWEEN to select data within a specific range.
• Data Grouping: Group results with GROUP BY.
• Database Joins: Master INNER JOIN, LEFT/RIGHT JOIN, and FULL OUTER JOIN for combining data from multiple tables.
• Advanced T-SQL: Explore CHOOSE, IIF, CASE WHEN, SUBSTRING, OFFSET FETCH NEXT ROWS.
• String & Data Functions: Discover CHOOSE, TRIM/LTRIM/RTRIM, COALESCE, CAST, CONVERT, TRY_CAST, TRY_CONVERT, TRY_PARSE, and PARSE.
• Common Table Expressions (CTEs): Unlock the power of CTEs for complex queries.
• Temporary, Variable & Global Tables: Understand the differences between these table types.
• String Manipulation: Learn STRING SPLIT, STUFF, and MERGE functions.
• Ranking Functions: Deep dive into ROW_NUMBER, OVER, PARTITION BY, ROWS/RANGE UNBOUNDED PRECEDING, FIRST/LAST VALUES, LAG, and LEAD.

Chapter 2: SQL Server Administration (11 Hours)

• Backup & Restore: Learn to create a robust backup and restore strategy for production servers.
• Database Corruption: Identify and repair database corruption – a common issue with Microsoft SQL Server.
• Database Configuration: Master database configuration and modification, including understanding AUTO_GROW and options like TRUSTWORTHY and DB_CHAINING.
• Isolation Modes: Understand and utilize different isolation modes (READ COMMITTED, SERIALIZABLE, SNAPSHOT).
• Constraints: Learn about Primary Keys (PK), Foreign Keys (FK), Check Constraints, and Unique Constraints.
• Sequences & Identity: Explore the use of sequences and identity columns.

Chapter 3: Optimizing SQL Server Performance (6 Hours)

• Indexing: A comprehensive look at indexing strategies to significantly improve SQL Server performance.
• SARGable Queries: Learn to rewrite SQL queries for better performance by creating SARGable (Search ARGument able) queries.
• Performance Tuning Techniques: Discover techniques to optimize your SQL queries and database operations.

Chapter 4: SQL Server Interview Preparation (40 Questions & Answers)

• Ace Your SQL Interview: Prepare for SQL Server job interviews with 40 frequently asked questions and detailed answers.
• Common Interview Topics: Cover essential concepts like primary keys, indexes, OLAP vs. OLTP, and the COALESCE function.
• Duplicate Removal: Learn how to efficiently remove duplicates from your SQL queries.

New Content (Added 2024 - Free for Existing Purchasers):

• SQL Server Security: (2 Hours) Learn how to configure security on your SQL Server.
• SQL Server Management with PowerShell: (3 Hours) Manage your SQL Server using PowerShell.
• Stored Procedure Performance: (2 Hours) Improve the performance of stored procedures.
• SQL Azure: (3 Hours) An introduction to SQL Azure.