Overview    
The MySQL for Beginners course helps you learn about the world's most popular open source database. Expert Oracle University instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of using relational databases.

 

Course objectives    
•    Explain MySQL storage engines
•    Explain database transactions
•    Obtain database metadata
•    Describe MySQL GUI tools
•    Monitor database performance
•    Perform database backup and recovery
•    Export and import database data
•    Describe the features and benefits of MySQL
•    Explain the basics of relational databases
•    Design an effective database
•    Build a database and tables by using SQL Modify or delete database entities
•    Query data with the SELECT command
•    Join data from multiple tables
•    Perform nested subqueries
•    Use built-in MySQL functions

 

Learn to    
•    Explain the relational database model.
•    Describe the features and benefits of MySQL.
•    Install and configure the MySQL server and clients.
•    Design efficient databases.
•    Use Structured Query Language (SQL) to build your database and query data.
•    Employ appropriate MySQL tools.

 

Audience    
•    Administrator
•    Architect
•    Database Administrator
•    Developer


COURSE OUTLINE:

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
 

D61918 | MySQL for Beginners Ed3

SKU: ORACLE-D61918
NETEC
DESCUENTOS Y PAGOS
Suscríbase a nuestro newsletter
  • Facebook Netec
  • Twitter Netec
  • Linkedin Netec
  • Youtube Netec
  • Instagram Netec

Copyright 2019 Netec. Todos los derechos reservados.