Introduction to SQL Server
Become proficient at using SQL Server to perform common data manipulation tasks.
- 4 hours
- 13 Videos
- 46 Exercises
- 9,181 Participants
- 3,850 XP
Create Your Free Account
By pressing Continue you accept the Terms of Use and Privacy Policy. You also accept that you are aware that your data will be stored outside of the EU and that you are above the age of 16.
Loved by learners at thousands of top companies:
Course Description
SQL is an essential skill for data scientists, and Microsoft SQL Server is one of the world's most popular database systems. In this course, you'll start with simple SELECT statements, and refine these queries with ORDER BY and WHERE clauses. You'll learn how to group and aggregate your results, and also how to work with strings. You'll also cover the most common way to join tables, how to create tables, and inserting and updating data. You'll mainly work with the Chinook digital media database, representing sales of various artists and tracks. The music theme continues with the classic rock and Eurovision datasets, while we also look at trends in power outages in the US. Overall, you'll become proficient in the most common data manipulation tasks in SQL Server and build a solid foundation for the upcoming T-SQL courses here on DataCamp!
-
1
SELECTion Box
FreeHit 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.
-
Joining tables
This chapter covers the basics of joining tables, using INNER, LEFT, and RIGHT joins, so that you can confidently retrieve data from multiple sources.
-
Groups, strings, and counting things
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.
-
You've got the power
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.
-
1
SELECTion Box
FreeHit 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.
-
Groups, strings, and counting things
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.
-
Joining tables
This chapter covers the basics of joining tables, using INNER, LEFT, and RIGHT joins, so that you can confidently retrieve data from multiple sources.
-
You've got the power
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.
What do other learners have to say?
“I've used other sites, but DataCamp's been the one that I've stuck with.”
Devon Edwards Joseph
Lloyd's Banking Group
“DataCamp is the top resource I recommend for learning data science.”
Louis Maiden
Harvard Business School
“DataCamp is by far my favorite website to learn from.”
Ronald Bowers
Decision Science Analytics @ USAA
John MacKintosh
Data Manager
I'm based in the UK and work in the healthcare sector. I was introduced to SQL and SQL Server in 2010. My course aims to help those who are coming from spreadsheets, or who are otherwise new to SQL Server, to get up to speed quickly, so they too can become more effective in their roles. It contains all the information that I would have loved to have known when I first began using it. As well as SQL Server, I also love using R, particularly for data visualisation
See MoreTracks
Collaborators
-
Mona Khalil
-
Yashas Roy