Introduction to SQL Server
Learn to use SQL Server to perform common data manipulation tasks and master common data manipulation tasks using this database system.
Start Course for Free4 hours13 videos46 exercises149,494 learnersStatement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Training 2 or more people?
Try DataCamp for BusinessLoved by learners at thousands of companies
Course Description
Master the basics of Microsoft SQL Server—one of the world's most popular database systems.
This course covers:
✓ How to use SELECT statements to retrieve data
✓ How to use SQL Server aggregate functions
✓ How to manipulate text fields
✓ How to retrieve data from multiple sources
✓ All of the key aspects of working with data in SQL Server
Each time you're introduced to a new concept or function, you'll have the opportunity to test your knowledge and build your confidence. You'll work with a digital media database to review the sales of various artists and tracks, Eurovision datasets, and review trends in US power outages to explore a number of different data types and scenarios.
This course covers:
✓ How to use SELECT statements to retrieve data
✓ How to use SQL Server aggregate functions
✓ How to manipulate text fields
✓ How to retrieve data from multiple sources
✓ All of the key aspects of working with data in SQL Server
Each time you're introduced to a new concept or function, you'll have the opportunity to test your knowledge and build your confidence. You'll work with a digital media database to review the sales of various artists and tracks, Eurovision datasets, and review trends in US power outages to explore a number of different data types and scenarios.
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.In the following Tracks
SQL Server Developer
Go To TrackSQL Server Fundamentals
Go To Track- 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.
Welcome50 xpSimple selections100 xpMore selections100 xpOrdering and filtering50 xpOrder by100 xpWhere100 xpWhere again100 xpWorking with NULL values100 xpWHERE the wild things are50 xpExploring classic rock songs100 xpExploring classic rock songs - AND/OR100 xpUsing parentheses in your queries100 xp - 2
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.
- 3
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.
- 4
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.
Training 2 or more people?
Get your team access to the full DataCamp platform, including all the features.In the following Tracks
SQL Server Developer
Go To TrackSQL Server Fundamentals
Go To Trackdatasets
Eurovision Song ContestPower outages in USAClassic rock radio station songsChinook Database as zipped CSV filescollaborators
DataCamp Content Creator
See MoreCourse Instructor
DataCamp offers interactive R, Python, Spreadsheets, SQL and shell courses. All on topics in data science, statistics, and machine learning. Learn from a team of expert teachers in the comfort of your browser with video lessons and fun coding challenges and projects.
Join over 15 million learners and start Introduction to SQL Server today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.