Skip to content

Instantly share code, notes, and snippets.

@misho-kr

misho-kr/Introduction to Relational Databases in SQL.md

Created March 1, 2021 04:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save misho-kr/9f9f79689bd8f4a1eef44b3f333ed122 to your computer and use it in GitHub Desktop.
Save misho-kr/9f9f79689bd8f4a1eef44b3f333ed122 to your computer and use it in GitHub Desktop.
Download ZIP
Summary of "Summary of "Merging DataFrames with pandas" course on Datacamp
Raw
Introduction to Relational Databases in SQL.md

Summary of "Merging DataFrames with pandas

Lead by Timo Grossenbacher, Project Lead Automated Journalism at Tamedia

You can model different phenomena in your data, as well as the relationships between them. This gives your data structure and consistency, which results in better data quality. In this course, you'll experience this firsthand by working with a real-life dataset that was used to investigate questionable university affiliations. You'll learn how to create tables and specify their relationships, as well as how to enforce data integrity. You'll also discover other unique features of database systems, such as constraints.

Your first database

Create your very first database with a set of simple SQL commands. Next, migrate data from existing flat tables into that database. Learn how meta-information about a database can be queried.

Enforce data consistency with attribute constraints

Specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.

Uniquely identify records with key constraints

Add primary and foreign keys to the tables.

Glue together tables with foreign keys

Leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. Run ad hoc analyses on your new database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment