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 !

Created by: ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.
Join the masterclass SQL Server course !

What Will I 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 !

Requirements

• Have a strong desire to learn and a PC in great shape 🙂

Target audience

• Beginners who don't know anything about SQL Server, and who want to get started.
• Future Database Administrators (DBAs)
• Developers who want to learn about TSQL
• BI consultants working on technologies other than SQL Server (Oracle etc...)