SQL Programmer

Issued by Vanguard Digital Consulting Pty Limited

Understand and appreciate the need of RDBMS along with the awareness of database schema, ER-diagrams and basic DDL commands involving creating tables and inserting data. Demonstrate the ability to write complex queries involving multi table joins, create views and writing subqueries.

Type Validation
Level Foundational
Time Weeks
Cost Free

Skills

Database Schema
Data Definition Language
Pandas (Python Package)
SQLite
SQL (Programming Language)

Earning Criteria

Demonstrate the ability to query data from an RDBMS like Oracle. Ability to join tables, create views and write subqueries to answer business questions. Integration SQL with Python (SQL lite) and write SQL style queries on Pandas data frames.