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.

This exercise is part of the course

Introduction to SQL Server

BeginnerSkill Level

4.8+

Start Course for Free

Hit the ground running by learning the basics of SELECT statements to retrieve data from one or more columns. You'll also learn how to apply filters to both numeric and text data, and sort the results.

Exercise 1: Welcome Exercise 2: Simple selections Exercise 3: More selections Exercise 4: Ordering and filtering Exercise 5: Order by Exercise 6: Where Exercise 7: Where again Exercise 8: Working with NULL values Exercise 9: WHERE the wild things are Exercise 10: Exploring classic rock songs Exercise 11: Exploring classic rock songs - AND/OR Exercise 12: Using parentheses in your queries

Herein, you'll learn how to use important SQL Server aggregate functions such as SUM, COUNT, MIN, MAX, and AVG. Following that, you'll learn how to manipulate text fields. To round out the chapter, you'll power up your queries using GROUP BY and HAVING, which will enable you to perform more meaningful aggregations.

Exercise 1: Aggregating Data Exercise 2: Summing Exercise 3: Counting Exercise 4: MIN, MAX and AVG Exercise 5: Strings Exercise 6: LEN'gth of a string Exercise 7: Left and right Exercise 8: Stuck in the middle with you Exercise 9: Grouping and Having Exercise 10: GROUP BY Exercise 11: Having Exercise 12: Grouping together

This chapter covers the basics of joining tables, using INNER, LEFT, and RIGHT joins, so that you can confidently retrieve data from multiple sources.

Exercise 1: Joining tables Exercise 2: Inner Joins - a perfect match Exercise 3: Inner Joins (II)Exercise 4: Inner Join (III) - Join 3 tables Exercise 5: LEFT & RIGHT JOIN Exercise 6: LEFT join Exercise 7: RIGHT JOIN Exercise 8: UNION & UNION ALL Exercise 9: UNION ALL Check Exercise 10: Join the UNION

In this final chapter, you'll get really hands on! You've worked with existing tables, but in this chapter, you'll get to CREATE and INSERT data into them. You'll also UPDATE existing records and practice DELETE statements in a safe environment. This chapter ensures the course gives you a thorough introduction to the key aspects of working with data in SQL Server.

Exercise 1: Creator Exercise 2: CRUD operations Exercise 3: Create tables Exercise 4: Insert, Update, Delete Exercise 5: Insert Exercise 6: Update Exercise 7: Delete Exercise 8: Declare yourself Exercise 9: DECLARE and SET a variable Exercise 10: Declare multiple variables Exercise 11: Ultimate Power Exercise 12: Congratulations!

Current Exercise