SQL For Developers
Hands-on Oracle SQL for developers using SCOTT and HR schemas: SELECT, filtering, joins, aggregation, subqueries, CTEs, analytic functions, hierarchical queries, DDL, DML, transactions, views, constraints, performance tuning, and capstone labs.
Topic 1: SQL Foundations with SCOTT and HR
Relational Data and SQL
Topic 2: SELECT Fundamentals
Selecting Columns
Topic 3: DISTINCT and NULL
Unique Results
Topic 4: WHERE Filtering
Predicates
Topic 5: IN, BETWEEN and LIKE
Range and List Predicates
Topic 6: ORDER BY and Top-N
Sorting
Topic 7: Oracle Single-Row Functions
Character Functions
Topic 8: NULL Handling and CASE
NVL and COALESCE
Topic 9: Aggregate Functions
COUNT, SUM and AVG
Topic 10: GROUP BY
Grouping Rows
Topic 11: HAVING
Filtering Groups
Topic 12: INNER JOIN
Employee and Department Joins
Topic 13: OUTER JOIN
LEFT JOIN
Topic 14: Multi-Table Joins
HR Reporting Joins
Topic 15: Self Joins
Employee and Manager
Topic 16: Subqueries
Scalar Subqueries
Topic 17: Correlated Subqueries
Department Average
Topic 18: Set Operators
UNION and UNION ALL
Topic 19: Inline Views and CTEs
Inline Views
Topic 20: Analytic Functions
ROW_NUMBER, RANK and DENSE_RANK
Topic 21: Advanced Analytics
LAG and LEAD
Topic 22: Hierarchical Queries
CONNECT BY
Topic 23: Date and Time SQL
Date Arithmetic
Topic 24: Conversion Functions
TO_CHAR
Topic 25: DDL Fundamentals
CREATE TABLE
Topic 26: Constraints
Primary Keys
Topic 27: INSERT
Single Row INSERT
Topic 28: UPDATE
Targeted Updates
Topic 29: DELETE and MERGE
DELETE
Topic 30: Transactions
COMMIT and ROLLBACK
Topic 31: Views
CREATE VIEW
Topic 32: Sequences
NEXTVAL and CURRVAL
Topic 33: Indexes and Execution Plans
Index Concepts
Topic 34: SQL Performance
Efficient Predicates
Topic 35: Oracle Data Dictionary
USER_ Views
Topic 36: SCOTT Classic SQL Lab
EMP and DEPT
Topic 37: HR Compensation Analysis
Salary Statistics
Topic 38: HR Geographic Analysis
Location Reporting
Topic 39: HR Job History
History Joins
Topic 40: Advanced SQL Interview Patterns
Top-N Per Group
Topic 41: SQL Logical Processing
Clause Order
Topic 42: SQL Capstone
HR Analytics Project
Course Progress
Enroll to start learning!
Course Stats
- Total Topics 42
- Total Lessons 42
- Total Sessions 42
- Total Notes 42
- Estimated Time 44.10000000000001 hours
This course is only available through program enrollment.
View Program: Full Stack Development