Database Design and Introduction to MySQL

Lecturer
Eidostech Academy
0 Reviews
FreeTake this course

Course Description

Course Info

  • Lessons: 41
  • Prerequisites: No

Curriculums

Database Design

  • a. Introduction
    Lesson
  • b. What is a Data Warehouse?
    Lesson
  • c. Structure of a Data Warehouse
    Lesson
  • d. Star Schema
    Lesson
  • e. OLAP vs OLTP
    Lesson
  • f. SETL
    Lesson
  • g. Entity Constraints
    Lesson
  • h. Referential Constraints
    Lesson
  • i. Semantic Constraints
    Lesson
  • j. ERDs
    Lesson
  • k. Start Schema: A demonstration
    Lesson
  • l. Summary
    Lesson

Database Creation in MySQL Workbench

  • a. Introduction
    Lesson
  • b. Introduction to DDL and DML Statements
    Lesson
  • c. DDL Statements: a Demonstration
    Lesson
  • d. DML Statements: a Demonstration
    Lesson
  • e. Modifying Columns
    Lesson
  • f. Practice Exercise – DDL and DML Statements
    Lesson
  • g. Summary
    Lesson

Querying in MySQL

  • a. Introduction
    Lesson
  • b. SQL Statements and Operators
    Lesson
  • c. Aggregate Functions
    Lesson
  • d. Ordering
    Lesson
  • e. The Having Clause
    Lesson
  • f. String and Date – Time Functions
    Lesson
  • g. Regular Expressions
    Lesson
  • h. Nested Queries
    Lesson
  • i. CTEs
    Lesson
  • j. Views
    Lesson
  • k. Summary
    Lesson

Joins and Set Operations

  • a. Introduction
    Lesson
  • b. Set Theory
    Lesson
  • c. Types of Joins
    Lesson
  • d. Types of Joins: A Demonstration
    Lesson
  • e. Outer Joins: A Demonstration
    Lesson
  • f. Views with Joins
    Lesson
  • g. Set Operations with SQL
    Lesson
  • h. Practice Questions
    Lesson
  • i. Summary
    Lesson

SQL Practice Case Study

  • a. SQL Practice Case Study
    Lesson

Questions

  • a. Questions
    Lesson

Reviews

0
0 Ratings
stars 5
0%
0
stars 4
0%
0
stars 3
0%
0
stars 2
0%
0
stars 1
0%
0

There are no reviews yet.

Leave a Review

Be the first to review “Database Design and Introduction to MySQL”