MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 241 lectures (12h 38m) | Size: 6.23 GB
Learn SQL in this 12-hour course the job of developer on SQL Server 2019 with more 80 exercices !
What you'll learn:
Set up your environment by installing Management Studio and SQL Server.
Creating, deleting and modifying a database and a table
Learning how to select data with the SELECT,Updating data with the UPDATE,Deleting data with DELETE and INSERT
Rename columns with aliases and Select a certain number of lines with the TOP
The usefulness of square brackets and comments on SQL
The IN, NOT IN, IS and IS NOT operators and Comparison operators = !=
Sort the data with the ORDER BY and Aggregate functions: MIN, MAV and AVG
Remove duplicates with the DISTINCT and Copying a table via SELECT INTO
AND and OR,BETWEEN operators and the HAVING.
Let's combine the data with GROUP BY and the PRINT command.
A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on).
Let's discover the specificities of UNION and UNION ALL,and the LEFT and RIGHT function.
Let's go even further with Transact SQL with the CHOOSE,IIF,CASE WHEN,SUBSTRING, OFFSET FETCH NEXT ROWS.
Have you heard of the CHOOSE, TRIM/LTRIM/RTIM or COALLESCE function?
Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT, as well as TRY_PARSE and PARSE.
Discover the score functions (ROW_NUMBER,OVER PARTITION BY, LAG and LEAD,ROWS /RANGE UNBOUNDED PRECEDING, FIRST_VALUES and LAST_VALUES)
Create, modify and delete a view and a stored procedure
Tackle the little-known CTE (Common table expression)
And more than 50 practical exercises !
Requirements
Just a computer under Windows, the installation of your environment is explained in this course
Description
Developer SQL is nowadays a full time assured job, it is an extremely sought after job in the working world.
************ After installing Management Studio and SQL Server you will learn : ************************
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.
The creation and definition of a 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?
We will do a little performance by discovering the term SARGABLE.
******* And at the end of the course take a virtual interview to prepare for your future interview on SQL *******
Start out more confident by tackling all these theoretical questions, so that you can face an interview on SQL.
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 ?
******* Important points about this course ********
This course covers all SQL Server versions, even SQL Server 2019.
This online course is 12h00 hours of demo and 30 minutes of theory. Theory is in the classroom, not in this course
I made sure that the videos are not too soporific, and that they don't exceed 10 minutes.
Taking this course will help you to stand out technically from your colleagues, or during a job interview.
This course will help you to pass the Microsoft certifications 70-461 and 70-761 concerning the Transact SQL (From SELECT query to advanced SQL. Exams for SQL Server 2012, 2014, 2016, 2017, 2019)
If you really want to become more proficient in TSQL, frankly you won't find anywhere else a course as in-depth as this one, I can guarantee it!
Who this course is for
Future Database Administrators (DBAs)
Developers who want to learn about TSQL
BI consultants working on technologies other than SQL Server (Oracle etc...)
Students who want to start using SQL
Tech leads (CRM, Web etc...) who want to discover TSQL
