Overview What You Will Learn Curriculum Instructor

Course Overview

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. 

By the end of this course, you will have learned how to work with SQL and NoSQL Databases in the Python Programming Language.

The necessary resources for this course are in the "Resources" section of Video 1.1. You can also access them through this direct link - https://github.com/ec-council-learning/Databases-with-Python-MySQL-SQLite-MongoDB-with-Python

What You Will Learn

  • Learn to build and manipulate Databases with Python
  • Master SQL programming
  • Learn how to install and use the MySQL tools
  • Explore how to use MySQL with Python
  • Learn to create
  • insert
  • update
  • filter
  • and delete records
  • tables
  • and databases in SQL
  • How to apply the SQL Commands in Python without installing programs
  • Learn about using SQLite with Python
  • Master NoSQL programming
  • Gain an understanding on installing and using the MongoDB tools
  • Practicing MongoDB with Python
  • How to create
  • insert
  • update
  • filter
  • and delete documents and collections in NoSQL

Program Curriculum

  • What You Should Know
  • What is MySQL?
  • What is SQLite?
  • What is MongoDB?
  • $7 Million Cybersecurity Scholarship by EC-Council

  • 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 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 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

Instructor

Ahmed Ibrahim

Ahmed Ibrahim has taught more than 300,000 developers and engineers from over 175 countries around the world. He has experience with many programming languages and tools. He also possesses proficient knowledge and experience in Software Engineering and Data Science with skills to analyze, design, and develop. He has a Bachelor's degree in Electrical, Communications, and Computer Engineering.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering extensive resources with 600+ courses and diverse Learning Paths to enhance your skills.

$ 499.00
Billed annually or $59.00 billed monthly
Get Started Now
Start your 7-day trial for $1

What is included

  • 700+ Premium Short Courses
  • 50+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs, CTF Challenges, and exclusive EC-Council certifications for comprehensive skill-building.

$ 599.00
Billed annually or $69.00 billed monthly
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 800+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month
  • 3 Official EC-Council Essentials Certifications¹ (retails at $897!)
    Exclusive Bonus with Annual Plans

¹This plan includes Digital Forensics Essentials (DFE), Ethical Hacking Essentials (EHE), and Network Defense Essentials (NDE) certifications. No other EC-Council certifications are included.

Related Courses

  • Statistics Fundamentals: Bundled

    Statistics Fundamentals: Bundled

    Short Course

    Statistics Fundamentals: Bundled

    Data Science

    Theory and Python

    $59.99

    Beginner

    14 hr 32 m

  • Data Wrangling with Pandas - Part 2

    Data Wrangling with Pandas - Part 2

    Short Course

    Data Wrangling with Pandas - Part 2

    Data Science

    Explore the World of Data Processing with Pandas and Get a Ch...

    $59.99

    Beginner

    3 hr 11 m

  • Hands-on Python Web Scraping from Scratch

    Hands-on Python Web Scraping from Scratch

    Short Course

    Hands-on Python Web Scraping from Scratch

    Data Science

    Master the art of programming & building custom web scrap...

    $69.99

    Beginner

    4 hr 30 m

  • Data Visualization Using Tableau - Part 3

    Data Visualization Using Tableau - Part 3

    Short Course

    Data Visualization Using Tableau - Part 3

    Data Science

    Master Tableau Calculations and Create Your Own Dashboards!

    $49.99

    Beginner

    2 hr 30 m

  • Applied Logistic Regression

    Applied Logistic Regression

    Short Course

    Applied Logistic Regression

    Data Science

    A data-driven approach to classification

    $59.99

    Beginner

    3 hr 9 m

  • A Crash Course to Build Your Own Chatbot

    A Crash Course to Build Your Own Chatbot

    Short Course

    A Crash Course to Build Your Own Chatbot

    Data Science

    Learn the essentials of creating your chatbot from scratch us...

    $79.99

    Beginner

    4 hr 0 m

  • Deep Dive into Snowflake

    Deep Dive into Snowflake

    Short Course

    Deep Dive into Snowflake

    Data Science

    Master Snowflake for Advanced Data Warehousing and Analytics

    $49.99

    Advanced

    2 hr 30 m

  • Business Intelligence with Power BI Desktop

    Business Intelligence with Power BI Desktop

    Short Course

    Business Intelligence with Power BI Desktop

    Data Science

    Master Power BI, Data analysis, Visualization, and Designing ...

    $59.99

    Intermediate

    7 hr 8 m

1 8