Database Design

REGISTER: Sign me up

free course

Database Design

This is a database design series that was designed to help you understand database concepts. This is my second database design series and is a bit more technical than my first. This series will be best for you if you need a deeper grasp of database design.

Saiba mais.

Start now for free!

This course is available to subscribers! Get to know the plans.

This course has a free digital certificate of completion.

workload

9h

premium access

7 days

created on

11/12/2017

Complete course
with certificate!

On completion of this course, you will receive a digital certificate.

Increase your chances of being hired by qualifying your skills with certificates.

Why choose Learncafe?

Here at Learncafe you can access your course whenever you want. Courses are available 24 hours a day, every day of the week.

As well as being an easy-to-use platform, on any device with Internet access, you also receive a Digital Certificate when you complete your course.

Syllabus:

Aula #1 - Database Design - Introduction
Aula #2 - Database Design 1 - What is a Database?
Aula #3 - Database Design 2 - What is a Relational Database?
Aula #4 - Database Design 3 - RDBMS
Aula #5 - Database Design 4 - Introduction to SQL
Aula #6 - Database Design 5 - Naming Conventions
Aula #7 - Database Design 6 - What is Database Design?
Aula #8 - Database Design 7 - Data Integrity
Aula #9 - Database Design 8 - Database Terms
Aula #10 - Database Design 9 - More Database Terms
Aula #11 - Database Design 10 - Atomic Values
Aula #12 - Database Design 11 - Relationships
Aula #13 - Database Design 12 - One-to-One Relationships
Aula #14 - Database Design 13 - One-to-Many Relationships
Aula #15 - Database Design 14 - Many-to-Many Relationships
Aula #16 - Database Design 15 - Designing One-to-One Relationships
Aula #17 - Database Design 16 - Designing One-to-Many Relationships
Aula #18 - Database Design 17 - Parent Tables and Child Tables
Aula #19 - Database Design 18 - Designing Many-to-Many Relationships
Aula #20 - Database Design 19 - Summary of Relationships
Aula #21 - Database Design 20 - Introduction to Keys
Aula #22 - Database Design 21 - Primary Key Index
Aula #23 - Database Design 22 - Look up Table
Aula #24 - Database Design 23 - Superkey and Candidate Key
Aula #25 - Database Design 24 - Primary Key and Alternate Key
Aula #26 - Database Design 25 - Surrogate Key and Natural Key
Aula #27 - Database Design 26 - Should I use Surrogate Keys or Natural Keys?
Aula #28 - Database Design 27 - Foreign Key
Aula #29 - Database Design 28 - NOT NULL Foreign Key
Aula #30 - Database Design 29 - Foreign Key Constraints
Aula #31 - Database Design 30 - Simple Key, Composite Key, Compound Key
Aula #32 - Database Design 31 - Review and Key Points....HA GET IT? KEY points!
Aula #33 - Database Design 32 - Introduction to Entity Relationship Modeling
Aula #34 - Database Design 33 - Cardinality
Aula #35 - Database Design 34 - Modality
Aula #36 - Database Design 35 - Introduction to Database Normalization
Aula #37 - Database Design 36 - 1NF (First Normal Form of Database Normalization)
Aula #38 - Database Design 37 - 2NF (Second Normal Form of Database Normalization)
Aula #39 - Database Design 38 - 3NF (Third Normal Form of Database Normalization)
Aula #40 - Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index)
Aula #41 - Database Design 40 - Data Types
Aula #42 - Database Design 41 - Introduction to Joins
Aula #43 - Database Design 42 - Inner Join
Aula #44 - Database Design 43 - Inner Join on 3 Tables
Aula #45 - Database Design 44 - Inner Join on 3 Tables (Example)
Aula #46 - Database Design 45 - Introduction to Outer Joins
Aula #47 - Database Design 46 - Right Outer Join
Aula #48 - Database Design 47 - JOIN with NOT NULL Columns
Aula #49 - Database Design 48 - Outer Join Across 3 Tables
Aula #50 - Database Design 49 - Alias
Aula #51 - Database Design 50 - Self Join
+ Show more

Get to know
the personin charge:

Learncafe in English

Learning is never too much. We create this profile so you can access various free courses. From the available material, you can acquire new knowledge on topics such as: education, health, among other areas. All works and materials have the rights reserved to their respective authors.

view profile see courses
0 people signed up for this course.

General evaluation of the course:


Modules & lessons

Module 1: Database Design

view all

Choose a plan:

Free Plan Grátis
  • 9 CLASS HOURS
  • 30 free access days*
  • No grace period**
  • Certificate of completion***
  • Immediate access
Inscrever Agora
* O prazo de acesso ao conteúdo do curso é válido durante a vigência da mensalidade ou compra avulsa.
** O prazo de carência refere-se ao tempo total de espera para que um usuário possa iniciar um outro curso na plataforma.
*** O certificado de conclusão do curso é oferecido separadamente para compra avulsa em dois formatos: digital para download e impresso via Correios.

Start studying in just a few clicks:

The knowledge you've been looking for to improve your
career is just a few clicks away!

Sign up now

Sign up for Learncafe

+200.000 study hours
+300.000 videos available
+30.000 fixation exercises
+9.000 available courses
Ei, espera! Que tal você concorrer a 20 mil?