Databases with Python: MySQL, SQLite & MongoDB with Python

Learn and understand how to work with SQL and NoSQL Databases with the Python Programming Language.

4.44 (128 reviews)
Udemy
platform
English
language
Programming Languages
category
25,779
students
3 hours
content
Oct 2021
last update
$84.99
regular price

What you will learn

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

Description

Hello and welcome to the Databases with Python: MySQL, SQLite & MongoDB with Python Course.

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

Screenshots

Databases with Python: MySQL, SQLite & MongoDB with Python - Screenshot_01Databases with Python: MySQL, SQLite & MongoDB with Python - Screenshot_02Databases with Python: MySQL, SQLite & MongoDB with Python - Screenshot_03Databases with Python: MySQL, SQLite & MongoDB with Python - Screenshot_04

Content

Introduction

Course Introduction
What you should know
What is MySQL?
What is SQLite?
What is MonogDB?

MySQL with Python

Download MySQL
Install MySQL
MySQL Connector
Creating database and testing
Creating tables and checking
PRIMARY KEY for tables
Insert records into tables
Adding many records
SELECT and fetchall data
SELECT COLUMNS
Get the first record
Filter the results
Wildcard Characters
Sorting the results
Deleting records and preventing SQL injections
Removing tables
Updating tables and escaping values
Limitation

SQLite with Python

SQLite with Python Part 1
SQLite with Python Part 2
SQLite with Python Part 3
SQLite with Python Part 4
SQLite with Python Part 5
SQLite with Python Part 6
SQLite with Python Part 7
SQLite with Python Part 8
SQLite with Python Part 9
SQLite with Python Part 10
SQLite with Python Part 11

MongoDB with Python

MongoDB with Python Part 1
MongoDB with Python Part 2
MongoDB with Python Part 3
MongoDB with Python Part 4
MongoDB with Python Part 5
MongoDB with Python Part 6
MongoDB with Python Part 7
MongoDB with Python Part 8
MongoDB with Python Part 9
MongoDB with Python Part 10
MongoDB with Python Part 11
MongoDB with Python Part 12
MongoDB with Python Part 13

Reviews

Taras
June 21, 2022
way too shallow overview how of how it works and too much attention to such super basic and obvious issues as highlighting that we could change the name of the variable in the cycle declaration or that we should place the coma delimiter between arguments in the function
Ian
June 21, 2022
You teach very good and explain very well, i have learned a lot about the database, i congratulate you!
Mateus
May 17, 2022
Has been an excellent experience. I has study python in the last days but my knowledge with databases are small and I thought necessary learn that to improve my abilities.
Roman
May 12, 2022
Clear explanation, nice introduction to CRUD operations with DBMS using python, videos length could be halved if instructor wouldn't repeat the same explanation so many times.
Lucien
November 19, 2021
The course gives you a kickstart into using MySQL, SQLite and MongoDB in a clear (and repetitive) way. However, you won't learn much about features other than basic CRUD. The part on MySQL and SQLite is really just about how to connect and run queries. After that, it's just a repetition of SQL queries run through the Python wrapper. Things are little different in the MongoDB section, where operations actually refer to specific functions used in Python. After this course, you will definitely need to dig deeper into JOINS and alikes, to make good use of SQL and Mongo. Without this, you won't know which tech to use (MySQL, SQLite or MongoDB) for your Python project. For instance, why is the MongoDB structure more suitable for this or that, etc. Would rename the course as an "introduction" and offer an advanced module dealing with these most crucial aspects.

Charts

Price

Databases with Python: MySQL, SQLite & MongoDB with Python - Price chart

Rating

Databases with Python: MySQL, SQLite & MongoDB with Python - Ratings chart

Enrollment distribution

Databases with Python: MySQL, SQLite & MongoDB with Python - Distribution chart

Coupons

DateDiscountStatus
10/28/2021100% OFF
expired
10/28/202192% OFF
expired
11/2/2021100% OFF
expired
11/18/2021100% OFF
expired
11/20/2021100% OFF
expired
12/12/2021100% OFF
expired
12/21/2021100% OFF
expired
12/28/2021100% OFF
expired
1/15/2022100% OFF
expired
2/3/2022100% OFF
expired
2/22/2022100% OFF
expired
3/15/2022100% OFF
expired
3/23/2022100% OFF
expired
3/29/2022100% OFF
expired
4/12/2022100% OFF
expired
4/19/2022100% OFF
expired
4/26/202292% OFF
expired
5/5/2022100% OFF
expired
5/17/2022100% OFF
expired
5/27/2022100% OFF
expired
6/6/2022100% OFF
expired
6/14/2022100% OFF
expired
6/21/2022100% OFF
expired
7/4/2022100% OFF
expired
7/19/2022100% OFF
expired
7/26/202288% OFF
expired
8/3/2022100% OFF
expired
4349894
udemy ID
10/14/2021
course created date
10/28/2021
course indexed date
Bot
course submited by