SQL Server 2022 : The 28 hour Masterclass course (16 in 1)
SQL Server 2022 : The 28 hour Masterclass course (16 in 1), available at $64.99, has an average rating of 3.36, with 397 lectures, based on 295 reviews, and has 1912 subscribers.
You will learn about Learn the SQL language from A to Z (10 hours of lessons). To administer an SQL server ( 13 hours of lessons ). Greatly improve the performance of your SQL Server engine ( 4 hours of lessons ). And take a virtual interview at the end of the course with these 40 questions and 40 answers! + 80 practical exercises are in this course to consolidate your knowledge! In short, become a real expert on SQL server (and that's very much in demand). This course is ideal for individuals who are Future Database Administrators (DBA) or Developers who want to learn about SQL or BI consultants working on technologies other than SQL Server (Oracle etc…) or Students who want to get started on SQL or Tech leads (CRM, Web etc…) who want to discover SQL It is particularly useful for Future Database Administrators (DBA) or Developers who want to learn about SQL or BI consultants working on technologies other than SQL Server (Oracle etc…) or Students who want to get started on SQL or Tech leads (CRM, Web etc…) who want to discover SQL.
Enroll now: SQL Server 2022 : The 28 hour Masterclass course (16 in 1)
Summary
Title: SQL Server 2022 : The 28 hour Masterclass course (16 in 1)
Price: $64.99
Average Rating: 3.36
Number of Lectures: 397
Number of Published Lectures: 394
Number of Curriculum Items: 397
Number of Published Curriculum Objects: 394
Original Price: €89.99
Quality Status: approved
Status: Live
What You Will Learn
- Learn the SQL language from A to Z (10 hours of lessons).
- To administer an SQL server ( 13 hours of lessons ).
- Greatly improve the performance of your SQL Server engine ( 4 hours of lessons ).
- And take a virtual interview at the end of the course with these 40 questions and 40 answers!
- + 80 practical exercises are in this course to consolidate your knowledge!
- In short, become a real expert on SQL server (and that's very much in demand).
Who Should Attend
- Future Database Administrators (DBA)
- Developers who want to learn about SQL
- BI consultants working on technologies other than SQL Server (Oracle etc…)
- Students who want to get started on SQL
- Tech leads (CRM, Web etc…) who want to discover SQL
Target Audiences
- Future Database Administrators (DBA)
- Developers who want to learn about SQL
- BI consultants working on technologies other than SQL Server (Oracle etc…)
- Students who want to get started on SQL
- Tech leads (CRM, Web etc…) who want to discover SQL
This course also takes the new SQL Server version 2022(new features such as GREATEST, LEAST, WINDOWS, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES are discussed)
Welcome to the richest and most comprehensive course on the Udemy platform about SQL Server.
This course lists the 16 courses in my catalogue:
-
SQL Server for complete beginners (7 hours of practice + 80 practical exercises)
-
Learn the in-demand job of developer SQL
-
The Complete SQL Server 2019 Database Administration Course
-
SQL Server 2019 : Administration SQL Server Part 1
-
SQL Server 2019 : Administration SQL Server Part 2
-
SQL Server 2019 : Administration SQL Server Part 3
-
The complete course about BACKUP and RESTORE
-
Detecting and Correcting Database Corruption
-
SQL Server: Configuring and modifying a database on SQL
-
99 queries to master SQL in less than 4 hours!
-
SQL Server: The complete course on Indexes
-
Learn the in-demand job of DBASQL Server
-
SQL Server: Security and Privilege Management
-
Come and challenge the Transact SQL with these 50 exercises
-
Joins, partition functions, and CTE in Transact SQL 2019.
-
Prepare your future interview on SQL Server (with these 40 questions and 40 answers ! )
I challenge you to find in a single course 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 and TOP.
-
Learn how to remove duplicates with the DISTINCT and discover the Comparison operators = != and 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 and Group several results with the GROUP BY
-
A long chapter of 1h30 minutes on JOINSwith 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.
-
Let’s go even further with Transact SQL with the IIF,CASE WHEN,OFFSET FETCH NEXT ROWS and CHOOSE.
-
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 chapterof 1h30 minutes 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 (11 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 casesper 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.
-
Administration rhymes with precaution, and therefore of course with security. We will discuss security and privilege management during 2 hours. We will learn how to set up a robust and secure SQL server.
-
We will cover a long chapter on the different isolation modes (READ COMMITED, SERIALIZABLE, SNAPSHOT…), we will also see the different types of constraints(PK,FK,CHECK,UNIQUE…), as well as SEQUENCES, and IDENTITY.
-
We will also discuss the change data capture (CDC), many new features released on SQL Server 2016 such as Row Level Security, Dynamic Data Masking (DDM), Temporal Data.
◉ 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.
◉ Chapter 4:Come and take a virtual interview through these 40 questions and 40 theoretical answers.
-
Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.
-
You are a Java developer or Python for example, you go to an interview, you don’t really know what to review beforehand, this is a summary of the most frequently asked questions.
-
For example :What is a primary key ? what is an index? What is the difference between OLAP and OLTP ? Do you know the COALLESCE function ? or how do you remove duplicates with your query ?
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 :
-
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.
Course Curriculum
Chapter 1: Setting up your environment
Lecture 1: Presentation and overview
Lecture 2: Small explanation on the subtitles
Lecture 3: Tools for working
Lecture 4: Installation of SQL Server
Lecture 5: Installation of Management Studio
Lecture 6: First use of Management Studio
Lecture 7: Presentation of my new platform ELOA FORMATION, join me 🙂
Lecture 8: Let me introduce myself, and my company
Chapter 2: **** Part 1 : The Transact SQL (10 hours of class) ***
Lecture 1: Welcome on the first chapter about the Transact SQL
Chapter 3: Let's create our first wonderful database !
Lecture 1: What is a Database?
Lecture 2: Demo: How to create a database in SQL Server ?
Lecture 3: Demo: How to delete and modify the name of a database ?
Lecture 4: Database Exercise
Lecture 5: Corrected Exercise on the database
Chapter 4: Let's create our first fantastic table !
Lecture 1: What is a table ?
Lecture 2: Démo : How to create a table ?
Lecture 3: Démo : How to modify and delete a table ?
Lecture 4: Exercise on the table
Lecture 5: Corrected for the exercise on the table
Chapter 5: Let's start playing with data with SELECT,UPDATE,INSERT and DELETE
Lecture 1: Démo :Let's learn how to insert data with INSERT
Lecture 2: Démo : Discover the SELECT statement
Lecture 3: Démo : Discover the UPDATE statement
Lecture 4: Démo: let's talk about DELETE statement in this vidéo
Lecture 5: Démo : How to make an UPDATE on two columns ?
Lecture 6: Démo : The comments and square brackets utility on SQL
Lecture 7: How to INSERT several identical values at once ?
Chapter 6: Exercise and correction 1 to 5 on SELECT,UPDATE,INSERT,DELETE
Lecture 1: Exercise 1
Lecture 2: Exercise 2
Lecture 3: Exercise 3
Lecture 4: Exercise 4
Lecture 5: Exercise 5
Lecture 6: Correction Exercise 1
Lecture 7: Correction Exercise 2
Lecture 8: Correction Exercise 3
Lecture 9: Correction Exercise 4
Lecture 10: Correction Exercise 5
Lecture 11: Focus on previous sessions
Chapter 7: Let's go a little further in the SQL transact (DISTINCT,LIKE ..)
Lecture 1: Démo : Discover the column aliases
Lecture 2: Démo : Tackle the secrets of LIKE
Lecture 3: Démo : Do you know the usefulness of the TOP ?
Lecture 4: Démo : Remove duplicates with the DISTINCT
Lecture 5: Demo :Comparison operators = != and so on
Lecture 6: Demo :The IN, NOT IN, IS and IS NOT operators
Lecture 7: Démo: How to copy a table with the SELECT INTO ?
Chapter 8: Exercise and correction 6 to 16 (DISTINCT,LIKE …)
Lecture 1: Exercise 6
Lecture 2: Exercise 7
Lecture 3: Exercise 8
Lecture 4: Exercise 9
Lecture 5: Exercise 10
Lecture 6: Exercise 11
Lecture 7: Exercise 12
Lecture 8: Exercise 13
Lecture 9: Exercise 14
Lecture 10: Exercise 15
Lecture 11: Exercise 16
Lecture 12: Correction of exercise 6 to 16
Chapter 9: Let's go even further with Transact SQL (AND,OR, MIN,MAX…)
Lecture 1: What are we going to discuss in this second part on the Transact SQL?
Lecture 2: Démo : Let's talk about the AND,OR operators.
Lecture 3: Démo : Sort your data with ORDER BY
Lecture 4: Démo : Discover aggregate functions with MIN MAX and AVG
Lecture 5: Démo : Let's discover the COUNT and SUM
Lecture 6: Démo : How to SELECT a range of data with the BETWEEN
Lecture 7: Démo : Group several results with the GROUP BY
Lecture 8: Démo : Let's discover the specificities of HAVING
Lecture 9: Démo : Let's talk about the PRINT
Lecture 10: Focus on previous sessions
Chapter 10: Exercise and correction 17 to 25 (AND,OR, MIN,MAX…)
Lecture 1: Exercise 17
Lecture 2: Exercise 18
Lecture 3: Exercise 19
Lecture 4: Exercise 20
Lecture 5: Exercise 21
Lecture 6: Exercise 22
Lecture 7: Exercise 23
Lecture 8: Exercise 24
Lecture 9: Exercise 25
Lecture 10: Correction Exercise 17 to 25 on part 2
Chapter 11: Learn to combine data with the power of JOINS
Lecture 1: Introduction on the Joins
Lecture 2: Démo: INNER JOIN
Lecture 3: Démo: LEFT and RIGHT JOIN
Lecture 4: Démo: FULL OUTER JOIN
Lecture 5: Démo : The CROSS JOIN
Lecture 6: Démo : The CROSS APPLY and OUTER APPLY
Lecture 7: Démo: How to make a join with several tables ?
Lecture 8: Démo: Update a table with JOIN
Lecture 9: Démo: LEFT JOIN VS NOT IN VS NOT EXISTS
Lecture 10: Démo : Do you know EXECPT and INTERSECT ?
Lecture 11: Démo : Do You know the HINT on the joins ?
Chapter 12: Exercise and correction 26 to 33 on the joins
Lecture 1: Set up exercises on the joins
Instructors
-
ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.
Join the masterclass SQL Server course !
Rating Distribution
- 1 stars: 16 votes
- 2 stars: 11 votes
- 3 stars: 38 votes
- 4 stars: 72 votes
- 5 stars: 158 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024