Database Design

REGISTER: Sign me up

Categories Free courses Featured courses Courses on sale All courses
I want to learn I want to teach Earn Money!
BR - USD ($)

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

price

Free Course

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.

See More
View Certificate
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 person in 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 enrolled in this course.

General evaluation of the course:

Modules & lessons

Module 1: Database Design

Creating a class flash text

Lesson 1.1 : Introdução, Fonte e Autoria

Creating a class flash video

Lesson 1.2 : Database Design - Introduction

Creating a class flash video

Lesson 1.3 : Database Design 1 - What is a Database?

Creating a class flash video

Lesson 1.4 : Database Design 2 - What is a Relational Database?

Creating a class flash video

Lesson 1.5 : Database Design 3 - RDBMS

Creating a class flash video

Lesson 1.6 : Database Design 4 - Introduction to SQL

Creating a class flash video

Lesson 1.7 : Database Design 5 - Naming Conventions

Creating a class flash video

Lesson 1.8 : Database Design 6 - What is Database Design?

Creating a class flash video

Lesson 1.9 : Database Design 7 - Data Integrity

Creating a class flash video

Lesson 1.10 : Database Design 8 - Database Terms

Creating a class flash video

Lesson 1.11 : Database Design 9 - More Database Terms

Creating a class flash video

Lesson 1.12 : Database Design 10 - Atomic Values

Creating a class flash video

Lesson 1.13 : Database Design 11 - Relationships

Creating a class flash video

Lesson 1.14 : Database Design 12 - One-to-One Relationships

Creating a class flash video

Lesson 1.15 : Database Design 13 - One-to-Many Relationships

Creating a class flash video

Lesson 1.16 : Database Design 14 - Many-to-Many Relationships

Creating a class flash video

Lesson 1.17 : Database Design 15 - Designing One-to-One Relationships

Creating a class flash video

Lesson 1.18 : Database Design 16 - Designing One-to-Many Relationships

Creating a class flash video

Lesson 1.19 : Database Design 17 - Parent Tables and Child Tables

Creating a class flash video

Lesson 1.20 : Database Design 18 - Designing Many-to-Many Relationships

Creating a class flash video

Lesson 1.21 : Database Design 19 - Summary of Relationships

Creating a class flash video

Lesson 1.22 : Database Design 20 - Introduction to Keys

Creating a class flash video

Lesson 1.23 : Database Design 21 - Primary Key Index

Creating a class flash video

Lesson 1.24 : Database Design 22 - Look up Table

Creating a class flash video

Lesson 1.25 : Database Design 23 - Superkey and Candidate Key

Creating a class flash video

Lesson 1.26 : Database Design 24 - Primary Key and Alternate Key

Creating a class flash video

Lesson 1.27 : Database Design 25 - Surrogate Key and Natural Key

Creating a class flash video

Lesson 1.28 : Database Design 26 - Should I use Surrogate Keys or Natural Keys?

Creating a class flash video

Lesson 1.29 : Database Design 27 - Foreign Key

Creating a class flash video

Lesson 1.30 : Database Design 28 - NOT NULL Foreign Key

Creating a class flash video

Lesson 1.31 : Database Design 29 - Foreign Key Constraints

Creating a class flash video

Lesson 1.32 : Database Design 30 - Simple Key, Composite Key, Compound Key

Creating a class flash video

Lesson 1.33 : Database Design 31 - Review and Key Points....HA GET IT? KEY points!

Creating a class flash video

Lesson 1.34 : Database Design 32 - Introduction to Entity Relationship Modeling

Creating a class flash video

Lesson 1.35 : Database Design 33 - Cardinality

Creating a class flash video

Lesson 1.36 : Database Design 34 - Modality

Creating a class flash video

Lesson 1.37 : Database Design 35 - Introduction to Database Normalization

Creating a class flash video

Lesson 1.38 : Database Design 36 - 1NF (First Normal Form of Database Normalization)

Creating a class flash video

Lesson 1.39 : Database Design 37 - 2NF (Second Normal Form of Database Normalization)

Creating a class flash video

Lesson 1.40 : Database Design 38 - 3NF (Third Normal Form of Database Normalization)

Creating a class flash video

Lesson 1.41 : Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index)

Creating a class flash video

Lesson 1.42 : Database Design 40 - Data Types

Creating a class flash video

Lesson 1.43 : Database Design 41 - Introduction to Joins

Creating a class flash video

Lesson 1.44 : Database Design 42 - Inner Join

Creating a class flash video

Lesson 1.45 : Database Design 43 - Inner Join on 3 Tables

Creating a class flash video

Lesson 1.46 : Database Design 44 - Inner Join on 3 Tables (Example)

Creating a class flash video

Lesson 1.47 : Database Design 45 - Introduction to Outer Joins

Creating a class flash video

Lesson 1.48 : Database Design 46 - Right Outer Join

Creating a class flash video

Lesson 1.49 : Database Design 47 - JOIN with NOT NULL Columns

Creating a class flash video

Lesson 1.50 : Database Design 48 - Outer Join Across 3 Tables

Creating a class flash video

Lesson 1.51 : Database Design 49 - Alias

Creating a class flash video

Lesson 1.52 : Database Design 50 - Self Join

view all

Choose a plan:

Free Plan Free
  • 9 CLASS HOURS
  • 30 free access days*
  • No grace period**
  • Certificate of completion***
  • Immediate access
Sign up now
* 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?
Comprar e participar
Não, não quero concorrer a R$ 20 MIL.