MySQL for Beginners Training Ed 3

MySQL for Beginners Training Ed 3 (D66380GC30)

Introduction:

MySQL for Beginners Training Ed 3 Course Description

The MySQL for Beginners Training Ed 3 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.

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.

Customize It:

With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.

Audience/Target Group

Administrator
Database Administrators
Database Designers
Developer

MySQL for Beginners Training Ed 3 (D66380GC30)Related Courses:

Duration: 4 days

Class Prerequisites:

Basic computer literacy is required
Previous experience with any command-line program.
Knowledge of database concepts.

Skills Gained:

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

Course Content:

Introduction to MySQL

Course Goals
Course Lesson Map
MySQL Overview
MySQL Database Server Editions
MySQL Products
MySQL Services and Support
MySQL Resources
Example Databases

MySQL Server and Client

MySQL Client/Server Model
Communication protocols
MySQL Connectors
The LAMP Stack
Installation of the MySQL server
MySQL Server and Client Startup
Keyboard Editing
Session Logging With the tee File

Database Basics

Basics of Relational Databases
Spreadsheet Versus Database
Entities and Relationships
Relationship Categories
SQL Language and MySQL
SQL data definition language
SQL data manipulation language

Database Design

Database Modeling
Structure and Cardinality Diagram (ERD)
Keys
Normalization
Database Design
Viewing and Evaluating a Database

Table Data Types

Data Types as Part of Database Design
Numeric Data Types
Temporal Data Types
Character String Data Types
Character Set and Collation Support
Binary String Data Types
Data Type Considerations
The Meaning of NULL

Database and Table Creation

Creating a Database
Creating a Table
Showing How a Table Was Created
Column Options
Table Options
Table Indexing
Table Constraints

Basic Queries

The SELECT Statement
Troubleshooting
SQL Modes for Syntax Checking
Common SQL Modes
MySQL Workbench for SQL Development

Database and Table Maintenance

Deleting databases and tables
Creating a new table using an existing table
Confirming the creation of a new table
Copying an existing table structure
Creating a temporary table
Adding, removing and modifying table columns
Adding, removing and modifying indexes and constraints

Table Data Manipulation

Manipulating Table Row Data
The INSERT Statement
The REPLACE Statement
The UPDATE Statement
The DELETE Statement

Functions

Functions in MySQL Expressions
Using Functions
String Functions
Temporal Functions
Numeric Functions
Control Flow Functions
Aggregate Functions
Spaces in Function Names

Exporting and Importing Data

Exporting with a Query
Exporting with a MySQL Utility
Importing from a Data File
Importing with a MySQL Utility

Joining Tables

Combining Multiple Tables
Joining Tables with SELECT
Comma-Separated Joins
Inner Joins
Outer Joins
Table Name Aliases

Table Subqueries

Advantages of Using a Subquery
Placement of Subqueries
Subquery Categories
Subquery Result Table Types
Subquery Type/Placement
Finding Mismatches
Modifying Tables using Subqueries
Converting Joins to Subqueries

MySQL Graphical User Interface Tools

MySQL Workbench
MySQL Enterprise Monitor

Supplementary Information

Storage Engines
Creating Views
Transactions
Retrieving Metadata
Performance Schema
MySQL Enterprise Backup

Conclusion

Course Goals
MySQL Curriculum Path
MySQL Resources
Evaluation
Final QA

Request More Information

Time Frame: 0-3 Months4-12 Months

No Comments Yet.

Leave a comment