Python Database Course: SQLite, PostgreSQL, MySQL,SQLAlchemy

Focused View

Elshad Karimov

12:54:09

18 View

1 - Introduction

1 - How to use the Course.mp4

01:38

2 - A Comprehensive Python Starter Kit

2 - IDE Code Editor for the Course.mp4

08:08

3 - Start Code.txt

3 - Values and Types.mp4

10:45

4 - Start Code Variables.txt

4 - Variables.mp4

09:27

5 - Operators.mp4

15:08

5 - Start Code Operators.txt

6 - Asking User for Input.mp4

10:43

6 - Input Fucntion.txt

7 - Python Comments.mp4

04:44

7 - Python Comments.txt

8 - Variable Naming.mp4

05:36

9 - Boolean Expressions.mp4

07:00

9 - Boolean Expressions.txt

10 - Conditional Execution.mp4

13:20

10 - Conditional Execution.txt

11 - Nested Conditionals.mp4

11:18

12 - Chained Conditionals.mp4

10:04

13 - Multiple IF Statements.mp4

10:43

14 - Logical Operators.mp4

08:11

14 - Logical Operators.txt

15 - Try and Except.mp4

14:29

15 - Try and Except.txt

16 - Builtin Functions.txt

16 - Calling Builtin Functions.mp4

07:02

17 - Math Module.mp4

12:06

17 - Math Module.txt

18 - Randomization.txt

18 - Random Module.mp4

10:53

19 - Defining Function.mp4

09:40

19 - Defining Function.txt

20 - Indentation.txt

20 - Indentation in Python.mp4

09:12

21 - Functions with Input.txt

21 - Function with Inputs.mp4

09:42

22 - Positional and Keyword Arguments.mp4

09:41

22 - Positional and Keyword Arguments.txt

23 - Function with Output.mp4

15:16

23 - Function with Outputs.txt

24 - Docstring.mp4

04:11

24 - Docstring.txt

25 - List and Iteration.txt

25 - List and Iterations.mp4

13:44

26 - Foor Loop.txt

26 - For Loop.mp4

09:33

27 - Start Here.txt

27 - Updating Variables.mp4

04:51

28 - Loop Over Custom Function.mp4

03:09

28 - Start Code.txt

29 - Range Function with Loop.mp4

05:23

29 - Start Code.txt

30 - While Loop.mp4

04:13

31 - Continue and Break.mp4

07:37

31 - Continue and Break.txt

32 - Strings Start Code.txt

32 - What is a String.mp4

10:36

33 - String Operations.mp4

08:56

33 - String Operations.txt

34 - String Methods.mp4

10:20

34 - String Methods.txt

35 - String Parsing.mp4

07:59

35 - String Parsing.txt

36 - Escape Sequence.mp4

05:24

36 - Escape Sequence.txt

37 - String Formatting.mp4

12:43

37 - String Formatting.txt

3 - Introduction to Databases in Python

38 - What is a Database.mp4

03:21

39 - Relational Databases.mp4

05:48

40 - Non Relational Databases.mp4

05:40

41 - Python Database API.mp4

02:53

4 - SQLite in Python

42 - What is SQL.mp4

04:08

43 - What is SQLite.mp4

02:20

44 - Connect SQLite with Python.mp4

06:59

44 - SQLite.zip

45 - SQLite Browser.mp4

05:06

46 - Create Table in SQLite.mp4

05:52

46 - SQLite Data Types.txt

47 - What is Cursor.mp4

02:40

48 - Insert INTO Adding Data to a Table in SQLite.mp4

12:02

49 - CSVtoSQLite.zip

49 - CSVtoSQLiteSTART.zip

49 - CSV Library Documentation.txt

49 - Insert data from CSV to SQLite.mp4

07:40

50 - SELECT Retrieve Data from SQLIte.mp4

06:35

51 - WHERE Filter Data in SQLite.mp4

12:38

52 - UPDATE Change Data.mp4

06:07

53 - DELETE DROP Remove Data.mp4

04:42

54 - JOINS Access Tables Together.mp4

07:47

54 - JoinTables.zip

5 - Real Project Password Manager using SQLite

55 - What you will make by the end of the section.mp4

02:41

56 - Step 1 Design Layout and Create Widgets.mp4

06:58

57 - Step 2 Place Widgets on Screen.mp4

08:56

58 - Step 3 Develop Backend.mp4

11:34

59 - Password-Manager.zip

59 - Step 4 Connecting Backend with Frontend.mp4

13:18

6 - SQL Alchemy Core

60 - What is SQLAlchemy.mp4

04:18

61 - Connecting Database and Create Table using SQLAlchemy Core.mp4

06:58

62 - Insert Data to SQLite using SQLAlchemy Core.mp4

05:40

