Database Concepts

  • Databases
  • Databases Management System (DBMS)
  • Characteristics of a Database
  • Users of a Database
  • Types of Database Management Systems
  • Relational Database
  • Hierarchal Database
  • Network Database Model
  • Object-oriented Models

Using MySQL Client

  • Introduction
  • Using MySQL Client
  • Installation of MySQL
  • Installing MySQL on Linux/Unix
  • Installing MySQL on Windows
  • MySQL Client Programs
  • Types

Date, Time and Other Functions

  • Date and Time Functions
  • String Functions
  • Control Flow Functions

Managing Data

  • Ways to Manage Data
  • Exporting Data to a Simple CSV File
  • Exporting Data to a Custom File Format
  • Import Data from a Simple CSV File
  • Import Data from Custom File Formats

Limit, Aggregate and Union Functions

  • Limit Functions
  • Aggregate Function
  • Types of Aggregate Functions
  • Union Function

Indexes and Views

  • Indexes
  • Views

Module 7: Basic Select Function

  • SELECT Command