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.