MySql for Beginners

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

Il corso è rivolto a Administrator, Architect, Database Administrator, Developer

Nessuno

Al termine del corso i partecipanti saranno in grado di:

• Conoscere il modello di database relazionale.
• Conoscere le caratteristiche e i vantaggi di MySQL.
• Installare e configurare il server e i client MySQL.
• Progettare database efficienti.
• Usare Structured Query Language (SQL) per costruire un database e interrogare i dati.
• Impiegare strumenti MySQL appropriati.