Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: SQL Server 2022 for complete beginners (7 hours of practice)
Rating: 4.7 (93 reviews)

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

Last updated 6/2024

English

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
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 content

24 sections • 135 lectures • 7h 15m total length

Small explanation on the subtitles0:47
Presentation and overview4:49
Tools for working1:54
Installation of SQL Server9:38
Installation of Management Studio2:07
Install SQL Server Management Studio, download components, and connect to the server. The beginner session guides you through selecting the right version and completing the setup.
First use of Management Studio5:14
Launch SQL Server Management Studio, connect to a database, explore with Object Explorer, create a database, and run a new query to practice basic SQL.

What is a Database?2:10
Understand how a database organizes data by storing and retrieving information, and why centralizing scattered data into a single database makes querying easier and reduces obsolete data.
Demo: How to create a database in SQL Server ?4:06
Demo: How to delete and modify the name of a database ?3:09
Learn to rename a database and drop a database in SQL Server 2022 using T-SQL and graphical tools.
Database Exercise0:52
Tackle a database exercise in SQL Server 2022 for complete beginners. Work through questions about creating exercises, renaming them to exercise two, and proceed after this exercise.
Corrected Exercise on the database4:36
Create a database named exercise, execute the query, and refresh to verify; then rename to exercise, alter the name, and drop the database.

What is a table ?1:54
Explore the basics of databases and tables in a database management system, including rows and columns, column naming, and how to create tables with the simple create table syntax.
Démo : How to create a table ?7:37
Learn to use the current database and create a two-column table with proper syntax, including commas and parentheses, in this SQL Server 2022 beginner demonstration.
Démo : How to modify and delete a table ?4:18
Learn how to modify and delete a table in SQL Server 2022, including renaming a table, dropping it, and refreshing to confirm the change.
Exercice on the table0:44
Corrected for the exercise on the table3:39
Correct the exercise by presenting the solution, apply the proper sql syntax, write the query, create and drop the table, and verify results with a refresh.

Démo :Let's learn how to insert data with INSERT9:08
Démo : Discover the SELECT statement7:53
We have inserted data, we have data on the table, now we have to select them and sometimes we can even filter the data.
In this demo, we are going to discover the SELECT, which will allow us to bring back and filter the data in the table we have created before.
Démo : Discover the UPDATE statement5:00
We have inserted the data, selected them, filtered them with the WHERE clause, now, we are going to update data.
Updating data on SQL is launched with a simple UPDATE.
Démo: let's talk about DELETE statement in this vidéo3:48
Démo : How to make an UPDATE on two columns ?3:34
Learn how to update two columns in a single statement in SQL Server 2022, using comma-separated assignments to change nicknames and first names, with date updates as needed.
Démo : The comments and square brackets utility on SQL5:16
Démo : How to INSERT several identical values at once ?2:51

Exercise 11:38
Begin with exercise 1 in SQL Server 2022 for complete beginners to practice entering your name and an age of four numbers, then follow prompts to answer the first question.
Exercise 20:53
Practice exercise 2 guides beginners in SQL Server 2022 to set five values with corresponding ages, including 18, 16, 17, 23, and 22.
Exercise 30:13
Exercise 40:11
Exercise 50:16
Engage in exercise 5 to practice with a table, focusing on naming choices and resolving the final question in this beginner SQL Server 2022 module.

Correction Exercise 12:05
Practice correction exercise 1 guides students through creating a student record, correcting the first name and the name, and refreshing the table to verify corrections.
Correction Exercise 21:44
Practice correcting an insert into a student table, focusing on column order. Insert five rows with the first name Quidam and the corresponding age to demonstrate the process.
Correction Exercise 30:55
Correction Exercise 41:28
Work through correction exercise 4 to explore how data and digital-age concepts apply to SQL Server 2022 for complete beginners.
Correction Exercise 51:17
Focus on previous sessions1:35
Explore building and querying a database in SQL Server 2022, inserting and filtering data, and advancing queries with transactions, distinct, select into, and order by.

