After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
课程介绍
In this course, you'll learn the basics of using SQL with Python. This will be useful because databases are ubiquitous and data scientists, analysts, and engineers must interact with them constantly. The Python SQL toolkit SQLAlchemy provides an accessible and intuitive way to query, build, and write to essential databases, including SQLite, MySQL, and PostgreSQL.
先修要求
课程大纲
课程大纲
1
Basics of Relational Databases
In this chapter, you’ll get acquainted with the fundamentals of relational databases and the relational model for database management. You will learn how to connect to a database and interact with it by writing basic SQL queries, both in raw SQL as well as SQLAlchemy, which provides a Pythonic way of interacting with databases.
- Introduction to Databases50 经验值
- Relational model50 经验值
- Connecting to your database50 经验值
- Engines and connection strings100 经验值
- Autoloading Tables from a database100 经验值
- Viewing Table details100 经验值
- Introduction to SQL queries50 经验值
- Selecting data from a Table: raw SQL100 经验值
- Selecting data from a Table with SQLAlchemy100 经验值
- Handling a ResultSet100 经验值
- Congratulations!50 经验值
2
Applying Filtering, Ordering and Grouping to Queries
In this chapter, you will build on your database knowledge by writing more nuanced queries that allow you to filter, order, and count your data—all within the Pythonic framework provided by SQLAlchemy.
3
Advanced SQLAlchemy Queries
In this chapter, you will learn to perform advanced—and incredibly useful—queries that enable you to interact with your data in powerful ways.
4
Creating and Manipulating your own Databases
In the previous chapters, you interacted with existing databases and queried them in different ways. Now, you will learn how to build your own databases and keep them updated.
5
Putting it all together
Bring together all of the skills you acquired in the previous chapters to work on a real-life project. From connecting to a database and populating it, to reading and querying it.
Introduction to Databases in Python
课程完成
