Master Databases in Python: In-Depth Training on SQLAlchemy, SQLite, PostgreSQL, and MySQL

What you'll learn

Understand and Apply Fundamental Python Database Concepts

Implement and Manage SQLite Databases using Python

Develop Proficiency with PostgreSQL and MySQL using Python

Master SQLAlchemy for Database Operations

Adapt to Real-world Scenarios with Hands-On Projects

Requirements

Basic Python Knowledge

Description

Welcome to the Python Database Course, a comprehensive journey through the world of database management and integration using Python. This course is meticulously designed to provide in-depth training on four major databases: SQLite, PostgreSQL, MySQL, and the SQLAlchemy ORM. Whether you're a beginner aspiring to delve into the realm of databases, or an experienced developer aiming to enhance your database skills in Python, this course is tailored just for you.Course Highlights:SQLite Mastery: Start your database journey with SQLite, the go-to choice for lightweight database needs. Learn to implement, query, and manage SQLite databases with Python, making it ideal for small-scale projects and standalone applications.PostgreSQL Proficiency: Dive into the world of enterprise-level databases with PostgreSQL. Understand how to set up robust, efficient, and secure databases. Delve into advanced features like indexing, views, and stored procedures to manage complex data with ease.MySQL Integration: Gain expertise in one of the most popular database systems, MySQL. Learn the nuances of using MySQL with Python to handle large-scale data operations. Master techniques to optimize, secure, and scale your MySQL databases.SQLAlchemy Core: Unravel the power of SQLAlchemy as an ORM (Object Relational Mapper). Learn to bridge the gap between Python code and database engines, enabling seamless data manipulation and querying with high-level Pythonic constructs.What You Will Learn:Fundamentals of database theory and SQL.Practical implementation of CRUD operations (Create, Read, Update, Delete).Advanced database concepts such as transactions, indexing, and normalization.Hands-on experience with real-world database applications.Best practices for database design, security, and performance optimization.Why Choose This Course?Hands-On Approach: Engage in practical exercises, projects, and case studies to solidify your learning experience.Industry-Relevant Skills: Equip yourself with the skills sought after in today's tech-driven job market.Expert Instruction: Learn from seasoned instructors with years of industry and teaching experience.Community and Support: Join a community of like-minded learners and receive dedicated support throughout your learning journey.Flexibility and Convenience: Enjoy the freedom of self-paced learning, tailored to fit your schedule.Who Is This Course For?Aspiring data scientists and database professionals.Software developers and engineers looking to expand their database skills.Python programmers who wish to integrate databases into their applications.Anyone interested in mastering database management through Python.Get ready to embark on a transformative learning experience that will elevate your Python and database skills. Enroll now and start your journey towards mastering SQLite, PostgreSQL, MySQL, and SQLAlchemy!

Overview

Section 1: Introduction

Lecture 1 How to use the Course

Section 2: A Comprehensive Python Starter Kit

Lecture 2 IDE - Code Editor for the Course

Lecture 3 Values and Types

Lecture 4 Variables

Lecture 5 Operators

Lecture 6 Asking User for Input

Lecture 7 Python Comments

Lecture 8 Variable Naming

Lecture 9 Boolean Expressions

Lecture 10 Conditional Execution

Lecture 11 Nested Conditionals

Lecture 12 Chained Conditionals

Lecture 13 Multiple IF Statements

Lecture 14 Logical Operators

Lecture 15 Try and Except

Lecture 16 Calling Builtin Functions

Lecture 17 Math Module

Lecture 18 Random Module

Lecture 19 Defining Function

Lecture 20 Indentation in Python

Lecture 21 Function with Inputs

Lecture 22 Positional and Keyword Arguments

Lecture 23 Function with Output

Lecture 24 Docstring

Lecture 25 List and Iterations

Lecture 26 For Loop

Lecture 27 Updating Variables

Lecture 28 Loop Over Custom Function

Lecture 29 Range Function with Loop

Lecture 30 While Loop

Lecture 31 Continue and Break

Lecture 32 What is a String?

Lecture 33 String Operations

Lecture 34 String Methods

Lecture 35 String Parsing

Lecture 36 Escape Sequence

Lecture 37 String Formatting

Section 3: Introduction to Databases in Python

Lecture 38 What is a Database?

Lecture 39 Relational Databases

Lecture 40 Non Relational Databases

Lecture 41 Python Database API