Démo : Discover the column aliases4:37
Explore how to create column aliases in SQL Server 2022, using the as syntax to rename fields like name to nickname and run a live demo from select statements.
Démo : Tackle the secrets of LIKE9:12
Explore how the like operator refines filters with pattern matching and wildcards, using practical examples on names and birth dates, plus a wizard for combining characters to target searches.
Démo : Do you know the usefulness of the TOP ?5:12
This demo explains the usefulness of the TOP clause in SQL Server 2022, showing how to retrieve the first N rows (1, 5, 100, 1000) and perform simple row operations.
Démo : Remove duplicates with the DISTINCT2:14
Demo :Comparison operators = != and so on7:40
Explore SQL comparison operators, including =, !=, <, <=, >, and >=, through hands-on demo queries that filter ages, count rows, and compare different syntax forms.
Demo :The IN, NOT IN, IS and IS NOT operators8:28
Explore how to use the IN, NOT IN, IS, and IS NOT operators in SQL Server 2022, with hands-on queries filtering by name and date of birth.
Démo: How to copy a table with the SELECT INTO ?4:43
Demonstrates copying a table with select into, duplicating the main table or subsets of data, and creating a backup before changes. Shows filter-driven copies using where clauses for specific rows.

Exercise 60:46
Begin the exercise by answering the first question: remove duplicates in the age field, and learn by doing to improve quickly without cheating.
Exercise 70:22
Exercise 80:11
Exercise 90:08
Exercise 100:12
Exercise 10 in SQL Server 2022 for complete beginners presents two different ways to achieve equal outcomes, applying beginner-friendly practice to SQL tasks.
Exercise 110:11
Exercise 120:10
Exercise 130:10
Retrieve the first seven rows from a table in SQL Server 2022 with exercise 13 DEC, helping complete beginners practice basic querying.
Exercise 140:14
Exercise 150:44
Exercise 160:16
Explore exercise 16 and examine how others think about the movement function within this SQL Server 2022 for complete beginners course.

What are we going to discuss in this second part on the Transact SQL?1:07
Explore the second part of Transact-SQL basics, introducing aggregate functions like max and average, and demonstrating filtering data with where and having clauses.
Démo : Let's talk about the AND,OR operators.9:58
Demonstrate the and and or operators in SQL Server 2022, showing how to filter with where clauses using multiple conditions and examples on birth month, age, and gender.
Démo : Sort your data with ORDER BY6:26
Learn how to sort data with order by in sql server 2022, using ascending and descending orders on numbers, dates, and text, and note that ascending applies automatically by default.
Démo : Discover aggregate functions with MIN MAX and AVG6:25
Discover how to use min, max, and avg aggregate functions in SQL Server 2022, with examples calculating youngest and oldest ages and overall average.
Démo : Let's discover the COUNT and SUM6:52
Démo : How to SELECT a range of data with the BETWEEN4:12
Master the between operator to select data ranges in SQL queries. See examples such as ages between 16 and 33 and birth years between 1976 and 1983.
Démo : Group several results with the GROUP BY5:41
Démo : Let's discover the HAVING5:00
Démo : Let's talk about the PRINT4:00
Explore how the SQL Server print statement outputs messages to the client and helps track progress during large batch updates, with a practical demonstration.
Focus on previous sessions3:21

Requirements

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

Description

This course also takes the new SQL Server version 2022 (new features such as GREATEST, LEAST, WINDOWS, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES are discussed)

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 HAVING and the PRINT.
The joins with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on
Let's go even further with Transact SQL with the IIF,CASE WHEN,SUBSTRING, OFFSET FETCH NEXT ROWS.
Have you heard of the CHOOSE, TRIM/LTRIM/RTIM or COALLESCE function?
Let's discover the specificities of UNION and UNION ALL, and the LEFT and RIGHT function.
Let's look at the conversion functions through CAST and CONVERT, TRY_CAST and TRY_CONVERT, as well as TRY_PARSE and PARSE.
The creation and definition of a view.
The creation and definition of a Stored Procedure.

This course includes more than 50 questions !

This course is 7 hours of demo and 30 minutes of theory. Theory is in the classroom, not in this course :)

Why should I use SQL technology?

SQL is one of the most actively sought-after skills on the job market.
Administering an SQL server and querying in TSQL today is a full-time job.
Furthermore, SQL Server, because of its simplicity, allows you to quickly become competent in very specific subjects.
Once this course is over, believe me that you will be much more comfortable with the SQL language.
I also made sure that the videos don't exceed 10 minutes, so it won't be too soporific :)

Who this course is for:

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...)

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

What you'll learn

Explore related topics

Course content

Let's Set Up our working environment installing Management Studio and SQL Server6 lectures • 24min

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 DELETE7 lectures • 38min

Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE5 lectures • 3min

Correction Exercise 1 to 5 on SELECT,UPDATE,INSERT,DELETE6 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...)10 lectures • 53min

Requirements

Description

Who this course is for: