Databases with Python: MySQL, SQLite & MongoDB with Python
- Description
- Curriculum
- FAQ
- Reviews
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.
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
-
Practicing MongoDB with Python
-
Create, insert, update, filter and delete documents and collections in NoSQL
-
Get the instructor QA support
-
and more.
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
-
6Download MySQLVideo lesson
-
7Install MySQLVideo lesson
-
8MySQL ConnectorVideo lesson
-
9Creating database and testingVideo lesson
-
10Creating tables and checkingVideo lesson
-
11PRIMARY KEY for tablesVideo lesson
-
12Insert records into tablesVideo lesson
-
13Adding many recordsVideo lesson
-
14SELECT and fetchall dataVideo lesson
-
15SELECT COLUMNSVideo lesson
-
16Get the first recordVideo lesson
-
17Filter the resultsVideo lesson
-
18Wildcard CharactersVideo lesson
-
19Sorting the resultsVideo lesson
-
20Deleting records and preventing SQL injectionsVideo lesson
-
21Removing tablesVideo lesson
-
22Updating tables and escaping valuesVideo lesson
-
23LimitationVideo lesson
-
24SQLite with Python Part 1Video lesson
-
25SQLite with Python Part 2Video lesson
-
26SQLite with Python Part 3Video lesson
-
27SQLite with Python Part 4Video lesson
-
28SQLite with Python Part 5Video lesson
-
29SQLite with Python Part 6Video lesson
-
30SQLite with Python Part 7Video lesson
-
31SQLite with Python Part 8Video lesson
-
32SQLite with Python Part 9Video lesson
-
33SQLite with Python Part 10Video lesson
-
34SQLite with Python Part 11Video lesson
External Links May Contain Affiliate Links read more