Welcome to the SQL Course repository! This project contains a Jupyter notebook with exercises from a SQL course conducted by Unión Informática. The notebook focuses on creating and managing databases, writing SQL queries, and practicing database design concepts.
The Enunciados/ directory contains PDF files with the activity descriptions and requirements for the SQL exercises covered in this repository.
The main content is within the Actividades.ipynb notebook, where you can follow along with the exercises and review the solutions. Each exercise corresponds to specific SQL tasks, ranging from database creation to complex queries.
Additionally, the img/ directory contains images that might be referenced within the notebook for explanations or visual aids.
The course covers the following topics:
- Class 1: Database definition, SQL overview, and database access.
- Class 2: Query execution in Management Studio, database exploration.
- Class 3: Backup and database restoration.
- Class 4: Data types: Text, numeric (integers, reals), date and time.
- Class 5: Selecting data: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
- Class 6: Advanced SELECT statement usage.
- Class 7: Search conditions: Logical, relational, arithmetic operators, BETWEEN, LIKE.
- Class 8: Tables and characteristics: Table creation, Primary and Foreign Keys, Entity-Relationship Model, table relationships.
- Class 9: Selecting data from multiple tables: JOIN (INNER, LEFT, RIGHT).
- Class 10: Table modifications: INSERT, UPDATE, DELETE, and best practices.
- Class 11: Variables and temporary tables.
- Class 12: Aggregation functions: SUM, AVG, MIN, MAX, COUNT, GROUP BY, HAVING.
- Class 13: Views and stored procedures.
- Class 14: Functions: Arguments, return values, creation, modification, deletion.
- Class 15: Data type conversion, date manipulation.
This project utilizes:
- SQL
- SQLite
Distributed under the MIT License. See the LICENSE file for more details.
This repository contains exercises from a SQL course taught by Unión Informática, focusing on developing database skills, writing efficient SQL queries, and understanding relational database management systems.