62 - SQLAlchemy.zip

63 - Retrieve Data from SQLite using SQLAlchemy.mp4

07:28

64 - Update Data using SQLAlchemy Core.mp4

06:02

65 - Delete Data using SQLAlchemy Core.mp4

02:35

66 - Join Tables Docs.txt

66 - Join Tables using SQLAlchemy Core.mp4

04:53

66 - SQLAlchemyJoins.zip

7 - Password Manager Project using SQLAlchemy Core

67 - Password-Manager.zip

67 - What you will make by the end of the section.mp4

02:17

68 - Develop Backend using SQLAlchemy Core.mp4

09:39

68 - Password-Manager-SQLAlchemy-Core.zip

8 - SQL Alchemy ORM

69 - Connecting Database and Create Table using SQLAlchemy ORM.mp4

06:31

70 - Insert Data to Database using SQLAlchemy ORM.mp4

04:17

70 - SQLAlchemy-ORM.zip

71 - Retrieve Data From Database using SQLAlchemy ORM.mp4

05:14

72 - Filter Operations SQLAlchemy ORM.mp4

05:06

73 - Update Data using SQLAlchemy ORM.mp4

03:41

74 - Delete Data From Database using SQLAlchemy ORM.mp4

01:06

75 - Building Relationship SQLAlchemy ORM.mp4

09:46

76 - Join Tables using SQLAlchemy ORM.mp4

06:43

9 - Password Manager using SQLAlchemy ORM

77 - What you will make by the end of the section.mp4

01:58

78 - Develop Backend Using SQLAlchemy ORM.mp4

11:20

78 - Password-Manager-SQLAlchemy-ORM.zip

78 - Password-Manager-SQLAlchemy-ORM-START.zip

10 - MySQL in Python

79 - What is MySQL.mp4

04:14

80 - Downloads.txt

80 - Installing MySQL on Mac.mp4

08:06

81 - Installing MySQL Workbench on Mac.mp4

03:07

82 - Installing MySQL and MySQL Workbench on Windows.html

83 - Creating Database and Tables in MySQL.mp4

15:26

83 - Data Types.txt

84 - Connecting MySQL using Python.mp4

07:17

85 - MySQL.zip

85 - MySQL Database Operations using Python.mp4

11:40

86 - MySQL-SLQAlchemy-ORM.zip

86 - Pythonic Application SQLAlchemy ORM MySQL.mp4

11:04

87 - InsertRetrieve Data to MySQL using SQLAlchemy ORM.mp4

09:03

87 - MySQL-SLQAlchemy-ORM-2.zip

88 - MySQL Challenge.mp4

10:37

89 - Import Data from CSV to MySQL.mp4

09:14

89 - MySQL-CSV-START.zip

90 - Import Data using Pandas to MySQL.mp4

03:47

90 - MySQL-Pandas.zip

90 - MySQL-Pandas-START.zip

11 - Employee Management System MySQL App

91 - EMP-Manager-START.zip

91 - What you will make by the end of the section.mp4

04:01

92 - Step 1 Create Database and Table in MySQL.mp4

08:07

93 - Step 2 Insert Data MySQL.mp4

04:11

94 - EMP-Manager.zip

94 - Step 3 FetchUpdateDelete Data from MySQL.mp4

06:41

12 - PostgreSQL in Python

95 - What is PostgreSQL.mp4

02:23

96 - Installing PostgreSQL on Mac.mp4

03:57

97 - Installing PostgreSQL on Windows.html

98 - Create a PostgreSQL Database.mp4

04:40

98 - employees.csv

99 - Insert and Select Data using SQL Statements.mp4

10:56

100 - PostgreSQL-Core.zip

100 - Pythonic Interactions with PostgreSQL using SQLAlchemy Core.mp4

09:40

101 - Pythonic Interactions with PostgreSQL using SQLAlchemy ORM.mp4

08:30

102 - Create Stored Procedure in PostgreSQL and Call it using Python.mp4

14:42

13 - HCM using PostgreSQL

103 - HCM-PostgreSQL-START.zip

103 - What you will make by the end of the section.mp4

02:44

104 - HCM-PostgreSQL.zip

104 - Project Solution PostgreSQL Implementation.mp4

15:20

Description

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

Who is this for?

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.

What You Need to Know?

Basic Python Knowledge

More details

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!

Who this course is for:
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.

User Reviews

Rating

average 0

Total votes0

Focused display

I am Elshad Karimov and I am a Software Developer, online instructor , blogger and author of book, Data Structures and Algorithms in Swift. I have more than 10 years of software development experience with a solid background in Python and Java as well as Oracle PL/SQL, Swift and C#. I have been working in several companies and developed several extensions for financial and billing softwares. I have developed several games using Unity and mobile apps for different purposes.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.