No products in the cart.

Log In Sign Up

Home
Course
IT & Software
Mastering SQL Programming

Mastering SQL Programming

Learn all the fundamentals and advanced data management techniques of SQL programming with our comprehensive tutorials.

Course Highlights

SQL is a programming language for retrieving and managing information stored in the relational database. Our SQL course covers various SQL topics to help you start your database programming.

The SQL Programming course will take you through the fundamental SQL concepts and explain how SQL works. Here, you’ll learn about different SQL tools for data management operations and understand how to install them. Gradually, the course will take you through browsing and filtering data. You’ll understand what a database is and learn about different SQL data types and the various methods for filtering data. Again, you’ll understand how to filter data with logical operators in SQL. The course will also teach you about SQL arithmetic operators and how to concatenate strings in SQL results.

Our SQL Course will also introduce you to different SQL functions. It will teach you about nested queries, casting and data conversion, combination relationships, and SQL joins. The course will also explain DML in SQL and familiarise you with the various DML commands in SQL. Finally, you’ll find a comprehensive SQL Data Definition Language (DDL) guide.

Learning outcome

Understand the fundamentals of SQL and how to configure tools.
Browse and filter data efficiently.
For more complicated queries, use logical operators.
SQL allows you to perform mathematical computations.
Use sorting, aliasing, and record limit approaches.
Handle NULL data by employing DISTINCT and CASE commands.
Learn complex concepts, including nested queries and data joins.

Course media

Skill Up Trustpilot Review

Skill Up Market Place Review

Why should I take this course?

Learn SQL from the ground up.
Develop your data management skills.
Improve your ability to run complicated data searches.
Learn SQL functions and operations.
Increase your chances of getting a job in a data-driven field.

Career Path

Database Administrator
Data Analyst
SQL Developer
Business Intelligence Analyst
Data Engineer
Data Scientist
Software Developer

Requirements

Course Curriculum

Unit 01: Introduction

Introduction

00:01:00
Tools Used in This Course

00:01:00

Unit 02: Setting up Course Tools

Download PostgreSQL

00:02:00
Install PostgreSQL

00:03:00
Download SQLectron

00:02:00
Install SQLectron

00:01:00
Connect to PostgreSQL – Credentials

00:01:00
Connect to PostgreSQL Using SQLectron

00:02:00
Import Course Data Using SQLectron

00:02:00
FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data

00:08:00

Unit 03: Browsing & Filtering Data

Check Imported Data

00:06:00
What is a Database?

00:01:00
SQL Data Types

00:02:00
Finally Some Fun! Extracting Data Based on Requirements

00:01:00
Filtering Data using WHERE Keyword

00:08:00
Filter Data by Range Using BETWEEN

00:03:00
Filter Data by Set of Values Using IN

00:03:00
Filter Data by Date

00:05:00
More Filtering by Date

00:03:00
Another Query Filtering by Date

00:01:00
Filter Data by Strings

00:04:00
More Filtering by Strings

00:05:00
More Filtering by Strings 2

00:10:00
More Filtering by Strings 3

00:02:00
How to Ignore Caps when Filtering by String

00:04:00

Unit 04: Filter Data with AND, OR, NOT Operators

AND Operator

00:10:00
OR Operator

00:02:00
NOT Operator

00:09:00
AND, OR & NOT Operators: Which Has the Highest Priority?

00:06:00

Unit 05: Math Operations

Basic Math Operations

00:06:00
Modulo Operator

00:04:00
Calculate The Net Salary for Employees

00:06:00
Filter Data with Math Equations

00:03:00

Unit 06: String Concatenation

Concatenate Strings with ‘||’ Operator

00:06:00
Concatenate Strings with Numbers

00:02:00

Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records

Give Your Report Fields A Cool Name

00:04:00
A Report for Payroll

00:07:00
Order Records by Column

00:06:00
Order Records by Multiple Columns

00:12:00
How Alias Names Cannot Be Used with WHERE

00:02:00
LIMIT Record Count Fetched by Your Query

00:08:00

Unit 08: NULL, DISTINCT & CASE Statements

Fetch A Field’s Unique Values Using DISTINCT

00:03:00
Using DISTINCT Keyword with Multiple Columns

