• Post category:StudyBullet-3
  • Reading time:8 mins read


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

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.


Get Instant Notification of New Courses on our Telegram channel.


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

English
language

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