Oracle - Course Details

MySQLB-SSC MySQL for Beginners - Self-Study Course

Oracle Course Description:
This MySQL for Beginners course teaches you about this powerful relational database management system. Expert Oracle University instructors will review all the basics to get you on your way.
Oracle Course Duration:
Self Placed
Oracle Course Target Audience:
NONE
Oracle Course Prerequisite:
Basic computer literacy is required,Previous experience with any command-line program,Knowledge of database concepts
Course Content:
  • Introduction

    • Features and Benefits of MySQL
    • MySQL Products and Service
    • Community vs. Enterprise
    • MySQL Certification Program
    • MySQL Certification Program
    • MySQL Website
    • MySQL Architecture
    • Install and Start MySQL

  • Database Basics

    • SQL Language and MySQL
    • Database Design
    • Database Modeling
    • Keys
    • Normalization
    • Data Types
    • What is NULL?
    • Viewing Database Structure

  • Database Creation

    • Create a New Database Structure
    • Creating a Database
    • Creating a Table

  • Basic Queries

    • The SELECT Command
    • MySQL Query Browser
    • Troubleshooting

  • Database Maintenance

    • Delete an Entire Database
    • Maintaining Tables
    • Maintaining Columns
    • Indexes and Constraints
    • Data Manipulation

  • Delete/Modify Table row Data

    • The INSERT Command
    • The REPLACE Command
    • The UPDATE Statement
    • The DELETE Command

  • Functions

    • Simple Functions
    • Grouping With Functions

  • Joining Tables

    • Combining Multiple Tables
    • Inner Joins
    • Outer Joins

  • Exporting/Importing Data

    • Exporting Data
    • Importing Data

  • Sub queries

    • What is a Sub query?
    • Categories of Sub queries
    • Sub query Types
    • Placing Sub queries
    • Other Sub query Uses
    • Other Sub query Uses

  • Supplementary Information

    • Creating VIEWs
    • Transactions
    • Storage Engines
    • Retrieving Metadata

  • Conclusion

    • Course Review
    • Training and Certification Website
    • Course Evaluation
    • Thank You!
    • QA Session