Basic Course

SQL Basics in MS SQL Server

Start here if you're new to SQL Server. Learn the basics of T-SQL for SQL Server, retrieve data from an SQL Server database and build simple reports.

4.88 ★★★★★ ★★★★★ (6500 ratings)

60,106 learners enrolled

Lifetime access

limited to this course only

$39

Want a better deal?

Get unlimited lifetime access to all 76 present and future courses

Save $450

Unlimited lifetime access

to all 76 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 10 h

Coding challenges 130

Skills you will gain

  • Retrieve information from a SQL Server database
  • Build basic reports from scratch
  • Write complex WHERE conditions, using logical operators like AND, OR, and NOT
  • Understand the LIKE, ILIKE, IN, and BETWEEN operators
  • Work with multiple tables
  • Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
  • Create simple reports using GROUP BY and aggregate functions
  • Write subqueries and complex instructions
  • Understand SQL set operations: UNION, INTERSECT, and EXCEPT

Last reviews

Description

Databases are part of our everyday life, and being able to communicate with them is essential. This course will teach you the basics of T-SQL, a powerful query language that lets you work with many types of data.

The SQL Basics in MS SQL Server course starts with simple queries performed on a single table. These exercises will show you how to retrieve exactly what you need. Next, you'll start working with multiple tables. You will find out about the subtle differences between various joining methods, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN.

As you go deeper into the course, you'll master using the GROUP BY function to create simple reports. You'll also start investigating subqueries. Finally, you can test your knowledge (and earn your certificate!) in a comprehensive quiz.

Cover image for the 'SQL Basics in MS SQL Server' course

Looking to get started in T-SQL? Give this course a try – the fascinating world of T-SQL queries is only a click away!

What Do You Need to Take This Course?

Just a web browser and an Internet connection

This Course Will Teach You How To:

  • Retrieve information from a SQL Server database
  • Build basic reports from scratch
  • Write complex WHERE conditions, using logical operators like AND, OR, and NOT
  • Understand the LIKE, ILIKE, IN, and BETWEEN operators
  • Work with multiple tables
  • Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
  • Create simple reports using GROUP BY and aggregate functions
  • Write subqueries and complex instructions
  • Understand SQL set operations: UNION, INTERSECT, and EXCEPT

Plus, you'll get to practice your skills on over 131 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to learn T-SQL and SQL Server
  • Analysts who use relational databases
  • Students taking courses in relational databases
  • Beginning programmers
  • Business database users who want to improve their skills

Table of contents

Course progress 0%

Exercises completed 0/130

  1. A primer on databases

    0/6

    Find out what relational databases are and get to know T-SQL – a language to talk to SQL Server databases

  2. Selecting data from one table

    0/23

    Discover how to select data from a single table

  3. Querying more than one table

    0/13

    Learn how to select data from multiple tables

  4. Aggregation and grouping

    0/25

    Computations in T-SQL? Why not? You'll learn how to group rows and compute statistics with aggregate functions

  5. More on JOINs

    0/20

    Learn about various kinds of JOINs to best suit your needs

  6. Subqueries

    0/23

    Queries within queries? That's right! Discover how to build and use subqueries

  7. Set operations

    0/11

    Combine query results using set operations like UNION, INTERSECT, and EXCEPT

  8. Quiz

    0/9

    Check your SQL Server skills

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (43)

Average rating

4.88/5

★★★★★ ★★★★★ (6500 ratings)

5 stars

90%

4 stars

10%

3 stars

0%

2 stars

0%

1 stars

0%