Welcome to the SQL Courses! This repository contains the final project files for SQL 101, 102, and 103 courses from satr.codes.
-
SQL 101:
- Concept of Databases and Their Uses: Understanding the basics of databases and their importance in the data-driven world.
- Working with Tables: How to create tables, understand their structure, and the relationships between them.
- Data Management: Includes adding, viewing, modifying, and deleting data using basic SQL queries.
-
Final Project: SQL101
-
SQL 102:
- Working with Data: Understanding how to manipulate and manage data within a database.
- Overview of Aggregate Functions: Exploring functions that perform calculations on a set of values and return a single value (e.g., COUNT, SUM, AVG).
- Overview of Scalar Functions: Examining functions that operate on a single value and return a single value (e.g., UPPER, LOWER, ROUND).
-
Final Project: SQL102
-
SQL 103:
- Concept of Relationships Between Tables: Understanding how tables interact and relate to one another within a database.
- Concept of JOINS: Exploring different types of joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, etc.) to retrieve data from multiple tables based on related columns.
- Concept of FOREIGN KEY: Examining the role of foreign keys in maintaining referential integrity between tables.
-
Final Project: SQL103
Total Learning Hours: 3.5
Happy learning!