Skip to main content

course

Introduction to SQL Server

Beginner

4.2+

Updated 12/2024

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

Included for FreePremium or Teams

SQLSoftware Development4 hours13 videos46 exercises3,850 XP150,588Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

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 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.

Prerequisites

There are no prerequisites for this course

1

SELECTion Box

Simple selections

More selections

Ordering and filtering

Where again

Working with NULL values

WHERE the wild things are

Exploring classic rock songs

Exploring classic rock songs - AND/OR

Using parentheses in your queries

2

Groups, strings, and counting things

Aggregating Data

MIN, MAX and AVG

LEN'gth of a string

Left and right

Stuck in the middle with you

Grouping and Having

Grouping together

3

Joining tables

Joining tables

Inner Joins - a perfect match

Inner Joins (II)

Inner Join (III) - Join 3 tables

LEFT & RIGHT JOIN

UNION & UNION ALL

UNION ALL Check

Join the UNION

4

You've got the power

CRUD operations

Create tables

Insert, Update, Delete

Declare yourself

DECLARE and SET a variable

Declare multiple variables

Ultimate Power

Congratulations!

Introduction to SQL Server

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.2

from 58 reviews

50%

31%

16%

3%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Arie H.

24 days

This course is teaching about the fundamental of SQL which flavor is Microsoft SQL Server. This course are excellent introductory course that covers all about fundamental SQL Server. If you are just learning about SQL you should take this course.

Antwyn M.

2 months

Excellent course!!

Syafiq M.

9 months

On point

Lyndon H.

12 months

Having once being a database admin (years ago) I found this to be a gentle reminder of the basics.

Cristian M.

12 months

A very complete course

"This course is teaching about the fundamental of SQL which flavor is Microsoft SQL Server. This course are excellent introductory course that covers all about fundamental SQL Server. If you are just learning about SQL you should take this course."

Arie H.

"Excellent course!!"

Antwyn M.

"On point"

Syafiq M.

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

Create Your Free Account

Google LinkedIn Facebook

or

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