Backend Software Engineering

Описание курса

80+ Amaliy vazifalar

55+ Uyga vazifalar

5+Portfolio loyihalari

8 oy

Modullar

Kurs davomida o‘tilishi rejalashtirilgan modullar ro‘yxati

Module 0: Core Mindset

• Core: What is a Computer and how it works?
• Core: Number Systems and Logic Gates
• Flowcharts: conditionals and loops - solving problems without writing code
• C language: Introduction, Variables and Data Types
• C language: Conditionals and Loops
• C language: Functions and Recursion
• C language: Arrays and Strings
• C language: Pointers and Memory Adressing
• C language: Static and Dynamic Memory
• C language: Structs and Data Modeling
• C language: File I/O
• Project 1: Student Management System
• OS: What is an Operating System?
• OS: Introduction to Processes
• OS: Interprocess Communication (over sockets)
• OS: Concurrency and Parallelism: Comparing Processes and Threads
• Networking: What is a Computer Networking?
• Networking: TCP and UDP protocols. Client-Server architecture
• Core: Working with Git
• Project 2: Build Your Own TCP Server in C

Module 1: Python

• Variables, Data Types, Conditionals
• Loops and Recursion
• Sequence Data Types: list, tuple, set
• Mapping Data Type: dict
• Functions, function annotations
• Decorators: Functions are objects!
• Functional programming: lambda, map(), filter()
• Exception Handling
• File Handling and Context Managers
• Intro to OOP: Classes and Objects
• Object methods, class methods, static methods
• Inheritance and Polymorphism. super() keyword
• Modules and Packages: pip package manager
• Virtual Environments: venv
• Sending requests to the web
• Project 3: Bank Management CLI application

Module 2: Database Systems

• What is a database?
• Intro to SQL? What are RDBMS?
• Relational database structure
• Basic Querying: SELECT, WHERE, ORDER BY
• Insert, Update and Remove data: INSERT, UPDATE, DELETE
• Aggregate functions: MAX, MIN, COUNT, SUM, AVG
• Operators: IN, BETWEEN, LIKE, ILIKE
• NULL values. SQL Constraints
• Primary Keys and Foreign Keys
• Relationships: One-to-One, One-to-Many and Many-to-Many
• SQL joins: INNER JOIN, LEFT JOIN, RIGHT JOIN
• Set Operations: UNION, INTERSECTION and EXCEPT
• Python DB-API (psycopg2)
• Introduction to ORMs (SQLAlchemy)
• Project 4: Bank Management ORM application

Module 3: FastAPI

• Why do we need web frameworks?
• Intro to Asynchronous Programming: Event loop
• Pythonic Constructs: Iterators, Generators and Coroutines
• Our first FastAPI endpoints with fake database
• Request parameters: Path, Query, Header and Body
• Pydantic Models: Validations Made Easy!
• Dependency Injection
• Integrating our FastAPI application with database
• Database migrations: Alembic
• Authentication and Authorization: Session and JWT
• Testing: FastAPI TestClient and Pytest
• Project 5: Gamified E-Learning Platform API

Module 4: Django

• MVC structure, HTTP request-response cycle, basic app
• URLs and views: rendering templates using function-based and class-based views
• Unit Tests
• Models: connecting to database and managing it with Django ORM
• Django Admin interface: customizations
• Django Forms
• Authentication: built-in session based auth
• Deeper into User model: Customize User model
• Basic CRUD operations in templates: Generic Views
• Deeper look on Django’s Template Language
• Sending emails: password reset and register confirmations
• Permissions and Authorization (Custom Permissions)
• Static and Media Files (File Uploads, Django Storages)
• Django REST Framework intro: API Views and Serializers
• Practicing with CRUD APIs using Generic Views and serializers
• API Unit testing
• DRF’s built-in authentication and permissions
• Implementing JWT authentication with Custom User model
• Swagger documentation support
• DRF filters
• Django Signals
• i18n and l10n
• Management commands
• Caching - Redis
• Asynchronous tasks: Celery