SQL Server: El curso Masterclass 2022 (20 horas)

Become a SQL Server expert with this comprehensive Masterclass! This 20-hour course, packed with over 80 exercises, will equip you with the skills to excel in SQL Server administration and prepare you for Microsoft certifications including 70-462, 70-764, and 70-765. We also cover 70-461 and 70-763 certifications, covering everything from basic Transact SQL queries to advanced techniques. This course is designed for SQL Server 2012, 2014, 2016, 2017, and 2019 exams.

What sets this course apart? You won't find this depth in any other Udemy course! We dedicate three crucial chapters to mastering SQL Server:

Chapter 1: Transact SQL for Beginners to Advanced Users (10 hours)

• SQL Server & Management Studio Setup: Learn to install SQL Server and Management Studio on your workstation.
• Database & Table Creation: Master the creation and definition of databases and tables.
• Data Manipulation (DML): Become proficient with SELECT, UPDATE, INSERT, and DELETE statements.
• Advanced Querying: Explore column aliases, the nuances of LIKE operator, and the power of TOP.
• Data Filtering & Duplicates: Learn to remove duplicate data using DISTINCT, and master comparison operators like =, !=.
• Data Copying: Efficiently copy tables using SELECT INTO.
• Logical Operators: Understand and utilize IN, NOT IN, IS, and IS NOT.
• Data Ordering: Master ORDER BY for sorting your data.
• Aggregate Functions: Utilize MIN, MAX, AVG, COUNT, and SUM along with AND, OR operators.
• Data Range Selection: Learn to select specific data ranges using BETWEEN.
• Grouping Data: Master GROUP BY for data aggregation.
• Joins: A deep dive into INNER JOIN, LEFT/RIGHT JOIN, and FULL OUTER JOIN.
• UNION & Subqueries: Explore UNION, UNION ALL, and the LEFT and RIGHT functions.
• String Manipulation: Learn CHOOSE, TRIM, LTRIM, and RTRIM.
• Advanced Functions: Master IIF, CASE WHEN, OFFSET FETCH NEXT ROWS.
• Data Conversion: Understand CAST, CONVERT, TRY_CAST, TRY_CONVERT, TRY_PARSE, and PARSE.
• Database Objects: Create and define views, stored procedures, functions, schemas, and triggers.
• Ranking Functions: Unlock the power of ROW_NUMBER, OVER, PARTITION BY, ROWS/RANGE UNBOUNDED PRECEDING, FIRST/LAST VALUES, LAG, LEAD, DENSE_RANK, RANK, and NTILE.
• Common Table Expressions (CTEs) & Derived Tables: Master CTEs and derived tables for complex queries.
• Temporary, Variable, and Global Tables: Understand the differences and use cases for each table type.

Chapter 2: Complete SQL Server Administration (6 hours)

• Backup & Restore: Learn to implement a robust backup and restore strategy for your SQL Server environment.
• Database Corruption: Detect and repair database corruption – a critical skill!
• Database Configuration: Master SQL Server configuration and modification, including understanding options like Autogrow, TRUSTWORTHY, and DB_CHAINING. Avoid performance pitfalls caused by incorrect configuration!

Chapter 3: SQL Server Performance Optimization (4 hours)

• Indexing: A comprehensive look at indexing techniques to dramatically improve SQL Server performance.
• SARGable Queries: Discover how to write SARGable queries for optimal performance. Avoid costly server upgrades by optimizing your queries!

New Content Added in 2021 (Free for Existing Students):

• SQL Server Security Configuration (2 hours)
• SQL Server Administration with PowerShell (3 hours)
• Optimizing Stored Procedures (2 hours)
• Introduction to SQL Azure (3 hours)

This course includes over 100 exercises and solutions. Estimated completion time: 30-40 hours. Start your journey to becoming a SQL Server professional today!