Intro to Relational Databases

Intermediate
Free Course
4 weeks duration

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.

In the course Intro to Relational Databases on Udacity, you will learn about the fundamentals of relational databases and how they allow you to structure data into tables. You will also understand the significance of unique keys and relationships between tables. Additionally, you will gain knowledge of SQL, the widely used Structured Query Language, and its select and insert statements for reading and writing data. Furthermore, you will explore the operators and syntax available to efficiently scan and join tables. The course also covers accessing relational databases from Python code using the Python DB-API and running a Python web application with a database on a virtual machine. You will also learn about common security pitfalls in database applications, including the famous Bobby Tables. Lastly, you will delve deeper into SQL by learning how to design and create new databases, understand normalized design for writing effective code, and utilize SQL join operators to connect data from different tables seamlessly.

About Provider

Udacity
Udacity
Online Education Provider ยท 302 courses
Description
Udacity is an online learning platform that offers a wide range of courses and programs in various fields such as technology, business, data science, and artificial intelligence. It was founded in 2012 by Sebastian Thrun, David Stavens, and Mike Sokolsky with the aim of providing accessible and affordable education to individuals worldwide. Udacity's courses are designed in collaboration with industry experts and leading companies, ensuring that the content is relevant and up-to-date. The platform offers both self-paced courses and guided programs, allowing learners to choose the learning style that suits them best. Udacity also provides career services and support, including resume reviews, interview preparation, and job placement assistance, to help learners transition into their desired careers.