Intro to Relational Databases
About this Course
This course is a quick, fun introduction to using a relational database from your code, using examples in Python. You'll learn the basics of SQL (the Structured Query Language) and database design, as well as the Python API for connecting Python code to a database. You'll also learn a bit about protecting your database-backed web apps from common security problems.
After taking this course, you'll be able to write code using a database as a …
Intro to Relational Databases
About this Course
This course is a quick, fun introduction to using a relational database from your code, using examples in Python. You'll learn the basics of SQL (the Structured Query Language) and database design, as well as the Python API for connecting Python code to a database. You'll also learn a bit about protecting your database-backed web apps from common security problems.
After taking this course, you'll be able to write code using a database as a backend to store application data reliably and safely.
Relational databases are a powerful tool used throughout the industry. Learn the basics of SQL and how to connect your Python code to a relational database.
[
If you look under the hood of a lot of major web sites — from Wikipedia to Reddit — you’ll find a relational database somewhere.
,Database systems such as PostgreSQL and MySQL have been part of the web developer’s toolkit for many years, and remain some of the most powerful tools available for storing and manipulating structured data.
,If you’re planning to continue on in full-stack development, knowing about databases is essential background. Even though many toolkits hide the details of the database from your application code, being able to interact with the database will serve you well in designing, debugging, and maintaining your applications.
]
lesson 1
Data and Tables
Learn about how relational databases let you structure data into tables.
Learn about the importance of unique keys and relationships between tables.
lesson 2
Elements of SQL
Begin learning SQL, the Structured Query Language used by most relational databases.
Learn about the select and insert statements, the basic operations for reading and writing data.
Learn about the operators and syntax available to get the database to scan and join tables for you.
lesson 3
Python DB-API
Learn how to access a relational database from Python code.
Use a virtual machine (VM) to run a Python web application with a database.
Common security pitfalls of database applications, including the famous Bobby Tables.
lesson 4
Deeper Into SQL
Learn how to design and create new databases.
Learn about normalized design, which makes it easier to write effective code using a database.
Learn how to use the SQL join operators to rapidly connect data from different tables.
