SATR.CODES SQL Courses

Welcome to the SQL Courses! This repository contains the final project files for SQL 101, 102, and 103 courses from satr.codes.

Course Overview

• 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!