Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>Database Design & Development>Introduction to Relational Databases in SQL
Data ScienceIntroduction to Relational Databases in SQL
Price:Paid
Length:4 Hours
Language:English
Content type:video
level:intermediate
Updated:26 February 2024
Published:27 August 2022
Similar courses
Opportunities
Courses>Database Design & Development>Introduction to Relational Databases in SQL
Introduction to Relational Databases in SQL
4 Hours
100309 students
Syllabus
In this chapter, you'll create your very first database with a set of simple SQL commands. Next, you'll migrate data from existing flat tables into that database. You'll also learn how meta-information about a database can be queried.
After building a simple database, it's now time to make use of the features. You'll specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.
Now let’s get into the best practices of database engineering. It's time to add primary and foreign keys to the tables. These are two of the most important concepts in databases, and are the building blocks you’ll use to establish relationships between tables.
In the final chapter, you'll leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. And you'll run ad hoc analyses on your new database.
Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>Database Design & Development>Introduction to Relational Databases in SQL
Data ScienceIntroduction to Relational Databases in SQL
Price:Paid
Length:4 Hours
Language:English
Content type:video
level:intermediate
Updated:26 February 2024
Published:27 August 2022
Similar courses
Opportunities
Courses>Database Design & Development>Introduction to Relational Databases in SQL
Introduction to Relational Databases in SQL
4 Hours
100309 students
Syllabus
In this chapter, you'll create your very first database with a set of simple SQL commands. Next, you'll migrate data from existing flat tables into that database. You'll also learn how meta-information about a database can be queried.
After building a simple database, it's now time to make use of the features. You'll specify data types in columns, enforce column uniqueness, and disallow NULL values in this chapter.
Now let’s get into the best practices of database engineering. It's time to add primary and foreign keys to the tables. These are two of the most important concepts in databases, and are the building blocks you’ll use to establish relationships between tables.
In the final chapter, you'll leverage foreign keys to connect tables and establish relationships that will greatly benefit your data quality. And you'll run ad hoc analyses on your new database.
Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot