Implement a Relational Database with SQL

Course
en
English
4 h
This content is rated 0 out of 5
Source
  • From openclassrooms.com
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 2 Sequences
  • Introductive Level

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

Syllabus

Part 1 - Design Your Database
1. Get the Most Out of This Course
2. Design the Tables and Fields That Will Make Up Your Database
3. Choose the Right Data Types for Your Data
4. Data Integrity: Keep Your Database From Falling Apart
5. Optimize Your Data Retrieval Time Through Indexing
Quiz: Check Your Database Design Skills!
 

Part 2 - Construct and Maintain Your Database
1. Communicate With Your Database Using Basic SQL
2. Populate and Manage Your Tables
3. Put It All Together
4. Get some practice building an employee database!

Certificate

Prerequisite

To succeed in this course, you should already have some basic knowledge of relational databases. If you don't yet, we recommend taking the following short course before you get started on this one:

  • Design the logical model of your relational database

Instructors

Victor Wilkinson
Software developer and adjunct instructor currently working on a VB6 to VB.NET software conversion for FBE Associates.

Editor

OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.

Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.

Platform

OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.

Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.

This content is rated 4.5 out of 5
(no review)
This content is rated 4.5 out of 5
(no review)
Complete this resource to write a review