Course Overview
The MySQL Fundamentals training is the mastering MySQL, the world`s most popular open source database. Develop solid understand and practical experience using relational databases, SQL and the MySQL Server and tools.
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.
Benefits to the Participants:
This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL you will also gain an understanding of relational databases. In general, learning how to design your database so it`s robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases. Populate them with data and query that data though extensive hands-on practices.
Manages Your MySQL Database
In addition to covering core concepts, this course introduces you to more advanced tools and techniques to help you manage your MySQL database and put your new skills to work.
Who Should Attend?
Application Developers, Database Administrators, Database Designers, Developer.
Pre-requisite
Basic knowledge in MySQL and any programming language.
Course Outlines
- MySQL Overview
- MySQL Resources
- MySQL Training
- MySQL Client/Server Model
- MySQL Connectors
- Installation of the MySQL Server
- Setting the roor Password
- Starting and stopping the MySQL Server
- Using the MySQL Client
- MySQL Workbench
- Basics of Relational Databases
- Spreadsheet versus Database
- Entities and Relationships
- Relationship Categories
- SQL Data Definition Language
- SQL Data Manipulation Language
- Database Modelling
- Keys
- Normalization
- Database Design
- Viewing and Evaluating a Database
- Data Types a sPart of Database Design
- Numeric Data Types
- Temporal Data Types
- String Data Types
- Character Set and Collation Support
- Data Type Consideration
- The Meaning of NULL
- Creating a Database
- Creating a Table
- Showing How a Table was Created
- Column Options
- Table Options
- Indexes, Keys and Constraints
- 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
- Addinng, Removing and Modifying Table Columns
- Adding, Removing and Mdifying Indexes
- The SELECT Statements
- Creating Views
- Querying Data from an Application
- Exporting and Importing a Deliited File
- Troubleshooting
- Manipulating Data
- Inserting Records
- Replacing Existing Records
- Updating Existing Records
- Deleting Records
- Exporting and Importing a Script
- Multistatement Transaction
- Modifying Data from an Application
- Function in MySQL Expressions
- Using Functions
- String Functions
- Date and Time Function
- Numeric Fucntioins
- Aggregate Function
- Spaces in Functions Names
- Querying Multiple Tables
- Joining Tables with SELECT
- Inner Joins
- Outer Joins
- Table Name Aliases
- MySQL Curriculum Path
- MySQL Resources