Course

Python ORM - MSIB 7 - 2024

12 credits

Advanced

Enroll

Online

2350000 IDR.

The course covers the basics of mapping between a relational base and an object-oriented model (ORM) with a focus on the Django framework. It starts with an introduction to ORM and its key concepts before moving on to working with models in Django, including defining models, fields and methods. The course then delves into advanced topics such as Django's migrations and admin interface, query operations, relationships between models, and inheritance. Students will also learn more advanced techniques for working with models and working with ORM queries in Django. The course also covers another popular Python ORM framework, SQLAlchemy, which offers an alternative approach. Exercises will be provided throughout the course to help reinforce their knowledge at each step. By the end of this course, attendees will have the basic skills to build robust, scalable, and efficient database-driven web applications using Python ORM frameworks.

Topics

Resources
Resources

No description yet

Resources

There are no resources for this lecture yet
Course Introduction
Course Introduction

No description yet

Resources

There are no resources for this lecture yet
ORM Introduction
ORM Introduction

• ORM - Overview, Use Cases and Advantages;
• Database Drivers;
• Django ORM;
• Using ORM in Django.

Resources

There are no resources for this lecture yet
Django Models Basics
Django Models Basics

• Introduction to Models;
• Model Fields and Field Types;
• Model Field Options.

Resources

There are no resources for this lecture yet
Exercise: Django Models Basics
Exercise: Django Models Basics

No description yet

Resources

There are no resources for this lecture yet
Migrations and Django Admin
Migrations and Django Admin

• Introduction to Migrations;
• Migration Commands;
• Introduction to Django Admin Site;
• Customizing Django Admin Site;
• Customizing Migrations.

Resources

There are no resources for this lecture yet
Exercise: Migrations and Django Admin
Exercise: Migrations and Django Admin

No description yet

Resources

There are no resources for this lecture yet
Data Operations in Django with Queries
Data Operations in Django with Queries

• CRUD;
• QuerySet Explained;
• Writing CRUD Queries in Django.

Resources

There are no resources for this lecture yet
Exercise: Data Operations in Django with Queries
Exercise: Data Operations in Django with Queries

No description yet

Resources

There are no resources for this lecture yet
Working with Queries in Django
Working with Queries in Django

• Advanced Queries in Django;
• Django Lookups;
• Django Bulk Queries.

Resources

There are no resources for this lecture yet
Exercise: Working with queries in Django
Exercise: Working with queries in Django

No description yet

Resources

There are no resources for this lecture yet
Django Models Relations
Django Models Relations

• Database Normalization;
• Relationships Explained;
• One-to-One Relationship;
• Many-to-One Relationship;
• Many-to-Many Relationship.

Resources

There are no resources for this lecture yet
Exercise: Django Models Relations
Exercise: Django Models Relations

No description yet

Resources

There are no resources for this lecture yet
Models Inheritance and Customization
Models Inheritance and Customization

• Inheritance of Models;
• Abstract Models;
• Custom Fields;
• Model Methods.

Resources

There are no resources for this lecture yet
Exercise: Models Inheritance and Customization
Exercise: Models Inheritance and Customization

No description yet

Resources

There are no resources for this lecture yet
Advanced Django Model Techniques
Advanced Django Model Techniques

• Mixins;
• Indexing;
• Meta Class.

Resources

There are no resources for this lecture yet
Exercise: Advanced Django Model Techniques
Exercise: Advanced Django Model Techniques

No description yet

Resources

There are no resources for this lecture yet
Advanced Queries in Django
Advanced Queries in Django

• Custom Managers;
• Prefetch Data;
• Debugging Queries.

Resources

There are no resources for this lecture yet
Exercise: Advanced Queries in Django
Exercise: Advanced Queries in Django

No description yet

Resources

There are no resources for this lecture yet
SQLAlchemy
SQLAlchemy

• Introduction;
• Defining Models;
• Migrations;
• Queries and CRUD Operations.

Resources

There are no resources for this lecture yet
Exercise: SQLAlchemy
Exercise: SQLAlchemy

No description yet

Resources

There are no resources for this lecture yet
Exam Preparation
Exam Preparation

No description yet

Resources

There are no resources for this lecture yet
Workshop - Simple Django Project
Workshop - Simple Django Project

No description yet

Resources

There are no resources for this lecture yet
Workshop - Simple Django Project with SQLAlchemy
Workshop - Simple Django Project with SQLAlchemy

No description yet

Resources

There are no resources for this lecture yet
Regular Exam
Regular Exam

No description yet

Resources

There are no resources for this lecture yet

See all topics

When does the course start?

Training starts on October 28, 2025. You can find a detailed schedule of classes in the " Topics " section.

When and where will the classes take place?

You can learn online in real time. Immediately after each lesson, you also get access to the lesson recording and learning resources.

What is the exam and when will it be held?

The exam will be held online on October 29 . It will include a practical part - in the form of practical tasks and a theoretical part - in the form of a test .

Will I get a certificate after the exam?

After passing the exam, you will acquire a certificate from SoftUni if you score above Mn. a good 5.00 from the practical part, and you will also have the opportunity to obtain a state-recognized " Professional Training Certificate " valid throughout the European Union. You can view the requirements for obtaining a certificate HERE .