Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udacity

Intro to Relational Databases

via Udacity

Overview

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.

Syllabus

  • 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.
  • 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.
  • 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.
  • 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.

Taught by

Karl Krueger

Reviews

2.1 rating, based on 7 Class Central reviews

Start your review of Intro to Relational Databases

  • Intro to Relational Databases is a short 4 lesson course offered by Udacity that covers the basics of SQL databases. Lessons 1 and 2 cover basic SQL querying, including grouping, ordering and inner joins, lesson 3 addresses inserts and concerns when…
  • Anonymous
    Taking this course now. Having considerable trouble with getting the required tools (the vagrant environment) in place so that I can just move on to the 3rd lesson. I have spent countless hours trying to get it stood up. Apparently, they do have…
  • Anonymous
    I took and finished this course a while ago, it improved my skillset with Relational DB. Learned things like HAVING and subqueries, etc. And enjoyed the zoo example. I just feel like the current 2 stars for this class is definitely a bit harsh. Though I do agree yah getting Vagrant to work to do the assignments may have been a bit out of the scope of Relational DB, but also, my experience working as a software engineer for 7 years has been that in a work environment, you do find many times you have to overcome setup issues, environment/tool configuration issues, etc. I think this course could be a good fit for many learners.
  • Anonymous
    Not enough information is given in the lectures to complete the programming assignments, especially lesson 3. Very frustrating. I give it one star, because it's free. However, I think you'd be better off with just google, stack exchange, and reddit.com/r/learnpython.
  • Anonymous
    Instructions for installing VM and vagrant do not work. The URL to access the virtual machine is no longer valid...

    Overall, the first 2 lessons were decent. But spent hours trying to get software installed to start lesson 3 and hit a wall.

  • Anonymous
    well, instructions are not enough to complete the project. I find it very poor, and compared to other courses database lectures are not sufficient.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.