We may earn an affiliate commission when you visit our partners.
Pluralsight logo

Working with Databases in Python 3

Douglas Starnes

This course will teach you how to develop applications in Python using both relational and NoSQL databases.

Read more

This course will teach you how to develop applications in Python using both relational and NoSQL databases.

In this course, Working with Databases in Python 3, you’ll learn to develop Python applications using both relational and NoSQL databases. First, you’ll explore how to use local databases for development. Next, you’ll discover how to use database servers with native drivers. Finally, you’ll learn how to use a mapper to work with data models in Python. When you’re finished with this course, you’ll have the skills and knowledge of relational and NoSQL databases in Python needed to use databases in your next Python application.

Enroll now

What's inside

Syllabus

Course Overview
Using a Local Relational Database - SQLite
Using a Relational Database - PostgreSQL and psycopg2
Using an ORM - SQLAlchemy
Read more
Using a Local NoSQL Database - Mongita
Using a NoSQL Database - MongoDB and pymongo
Using an ODM - MongoEngine

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Explores using SQL and NoSQL databases in Python, which is standard across the software and data science industries
Taught by Douglas Starnes, who is recognized for his work in teaching and developing Python applications
Examines relational and NoSQL databases, which are highly relevant to software and data science

Save this course

Save Working with Databases in Python 3 to your list so you can find it easily later:
Save

Activities

Coming soon We're preparing activities for Working with Databases in Python 3. These are activities you can do either before, during, or after a course.

Career center

Learners who complete Working with Databases in Python 3 will develop knowledge and skills that may be useful to these careers:
Database Administrator
A Database Administrator is responsible for the day-to-day operation and maintenance of database systems. They are responsible for installing, configuring, and monitoring databases, as well as managing user access and security. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Database Administrators. By taking this course, you will gain the skills needed to manage and maintain databases, making you a valuable asset to any organization looking to protect its data.
Database Designer
A Database Designer designs and develops database systems. They are responsible for creating data models, designing database schemas, and ensuring that databases are efficient and scalable. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Database Designers. By taking this course, you will gain the skills needed to design and develop database systems, making you a valuable asset to any organization looking to manage and store data effectively.
Data Scientist
A Data Scientist uses scientific methods to extract knowledge and insights from data. They are responsible for developing and deploying machine learning models, as well as analyzing and interpreting data. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Data Scientists. By taking this course, you will gain the skills needed to manage and interpret data, making you a valuable asset to any organization looking to leverage data to make better decisions.
Data Analyst
A Data Analyst works with data to analyze, interpret, and create visualizations to help organizations make decisions and solve problems. They are responsible for collecting and cleaning data, applying statistical methods, and presenting the results of their analysis. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Data Analysts. By taking this course, you will gain the skills needed to manage, manipulate, and interpret data, making you a valuable asset to any organization looking to make data-driven decisions.
Business Analyst
A Business Analyst works with stakeholders to analyze business needs and develop solutions that improve performance and efficiency. They are responsible for gathering and interpreting requirements, creating process flows, and developing prototypes. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Business Analysts. By taking this course, you will gain the skills needed to manage, manipulate, and interpret data, making you a valuable asset to any organization looking to improve its business processes.
Data Architect
A Data Architect designs and implements data management solutions for organizations. They are responsible for creating data models, developing data integration strategies, and ensuring that data is managed in a secure and efficient manner. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Data Architects. By taking this course, you will gain the skills needed to design and implement data management solutions, making you a valuable asset to any organization looking to leverage data to make better decisions.
Software Engineer
A Software Engineer designs, develops, and maintains software systems. They are responsible for writing code, testing software, and debugging errors. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Software Engineers. By taking this course, you will gain the skills needed to integrate databases into your software applications, making you a valuable asset to any organization looking to build robust and scalable software systems.
Information Security Analyst
An Information Security Analyst protects an organization's data and computer systems from unauthorized access, use, disclosure, disruption, modification, or destruction. They are responsible for developing and implementing security policies, monitoring network traffic, and responding to security incidents. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Information Security Analysts. By taking this course, you will gain the skills needed to protect data from unauthorized access and ensure that databases are secure and compliant.
Web Developer
A Web Developer designs, develops, and maintains websites and web applications. They are responsible for writing code, creating user interfaces, and ensuring that websites are accessible and performant. The Working with Databases in Python 3 course provides a foundation in using both relational and NoSQL databases, which are essential tools for Web Developers. By taking this course, you will gain the skills needed to integrate databases into your web applications, making you a valuable asset to any organization looking to build dynamic and data-driven websites.
Marketing Analyst
A Marketing Analyst is responsible for analyzing marketing data to help organizations make decisions about their marketing campaigns. They are responsible for collecting and cleaning data, applying statistical methods, and presenting the results of their analysis. The Working with Databases in Python 3 course may be useful for a Marketing Analyst who needs to understand how databases are used to store and manage marketing data. By taking this course, you will gain the skills needed to extract insights from marketing data and make recommendations to improve marketing campaigns.
Operations Analyst
An Operations Analyst is responsible for analyzing business processes to improve efficiency and effectiveness. They are responsible for collecting and cleaning data, applying statistical methods, and presenting the results of their analysis. The Working with Databases in Python 3 course may be useful for an Operations Analyst who needs to understand how databases are used to store and manage operational data. By taking this course, you will gain the skills needed to extract insights from operational data and make recommendations to improve business processes.
Technical Writer
A Technical Writer creates and maintains documentation for software products, systems, and applications. They are responsible for writing user manuals, tutorials, and other technical documentation. The Working with Databases in Python 3 course may be useful for a Technical Writer who needs to understand how databases are used in software applications. By taking this course, you will gain the knowledge needed to write documentation that is accurate and easy to understand.
Product Manager
A Product Manager is responsible for the development and launch of new products and features. They are responsible for defining product requirements, working with engineers to develop the product, and marketing the product to customers. The Working with Databases in Python 3 course may be useful for a Product Manager who needs to understand how databases are used in software products. By taking this course, you will gain the knowledge needed to make decisions about how data is stored and managed in your products.
Business Consultant
A Business Consultant helps organizations improve their performance and solve problems. They are responsible for analyzing business processes, developing recommendations, and implementing solutions. The Working with Databases in Python 3 course may be useful for a Business Consultant who needs to understand how databases are used in business applications. By taking this course, you will gain the knowledge needed to make recommendations about how data can be used to improve business performance.
Project Manager
A Project Manager is responsible for planning, executing, and closing projects. They are responsible for developing project plans, managing project teams, and ensuring that projects are completed on time and within budget. The Working with Databases in Python 3 course may be useful for a Project Manager who needs to understand how databases are used in software projects. By taking this course, you will gain the knowledge needed to make decisions about how data is stored and managed in your projects.

