Databases with Python: MySQL, SQLite & MongoDB with Python
What 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
- Using MongoDB with Python
- Create, insert, update, filter and delete documents and collections in NoSQL
- Get the instructor QA support
Requirements
- The basics of Python
- Jupyter Notebook or any Python IDE
Description
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
Who this course is for:
- 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
Instructors
SDE Arts by Ahmed EL Mohandes: Unleashing Your Inner Software Maestro
Tired of endless tutorials and scattered learning? At SDE Arts, we're not about information overload – we're about igniting your software development and data science skills with laser focus.
Think of us as your personal dojo for tech mastery. We sculpt raw talent into confident, high-value engineers through our precise, high-quality video courses. No fluff, just direct, actionable knowledge delivered by industry veterans.
We've honed our craft over 750,000 happy students strong, spanning 205 countries. From budding developers to seasoned engineers, we've witnessed countless transformations, propelling careers forward at breakneck speed.
Our philosophy is simple:
Time is precious: We respect yours by packing maximum value into every minute of our curated video content.
Quality over quantity: We obsess over meticulously crafted lessons, ensuring every step is clear and actionable.
Practicality is king: We don't just teach theory, we show you how to code like a pro, tackling real-world challenges head-on.
Join our courses and unlock your full potential. Whether you're a coding novice or a seasoned veteran, SDE Arts is your launchpad to a thriving career in software engineering and data science.
Ready to write your own tech success story?
Let's code your future, together.
Transforming lives through code and data: Meet Ahmed EL Mohandes, your expert guide to the world of software engineering and data science.
With over 750,000 students from 205+ countries under his wing, Ahmed's passion for simplifying complex skills shines through in everything he does.
He's not just an instructor, he's a bridge builder:
- Expert Software Development Engineer: Bringing years of real-world experience to the classroom.
- Sr. Data Science & ML Consultant: Demystifying data analysis and machine learning with practical insights.
- Training Content Expert & Lead Instructor: Crafting high-quality, engaging courses that cut through the noise and get you results.
His expertise spans the digital landscape:
- Languages: Python, R, JavaScript, Java, Go (and counting)
- Data Science: Master the tools and libraries for powerful data analysis and visualization.
- Databases: Relational and non-relational – he knows them all.
- Software Engineering & Data Science: From design to development, analysis to implementation, Ahmed equips you with the full skillset.
But Ahmed's true strength lies in his passion:
- Simplifying the complex: He takes daunting concepts and breaks them down into bite-sized, actionable steps.
- Clarifying the murky: Demystifying technical jargon and making coding and data science accessible to everyone.
- Sharing his knowledge: Driven by a desire to empower others, Ahmed pours his expertise into high-quality, direct-to-the-point video training courses.
Join Ahmed on a journey of transformation. Whether you're a budding developer, a data science aspirant, or anyone seeking to unlock the power of technology, Ahmed will be your trusted guide, opening doors to a world of possibilities.
Ready to start your journey? Explore Ahmed's courses today!