99 queries to master SQL in less than 4 hours!
Come and discover in this 4-hour course how to quickly make your first queries in Transact SQL.
4.83 (3 reviews)
29
students
5 hours
content
Jun 2024
last update
$34.99
regular price
What you will 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.
A long chapter on SQL joins (INNER JOIN, LEFT and RIGHT JOIN, FULL OUTER JOIN,and so on).
Screenshots
Related Topics
3735986
udemy ID
12/29/2020
course created date
3/7/2021
course indexed date
Bot
course submited by