Mô tả

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

Bạn sẽ học được gì

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

Yêu cầu

  • The basics of Python
  • Jupyter Notebook or any Python IDE

Nội dung khoá học

4 sections

Introduction

5 lectures
Introduction to course
01:42
What you should know
00:50
What is MySQL?
01:08
What is SQLite?
01:16
What is MonogDB?
01:23

MySQL with Python

18 lectures
Download MySQL
01:09
Install MySQL
06:20
MySQL Connector
03:32
Creating database and testing
07:40
Creating tables and checking
05:19
PRIMARY KEY for tables
06:05
Insert records into tables
07:05
Adding many records
05:15
SELECT and fetchall data
03:50
SELECT COLUMNS
05:08
Get the first record
04:47
Filter the results
06:50
Wildcard Characters
04:39
Sorting the results
07:00
Deleting records and preventing SQL injections
09:05
Removing tables
04:32
Updating tables and escaping values
06:10
Limitation
04:41

SQLite with Python

11 lectures
SQLite with Python Part 1
00:45
SQLite with Python Part 2
02:47
SQLite with Python Part 3
01:21
SQLite with Python Part 4
02:43
SQLite with Python Part 5
05:03
SQLite with Python Part 6
00:48
SQLite with Python Part 7
03:54
SQLite with Python Part 8
08:59
SQLite with Python Part 9
02:11
SQLite with Python Part 10
08:14
SQLite with Python Part 11
01:10

MongoDB with Python

13 lectures
MongoDB with Python Part 1
02:23
MongoDB with Python Part 2
01:53
MongoDB with Python Part 3
02:06
MongoDB with Python Part 4
08:52
MongoDB with Python Part 5
02:11
MongoDB with Python Part 6
04:44
MongoDB with Python Part 7
03:54
MongoDB with Python Part 8
03:23
MongoDB with Python Part 9
04:49
MongoDB with Python Part 10
02:37
MongoDB with Python Part 11
07:21
MongoDB with Python Part 12
03:24
MongoDB with Python Part 13
02:49

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.