Explore

Intro to Relational Databases

Approx. 4 weeks

Save Course

Go to Course

Brief Introduction

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 data

Course Summary

Learn the fundamentals of relational databases and how to design and work with them using SQL. This course will help you build a solid foundation in SQL and database management.

Key Learning Points

Understand the basics of relational databases and SQL syntax
Learn how to design and create a database schema
Become proficient in querying and modifying data in a database

Job Positions & Salaries of people who have taken this course might have

- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,500,000
- Spain: €25,000 - €40,000
- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,500,000
- Spain: €25,000 - €40,000
- USA: $50,000 - $90,000
- India: ₹300,000 - ₹1,200,000
- Spain: €20,000 - €35,000
- USA: $75,000 - $120,000
- India: ₹400,000 - ₹1,500,000
- Spain: €25,000 - €40,000
- USA: $50,000 - $90,000
- India: ₹300,000 - ₹1,200,000
- Spain: €20,000 - €35,000
- USA: $60,000 - $120,000
- India: ₹300,000 - ₹2,000,000
- Spain: €25,000 - €40,000

Learning Outcomes

Design and implement a database schema
Write and execute SQL queries to retrieve and modify data
Understand the fundamentals of relational databases

Prerequisites or good to have knowledge before taking this course

Basic understanding of programming concepts
Access to a computer with internet connection

Course Difficulty Level

Beginner

Course Format

Self-paced online course
Video lectures
Hands-on projects
Interactive quizzes

Similar Courses

SQL for Data Analysis
Data Wrangling with MongoDB

Related Education Paths

Notable People in This Field

Chris Love
Kendra Little

Related Books

Description

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.

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

Knowledge

Instructor videosLearn by doing exercisesTaught by industry professionals

Outline

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.

Summary of User Reviews

The Intro to Relational Databases course on Udacity has received positive reviews from many users. The course covers the fundamentals of databases and teaches SQL skills for retrieving and manipulating data. One key aspect that many users thought was good is the interactive nature of the course, which allows for hands-on experience with real-world data. Overall, users appreciate the practical and applicable nature of the course and the knowledgeable instructors. However, some users have mentioned a few cons, such as the lack of depth in certain topics and the occasional technical issues with the platform.

Pros from User Reviews

Hands-on experience with real-world data
Practical and applicable skills
Knowledgeable instructors
Interactive nature of the course
Good pacing and structure

Cons from User Reviews

Lack of depth in certain topics
Occasional technical issues with the platform
Limited interaction with other students
Some videos are too short
No quizzes or assessments

Recommended for you

Elasticsearch 7 and the Elastic Stack: In Depth and Hands On

Complete Elasticsearch tutorial - search, analyze, and visualize big data with Elasticsearch, Kibana, Logstash, & Beats. This course covers it all, from installation to operations, with over 100 lectures including 11 hours of video....

Save Course

MySQL: Become A MySQL Admin

Store, retrieve, and manipulate your data and design efficient database solutions with MySQL 8 MySQL is the most popular and widely used relational databases in the World today....

Save Course

Practice Exams | AWS Certified Developer Associate 2021

325 Test Quiz Questions on DVA-C01 ! Practice the AWS Certified Developer Exam & ace the AWS Certified Developer Exam! [Update July 2019]: 33 Bonus Questions have been added....

Save Course