Introduction to MySQL™ Development and Administration
MySQL Training Philippines
Overview
Course Benefits
You Will Learn How To
- Understand the features and benefits of MySQL
- Understand the basics of relational databases
- Understand the SQL and MySQL languages
- Understand Data/Column types with regard to efficient database design
- View a database design structure
- Extract basic database information using the SELECT command
- Delete or modify a database
- Delete or modify table row data
- Grouping query data using aggregation
- Connect data from multiple table rows using JOIN
- Perform nested sub-queries
- Use simple functions (String, Date, Numerical)
- Backup and restore the database
- Understand the MySQL storage engines, transactions and concurrency
- Administer databases with native tools like MySQL Administrator and MySQL Query Browser
- Enhance database performance using stored procedures and triggers
Who Should Attend
Course Investment
Course Outline
Introduction to MySQL
- Relational Database Systems
- MySQL Licensing
- Downloading MySQL
- MySQL Command Line Client
- Basic MySQL Commands
- MySQL Query Browser
Database Design Basics
- Tables and Relational Databases
- Primary Keys and Foreign Keys
- Relations
- Creating a Data Model
- Normalization
- Data Types
Data Definition Language
- The Structured Query Language
- Creating, Altering, and Deleting Databases
- Creating Tables
- Creating Columns
- Defining Primary Keys
- Foreign Keys and Column Constraints
The SELECT Statement
- Basic Form
- Displaying Specific Columns
- Using Aliases
- Arithmetic Expressions
- Filtering Data using the WHERE Clause
- Conditional and Logical Expressions
Altering Data
- Inserting Data into Tables (INSERT)
- Replacing Table Rows (REPLACE)
- Updating Table Rows (UPDATE)
- Deleting Table Rows (DELETE)
Working with Multiple Tables
- Queries on Multiple Tables
- Table Aliases
- Joins
- Updating and Deleting Multiple Tables
Advanced Queries
- Retrieving Unique Values (DISTINCT)
- Grouping and Aggregating Data (GROUP BY)
- Filtering Aggregated Results (HAVING)
- Sorting Results (ORDER BY)
- Limiting the Results (LIMIT)
Subqueries, Indexes, and Views
- Using Subquery Operators
- Query Optimization using Indexes
- Creating and Deleting Indexes
- Creating and Editing Views
MySQL Functions
- Character Strings
- Using the Date, Time, DateTime Functions
- Numeric Functions
- Full Text Search Functions
Concurrency and Transactions
- ACID Principles
- Transactions
- Table Locking
MySQL Administration
- Creating Users
- Setting Passwords
- Access Privileges
- Backup and Restore
- Introduction to Migration
- Using the MySQL Administrator
Stored Procedures and Triggers
- Basic Concepts
- Functions and Procedures
- Variables and Parameters
- Control Flow Statements
- Loops
- Error Handling
- Cursors
- Stored Procedure Administration
- Triggers
Schedule
Feb 28 - Mar 4, 2022 (Also available Live Online Training)
Reviews
"I find this course very meaningful and helpful to me. Looking forward to my next training developments with you. Thank you!"
Business System Analyst, First Metro Securities Brokerage Corporation
"Really like how the instructor organizes the topics and explain clearly the concepts also, the hands-on exercises are great!"
Manila Water Co. Inc
"Every course gives clear and understandable examples that greatly accompany the trainee."
Toshiba Information Equipment Philippines
"Excellent method to impart information. More power. Thank you for a great week of information and shared experiences."
Emerson Electric Asia, Ltd, ROHQ
"The course is well organized and very easy to understand. The instructor has a very good teaching method, he connects very well with his students. He uses terms that are easy to understand and he provides helpful examples."
Hewlett Packard Asia Pacific HK
"The course is great. I've come to appreciate SQL even more. Excellent instructor. He is able to explain all the topics very clearly. The content of the course covered most of the basics to get us started in mysql. The hand-out will be an indespensible tool for us."
GMA Network