Intro to Relational Databases

Online Course

Udacity
Intro to Relational Databases

What is the course about?

Intro to Relational Databases
The course Intro to Relational Databases is an online class provided by Udacity. The skill level of the course is Intermediate. It may be possible to receive a verified certification or use the course to prepare for a degree.

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.

Course description
  • Intro to Relational Databases
  • 4 weeks
  • SQL, DB-API, and More!
  • After taking this course, you’ll be able to write code using a database as a backend to store application data reliably and safely.
  • Data and Tables
  • Elements of SQL
  • Python DB-API
  • Deeper Into SQL
  • Learn about how relational databases let you structure data into tables.
  • Learn about the importance of unique keys and relationships between tables.
  • 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.
  • 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.
  • 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.
  • 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:
  • 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.
  • 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.

Prerequisites & Facts

Intro to Relational Databases

Course Topic

Computer Science, Programming

University, College, Institution

Udacity

Course Skill Level

Intermediate

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Degree & Cost

Intro to Relational Databases

To obtain a verified certificate from Udacity you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.
Udacity
Intro to Relational Databases
provided by Udacity

Reviews

Share your experience

Intro to Relational Databases
Udacity Udacity
Rate the course

Do you recommend the course? *
Here you can find information, reviews and user experiences for the course “Intro to Relational Databases“. The provider of the course – “Udacity” – will be glad to answer any questions you may have about the class, click here to use the offical support channels. It would be great if you could share your experience of participating in the course – Your honest review will surely help others to choose the right class!
School: Udacity
Topic: Computer Science, Programming