Skip to main content

Introduction to SQL Course | Online Training - GoSkills

Introduction to SQL

Taught by John Elder

Query databases, filter results and understand how data is structured and retrieved.

Get started
  • Get an accredited certificate
  • 14-day money-back guarantee

About this course

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.

Syllabus

7 sections · 33 lessons · 2h 1m total

Download syllabus

Intro to Databases & SQL 4 lessons · 16m

  1. 1. What is a database? We will discuss what a database is, the different types of databases and what they are used for 3m View lesson
  2. 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 3m View lesson
  3. 3. RDBMS Concepts We will look at the core concepts and structure of a relational database such as tables, columns, rows, etc 4m View lesson
  4. 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 4m View lesson

  1. 1. Setting Up Microsoft SQL Server We will install and setup Microsoft SQL Server 4m View lesson
  2. 2. Setting Up Microsoft SQL Server Management Studio We will install and setup SQL Server Management Studio. 3m View lesson
  3. 3. Connecting to a Server We will connect to a server and look at the Object Explorer 3m View lesson
  4. 4. System Databases We will take a look at the master and model databases as well as the msdb and tempdb Databases 3m View lesson
  5. 5. Creating a New Database We will create a new database within MS SQL Server 2016, and create a new table 5m View lesson
  6. 6. Adding Data to a Table We will add data to our Table 3m View lesson
  7. 7. Backing Up & Restoring a Database You will learn how to backup a database and how to restore a backup 4m View lesson

  1. 1. Simple SELECT Statements Here we will start to write SQL statements and queries, starting with basic SELECT statements 4m View lesson
  2. 2. WHERE Clause We can target specific columns using the WHERE clause along with a SELECT statement 2m View lesson
  3. 3. AND & OR Clause We can select data based on multiple conditions using the AND & OR clause 3m View lesson
  4. 4. ORDER BY Clause We will look at how we can sort returned data using the ORDER BY clause 3m View lesson
  5. 5. GROUP BY Clause We will look at how we can sort returned data using the GROUP_BY clause 3m View lesson

  1. 1. HAVING Clause The HAVING clause is similar to a WHERE clause but can use aggregation 3m View lesson
  2. 2. TOP Clause The TOP clause is used to limit the number of records that will be returned from a SELECT statement 3m View lesson
  3. 3. SELECT DISTINCT We can use DISTINCT to only return distinct or different values in a SELECT statement 3m View lesson
  4. 4. UNION The UNION operator is used to combine the result-set of two or more SELECT statements 5m View lesson
  5. 5. Functions We will look at some built in functions for performing calculations on data 3m View lesson

  1. 1. INSERT Statement We will insert our own records into a database using INSERT INTO 3m View lesson
  2. 2. UPDATE Statement The UPDATE statement can be used to change data that already exists in the SQL database 2m View lesson
  3. 3. DELETE Statement We can use DELETE FROM to remove data from the SQL database 3m View lesson
  4. 4. ALTER TABLE With ALTER TABLE, we can add, remove or change columns, data types and just about anything else 2m View lesson

  1. 1. Aliases Aliases can be used to temporary rename columns and tables 3m View lesson
  2. 2. INNER JOIN We will discuss and write inner joins to combine more than one table in a specific way 4m View lesson
  3. 3. OUTER JOIN We will discuss and write outer joins to combine more than one table in a specific way 3m View lesson
  4. 4. LEFT JOIN We will discuss and write left joins to combine more than one table in a specific way 3m View lesson
  5. 5. RIGHT JOIN We will discuss and write right joins to combine more than one table in a specific way 2m View lesson

  1. 1. Subqueries We will discuss combining queries together in a subquery 3m View lesson
  2. 2. Indexing We will talk about what indexing is and how to do it within MS SQL Server 2m View lesson
  3. 3. Primary Key We will discuss the Primary Key and why it's so important 4m View lesson

Time to humblebrag

Complete the course and pass the final test to get a verifiable CPD-accredited certificate

Share on LinkedIn

Add your certificate to your profile in one click, and let recruiters and managers see your new skills.

  • CPD accredited
  • Verifiable online
Sample GoSkills certificate of completion

Taught by John Elder

John founded one of the Internet's earliest advertising networks (bannerclicks.com) and sold it at the height of the first dot com boom. John went on to develop the award-winning Submission-Spider search engine submission software that's been used by over 3 million individuals, businesses, and governments in over 42 countries.

John has over 20 years experience in web development, building professional websites across all platforms. John's passion for learning new technologies led him to master both front end and back end work, making him a sought after full-stack developer.

Read more

The reviews are in

See what other learners think of our courses

4.7
Based on 344 learner reviews
See all reviews
  • “An excellent course, explained very clearly. Anyone can learn from this video.”
  • “Great place to start with SQL”
  • “Very complete course and good tests.”
Chris Sanchez, GoSkills learner
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth.
Chris Sanchez GoSkills learner

Your questions, answered

Frequently asked questions

We’ve compiled the most important information to help you get the most out of your experience. Can’t find what you’re looking for? Contact us.

Does my membership include other courses?

Yes. A GoSkills plan gives access to the full course library, not just this course.

You sure can. As a learner, you can sign up for a 7-day free trial here. If you’re training your organization, you can also start with a free plan here.

Your dashboard shows which lessons you’ve completed and how far you are through each course, so you always know where to pick up next.

Yep! With a business account, you can access the full course library along with the GoSkills LMS where you can assign courses, track team progress and report on results from one dashboard. Learn more about GoSkills for teams here.

Our support team is available at support@goskills.com for questions about your account or the platform. Reach out anytime!