🔍

Introduction to SQL

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 is here to help with any course-related inquiries.

Summary

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

Features

Premium video tutorials
Personalized Learning
Learn at your own pace
Tests and Quizzes
Award winning instructors
Get Certified
Mobile - Learn on the go
Regularly updated content

Accreditations & Approvals

All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable. 

Instructors

All courses are taught by reputed trainers with relevant accreditations and industry experience.

Modules

What is a database?

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

 

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

 

RDBMS Concepts

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

 

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

Setting Up Microsoft SQL Server

We will install and setup Microsoft SQL Server

 

Setting Up Microsoft SQL Server Management Studio

We will install and setup SQL Server Management Studio.

 

Connecting to a Server

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

 

System Databases

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

 

Creating a New Database

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

 

Adding Data to a Table

We will add data to our Table

 

Backing Up & Restoring a Database

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

Simple SELECT Statements

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

 

WHERE Clause

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

 

AND & OR Clause

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

 

ORDER BY Clause

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

 

GROUP BY Clause

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

HAVING Clause

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

 

TOP Clause

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

 

SELECT DISTINCT

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

 

UNION

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

 

Functions

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

INSERT Statement

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

 

UPDATE Statement

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

 

DELETE Statement

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

 

ALTER TABLE

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

Aliases

Aliases can be used to temporary rename columns and tables
 

INNER JOIN

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

 

OUTER JOIN

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

 

LEFT JOIN

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

 

RIGHT JOIN

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

Subqueries

We will discuss combining queries together in a subquery

 

Indexing

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

 

Primary Key

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

Target Audience

  • Graduates exploring placement in entry-level Development positions across industries
  • Developers needing upskilling to be future-ready or become more productive in their current roles
  • Experienced individuals exploring Introduction to SQL to join the workforce

How do I Access The Program

  • Buy the course online
  • Save your payment transaction receipt for any future reference 
  • Our team will share the credentials to enable you access your course online within 2 business days of payment transfer

Bulk Orders

Incase you are looking for bulk user licenses, or customized Learning Paths for various Job Roles, reach out to us with your detailed requirements.

Contact Us
Subscription

Monthly, Annual

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products