Projects
Assignments
Overview
MySQL training course teaches attendees how to develop SQL statements, views, stored procedures, and triggers for their MySQL databases. Participants also learn how to design and implement a database and how to work with foreign keys, transactions, and stored programs.
Objectives
At the end of MySQL training course, participants will
Prerequisites
Experience in basic computer literacy with previous experience with command-line programs and some knowledge of database concepts is required. Some knowledge of data retrieval and reporting would be beneficial.
Course Outline
An Introduction to Relational Databases and SQLedforce2021-06-28T12:20:33+05:30
- An Introduction to Client/Server Systems
- An Introduction to the Relational Database Model
- An Introduction to SQL and SQL-Based Systems
- The SQL Statements
- How to Use SQL From An Application Program
MySQL Workbench and Other Development Toolsedforce2021-06-28T12:21:12+05:30
- An Introduction to MySQL Workbench
- Using Workbench to Run SQL Statements
- Using the Reference Manual
- Command Line Client
How to Retrieve Data From A Single Tableedforce2021-06-28T12:23:33+05:30
- An Introduction to the SELECT Statement
- The SELECT Clause
- The WHERE Clause
- The ORDER BY Clause
- The LIMIT Clause
How to Retrieve Data From Two Or More Tablesedforce2021-06-28T12:23:41+05:30
- Inner Joins
- Outer Joins
- Other Skills For Working With Joins
- How to Work With Unions
How to Insert, Update, and Delete Dataedforce2021-06-28T12:23:47+05:30
- Creating Test Tables
- Inserting New Rows
- Updating Existing Rows
- Deleting Existing Rows
Coding Summary Queriesedforce2021-06-28T12:23:53+05:30
- Aggregate Functions
- How to Group and Summarize Data
Coding Subqueriesedforce2021-06-28T12:23:59+05:30
- An Introduction to Subqueries
- How to Code Subqueries In the WHERE Clause
- How to Code Subqueries In Other Clauses
- Working With Complex Queries
How to Use Functionsedforce2021-06-28T12:26:11+05:30
- String Data
- Numeric Data
- Date/Time Data
- Other Functions You Should Know About
How to Design A Databaseedforce2021-06-28T12:26:16+05:30
- Design A Data Structure
- Normalize A Data Structure
- Using MySQL Workbench For Database Design
Creating Databases, Tables, and Indexesedforce2021-06-28T12:26:23+05:30
- Databases
- Tables
- Indexes
- A Script That Creates A Database
- How to Use MySQL Workbench
- Character Sets and Collations
- Storage Engines
Language Skills For Writing Stored Programsedforce2021-06-28T12:27:34+05:30
- An Introduction to Stored Programs
- How to Write Procedural Code
Transactions and Lockingedforce2021-06-28T12:27:38+05:30
- How to Work With Transactions
- How to Work With Concurrency and Locking
How to Create Stored Procedures and Functionsedforce2021-06-28T12:27:43+05:30
- Coding Stored Procedures
- Coding Stored Functions
- How to Use Workbench With Procedures and Functions
