subject

Udacity: Intro to Relational Databases

 with  Karl Krueger
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.

Why Take This Course?
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.

Syllabus

### Lesson 1: Data and Tables
In this lesson, you'll learn about how relational databases let you structure data into tables. You'll learn about the importance of unique keys and relationships between tables.

### Lesson 2: Elephants Elements of SQL
In this lesson, you'll begin learning SQL, the Structured Query Language used by most relational databases. You'll learn about the **select** and **insert** statements, the basic operations for getting data out of a database and putting data into a database. You'll learn about the operators and syntax available to get the database to scan and join tables for you.

### Lesson 3: Python DB-API
In this lesson, you'll learn how to access a relational database from Python code. You'll use a virtual machine (VM) running on your own computer to run a Python web application, and adapt that application to use a database backend. Then you'll learn about some of the most common security pitfalls of database-backed applications, including the famous Bobby Tables. This lesson also covers the SQL **update** and **delete** statements.

### Lesson 4: Deeper Into SQL
In this lesson, you'll learn how to design and create new databases. You'll learn about normalized design, which makes it easier to write effective code using a database. You'll also learn how to use the SQL **join** operators to rapidly connect data from different tables.

### Lesson 5: Final Project
In this project, you'll use your Python and SQL knowledge to build a database-backed Python module to run a game tournament. You'll design the database schema and write code to implement an API for the project.
6 Student
reviews
Cost Free Online Course
Pace Self Paced
Subject Databases
Provider Udacity
Hours 6 hours a week
Calendar 4 weeks long
+ Add to My Courses
Learn Data Analysis udacity.com

Learn to become a Data Analyst. Job offer guaranteed or get a full refund.

Advertisement
Become a Data Scientist datacamp.com

Learn Python & R at your own pace. Start now for free!

Advertisement
FAQ View All
What are MOOCs?
MOOCs stand for Massive Open Online Courses. These are free online courses from universities around the world (eg. Stanford Harvard MIT) offered to anyone with an internet connection.
How do I register?
To register for a course, click on "Go to Class" button on the course page. This will take you to the providers website where you can register for the course.
How do these MOOCs or free online courses work?
MOOCs are designed for an online audience, teaching primarily through short (5-20 min.) pre recorded video lectures, that you watch on weekly schedule when convenient for you.  They also have student discussion forums, homework/assignments, and online quizzes or exams.

6 reviews for Udacity's Intro to Relational Databases

Write a review
2 out of 2 people found the following review useful
2 years ago
profile picture
Anonymous is taking this course right now.
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 answers to the problem on the discussion boards but you have to pay to Read More
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 answers to the problem on the discussion boards but you have to pay to see it - I find that extraordinary given the fact that the focus of the course is supposed to be DBMS and Python, NOT setting up vagrant environments! Absolutely no troubleshooting guidance other than an EXTREMELY SLOPPY, poor quality video that literally mentioned critically important issues as an afterthought,(like needing to modify the base python DB server code IN ADDITION TO the Vagrantfile configuration !). The virtualbox/vagrant "installation instructions" make reference to screen shots that aren't even present. They don't even provide the logins for the Ubuntu VM that gets installed so that I could at least try to troubleshoot the problem from that perspective. finally, the course itself seems to struggle when trying to describe even basic concepts like SQL - they try to oversimplify it to the point where it actually becomes confusing! Again, *very* sloppy work!
Was this review helpful to you? YES | NO
2 years ago
Gregory J Hamel ( Life Is Study) audited this course and found the course difficulty to be easy.
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 using a database backend for a webapp and lesson 4 covers database des Read More
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 using a database backend for a webapp and lesson 4 covers database design principles and a few more advanced features like outer joins and subqueries. I won't get into the final project as Udacity's projects tend to be geared toward students with subscriptions.

Each lesson consist of several short videos with quizzes that involve multiple choice questions and coding exercises that revolve around altering and submitting SQL queries. The instructor is easy to understand and explains things well. The content is polished and I didn't notice any bugs, which is rare for a brand new course. On the other hand, the course is a bit too short and doesn't give beginners enough practice with newly introduced syntax before moving on. It would be helpful to give students a few short drills writing queries related to each newly introduced keyword from scratch. Also, to follow along with lesson 3, you have to download, install and interact with a virtual machine. The time necessary to download, install and figure out how to use the VM is probably more than is warranted with such a short course, although the VM may be used for other Udacity courses.

Intro to relational databases is a succinct overview of SQL basics that serves as a nice refresher for someone who has seen SQL before, but making it a little longer and providing more simple drills would probably be helpful for beginners.

I give Intro to relational databases 3.5 out of 5 stars: Good.
Was this review helpful to you? YES | NO
2 months ago
profile picture
Anonymous completed this course.
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 hav Read More
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.
Was this review helpful to you? YES | NO
11 months ago
profile picture
Anonymous completed this course.
This course, like most courses within Full Stack Web Developer Nanodegree, are not for beginners... As a beginner, I have spent countless hours trying to fill in the gaps. It is very very frustrating. I have completed 5 (I think? Maybe 4) courses within the nanodegree and although I have learned a lot, it has been extr Read More
This course, like most courses within Full Stack Web Developer Nanodegree, are not for beginners... As a beginner, I have spent countless hours trying to fill in the gaps. It is very very frustrating. I have completed 5 (I think? Maybe 4) courses within the nanodegree and although I have learned a lot, it has been extremely frustrating having to find a lot of answers myself, as a beginner, googling in the dark. I posted answers to the numerous problems I encountered so to make your life a little easier, at www.ajoannaproject.wordpress.com.
Was this review helpful to you? YES | NO
2 years ago
profile picture
Anonymous is taking this course right now.
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.
Was this review helpful to you? YES | NO
8 months ago
William Nguyen completed this course.
Was this review helpful to you? YES | NO