Learn how to create and manage the structure of a relational database.
Look at today’s software industry and you’ll see how popular relational databases have become. Creating Tables in SQL will show you how to start building your own custom database.
In this course, you’ll discover how to manage the structure of a relational database. You’ll be asked to create tables and drop (delete) them when they are no longer needed. You’ll also get acquainted with some of the best practices guiding database design.
Discover how to define various table elements, including constraints, primary keys, UNIQUE keys, and foreign keys. Learn how ALTER TABLE works and how you can use it to modify your table structure. Finally, learn how to create virtual tables called views.
If you want to take control of your database structure and understand it perfectly, this is the right course for you!
Just a web browser and an Internet connection
Plus, you’ll get to practice your skills on 177 interactive exercises.
92%
off
Reg. price
$1372
Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $99
36 hours left at this price!
87%
off
Reg. price
$359
Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS
Bundle price $45
36 hours left at this price!
76%
off
Reg. price
$193
Includes 5 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Tables in SQL
Bundle price $45
36 hours left at this price!
Remember what tables are? You will learn how to create simple tables
0% completed 0 of 13 exercises done
Text info, numbers, dates, logical values. Learn how to tell your database what data you're going to store
0% completed 0 of 43 exercises done
Let's recap creating tables and the basic data types
0% completed 0 of 6 exercises done
How to tell the database that an id column is really an identifier
0% completed 0 of 30 exercises done
Price below zero? A person over 1000 years old? It's not going to happen again. Learn how to tell the database what are the restriction for the data it stores
0% completed 0 of 36 exercises done
How to properly reference one table in another table
0% completed 0 of 27 exercises done
It's not just tables in the database. Learn what views are
0% completed 0 of 12 exercises done
Time to test your knowledge!
0% completed 0 of 10 exercises done
