Python Database Course: Learn MySQL, SQLite & MongoDB

You will learn how to use SQL and NoSQL databases with the Python programming language, from beginning to professionalism.

What you'll learn in this course

• Build and Manipulate Databases with Python

• Master SQL programming

• Installing and using the MySQL tools

• Using MySQL with Python

• Create, insert, update, filter and delete records, tables and databases in SQL

• Apply the SQL Commands in Python without installing programs

• Using SQLite with Python

• Master NoSQL programming

• Installing and using the MongoDB tools

• Using MongoDB with Python

• Create, insert, update, filter and delete documents and collections in NoSQL

• Get the instructor QA support

• Introduction 06:22

  • 1: Course Intro 01:43
  • 2: What you should know 00:50
  • 3: MySQL overview 01:09
  • 4: SQlite overview 01:16
  • 5: MongoDB overview 01:24

• MySQL with Python 1:39:14

  • 6: Download MySQL 01:09
  • 7: Install MySQL 06:21
  • 8: Install MySQL Connector 03:32
  • 9: Creating database and testing 07:40
  • 10: Creating tables and testing 05:19
  • 11: PRIMARY KEY for tables 06:05
  • 12: Insert records into tables 07:05
  • 13: Adding many records 05:15
  • 14: SELECT and fetchall data 03:51
  • 15: SELECT COLUMNS 05:08
  • 16: Get the first record 04:48
  • 17: Filter the results 06:51
  • 18: Wildcard Characters 04:40
  • 19: Sorting the results 07:00
  • 20: Deleting records and preventing SQL injections 09:05
  • 21: Removing tables 04:33
  • 22: Updating tables and escaping values 06:10
  • 23: Limitations 04:42

• SQLite with Python 38:02

  • 24: SQLite with Python 1 00:45
  • 25: SQLite with Python 2 02:48
  • 26: SQLite with Python 3 01:22
  • 27: SQLite with Python 4 02:44
  • 28: SQLite with Python 5 05:03
  • 29: SQLite with Python 6 00:49
  • 30: SQLite with Python 7 03:54
  • 31: SQLite with Python 8 09:00
  • 32: SQLite with Python 9 02:11
  • 33: SQLite with Python 10 08:15
  • 34: SQLite with Python 11 01:11

• MongoDB with Python 50:35

  • 35: Mongo DB with Python Part 1 02:24
  • 36: Mongo DB with Python Part 2 01:53
  • 37: Mongo DB with Python Part 3 02:07
  • 38: Mongo DB with Python Part 4 08:53
  • 39: Mongo DB with Python Part 5 02:12
  • 40: Mongo DB with Python Part 6 04:44
  • 41: Mongo DB with Python Part 7 03:54
  • 42: Mongo DB with Python Part 8 03:24
  • 43: Mongo DB with Python Part 9 04:49
  • 44: Mongo DB with Python Part 10 02:38
  • 45: Mongo DB with Python Part 11 07:22
  • 46: Mongo DB with Python Part 12 03:25
  • 47: Mongo DB with Python Part 13 02:50

Hello and welcome to Python Database 3 in 1 Ultimate Masterclass: Learn MySQL, SQLite & MongoDB.

Using and manipulating databases is one of the most important and powerful skills that every developer should master well, because it is in great demand in the market constantly and with high salaries.

So, if you want to be a professional developer, engineer or data scientist, it is very important to be familiar with dealing with databases of all kinds.

In this course, you will learn how to use different types of databases with the Python programming language, from beginning to professionalism. You will master the use of SQL through MySQL and SQLite, and Also NoSQL through MongoDB.

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or a place to hold the vast amounts of information in a corporate network.

What is MySQL?

MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL).

MySQL is open source, flexible, high performance, secure, and easy to use.

What is SQLite?

SQLite is a software library that provides a relational database management system. The lite in SQLite means lightweight in terms of setup, database administration, and required resources.

SQLite has the following noticeable features: self-contained, serverless, zero-configuration, transactional.

What is MongoDB?

MongoDB is an open-source NoSQL database management program used for large sets of distributed data.

Organizations can use Mongo DB for its ad-hoc queries, indexing, load balancing, aggregation, server-side execution and other features.

Hi, my name is Ahmed Ibrahim. I’m a software engineer and Data Science Professional, and I’ll be the instructor for this course.

If you have any questions during this course, please don’t hesitate to ask me questions, and I’ll answer you as soon as possible.

So, we have a lot to cover in this unique course.

Let’s get started

• Python developers
• Python Beginners who know the Python basics
• Intermediate Python developer
• Anyone who wants to use databases with Python
• Python developer who wants to advance his dev career
• Programmers, software developers, software engineers and data scientists
• Developers who curious about Databases

• The basics of Python
• Jupyter Notebook or any Python IDE

• Python Developer Avg. salary: $107,003 /Annual
• Software Engineer Avg. salary: $111,206 /Annual
• Software Developer Avg. salary: $100,000 /Annual
• SQL Database Developer Avg. salary: $100,866 /Annual
• Mongodb Developer Salary $121,436 /Annual

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included