Get startedGet started for free

Congratulations!

1. Congratulations!

Congratulations on completing this course. Let's recap what we covered.

2. What we learned...

We covered selecting one or more columns with SELECT, Ordering results with ORDER BY, and Filtering results using WHERE and HAVING clauses We covered Aggregating and summarising using SUM, COUNT, MIN, MAX and AVG, and Text manipulation with LEFT, RIGHT, LEN and SUBSTRING.

3. What we learned (II)...

And, if that wasn't enough, we also covered: GROUP BY for splitting results into groups of interest Basic Joins - using INNER, LEFT and RIGHT joins Combining data from different tables with UNION and UNION all. Transforming data using CASE statements. We also looked at creating tables, and inserting, updating and deleting records. We learned about creating and using variables for more efficient queries, and creating temporary tables.

4. Next Steps

This was a broad introduction to SQL Server, and you have learned a lot that you can use in your job straight away. However, SQL Server is a vast topic, and there is much more to learn. For that reason, you might also consider the following courses on DataCamp: Firstly - Intermediate SQL Server, will enhance your SQL Server skills even further. Joining Data in SQL is a comprehensive course, and will ensure you have a great understanding of this key SQL skill.

5. Congratulations!

There are many more SQL Server courses coming up on DataCamp so stay tuned. Once again, congratulations on completing this course, and I hope you will be confident in putting your new skills into practice.