SQL Server: The complete bootcamp for dumnies (6h of class)

Learn how to write the first queries and more in Transact SQL, with 40 practical exercises in SQL Server 2019!

⚡⚡ If you want to benefit from this course at a price of 10 euros, send me an email to [email protected], I will send you the discount coupon within the day ⚡⚡

What you’ll learn

Set up your environment by installing Management Studio and SQL Server..
Creating, deleting and modifying a database.
Create, delete and modify 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..
Learning the different types of columns (VARCHAR, CHAR, INT,DATETIME,GUID etc…).
A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on)..
Adding, deleting, modifying a column on a table.
Create, modify and delete a view and a stored procedure.
And more than 50 practical exercises !.

Course Content

Let’s Set Up our working environment installing Management Studio and SQL Server –> 7 lectures • 27min.
Let’s create our first wonderful database ! –> 5 lectures • 15min.
Let’s create our first fantastic table ! –> 5 lectures • 18min.
Let’s start playing with data with SELECT,UPDATE,INSERT and DELETE –> 7 lectures • 35min.
Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE –> 5 lectures • 3min.
Correction Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE –> 6 lectures • 9min.
Let’s go a little further in the SQL transact part 1 (DISTINCT,LIKE and so on..) –> 7 lectures • 42min.
Exercise 6 to 16 on Transact SQL Part 1 (DISTINCT,LIKE …) –> 11 lectures • 3min.
Correction Exercise 6 to 16 on part 1 (DISTINCT,LIKE…..) –> 1 lecture • 11min.
Let’s go even further with Transact SQL Part 2 (AND,OR, MIN,MAX and so on…) –> 9 lectures • 50min.

Requirements

Have a strong desire to learn and a PC in great shape :).

⚡⚡ If you want to benefit from this course at a price of 10 euros, send me an email to [email protected], I will send you the discount coupon within the day ⚡⚡

✔ Do you know absolutely nothing about SQL Server and want to get started with this technology?

✔ Do you want to learn how to write your very first queries in Transact SQL?

✅ Then this course is for you!

✏ In this course we will cover these different chapters:

Install SQL Server and management studio on your workstation.
The creation and definition of a database
The creation and definition of a table
Select, update, delete and insert data (SELECT,INSERT,UPDATE,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 specificities of COUNT and SUM and how to SELECT a range of data with the BETWEEN
Group several results with the GROUP BY and Let’s discover the specificities of HAVING and the PRINT.
The joins with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on
The creation and definition of a view.
The creation and definition of a Stored Procedure.
The creation and definition of a trigger.
Creating and defining a function.