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.

4.89 ★★★★★ ★★★★★ (1081 ratings)

6,501 Lerners enrolled

Lifetime access

limited to this track only

$195

Want a better deal?

Get unlimited lifetime access to all 76 present and future courses

Unlimited lifetime access

to all 76 present and future courses

$599

Free trial Yes

Certificate of completion Yes

Estimated time 50 h

Courses included 5

Skills you will gain

  • Create and manage tables
  • Identify and use common SQL data types in your projects
  • Define primary and foreign keys
  • Implement constraints for data integrity
  • Create, modify, and manage SQL views
  • Optimize query performance with indexes

Last reviews

Description

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. The Basics of Creating Tables in SQL
    ★★★★★ ★★★★★ (166) 80 Coding challenges Basic

    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.

  2. Data Types in SQL
    ★★★★★ ★★★★★ (635) 89 Coding challenges Basic

    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.

  3. SQL Constraints
    ★★★★★ ★★★★★ (65) 76 Coding challenges Basic

    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.

  4. Working with Views
    ★★★★★ ★★★★★ (206) 36 Coding challenges Advanced

    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.

  5. Understanding Indexes
    ★★★★★ ★★★★★ (123) 55 Coding challenges Advanced

    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.

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (1)

Average rating

4.89/5

★★★★★ ★★★★★ (1081 ratings)

5 stars

90%

4 stars

10%

3 stars

0%

2 stars

0%

1 stars

0%