Udemyallit

Teoria e Pratica dei Database Relazionali con SQL (e Python)

Learn relational databases, ER diagrams, SQL, and Python ORM. Master data modeling and database interaction. Perfect for aspiring developers!

4.7(254)
1,150students
6h 25m
Certificate
Alessandro Bemporad
Alessandro BemporadSenior Software Engineer, Project Manager, Trainer

Course Content

Teoria e Pratica dei Database Relazionali con SQL (e Python) is an all-levels Udemy course taught by Alessandro Bemporad. It runs 6h 25m, is taught in Italian, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 254 reviews, with 1,150 students enrolled. It is a paid course, last updated September 2023.

Master Relational Databases with SQL & Python: Theory & Practice

This comprehensive course provides a practical and theoretical understanding of relational databases, equipping you with the skills to effectively utilize SQL and Python for data management. Learn to bridge the gap between relational and object-oriented programming with a focus on Object-Relational Mapping (ORM).

What You'll Learn:

  • Relational Database Fundamentals: Gain a solid foundation in the core concepts of relational databases, including data relationships, attributes, data types, tuples, normalization, and keys, based on Edgar Codd's theoretical model.
  • Data Modeling with ER Diagrams: Explore the Entity-Relationship (ER) model for logical data representation. Learn to create ER diagrams and understand concepts like entities, relationships, cardinality, and modes. Master one-to-one, one-to-many, and many-to-many relationships, as well as associative and attributive entities.
  • SQL Mastery: Dive deep into SQL (Structured Query Language), the standard language for interacting with relational databases. Cover Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL), and Transaction Control Language (TCL). Apply SQL to real-world scenarios.
  • Object-Relational Mapping (ORM) with Python: Understand the principles of ORM and learn to map relational data to object-oriented models. Utilize the powerful Peewee library for Python to interact with databases using classes, objects, methods, and properties – eliminating the need to write raw SQL.
  • Practical Database Implementation: Gain hands-on experience with a real database schema. Apply theoretical knowledge to practical exercises and develop skills in database design and management.

Course Structure (4 Levels):

This course is structured into four progressive levels, guiding you from fundamental database theory to practical application.

  • Level 1: Relational Data Model: Introduction to the theoretical underpinnings of relational databases.
  • Level 2: Entity-Relationship Modeling: Learn to design logical data models using ER diagrams.
  • Level 3: SQL & Database Implementation: Master SQL and apply it to practical database scenarios.
  • Level 4: Object-Relational Mapping (ORM) with Peewee: Implement ORM using Python and the Peewee library.

Tools & Technologies:

  • SQLite: A lightweight and widely used relational database management system.
  • SQLite Studio: A free, interactive tool for managing SQLite databases.
  • Peewee: A powerful Python library for ORM.

Ideal For:

This course is designed for professionals and students in fields such as:

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(3)
2h 46m
all
5.0(7)
1h 17m
beginner

GDPR E PROTEZIONE DEI DATI

by Manuela Pironti

5.0(11)
4h 55m
intermediate