Relational database design

What you'll learn

How to design a database schema, how to set up tables, columns, data type, keys, relationship and how to normalize
Practical examples for database design
Best practices for creating database objects

Requirements

Some basic knowledge about writing SQL statements.

Description

Description:

This course is about designing a database schema. How to create tables, columns, set data types for columns, identify keys, identify relationship between tables and normalize.

No software installation is required. The database schema will be design using an online tool, also the SQL statements will be run inside the online tool Oracle livesql.

Why to start:

You want to know how to design your database schema.

You want to check if a database schema is designed correctly .

If you just started as a Oracle developer and want some knowledge about database design.

If you are a business person and just want to check if database objects are designed properly.

Course content:

The course has 4 chapters, you will learn to build 3 apps:

Database design concepts

Database design concepts

Practical examples

Best Practices

Who this course is for:

Database developers
Dababase designers