SQL Fundamentals

Welcome to SQL Fundamentals! This course is designed to introduce you to the foundational concepts of Structured Query Language (SQL), the standard language used to manage and manipulate data in relational databases. Whether you're aiming to become a data analyst, software developer, or want to work more confidently with data, understanding SQL is an essential skill. Throughout this class, you’ll learn how to retrieve, filter, update, and organize data efficiently using real-world examples and hands-on practice. Get ready to unlock the power of data and gain practical skills that are in high demand across industries!

We will learn using education enrollment information and see how to manipulate this data.

Week 1 

Introduction to Relational Database Management System 

Querying Data 

Sorting Data 

Assignment 1: Due at the end of Week 2 

Week 2 

Filtering Data 

Assignment 2: Due at the end of Week 3 

Week 3 

Joining Tables 

Grouping Data 

Assignment 3: Due at the end of week 4 

Week 4 

Subqueries 

Set Operations 

Quiz 1: Due at the end of week 5 

Week 5 

Creating Databases 

Table Datatypes 

Assignment 4: Due at the end of week 6 

Week 6 

Tables and Constraints 

Operations on Tables 

Assignment 5: Due at the end of week 8 

Week 7 

Modifying Data 

Week 8 

Views 

Indexes 

Quiz 2 Due at the end of Week 9 

Week 9 

Administration 1 

Final Examination: Due at the end of Week 10 

Week 10 

Administration 2 

Passing Grade: 80% 

Weighed Grade distribution: 

Assignments: 60% 

Quizzes: 20% 

Final Examination: 20% 

Master of Liberal Arts: Software Engineering - Harvard University

Graduate Certificate: Data Science - Harvard University

BSc(Hons) : Mathematical Sciences (Computer Science Major) - Kogi State University