SQL Certification (Self-Paced)

Develop the SQL skills needed to query databases, analyze structured data, and prepare for professional certification. Learn through hands-on projects and personalized instruction using PostgreSQL and Oracle-focused exam preparation.

Unit 1 18 Hours

SQL Course Online (Self-Paced)

Learn how to extract, filter, and manipulate data using SQL. This course covers PostgreSQL fundamentals, database querying, table joins, and advanced techniques for handling large datasets.

  • Write SQL queries to retrieve, filter, and sort data efficiently
  • Use joins to combine information from multiple tables and establish relationships
  • Apply aggregate functions like SUM, COUNT, AVG, and GROUP BY to summarize data
  • Work with subqueries, conditional logic (CASE statements), and advanced string functions
  • Optimize queries using indexes, data type conversions, and best practices
  • Explore views and user-defined functions to streamline database management
Lesson 1: Setting Up the Work Environment
Lesson 2: Let's Start Learning SQL Code
Lesson 3: Working with Characters & Numbers
Lesson 4: Using SQL Wildcards
Lesson 5: Indentifying Rows & Connecting Tables
Lesson 6: Inner vs. Outer Joins
Lesson 7: Changing Data Types
Lesson 8: Working with Dates
Lesson 9: Organizing Statistical Results Into Categories
Lesson 10: Subqueries
Lesson 11: Aggregate Window Functions
Lesson 12: Conditionals
Lesson 13: Views
Lesson 14: String Functions
Lesson 15: Additional Resources
Lesson 16: AI and SQL
  • 10 hours and 25 minutes of class content
  • Streaming access on desktop and mobile browsers
  • 100% satisfaction guarantee

In our SQL Certification Program, you’ll learn to write SQL queries, extract and analyze data, and generate insights from relational databases. This hands-on training uses PostgreSQL and the DBeaver app, but the skills apply to other platforms like SQL Server, MySQL, and Oracle SQL.

This program includes:

  • Our SQL Bootcamp (18 hours total)
  • Six (6) hours of private tutoring (two 3-hour sessions)
  • The Oracle Database SQL Certified Associate exam, with a free retake included
  • Guidance on PostgreSQL-to-Oracle differences during private training
  • Access to additional study materials for exam preparation
  • Option to replace the exam with one additional hour of private tutoring

Please note that this course teaches PostgreSQL, which is similar to Oracle SQL. Differences can be reviewed during the private training sessions to help you prepare for the certification exam.

Read more