cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Advanced

Track

Creating Database Structure

Learn how to create and manage tables, views, and indexes in popular relational database management systems like MySQL, SQL Server, Oracle, and PostgreSQL.

Start learning

50 free interactive coding challenges

Ultimate money saver

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

With our Forever plan this track will cost you only

$ 18.1

91% OFF

40 hours left

SEE PRICING

Regular track price

(5 x $39)

$195

BUY TRACK
5

Interactive courses

38 h

Estimated time

133

Users enrolled

☆☆☆☆☆
★★★★★

0 ratings

Discover the secrets of creating and managing the structure of a relational database. Do you work with relational databases? Want to learn how to create tables, views, and indexes? This track is especially for you. It will help you understand the technical side of data storage and learn how to manage it more efficiently.

In this track, you will learn SQL’s Data Definition Language (DDL) - the syntax used to create, modify, and remove tables, views, and indexes. To get the most out of it, you should know the basics of SQL, especially the DML (data manipulation language) part. We assume that you know when to use SELECT, INSERT, UPDATE, and DELETE.

(If you’re not familiar with the above SQL commands, start with our How to INSERT, UPDATE, and DELETE data in SQL course and then come back to this one.)

Creating Database Structure consists of five interactive courses. The first two deal with creating tables: you’ll learn the basic syntax of CREATE TABLE, uncover different data types, and learn how to select the right data types for your needs. The third course delves into constraints, or how databases verify the correctness of data. The last two courses will teach you how to work with views and indexes.

After completing this track, you'll know how to create, modify, and remove database objects.

All courses in the track are based on standard SQL. That means that you will be able to use the skills acquired here in almost any relational database management system (RDMS), including Oracle, SQL Server, MySQL, and PostgreSQL. We believe people learn best through practice and interactive tasks. So, during this course, you’ll write real SQL commands directly in the browser. Our platform runs and verifies your solution, letting you see how things work in real time. You don't have to install or set up anything on your device.

Track courses

1 0%
80

Coding challenges

☆☆☆☆☆
★★★★★

0 ratings

Advanced

The Basics of Creating Tables in SQL

Discover the basic building blocks of creating tables in MySQL, SQL Server, Oracle, and PostgreSQL. Learn all about primary keys, foreign keys, and the CREATE TABLE command.

Details
2 0%
89

Coding challenges

☆☆☆☆☆
★★★★★

0 ratings

Advanced

Data Types in SQL

Choose the right type of data for your needs. A data type tells the database what kind of information a column will store. Learn about common data types in SQL Server, MySQL, Oracle, and PostgreSQL.

Details
3 0%
76

Coding challenges

☆☆☆☆☆
★★★★★

0 ratings

Advanced

SQL Constraints

Constraints tell the database how to check the correctness of input data. Get to know the constraints available in SQL Server, MySQL, Oracle, and PostgreSQL. Learn how to create and alter constraints in a relational database.

Details
4 0%
36

Coding challenges

☆☆☆☆☆
★★★★★

0 ratings

Advanced

Working with Views

Query more effectively with SQL views! A view is a saved SQL query. Learn how to create, modify, and remove views in SQL Server, MySQL, Oracle, and PostgreSQL.

Details
5 0%
55

Coding challenges

☆☆☆☆☆
★★★★★

0 ratings

Advanced

Understanding Indexes

To be a database professional, you must understand how indexes work. These structures help the database to execute SQL queries faster. Learn how to create indexes and how to write SQL queries that best utilize them.

Details

Reviews (0)

Average rating

3.5 / 5

☆☆☆☆☆
★★★★★

0 ratings

Details

5 stars

0%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%