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.

Course Cost
Free
Timeline
Approx. 4 weeks
Skill Level
Intermediate
Included in Course
  • Icon course 01 3edf6b45629a2e8f1b490e1fb1516899e98b3b30db721466e83b1a1c16e237b1 Rich Learning Content

  • Icon course 04 2edd94a12ef9e5f0ebe04f6c9f6ae2c89e5efba5fd0b703c60f65837f8b54430 Interactive Quizzes

  • Icon course 02 2d90171a3a467a7d4613c7c615f15093d7402c66f2cf9a5ab4bcf11a4958aa33 Taught by Industry Pros

  • Icon course 05 237542f88ede3178ac4845d4bebf431ddd36d9c3c35aedfbd92e148c1c7361c6 Self-Paced Learning

  • Icon course 03 142f0532acf4fa030d680f5cb3babed8007e9ac853d0a3bf731fa30a7869db3a Student Support Community

Join the Path to Greatness

This free course is your first step towards a new career with the Full Stack Web Developer Nanodegree Program.

Free Course

Intro to Relational Databases

Enhance your skill set and boost your hirability through innovative, independent learning.

Icon steps 54aa753742d05d598baf005f2bb1b5bb6339a7d544b84089a1eee6acd5a8543d

Course Leads

  • Karl Krueger
    Karl Krueger

    Instructor

What You Will Learn

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

Prerequisites and Requirements

You can read and write basic code in Python. This course uses programming exercises in Python. If you haven't worked with Python before, check out our course Programming Foundations with Python.

If you can understand this code (maybe with the help of the random module documentation), you know enough Python for this course:

import random

def ChooseTwice(items):
    a = random.choice(items)
    b = random.choice(items)
    return a, b

names = ["Alice", "Bob", "Charlie", "Debra"]
(one, two) = ChooseTwice(names)
if one == two:
    print "%s is happy!" % one
else:
    print "%s likes %s!" % (one, two)

You can use a command-line interface (terminal). Some of the exercises in this course involve using a Unix-style command-line interface to enter commands, run Python programs, and navigate directories.

If you have taken our course on Git and Github, the level of command-line use in this course is similar.

You don't need to be a Web programmer. This course does include a small Web application and some HTML and JavaScript in examples, but you will not need to make changes in these languages.

You don't need any previous database experience. This course is an entry-level introduction to relational databases.

You need a programming text editor (such as Sublime Text) installed on your computer. You should be able to use it to open and edit files of Python code.

See the Technology Requirements for using Udacity.

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.

What do I get?
  • Instructor videos
  • Learn by doing exercises
  • Taught by industry professionals
Icon globe e82eae5d45465aba4fbe4bb746905ce55dc3324f310b79c60e4a20089057d347

Udacity 现已提供中文版本! A Udacity tem uma página em português para você! There's a local version of Udacity for you!

前往优达学城中文网站 Ir para a página brasileira Go to Indian Site or continue to Global Site