Python Database Course – Sqlite, Postgresql, Mysql,Sqlalchemy

Free Download Python Database Course – Sqlite, Postgresql, Mysql,Sqlalchemy
Published 12/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.19 GB | Duration: 12h 54m
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.

Homepage

https://www.udemy.com/course/python-database-course-sqlite-postgresql-mysqlsqlalchemy/