Databases with Python: MySQL, SQLite & MongoDB with Python
Learn and understand how to work with SQL and NoSQL Databases with the Python Programming Language.
Note: 4.3/5 (99 notes) 20,760 students
Instructor(s): SDE OCTOPUS | AI
Last update: 2021-10-26
What you’ll 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
- The basics of Python
- Jupyter Notebook or any Python IDE
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
Who this course is for
- 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
- 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
- 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
Time remaining or 781 enrolls left
|Don’t miss any coupons by joining our Telegram group|