Section 4: SQLite in Python

Lecture 42 What is SQL?

Lecture 43 What is SQLite?

Lecture 44 Connect SQLite with Python

Lecture 45 SQLite Browser

Lecture 46 Create Table in SQLite

Lecture 47 What is Cursor?

Lecture 48 Insert INTO - Adding Data to a Table in SQLite

Lecture 49 Insert data from CSV to SQLite

Lecture 50 SELECT - Retrieve Data from SQLIte

Lecture 51 WHERE - Filter Data in SQLite

Lecture 52 UPDATE - Change Data

Lecture 53 DELETE / DROP - Remove Data

Lecture 54 JOINS - Access Tables Together

Section 5: Real Project - Password Manager using SQLite

Lecture 55 What you will make by the end of the section

Lecture 56 Step 1 - Design Layout and Create Widgets

Lecture 57 Step 2 - Place Widgets on Screen

Lecture 58 Step 3 - Develop Backend

Lecture 59 Step 4 - Connecting Backend with Frontend

Section 6: SQL Alchemy Core

Lecture 60 What is SQLAlchemy?

Lecture 61 Connecting Database and Create Table using SQLAlchemy Core

Lecture 62 Insert Data to SQLite using SQLAlchemy Core

Lecture 63 Retrieve Data from SQLite using SQLAlchemy

Lecture 64 Update Data using SQLAlchemy Core

Lecture 65 Delete Data using SQLAlchemy Core

Lecture 66 Join Tables using SQLAlchemy Core

Section 7: Password Manager Project using SQLAlchemy Core

Lecture 67 What you will make by the end of the section

Lecture 68 Develop Backend using SQLAlchemy Core

Section 8: SQL Alchemy ORM

Lecture 69 Connecting Database and Create Table using SQLAlchemy ORM

Lecture 70 Insert Data to Database using SQLAlchemy ORM

Lecture 71 Retrieve Data From Database using SQLAlchemy ORM

Lecture 72 Filter Operations SQLAlchemy ORM

Lecture 73 Update Data using SQLAlchemy ORM

Lecture 74 Delete Data From Database using SQLAlchemy ORM

Lecture 75 Building Relationship SQLAlchemy ORM

Lecture 76 Join Tables using SQLAlchemy ORM

Section 9: Password Manager using SQLAlchemy ORM

Lecture 77 What you will make by the end of the section

Lecture 78 Develop Backend Using SQLAlchemy ORM

Section 10: MySQL in Python

Lecture 79 What is MySQL?

Lecture 80 Installing MySQL on Mac

Lecture 81 Installing MySQL Workbench on Mac

Lecture 82 Installing MySQL and MySQL Workbench on Windows

Lecture 83 Creating Database and Tables in MySQL

Lecture 84 Connecting MySQL using Python

Lecture 85 MySQL Database Operations using Python

Lecture 86 Pythonic Application SQLAlchemy ORM - MySQL

Lecture 87 Insert/Retrieve Data to MySQL using SQLAlchemy ORM

Lecture 88 MySQL Challenge

Lecture 89 Import Data from CSV to MySQL

Lecture 90 Import Data using Pandas to MySQL

Section 11: Employee Management System -MySQL App

Lecture 91 What you will make by the end of the section

Lecture 92 Step 1 - Create Database and Table in MySQL

Lecture 93 Step 2 - Insert Data MySQL

Lecture 94 Step 3 - Fetch/Update/Delete Data from MySQL

Section 12: PostgreSQL in Python

Lecture 95 What is PostgreSQL?

Lecture 96 Installing PostgreSQL on Mac

Lecture 97 Installing PostgreSQL on Windows

Lecture 98 Create a PostgreSQL Database

Lecture 99 Insert and Select Data using SQL Statements

Lecture 100 Pythonic Interactions with PostgreSQL using SQLAlchemy Core

Lecture 101 Pythonic Interactions with PostgreSQL using SQLAlchemy ORM

Lecture 102 Create Stored Procedure in PostgreSQL and Call it using Python

Section 13: HCM using PostgreSQL

Lecture 103 What you will make by the end of the section

Lecture 104 Project Solution - PostgreSQL Implementation

Anybody interested in learning databases using Python!,Self-taught programmers who have a basic knowledge in Python and want to be professional in Python Databases!,Students currently studying computer science and want supplementary material for databases in Python!,Professional programmers who want to sharpen their Python database skills.