Hello and welcome to The Basics of Creating Tables in SQL, the first course in the track, Creating Database Structure.
This track is meant for beginner data engineers who'd like to learn how to prepare the proper database infrastructure for data processing. You'll get to know how to create tables, what data types are, when to use constraints, how views work, and, finally, how to work with indexes.
This track assumes you can already write SQL queries (SELECT statements) and use INSERT/UPDATE/DELETE correctly. If not, take a look at the other tracks we offer before starting this course: SQL Basics in PostgreSQL and PostgreSQL INSERT, UPDATE, and DELETE Commands.
This is the first course in the track, Creating Database Structure. Here, you'll learn the basics of creating tables in SQL. Once you get the fundamentals down, you'll be able to expand your knowledge through further courses.
So, are you ready?
Peter loves toys and decided to open a “childhood museum” in his city. In the museum, he wants to showcase various kinds of toys from the past, with origins from all over the world.
As you can see, he has already written some code. This code is going to create a table where he will store data concerning all of his exhibits. Why don't you help him create it? Click to see how the table is created.
Click and to create the table.
