In this 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.
What You Will Learn
- Explore information stored in a database (tables, columns, rows, and more) using the graphical interface of DBeaver (a popular free database app)
- Write SQL queries to retrieve data from tables in a database
- Combine information from multiple tables with JOIN statements
- Filter data, group it, and sort it to extract the specific information you need
- Learn advanced techniques such as subqueries, string functions, and IF‑ELSE logic with CASE
- Learn how to use views and functions with parameters instead of directly querying tables
This program is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
