SQL Fundamentals

This course introduces students to the fundamentals of database systems and relational database management. Topics include data modeling, normalization, primary and foreign keys, and entity-relationship diagrams. Learners will gain hands-on experience using tools to create, modify, and query databases. The course also introduces popular database platforms such as MySQL and SQL Server. By the end, students will understand how structured data is stored, accessed, and managed in real-world environments. This foundational course lays the groundwork for all advanced SQL work that follows.

Students will learn how to write basic to intermediate SQL queries, including SELECT, INSERT, UPDATE, and DELETE statements. Emphasis is placed on mastering INNER, OUTER, LEFT, and RIGHT joins to combine data from multiple tables. The course explores filtering techniques, sorting, and the use of aliases. Students will complete exercises in query building using actual datasets. By the end of the course, they will be able to retrieve complex data using structured and nested queries. Practical assignments help reinforce best practices in query logic.

This course explores advanced features of SQL including aggregate functions, subqueries, CASE statements, and common table expressions (CTEs). Students will learn to manipulate data more efficiently through functions like RANK(), DENSE_RANK(), and ROW_NUMBER(). Emphasis is placed on optimization, performance tuning, and best practices for maintaining query efficiency. Through hands-on labs, learners will explore practical applications in business reporting and data transformation. By course completion, students will be proficient in writing robust SQL queries for analytical use cases. These skills are essential for success in data-heavy environments.

This course provides students with a strong foundation in relational database design. Key topics include normalization techniques, indexing strategies, data integrity, and schema creation. Students will learn to translate business requirements into logical and physical database structures. Tools such as Entity Relationship Diagrams (ERDs) design software will be used to model and implement real-world databases. The course culminates in the development of a complete database schema from scratch. By mastering these concepts, students will be prepared to build efficient and scalable databases.

Building on prior knowledge, this course focuses on writing multi-step queries and interpreting large datasets. Students will learn to use grouping, window functions, and conditional logic to uncover patterns in data. Emphasis is placed on using SQL as a data analysis tool to support decision-making. Students will also explore the basics of creating dashboards and integrating SQL outputs into reports. By the end of this course, learners will be comfortable handling analytical tasks using SQL. The course prepares students for real-world problem solving using data.

This course addresses how to build efficient, scalable databases through performance-focused design. Students will learn indexing strategies, query plan analysis, denormalization techniques, and caching. Real-world cases are used to evaluate performance bottlenecks and apply tuning strategies. Learners will also explore partitioning and concurrency control. By the end of this course, students will be able to assess and improve the efficiency of any SQL database. This course emphasizes measurable improvements in system performance.

Students will explore how SQL integrates into cloud environments and enterprise ecosystems. Topics include using SQL with cloud services like Amazon RDS, Azure SQL, and Google Cloud Platform. The course covers cloud-specific challenges such as latency, redundancy, and scaling. Learners will also examine how SQL supports enterprise data warehouses and data lakes. Students will complete labs simulating business workflows in a cloud-native context. This course is essential for understanding modern enterprise IT infrastructure.

This course focuses on automating database operations using stored procedures, functions, and triggers. Students will learn how to encapsulate business logic inside SQL objects and automate routine tasks. Topics include transaction handling, error management, and modular code development. Practical labs demonstrate how to enforce rules and integrity at the database level. This course prepares students to implement advanced automation in real-world systems. Students will leave with confidence in managing complex SQL workflows.

Students will explore the structure and function of data warehouses and the ETL (Extract, Transform, Load) process. Topics include star and snowflake schemas, staging tables, and data transformation pipelines. Students will learn how SQL is used to integrate data from multiple sources for reporting and analytics. The course includes practical labs simulating ETL jobs. By the end of the course, students will understand how warehousing supports business intelligence initiatives. This course bridges the gap between data storage and data strategy.

This course focuses on using SQL to support business intelligence activities. Students will write analytical queries for KPI monitoring, trend analysis, and performance reporting. The course covers query optimization for dashboards and integration with BI tools like Power BI and Tableau. Students will learn to translate business questions into data queries. By the end of the course, learners will be able to use SQL to create high-value data summaries and visualizations.

This course prepares students for certifications such as the Oracle SQL Associate, Google Data Analytics, and Microsoft DP-900. Exam content, sample questions, and practice labs are reviewed in detail. Learners will reinforce key SQL skills while focusing on test-taking strategy. The course includes diagnostic assessments to identify and improve weak areas. Students will leave the course confident and well-prepared for their chosen certification path.

In this final course, students will design and implement a comprehensive SQL-based solution to solve a real-world problem. The capstone involves creating a normalized database, building complex queries, and generating reports or dashboards. Emphasis is placed on showcasing a full workflow from requirements gathering to implementation. Students will be expected to document and present their project professionally. This course serves as both a culmination of learning and a portfolio piece for employment. Feedback from instructors simulates industry review processes.