Databases with Python- MySQL, SQLite MongoDB with Python

Databases with Python: MySQL, SQLite & MongoDB with Python, available at $54.99, has an average rating of 4.28, with 47 lectures, based on 640 reviews, and has 88919 subscribers.

You will learn about 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 This course is ideal for individuals who are Python developers or Python Beginners who know the Python basics or Intermediate Python developer or Anyone who wants to use databases with Python or Python developer who wants to advance his dev career or Programmers, software developers, software engineers and data scientists or Developers who curious about Databases It is particularly useful for Python developers or Python Beginners who know the Python basics or Intermediate Python developer or Anyone who wants to use databases with Python or Python developer who wants to advance his dev career or Programmers, software developers, software engineers and data scientists or Developers who curious about Databases.

Enroll now: Databases with Python: MySQL, SQLite & MongoDB with Python

Summary

Title: Databases with Python: MySQL, SQLite & MongoDB with Python

Price: $54.99

Average Rating: 4.28

Number of Lectures: 47

Number of Published Lectures: 47

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 47

Original Price: $99.99

Quality Status: approved

Status: Live

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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to course

Lecture 2: What you should know

Lecture 3: What is MySQL?

Lecture 4: What is SQLite?

Lecture 5: What is MonogDB?

Chapter 2: MySQL with Python

Lecture 1: Download MySQL

Lecture 2: Install MySQL

Lecture 3: MySQL Connector

Lecture 4: Creating database and testing

Lecture 5: Creating tables and checking

Lecture 6: PRIMARY KEY for tables

Lecture 7: Insert records into tables

Lecture 8: Adding many records

Lecture 9: SELECT and fetchall data

Lecture 10: SELECT COLUMNS

Lecture 11: Get the first record

Lecture 12: Filter the results

Lecture 13: Wildcard Characters

Lecture 14: Sorting the results

Lecture 15: Deleting records and preventing SQL injections

Lecture 16: Removing tables

Lecture 17: Updating tables and escaping values

Lecture 18: Limitation

Chapter 3: SQLite with Python

Lecture 1: SQLite with Python Part 1

Lecture 2: SQLite with Python Part 2

Lecture 3: SQLite with Python Part 3

Lecture 4: SQLite with Python Part 4

Lecture 5: SQLite with Python Part 5

Lecture 6: SQLite with Python Part 6

Lecture 7: SQLite with Python Part 7

Lecture 8: SQLite with Python Part 8

Lecture 9: SQLite with Python Part 9

Lecture 10: SQLite with Python Part 10

Lecture 11: SQLite with Python Part 11

Chapter 4: MongoDB with Python

Lecture 1: MongoDB with Python Part 1

Lecture 2: MongoDB with Python Part 2

Lecture 3: MongoDB with Python Part 3

Lecture 4: MongoDB with Python Part 4

Lecture 5: MongoDB with Python Part 5

Lecture 6: MongoDB with Python Part 6

Lecture 7: MongoDB with Python Part 7

Lecture 8: MongoDB with Python Part 8

Lecture 9: MongoDB with Python Part 9

Lecture 10: MongoDB with Python Part 10

Lecture 11: MongoDB with Python Part 11

Lecture 12: MongoDB with Python Part 12

Lecture 13: MongoDB with Python Part 13

Instructors

SDE Arts by Ahmed EL Mohandes
Where Skills Soar and Careers Take Flight

Ahmed El Mohandes
Expert Software Engineer | Sr. Data Science & ML Consultant

Rating Distribution

1 stars: 6 votes

2 stars: 19 votes

3 stars: 99 votes

4 stars: 226 votes

5 stars: 291 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!