Course Length

18 Lessons

Difficulty

Intermediate

Category

Databases

Getting Started

1

SQL Overview

Start Lesson →

2

Introduction

Start Lesson →

Basic Queries

3

SELECT Query

Start Lesson →

4

SQL Insert Query

Start Lesson →

5

UPDATE Query

Start Lesson →

6

Delete Query

Start Lesson →

Functions

7

SQL Functions

Start Lesson →

8

SQL LCASE Function

Start Lesson →

9

SQL AVG Function

Start Lesson →

Working with Data

10

Date & Datetime

Start Lesson →

11

Comparing Dates

Start Lesson →

16

Rounding Numbers

Start Lesson →

Advanced Queries

12

SQL Joins

Start Lesson →

13

Like

Start Lesson →

14

Multiple Conditions

Start Lesson →

15

Order By & Group By

Start Lesson →

Database Management

17

List All Tables

Start Lesson →

Assessment

18

SQL Quiz

Start Lesson →

What You'll Learn

• ✓Essential SQL query syntax and operations
• ✓Database management and manipulation
• ✓Working with dates and numeric data
• ✓Advanced queries and table joins
• ✓SQL functions and data aggregation

Prerequisites

• •Basic understanding of databases
• •Familiarity with data types
• •Basic computer skills
• •Access to a database management system