Learn Basic SQL with SQL Server 2019 Express

Get a Feel For Writing Queries Using SQL Server Express 2019

Created by: T O
Spreader of Knowledge

What Will I Learn?

• Find , download and install SQL Server Express 2019 and the Management Studio
• Understand how to configure the SQL Server Management Studio
• Understand how to work with select, where, like
• Understand how to configure different options in the SSMS
• Understand how to import records from text files
• Understand how to use >,
• Understand the logical order of the execution of queries
• Understand how to use order by with where and field aliasing
• Understand the difference between statements and clauses
• Understand how to use group by with having and order by
• Understand how to use over to window results
• Learn how to restore databases from back up

Requirements

• Make sure you are using SQL Server 2019 Express
• Versions below SQL Server 2019 Express might not work

Target audience

• This is a course for those who are interested in SQL Server and basic queries