Overview What You Will Learn Curriculum Instructor

Course Overview

Databases are the foundation of modern applications, enabling developers to efficiently store, manage, and retrieve structured and unstructured data. Integrating databases with Python allows developers to build scalable web applications, automate data-driven workflows, and create powerful backend services. This course provides a practical introduction to working with MySQL, SQLite, and MongoDB using Python, equipping learners with the skills to manage both relational and NoSQL databases in real-world applications.

This course begins with an overview of MySQL, SQLite, and MongoDB, highlighting their architectures, use cases, and key differences. You will then learn to integrate MySQL with Python by creating databases and tables, performing CRUD operations, filtering and sorting data, managing relationships, and implementing secure coding practices to prevent SQL injection. The course continues with SQLite, where you will build and manage lightweight file-based databases suitable for desktop, embedded, and local applications. Finally, you will explore MongoDB, learning how to create collections, insert, update, query, and delete documents while working with flexible NoSQL data structures through practical hands-on exercises.

By the end of this course, you will be able to confidently integrate MySQL, SQLite, and MongoDB into Python applications to design, manage, and query both relational and NoSQL databases.

What You Will Learn

  • Learn to build and manipulate databases with Python.
  • Master SQL programming.
  • Learn how to install and use MySQL tools.
  • Explore how to use MySQL with Python.
  • Learn to create, insert, update, filter, and delete records, tables, and databases in SQL.
  • Apply SQL commands in Python without installing additional database management programs.
  • Learn how to use SQLite with Python.
  • Master NoSQL programming concepts.
  • Gain an understanding of installing and using MongoDB tools.
  • Practice MongoDB development with Python.
  • Learn to create, insert, update, filter, and delete documents and collections in MongoDB.

Program Curriculum

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

  • 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
  • Chapter 2 Quiz

  • 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
  • Chapter 3 Quiz

  • 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
  • Chapter 4 Quiz
Load more modules

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

Fastest Way to Level Up Your Cybersecurity Skills

Invest in your future with flexible subscription plans that give you access to the world’s largest online cybersecurity course library. Whether you're exploring cybersecurity courses for beginners or advancing your expertise,
access in-demand courses, practical labs, and CTF challenges designed to support continuous learning.

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

Pro

Build your cybersecurity skills with 900+ bite-sized courses and curated learning paths designed for continuous learning.

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

What is included

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

Pro +

Develop real-world cybersecurity skills through hands-on labs and CTF challenges designed for practical learning.

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

Everything in Pro, Plus:

  • 1600+ Hands-on lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Hands-on Labs and Challenges added every month

Related Courses

  • Bootstrap 4 Quick Website Bootstrap Components Course
    Short Course

    Bootstrap 4 Quick Website Bootstrap Components Course

    Software Development

    Explore the basics of Bootstrap and learn to create a website...

    $49.99

    Beginner

    1 hr 30 m

  • CCNA - Understanding Routers and Switches
    Short Course

    CCNA - Understanding Routers and Switches

    Security Architecture and Operations

    A comprehensive guide to understanding the in-depth functioni...

    $49.99

    Intermediate

    2 hr 0 m

  • The Complete Full-Stack JavaScript Course
    Short Course

    The Complete Full-Stack JavaScript Course

    Software Development

    Learn full-stack web development using JavaScript (ReactJS, N...

    $79.99

    Beginner

    24 hr 17 m

  • React.JS for Ecommerce: Building a Store with React.JS
    Short Course

    React.JS for Ecommerce: Building a Store with React.JS

    DevSecOps

    From React.js Fundamentals to Crafting an Online Storefront

    $49.99

    Advanced

    3 hr 30 m

  • CISSP Certification Domains 5, 6, 7, and 8 Video Training
    Short Course

    CISSP Certification Domains 5, 6, 7, and 8 Video Training

    Cybersecurity

    This course is ideal for individuals who desire to pass the I...

    $69.99

    Intermediate

    6 hr 30 m

  • Helm 3 - Package Manager for Kubernetes
    Short Course

    Helm 3 - Package Manager for Kubernetes

    Software Development

    A must tool for every DevOps engineer

    $49.99

    Intermediate

    1 hr 27 m

  • Learn Ethical Hacking by Hacking Real Websites Legally
    Short Course

    Learn Ethical Hacking by Hacking Real Websites Legally

    Vulnerability Assessment and Pentesting

    Fun way to learn ethical hacking by playing online hacking ga...

    $69.99

    Beginner

    4 hr 18 m

  • Mastering Ansible Playbooks: Debugging and Security
    Short Course

    Mastering Ansible Playbooks: Debugging and Security

    Software Development

    Securing and Automating Linux and Windows Systems with Advanc...

    $99.99

    Advanced

    5 hr 34 m

1 50
View all