# SQL Databases

## About

- Level: Intermediate
- Lectures: 20 hours
- Self-study: 10 hours
- Exercises: 61
- Lines of code to write: 147
- Format: e-learning + weekly online meeting with the instructor
- Language: English or Polish

## Description

Build the data layer of a Python application using relational databases and object-relational mapping (ORM). Practice modeling relationships, creating schemas, running queries, and applying migrations. Exercises also introduce transactions, query analysis, and integration with data tools.

## Advantages

Learn how application models become database operations and where hidden costs or consistency problems can arise. You will practice clearer schema designs, useful queries, and controlled changes to an existing data model.

## Target Audience

- Python developers adding persistence to an application.
- Backend engineers working with models, migrations, and SQL.
- Analysts connecting Python workflows to relational data.

## Format

Learn through short videos and worked examples, then apply each topic in coding exercises. Automated checks help you test your solutions, and a progress spreadsheet helps you see what to work on next.

Weekly online meetings give you time for questions, code reviews, and working through difficult exercises with the instructor. Downloadable code, exercise templates, and reference notes support your independent practice.

Our trainers prepare the teaching materials from their professional experience. The materials have been developed since 2015, with more than 28,000 automated tests checking the code examples. Training is available in English or Polish.

## Course Outline

1. Introduction to ORM Systems:

   - Database design assumptions and information storage optimization
   - Types of database normalization
   - Best design practices
2. Data Modeling:

   - Creating a local database
   - Creating primary and foreign keys
   - Creating simple tables
3. Creating Relational Tables:

   - one to one
   - one to many
   - many to many
4. Deleting tables:

   - Changing table relationship schemas
   - Migrations
   - Restoring a previous version of the database
5. Database Interaction:

   - Reading data from relational and non-relational tables
   - Editing individual values/records
   - Creating queries with relationships
   - Creating subqueries
   - Passing query results to pandas DataFrames
6. Functions and Analysis:

   - Using basic mathematical functions for a selected dataset
   - Functions generating charts and statistics
   - Using custom Python functions defined by the user

## Our Experience

AATC trainers have taught software engineering since 2015, delivering more than 11,000 hours of training to over 32,000 students worldwide. The exercises draw on that teaching experience and professional projects.

## Prerequisites

- Basic knowledge of Python programming
- Familiarity with using an IDE (e.g., PyCharm, VSCode)
- Familiarity with using version control systems (e.g., Git)

## Setup

- Newest version of Python
- IDE of your choice (e.g., PyCharm, VSCode)
- Git installed and configured
- GitHub account
- Web browser (e.g., Chrome, Firefox, Safari, etc.)
- SQLite3 installed locally
- Possibility to install PostgreSQL locally (eg. using Docker)

## Related Courses

- [Django](<https://aatc.pl/software/web/django/index.md>)
- [REST API](<https://aatc.pl/software/web/rest-api/index.md>)
- [SQL Databases](<https://aatc.pl/software/web/database/index.md>)
- [DevOps](<https://aatc.pl/software/engineering/devops/index.md>)
- [All Courses](<https://aatc.pl/software/index.md>)

## Date

This course is scheduled on demand. Contact us with your preferred dates and group size so we can check availability and arrange a suitable session.

## Contact

Email [info@aatc.pl](<mailto:info@aatc.pl>) for help with program details, preparation, or booking.

## Apply

To apply, email [info@aatc.pl](<mailto:info@aatc.pl>) with your name, the program you are interested in, and your preferred dates.
