SQL Server 2022 for complete beginners (7 hours of practice)

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

4.67 (91 reviews)

Udemy

platform

English

language

Other

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.

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

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.

And more than 50 practical exercises !

Course Gallery

SQL Server 2022 for complete beginners (7 hours of practice) – Screenshot 1 — Screenshot 1 – SQL Server 2022 for complete beginners (7 hours of practice)

SQL Server 2022 for complete beginners (7 hours of practice) – Screenshot 2 — Screenshot 2 – SQL Server 2022 for complete beginners (7 hours of practice)

SQL Server 2022 for complete beginners (7 hours of practice) – Screenshot 3 — Screenshot 3 – SQL Server 2022 for complete beginners (7 hours of practice)

SQL Server 2022 for complete beginners (7 hours of practice) – Screenshot 4 — Screenshot 4 – SQL Server 2022 for complete beginners (7 hours of practice)

Loading charts...

SQL Server 2022 for complete beginners (7 hours of practice)

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.

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

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.

And more than 50 practical exercises !

Course Gallery

Related Topics