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
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.
Database normalization is the process of structuring a database, usually a relational database, in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity. It was first proposed by Edgar F. Codd as part of his relational model.
Normalization entails organizing the columns (attributes) and tables (relations) of a database to ensure that their dependencies are properly enforced by database integrity constraints. It is accomplished by applying some formal rules either by a process of synthesis (creating a new database design) or decomposition (improving an existing database design).
No software installation is required. The database schema will be design using an online tool, also the SQLstatements 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:
Database design concepts
Entities
Keys
Relationships
Database design steps
Design steps overview
Step 1 : The purpose
Step 2: Entities/Attributes/Data types
Step 3:Keys/ Candidate Keys/ Primary Keys
Step 4: Relationship
Step 5: Normalization
Practical examples
Student/activities example
Employees/skills
Dentist
Best Practices
Tables
Constraints
Indexes
Sequences
Views
Triggers
Next steps
The theory in this course is a must for a database designer or an oracle developer, but can be interesting for every persons that deals with databases.
