Start here if you're new to SQL Server. Learn the basics of T-SQL for SQL Server, retrieve data from an SQL Server database and build simple reports.
Databases are part of our everyday life, and being able to communicate with them is essential. This course will teach you the basics of T-SQL, a powerful query language that lets you work with many types of data.
The SQL Basics in MS SQL Server course starts with simple queries performed on a single table. These exercises will show you how to retrieve exactly what you need. Next, you'll start working with multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN.
As you go deeper into the course, you'll master using the GROUP BY function to create simple reports. You'll also start investigating subqueries. Finally, you can test your knowledge (and earn your certificate!) in a comprehensive quiz.
Looking to get started in T-SQL? Give this course a try – the fascinating world of T-SQL queries is only a click away!
Just a web browser and an Internet connection
Plus, you'll get to practice your skills on over 131 interactive exercises.
Find out what relational databases are and get to know T-SQL – a language to talk to SQL Server databases
Discover how to select data from a single table
Returning all data from a table
Select some columns
To be or NULL to be
A bit of mathematics
Learn how to select data from multiple tables
How to query more than one table
Computations in T-SQL? Why not? You'll learn how to group rows and compute statistics with aggregate functions
Limiting the output
Eliminating duplicate results
HAVING: filtering and ordering groups
Learn about various kinds of JOINs to best suit your needs
Get to know the data
Aliases for tables
Queries within queries? That's right! Discover how to build and use subqueries
Very simple subqueries
Subqueries with multiple results
Combine query results using set operations like UNION, INTERSECT, and EXCEPT
Check your SQL Server skills
5.00 / 5