SQL Server : The Masterclass course 2021 (21 hrs of class)

⚡⚡ Would you like to benefit from this course for a price between 12 and 16 dollars ? Then send me an email to [email protected] ⚡⚡

Become (really) an expert on SQL Server, through this 21-hour Masterclass course with more than 80 exercises ! 

This course will help you to pass the Microsoft certifications: 70-462, 70-764 and 70-765 concerning the administration of a SQL server. and also the certifications 70-461 and 70-763 concerning the Transact SQL (From SELECT query to advanced SQL. Exams for SQL Server 2012, 2014, 2016, 2017, 2019)

You will not find another course on the Udemy platform which includes these 3 very important chapters on SQL Server :

Chapter 1 : Transact SQL for the absolute beginner and also experienced developers (10 hours of class):

• Let's start by installing SQL Server and management studio on your workstation.

• The creation and definition of a database and a table.

• Let's start playing with data with SELECT,UPDATE,INSERT and DELETE

• Discover the column aliases and tackle the specificity and secrets of LIKE.

• Do you know the usefulness of the TOP ?

• Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and so on

• Copying a table with the SELECT INTO.

• Let's talk about the IN, NOT IN, IS and IS NOT operators, and Sort your data with ORDER BY.

• Discover aggregate functions with MIN MAX and AVG and the two operators AND,OR.

• Let's discover the specificity of COUNT and SUM and how to SELECT a range of data with the BETWEEN

• Group several results with the GROUP BY

• A long chapter of one hour and 30 minutes on joins with  INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on..

• Let's discover the specificity of UNION and UNION ALL,and the LEFT and RIGHT function.

• Have you heard of the CHOOSE, TRIM/LTRIM/RTIM ?

• Let's go even further with Transact SQL with the IIF,CASE WHEN,OFFSET FETCH NEXT ROWS.

• Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT.

• Let's approach the DATE type functions with DATEADD,DATEDIFF,GETDATE (), EOMONTH ...

• Let's deepen our knowledge of TSQL even more With IF/ELSE, STRING SPLIT,STUFF,MERGE…

• The creation and definition of a view and Stored Procedure,function, schéma and trigger.

• A very long chapter on RANKING functions such as ROW_NUMBER, OVER and PARTITION BY, ROWS /RANGE UNBOUNDED PRECEDING, FIRST and LAST VALUES, LAG and LEAD,ROW_NUMBER, DENSE _RANK, RANK, NTILE.

• We will discover a one hour course on CTE (common table expression). So powerful and so little known (I still don't understand by the way) and the derived table.

• Do you know the difference between Temporary tables, Variable tables and Global tables?

Chapter 2: The complete administration of a SQL Server (7 hours of class) :

• Tackle BACKUP and RESTORE for 3 hours, we will see in detail in this course, how to set up a robust and reliable strategy, to guarantee your data on a production server.

  
  

• In another 2 hour course, we will learn how to detect and repair corruption on a database. Did you know that Microsoft logs over 1000 support cases per day regarding corruption! And you, how would you react in case of corruption?

  
  

• We will also discuss during 3 hours, the configuration and modification of your database on SQL. Did you know that a bad Autogrow set on your database, can make you lose 60% of your performance? Do you know the TRUSTWORTHY or DB_CHAINING option? Everything is covered in this course, and believe me, you will be surprised at the number of options on a DB that SQL Server offers.

  
  

Chapter 3: How to improve performance on your production SQL server (4 hours).

• If we are talking about performance, we will of course be talking about indexes. This is a good thing because it will be covered in this chapter for 4 hours. A good implementation of your indexes can really save your performance on your SQL server. I strongly advise you to look at this chapter, to perhaps avoid going into huge costs of buying servers, which may not be necessary...

  
  

• Do you know SARGABLE queries? I let you discover it in this chapter, to rewrite your SQL queries, in a better way, and thus of course, better performance.

There will be many new sections added in 2021, of course if you have already purchased this course, these new modules will be free for you.

Here are the sections that will arrive in 2021:

• How to set up your security on your SQL Server ? (2 hours of class)

• How to administer your SQL server with powershell? (3 hours of class)

• Improve the performance of stored procedures  (2 hours of class)

• Let's go together on SQL Azure ! (3 hours of class)

• Of course there are more than 100 exercises and corrections in this course.

This course will have an estimated duration of between 30 and 40 hours once completed.