Oracle - Course Details

MySQLBN MySQL for Beginners NEW

Oracle Course Description:
If you're looking to build a solid foundation in your development career, this course is an ideal place to begin. MySQL for Beginners will introduce you to the fundamentals of relational databases and SQL through hands-on exercises.
Oracle Course Duration:
4 DAYS
Oracle Course Target Audience:
Administrator,Database Administrators,Database Designers
Oracle Course Prerequisite:
Basic computer literacy is required,Previous experience with any command-line program,Knowledge of database concepts
Course Content:
  • Introduction

    • MySQL Product
    • MySQL Services and Support
    • MySQL Resources
    • Example Databases

  • MySQL Server and Client

    • The client/server model overview
    • Communication protocols
    • Connectors and MySQL
    • The LAMP Stack
    • Installation of the MySQL server
    • MySQL Server and Client Startup

  • Database Basics

    • Basics of Relational Databases
    • SQL Language and MySQL

  • Database Design

    • Database Modeling
    • Keys
    • Normalization

  • Table Data Types

    • Data Types
    • Numeric Data Types
    • Temporal Data Types
    • Character String Data Types
    • The Meaning of Null

  • Database and Table Creation

    • Database Structure Creation
    • Database Creation
    • Table Creation

  • Basic Queries

    • The SELECT Statement
    • MySQL Workbench for SQL Development
    • Troubleshooting

  • Database and Table Maintenance

    • Deleting an Entire Database
    • Maintaining Tables
    • Maintaining Columns
    • Indexes and Constraints

  • Table Data Manipulation

    • Delete/Modify Table Row Data
    • The INSERT Statement
    • The REPLACE Statement
    • The UPDATE Statement
    • The DELETE Statement

  • Functions

    • Simple Functions
    • Grouping with Functions

  • Joining Tables

    • Combining Multiple Tables
    • Inner Joins
    • Outer Joins

  • Table Queries

    • What is a Subquery
    • Categories of Subqueries
    • Subquery Types
    • Placing Subqueries
    • Other Subquery Uses
    • Converting Subqueries to Joins

  • Exporting and Importing Data

    • Exporting Data
    • Importing Data

  • MySQL GUIs

    • MySQL Enterprise Monitor
    • MySQL Workbench

  • Supplemental Information

    • Creating Views
    • Transaction
    • Storage Engines
    • Retrieving Metadata
    • Performance Schema
    • MySQL Enterprise Backup

  • Conclusion

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