Skip to main content
HomeSQLIntroduction to SQL Server

Introduction to SQL Server

4.2+
51 reviews
Beginner

Learn to use SQL Server to perform common data manipulation tasks and master common data manipulation tasks using this database system.

Start Course for Free
4 Hours13 Videos46 Exercises
142,241 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 2 or more people?Try DataCamp For Business

Loved 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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

SQL Server Developer

Go To Track

SQL Server Fundamentals

Go To Track
  1. 1

    SELECTion Box

    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.

    Play Chapter Now
    Welcome
    50 xp
    Simple selections
    100 xp
    More selections
    100 xp
    Ordering and filtering
    50 xp
    Order by
    100 xp
    Where
    100 xp
    Where again
    100 xp
    Working with NULL values
    100 xp
    WHERE the wild things are
    50 xp
    Exploring classic rock songs
    100 xp
    Exploring classic rock songs - AND/OR
    100 xp
    Using parentheses in your queries
    100 xp
  2. 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.

    Play Chapter Now
  3. 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.

    Play Chapter Now
  4. 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.

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

SQL Server Developer

Go To Track

SQL Server Fundamentals

Go To Track

Datasets

Eurovision Song ContestPower outages in USAClassic rock radio station songsChinook Database as zipped CSV files

Collaborators

Collaborator's avatar
Mona Khalil
Collaborator's avatar
Yashas Roy
DataCamp Content Creator

Course 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.
See More

Don’t just take our word for it

*4.2
from 51 reviews
51%
29%
16%
4%
0%
Sort by
  • Austin O.
    6 months

    Good use of practice first hand.

  • Cesar H.
    7 months

    I wanted to share my thoughts on the introductory SQL course I recently completed. It was an incredibly valuable experience. The course not only covered the fundamentals of SQL but also provided a fantastic hands-on learning approach through exercises. The practical exercises were a standout feature, as they allowed me to apply what I learned in real-world scenarios. This hands-on experience truly solidified my understanding of SQL and made the learning process engaging and effective. I found this method of teaching to be both enjoyable and highly educational. In summary, I consider this course to be an excellent resource for anyone looking to learn SQL. The combination of clear explanations and interactive exercises makes it a valuable and efficient way to acquire this essential skill. Highly recommended!

  • Priyanka N.
    11 months

    Excellent level of teaching.

  • santhi l.
    12 months

    Good experience

  • Samuel D.
    12 months

    A real basic guide to sql. It will get your foot in the door for learning about databases and sql. Highly recommend to anyone who is interested in learning about the topic.

"Good use of practice first hand."

Austin O.

"Excellent level of teaching."

Priyanka N.

"Good experience"

santhi l.

Join over 13 million learners and start Introduction to SQL Server today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.