SQL Certification Training Course
- Caption
- Certificate
- Dedicated Tutors
Course Description
This SQL certification course gives you all of the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn how to correctly structure your database, author efficient SQL statements, and clauses, and manage your SQL database for scalable growth.
Key Features
• In-depth coverage of SQL fundamentals • Covers all of the important query tools and SQL commands • Industry-recognized course completion certificate • Lifetime access to self-paced learning
Proudly Display Your Achievement
Upon completion of your training, you will receive a personalized certificate of completion to help validate your new skills.
Step-by-Step Courses List
Lesson 01 - Introduction
- 1.1 Course Overview
Lesson 02 - Installation and getting started
- 2.1 Installation
Lesson 03 - Case Study Demo
- 3.1 Case study part one
- 3.2 Case study part two
Lesson 04 - Fundamental SQL statements
- 4.1 CREATE
- 4.2 Exercise one Create DB and Table
- 4.3 INSERT
- 4.4 Import data from File
- 4.5 Exercise two Inserting and Importing
- 4.6 SELECT statement
- 4.7 SELECT DISTINCT
- 4.8 WHERE
- 4.9 Logical Operators
- 4.10 Exercise three SELECT and WHERE
- 4.11 UPDATE
- 4.12 DELETE
- 4.13 ALTER
- 4.14 Exercise four Updating Table
Lesson 05 - Restore and Back-up
- 5.1 Restore and Back-up
- 5.2 Exercise five Restore and Back up
Lesson 06 - Selection commands Filtering
- 6.1 IN
- 6.2 BETWEEN
- 6.3 LIKE
- 6.4 Exercise six In Like and Between
Lesson 07 - Selection commands Ordering
- 7.1 Side Lecture Commenting in SQL
- 7.2 ORDER BY
- 7.3 LIMIT
- 7.4 Exercise 7 Sorting
Lesson 08 - Alias
- 8.1 AS
Lesson 09 - Aggregate Commands
- 9.1 COUNT
- 9.2 SUM
- 9.3 AVERAGE
- 9.4 MIN and MAX
- 9.5 Exercise eight Aggregate functions
Lesson 10 - Group by Commands
- 10.1 GROUP BY
- 10.2 HAVING
- 10.3 Exercise nine Group By
Lesson 11 - Conditional Statement
- 11.1 CASE WHEN
Lesson 12 - JOINS
- 12.1 Introduction to Joins
- 12.2 Inner Join
- 12.3 Left Join
- 12.4 Right Join
- 12.5 Full Outer Join
- 12.6 Cross Join
- 12.7 Except
- 12.8 Union
- 12.9 Exercise ten Joins
Lesson 13 - Subqueries
- 13.1 Subqueries
- 13.2 Exercise eleven Subqueries
Lesson 14 - Views and Indexes
- 14.1 VIEWS
- 14.2 INDEX
- 14.3 Exercise twelve Views
Lesson 15 - String Functions
- 15.1 LENGTH
- 15.2 UPPER LOWER
- 15.3 REPLACE
- 15.4 TRIM, LTRIM, RTRIM
- 15.5 CONCATENATION
- 15.6 SUBSTRING
- 15.7 LIST AGGREGATION
- 15.8 Exercise thirteen String Functions
Lesson 16 - Mathematical Functions
- 16.1 CEIL and FLOOR
- 16.2 RANDOM
- 16.3 SETSEED
- 16.4 ROUND
- 16.5 POWER
- 16.6 Exercise fourteen Mathematical Functions
Lesson 17 - Date-Time Functions
- 17.1 CURRENT DATE and TIME
- 17.2 AGE
- 17.3 EXTRACT
- 17.4 Exercise fifteen Date-time functions
Lesson 18 - PATTERN (STRING) MATCHING
- 18.1 PATTERN MATCHING BASICS
- 18.2 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
- 18.3 Exercise sixteen Pattern Matching
Lesson 19 -Data Type conversion functions
- 19.1 Converting Numbers Date to String
- 19.2 Converting String to Numbers Date
Lesson 20 - User Access Control Functions
- 20.1 User Access Control
Lesson 21 - Bonus Section Nail that Interview
- 21.1 Tablespace
- 21.2 PRIMARY KEY and FOREIGN KEY
Reviews
You must be logged in to post a review.
What is Included
-
Professional Certification
Exam-focused prep and certification guidance aligned to your learning path.
-
ATS-Optimized Resume
Build a resume that highlights your new skills for recruiters and hiring systems.
-
Mock Interviews
Practice real interview scenarios with structured feedback from career coaches.
-
LinkedIn Optimization
Polish your profile so employers discover your credentials and achievements.
-
Job Placement Support
Career guidance and placement resources on eligible programs.
-
Practical Labs
Hands-on labs and exercises to reinforce concepts from your courses.
There are no reviews yet.