We may earn an affiliate commission when you visit our partners.
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/bo9mna/working
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
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
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
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Working with Databases in Python 3 with these
activities:
Python Programming: A Modern Approach
Show steps
Provides a comprehensive overview of Python, building a solid foundation for the course
View
Learning Python: Powerful Object-Oriented...
on Amazon
Show steps
-
Read the book thoroughly
-
Take notes and highlight key concepts
-
Complete the exercises and practice problems
Glossary of Python Terms
Show steps
Strengthens your understanding of key concepts by creating a resource that you can refer to later
Browse courses on
Python
Show steps
-
Identify the key terms and concepts in the course
-
Create a glossary entry for each term
-
Organize the glossary entries in a logical order
Django Practice
Show steps
Builds foundation for the course by refreshing your Python skills and eliminates the friction caused by rusty web development skills
Browse courses on
Django
Show steps
-
Review Django documentation
-
Install Django and set up a project
-
Create a simple Django application
Five other activities
Expand to see all activities and additional details
Show all eight activities
Peer Learning Group
Show steps
Provides a supportive environment for learning, allowing you to clarify concepts and reinforce your understanding through discussions with peers
Show steps
-
Find a peer learning group or create your own
-
Meet regularly to discuss course materials and assignments
-
Work together on projects and assignments
Python Data Visualization with Pandas
Show steps
Reinforces concepts covered in the course by solidifying your skills through hands-on exercises and tutorials
Browse courses on
Pandas
Show steps
-
Find a tutorial on Python data visualization with Pandas
-
Follow the tutorial and complete the exercises
-
Create your own data visualization project using Pandas
Python Project for Beginners
Show steps
Gives you an opportunity to apply your skills and knowledge to a real-world project, building confidence and solidifying your understanding
Browse courses on
Python
Show steps
-
Identify a project idea that interests you
-
Plan and design your project
-
Implement your project using Python
-
Test and debug your project
-
Deploy your project
Python Script for Data Analysis
Show steps
Provides you with an opportunity to apply your skills and knowledge to a practical problem, solidifying your understanding and improving retention
Browse courses on
Python
Show steps
-
Identify a dataset that you want to analyze
-
Write a Python script to clean and analyze the data
-
Generate insights and visualizations from the data
Python Coding Challenge
Show steps
Provides an opportunity to test your skills against others and identify areas for improvement, motivating you to excel in the course
Show steps
-
Find a Python coding challenge
-
Practice and prepare for the challenge
-
Participate in the challenge and submit your solution
Python Programming: A Modern Approach
Show steps
Provides a comprehensive overview of Python, building a solid foundation for the course
View
Learning Python: Powerful Object-Oriented...
on Amazon
Show steps
Show steps
Show steps
- Read the book thoroughly
- Take notes and highlight key concepts
- Complete the exercises and practice problems
Glossary of Python Terms
Show steps
Strengthens your understanding of key concepts by creating a resource that you can refer to later
Browse courses on
Python
Show steps
Show steps
Show steps
- Identify the key terms and concepts in the course
- Create a glossary entry for each term
- Organize the glossary entries in a logical order
Django Practice
Show steps
Builds foundation for the course by refreshing your Python skills and eliminates the friction caused by rusty web development skills
Browse courses on
Django
Show steps
Show steps
Show steps
- Review Django documentation
- Install Django and set up a project
- Create a simple Django application
Five other activities
Expand to see all activities and additional details
Show all eight activities
Peer Learning Group
Show steps
Provides a supportive environment for learning, allowing you to clarify concepts and reinforce your understanding through discussions with peers
Show steps
Show steps
Show steps
- Find a peer learning group or create your own
- Meet regularly to discuss course materials and assignments
- Work together on projects and assignments
Python Data Visualization with Pandas
Show steps
Reinforces concepts covered in the course by solidifying your skills through hands-on exercises and tutorials
Browse courses on
Pandas
Show steps
Show steps
Show steps
- Find a tutorial on Python data visualization with Pandas
- Follow the tutorial and complete the exercises
- Create your own data visualization project using Pandas
Python Project for Beginners
Show steps
Gives you an opportunity to apply your skills and knowledge to a real-world project, building confidence and solidifying your understanding
Browse courses on
Python
Show steps
Show steps
Show steps
- Identify a project idea that interests you
- Plan and design your project
- Implement your project using Python
- Test and debug your project
- Deploy your project
Python Script for Data Analysis
Show steps
Provides you with an opportunity to apply your skills and knowledge to a practical problem, solidifying your understanding and improving retention
Browse courses on
Python
Show steps
Show steps
Show steps
- Identify a dataset that you want to analyze
- Write a Python script to clean and analyze the data
- Generate insights and visualizations from the data
Python Coding Challenge
Show steps
Provides an opportunity to test your skills against others and identify areas for improvement, motivating you to excel in the course
Show steps
Show steps
Show steps
- Find a Python coding challenge
- Practice and prepare for the challenge
- Participate in the challenge and submit your solution
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
For more career information including salaries, visit:
OpenCourser.com/course/bo9mna/working
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.
Save
Provides a comprehensive overview of deep learning. It great resource for anyone who wants to learn more about the basics of deep learning.
Save
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 database systems, including relational and NoSQL databases.
Provides a comprehensive overview of Python programming for data analysis, including coverage of relational and NoSQL databases.
Provides a practical introduction to data science, including coverage of relational and NoSQL databases.
Provides a comprehensive overview of database systems, including relational and NoSQL databases.
Save
Provides a comprehensive overview of database systems, including relational and NoSQL databases.
Provides a practical guide to data management.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/bo9mna/working
Share
Similar courses
Here are nine courses similar to
Working with Databases in Python 3.
Working with Databases in PHP 8
OpenCourser.com/course/0zwq1q/working
Working with Databases in PHP 8
Most relevant
Vector Search with Relational Databases using PostgreSQL
OpenCourser.com/course/lyu5cy/vector
Vector Search with Relational Databases using PostgreSQL
Most relevant
NoSQL Databases
OpenCourser.com/course/17tny7/nosql
NoSQL Databases
Most relevant
Practical CouchDB for Developers
OpenCourser.com/course/ft6zgg/practical
Practical CouchDB for Developers
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
OpenCourser.com/course/1qh2q5/database
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
NoSQL Database Systems
OpenCourser.com/course/emkao1/nosql
NoSQL Database Systems
Most relevant
Data Engineering Capstone Project
OpenCourser.com/course/c936bx/data
Data Engineering Capstone Project
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
OpenCourser.com/course/11vcfd/database
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
Create Your First NoSQL Database with MongoDB and Compass
OpenCourser.com/course/41hvib/create
Create Your First NoSQL Database with MongoDB and Compass
Most relevant
Time
163 hours
Level
Intermediate
Via
Pluralsight
Instructor
Douglas Starnes
Language
English
Good to know
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
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