Relational database design

Relational database design

Learn how to design database objects

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