Python for Databases: Learning Data Management with Python
Realize Python's potential to connect to and use a variety of database management systems.
Course overview
Learn how Python can work with relational and non-relational databases to store, retrieve, and manipulate data. The course moves from Python fundamentals through SQLite and PostgreSQL to other relational database systems and MongoDB Atlas.
Course coverage
Explore database tools and techniques across several systems, with Python as the common thread.
- 01 Python fundamentals
- 02 Database concepts
- 03 SQLite with Python
- 04 PostgreSQL and Python
- 05 Other relational databases
- 06 MongoDB Atlas with Python
- 07 Course conclusion
Participants will learn to
- Use Python syntax, data structures, control flow, functions, and error handling.
- Retrieve and manipulate data with SQL queries.
- Perform CRUD operations with SQLite.
- Connect Python to PostgreSQL and work with transactions.
- Recognize differences among relational database systems.
- Connect Python with MySQL, Oracle, Microsoft SQL Server, and IBM Db2.
- Create collections and work with documents in MongoDB Atlas.
- Compare relational and NoSQL approaches to data management.
Format and audience
For: Aspiring programmers, Python learners, data analysts, and software developers interested in database management.
Prerequisites: Some programming experience is ideal but not necessary. A working PC is listed as a requirement.
How it works: On-demand video with practical demonstrations, exercises, articles, and downloadable resources.
Explore the course
Review the current course details and enrollment options on Udemy.
Additional one day Instructor Lead program is also available upon request! Request a Quote