Back
Course details
View pricing Try for free
View pricing Try for free

Introduction to SQL

Testimonials (211 reviews)

Features

Premium video tutorials

Award-winning instructors

Personalized learning

Get certified

Learn at your own pace

Mobile (learn on-the-go)

Unlimited tests and quizzes

Regularly updated content


Overview

SQL is the world's most widely used programming language for database management, an essential skill for back-end web development and data analytics. Designed for beginners, this Introduction to SQL course will give you the foundation you need to get started with Structured Query Language in Microsoft SQL Server, through hands-on application and examples.

By the end of the course you will have a practical understanding of how to set up and connect to a server, create databases and tables, insert and update data, and create and filter queries to get the valuable insights you need.

In this course we are using Microsoft SQL Server's T-SQL, but you will be able to apply most of what you learn to many other databases such as MySQL, PostgreSQL, Oracle and more.

Highlights:

  • 33 practical tutorials.
  • Understand the structure of databases with RDBMS concepts.
  • How to set up Microsoft SQL Server and SQL Management Studio.
  • Create a new database and add data to tables.
  • Back up and restore your database to protect your data.
  • Use a SELECT statement to retrieve data.
  • Filter records with WHERE, AND, OR clauses.
  • Arrange results with ORDER BY and GROUP BY clauses.
  • Search within aggregate groups with HAVING clause.
  • Calculate data with Count, Average, and Sum functions.
  • Update and remove data with UPDATE and DELETE statements.
  • Combine and join tables with JOIN clauses.
  • Other SQL concepts such as subqueries, indexing and primary key.

Once enrolled, our friendly support team and tutors are here to help with any course related inquiries.

Introduction to SQL
Focus video player for keyboard shortcuts
Auto
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Summary

Skill level: Beginner
Certificate: Yes
Lessons: 33
Pre-requisites: None
Video duration: 2h 01m
Estimated study time: 16h 30m for all materials

Instructor

John Elder

John Elder

Presenter


Syllabus

Intro to Databases & SQL 4 lessons Free Lesson

1

Try it!

What is a database?

We will discuss what a database is, the different types of databases and what they are used for

2

An Overview of SQL

We will discuss what SQL(Structured Query Language) is, what it is used for and some of the different systems that use SQL

3

RDBMS Concepts

We will look at the core concepts and structure of a relational database such as tables, columns, rows, etc

4

Working With Data Types

We will discuss some of the important data types that may be used in a relational database, including Integer, varchar, text and much more

Microsoft SQL Server & Management Studio Setup 7 lessons

1

Setting Up Microsoft SQL Server

We will install and setup Microsoft SQL Server

2

Setting Up Microsoft SQL Server Management Studio

We will install and setup SQL Server Management Studio.

3

Connecting to a Server

We will connect to a server and look at the Object Explorer

4

System Databases

We will take a look at the master and model databases as well as the msdb and tempdb Databases

5

Creating a New Database

We will create a new database within MS SQL Server 2016, and create a new table

6

Adding Data to a Table

We will add data to our Table

7

Backing Up & Restoring a Database

You will learn how to backup a database and how to restore a backup

Selecting & Filtering Data 1 5 lessons Free Lesson

1

Try it!

Simple SELECT Statements

Here we will start to write SQL statements and queries, starting with basic SELECT statements

2

WHERE Clause

We can target specific columns using the WHERE clause along with a SELECT statement

3

AND & OR Clause

We can select data based on multiple conditions using the AND & OR clause

4

ORDER BY Clause

We will look at how we can sort returned data using the ORDER BY clause

5

GROUP BY Clause

We will look at how we can sort returned data using the GROUP_BY clause

Selecting & Filtering Data 2 5 lessons

1

HAVING Clause

The HAVING clause is similar to a WHERE clause but can use aggregation

2

TOP Clause

The TOP clause is used to limit the number of records that will be returned from a SELECT statement

3

SELECT DISTINCT

We can use DISTINCT to only return distinct or different values in a SELECT statement

4

UNION

The UNION operator is used to combine the result-set of two or more SELECT statements

5

Functions

We will look at some built in functions for performing calculations on data

Inserting, Updating & Deleting Data 4 lessons

1

INSERT Statement

We will insert our own records into a database using INSERT INTO

2

UPDATE Statement

The UPDATE statement can be used to change data that already exists in the SQL database

3

DELETE Statement

We can use DELETE FROM to remove data from the SQL database

4

ALTER TABLE

With ALTER TABLE, we can add, remove or change columns, data types and just about anything else

Combining & Joining Multiple Tables 5 lessons Free Lesson

1

Aliases

Aliases can be used to temporary rename columns and tables

2

Try it!

INNER JOIN

We will discuss and write inner joins to combine more than one table in a specific way

3

OUTER JOIN

We will discuss and write outer joins to combine more than one table in a specific way

4

LEFT JOIN

We will discuss and write left joins to combine more than one table in a specific way

5

RIGHT JOIN

We will discuss and write right joins to combine more than one table in a specific way

Other SQL Concepts 3 lessons

1

Subqueries

We will discuss combining queries together in a subquery

2

Indexing

We will talk about what indexing is and how to do it within MS SQL Server

3

Primary Key

We will discuss the Primary Key and why it's so important

Download syllabus


Certificates

You can earn 2 certificates with this course

Certificate of Training

Rewarded upon successful completion of your training course.

See sample

Certificate of Achievement

Rewarded upon successful completion of your training course and test.

See sample
Get started View pricing
View pricing Get started

See what our customers are saying...

“Thank you, John Elder! This was a concise introduction to SQL. I liked the course design and videos! The quizzes reinforced the important points in the video segments. Well done!!”

    

Shahla Pirnia

“This was an awesome course. I was able to follow along and practice what the instructor was telling me. It really has me interested in data analytics and I'm excited to watch another course!”

    

Kaylie

“Nice course. It was short and easy to learn, not boring at all.”

    

Swapnil Choudhary

“It is the best platform to learn SQL, I believe.”

    

Prem Prakash Srivastava

“Excellent course for a beginner.”

    

Anoop Suraj Ambikumar

“You made it very simple to learn! Thank you!”

    

Danae R Richardson

“I'm very happy with this course! Thanks a lot!”

    

GEORGE SEVERIN

“This course was educational and fun. The instructor sounded very friendly and was a pleasure to listen to.”

    

James Dyke

“Very informative and loved the way he has taught it.”

    

Salman Afzal

“Excellent!”

    

Dan

“very good beginner’s course ”

    

Soshinie A. Singh

“Great Course. Easy to follow and understand. Excellent Instructor”

    

Rasheek K. Johnson

Others who bought this course also viewed

GoSkills Unlimited
     4.7 (32,083 reviews)
Recommended
Microsoft Excel 365 - Basic & Advanced
     4.7 (2,479 reviews)
Recommended
Project Management Basics
     4.7 (234 reviews)
Microsoft PowerPoint 365
     4.7 (101 reviews)
Back to the top

© 2023 GoSkills Ltd. Skills for career advancement