dots bg

SQL Fundamentals: A Beginner's Guide

Course Instructor OdinSchool

FREE

To enroll in this course, please contact the Admin
Contact Admin
dots bg

Course Overview

Schedule of Classes

Start Date & End Date

Mar 20 2024 - Dec 31 2030

Course Curriculum

1 Subject

SQL Fundamentals: A Beginner's Guide

3 Exercises • 22 Learning Materials

Course Walkthrough

Course Walkthrough

Introduction to SQL & Create Database

Introduction to SQL

MySQL Workbench Installation for Windows

MYSQL Workbench Installation For MAC

Importing SQL files in Workbench

Create Database

Insert, Alter, and Select

Insert

Alter

Select

Practice Quiz 1

Practice Quiz 1

Exercise

Functions,Order By & Limit

String Functions

Numeric and Temporal functions

SQL functions- Order by, Limit

Aggregate functions in SQL

Like, Group By, Having and SQL Joins

Like and ILike (wildcards)

Group By

Having

SQL Joins

Inner Join

Full outer join

Left Outer Join

Right Outer Join

Union

Practice Quiz 2

Practice Quiz

Exercise

Final Assessment

Final Assessment

Exercise

Course Instructor

tutor image

OdinSchool

107 Courses   •   33032 Students