Reading list

We've selected 15 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Working with Databases in Python 3.
Provides a clear and concise introduction to probability. It valuable resource for students and practitioners of all fields who want to gain a foundational understanding of probability that is not catered toward mathematicians.
Provides a comprehensive overview of natural language processing. It great resource for anyone who wants to learn more about the basics of natural language processing.
Provides a comprehensive overview of speech and language processing. It great resource for anyone who wants to learn more about the basics of speech and language processing.
Provides a comprehensive overview of information theory, inference, and learning algorithms. It great resource for anyone who wants to learn more about the basics of information theory, inference, and learning algorithms.
Provides a comprehensive overview of convex optimization. It great resource for anyone who wants to learn more about the basics of convex optimization.
Provides a gently-paced and easy-to-follow introduction to linear algebra. It valuable resource for students and practitioners of all fields who want to gain a foundational understanding of linear algebra that is not catered toward mathematicians.
Comprehensive guide to MongoDB, a popular NoSQL database.
Provides a comprehensive overview of deep learning. It great resource for anyone who wants to learn more about the basics of deep learning.
Provides a comprehensive overview of computer vision. It great resource for anyone who wants to learn more about the basics of computer vision.
Provides a comprehensive overview of Python programming for data analysis, including coverage of relational and NoSQL databases.
Provides a comprehensive overview of database systems, including relational and NoSQL databases.
Provides a comprehensive overview of database systems, including relational and NoSQL databases.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Working with Databases in Python 3.
Working with Databases in PHP 8
Most relevant
Vector Search with Relational Databases using PostgreSQL
Most relevant
NoSQL Databases
Most relevant
Practical CouchDB for Developers
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
Data Engineering Capstone Project
Most relevant
NoSQL Database Systems
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
Vector Search with NoSQL Databases using MongoDB &...
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser