Instructor-led training
MySQL for Developers Training in Malmo, Sweden
Data training from Hartmann Software Group, delivered onsite in Malmo, Sweden or live online.
What you'll learn
Prerequisites
Course Outline
Module 1: Introduction to Relational Databases
- Why a Relational Database?
- Relational Database Management Systems
- MySQL Community and Workbench
Module 2: Modeling a Relational Database
- What is the Relational Model?
- The Entity-Relationship Model
- Designing the Database Schema
Module 3: SQL Language
- About SQL
- Basic Query Syntax
- Querying with MySQL Workbench
Module 4: Implementing Database Design
- Reviewing the Database Design
- Creating a Database
- Creating Tables
- Creating Indexes
Module 5: Data Modification
- Modifying Data
- Handling Duplicate Values and Rows
- Handling Transactions
Module 6: Advanced Queries
- Table Joins and Aliases
- Grouping and Aggregating
- Set Operations
- Sub-queries and Derived Tables
Module 7: Data Types and Variables
- Data Types
- Variables
- Data Type Conversion
Module 8: Flow Control and Iteration
- Operators
- Decision Making
- Iteration
Module 9: Viewing Data
- Views
- Functions
- Accessing Metadata
Module 10: SQL Programming
- Stored Procedures
- Triggers
- MySQL and Python
Module 11: Query Optimization
- Optimization
- Optimizing SQL Queries
- EXPLAIN ANALYZE
Module 12: Importing and Exporting Data
- Importing Data
- Exporting Data
- MySQL Workbench Wizard
Train your team with HSG
Private, instructor-led training customized for your organization.
- Onsite or live online delivery
- Customized curriculum
- Training for groups of 3 or more
- Flexible scheduling
- Experienced instructors
Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com
Ready to train your team?
Let's customize this training for your organization.
Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.