00:06:00
What is a NULL Value Anyway?

00:05:00
Build More Sophisticated Queries with CASE Statements

00:10:00
Your Knowledge So Far Under A Great Test

00:09:00

Unit 09: Functions in SQL: Multiple-Row Functions

Let Me Introduce You to Functions

00:04:00
SUM Function

00:04:00
AVG (Average) Function

00:04:00
COUNT Function

00:07:00
MIN & MAX Functions

00:04:00
How To Count Your Field’s Unique Values

00:04:00
GROUP BY Clause: Use Functions with Dimensions

00:06:00
GROUP BY More Than One Dimension

00:05:00
Now For Some Tough Workout

00:09:00
Filter By Aggregate Functions with HAVING Clause

00:08:00

Unit 10: Functions in SQL: Single-Row Functions

Character Functions – UPPER, LOWER & INITCAP

00:08:00
Character Functions – CONCAT & LENGTH

00:10:00
Character Functions – LPAD & RPAD

00:13:00
Character Functions – TRIM

00:04:00
Character Functions – REPLACE

00:09:00
Character Functions – SUBSTR

00:10:00
Number Functions – MOD & ROUND

00:11:00
Number Functions – TRUNC

00:07:00

Unit 11: Nested Queries

Selectception: A Select Query inside another Select Query!

00:06:00

Unit 12: Casting & Data Conversion

Auto Data Conversion in SQL

00:11:00
Cast Date to Character

00:10:00
Cast Number to Character

00:09:00
Cast Timestamp to Character

00:07:00
Cast Character to Number

00:08:00
Cast Character to Date & Timestamp

00:09:00

Unit 13: Combination Relationships

UNION

00:03:00
UNION ALL

00:02:00
Important Note about Combining Queries

00:02:00
INTERSECT

00:01:00
EXCEPT

00:01:00

Unit 14: Joins in SQL

Employees & Departments Tables Revised

00:03:00
Entity Relationship Diagram (ERD)

00:09:00
Cartesian Join

00:09:00
Table Aliases with Joins

00:07:00
Why I Don’t Recommend Cartesian Joins

00:08:00
Inner Join

00:06:00
In-Depth Look into Join Types in SQL

00:03:00
Outer Join – Right, Left & Full

00:08:00

Unit 15: Data Manipulation (DML)

INSERT a New Record to a Table

00:09:00
Insert Without Specifying Column Names

00:09:00
UPDATE a Record’s Field Values

00:07:00
CAUTION! How an UPDATE Query Can Go Wrong

00:04:00
Update a Record Using Single-Row Functions

00:04:00
A Good Exercise: Extract Employee’s Email Address

00:02:00
Solution: Extract Employee’s Email Address

00:13:00
DELETE a Table’s Record

00:06:00
Insert Records with Nested Select Queries

00:06:00

Unit 16: SQL Data Definition Language (DDL)

SQL Data Types Revised

00:13:00
Bookstore Data Set: Let’s Move It to Database

00:04:00
Create Your First Table!

00:08:00
Insert Data to Your New Table

00:08:00
Change Column Data Type

00:07:00
Rename Column

00:04:00
Add a New Column to Table

00:04:00
Constraints in SQL

00:01:00
Primary Keys

00:14:00
NOT NULL Constraint

00:05:00
UNIQUE Constraint

00:04:00
DEFAULT Constraint

00:04:00
Foreign Keys

00:08:00
Use Foreign Keys with Joins – Books & Publishers

00:06:00
Foreign Keys – Properties

00:06:00
Drop Column

00:01:00
DROP Table

00:01:00
Create a New Table with Select Statement

00:05:00
A Trick to Create an Empty Table with Select Statement

00:03:00
Insert New Records Using Select Statement

00:06:00
Views

00:03:00
Schemas

00:02:00
Create & Use Schemas

00:04:00

Resources

Resources – Mastering SQL Programming

Assignment

Assignment – Mastering SQL Programming

Mastering SQL Programming

£25

TAKE THIS COURSE

14-Day Money-Back Guarantee

This course includes:

Duration:

10 hours, 37 minutes
Access:

1 Year
Units:

118

Want to get everything for £149

Take Lifetime Pack

Chat with usLiveChat