Instructor-led training
Fundamentals of MySQL Training in Stockholm, Sweden
Data training from Hartmann Software Group, delivered onsite in Stockholm, Sweden or live online.
What you'll learn
Fundamentals of MySQL is the first step in mastering MySQL, the world's most popular open-source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools. This course is perfect for those interested using MySQL for backend data storage in their applications.
Hands-on activities are included designed to reinforce the content delivered in the course. A step-by-step document is provided to guide in creating a hands-on Windows 10 VM. A cloud-based VM is also available for the attendees to use, which can be purchased separately.
Prerequisites
None
Course Outline
Module 1: Introduction to RDBMS and MySQL
- Why a Relational Database?
- Relational Database Management Systems
- Relational Database Concepts
- About MySQL
Module 2: SQL Language
- About SQL
- Basic Query Syntax
- Querying with MySQL Workbench
Module 3: Data Modification
- Modifying Data
- Handling Duplicate Values and Rows
- Handling Transactions
Module 4: Advanced Queries
- Table Joins and Aliases
- Grouping and Aggregating
- Viewing Metadata
Module 5: Using MySQL Objects
- Views
- Stored Procedures
- Functions
Module 6: Exporting and Importing Data
- Exporting Data
- Importing 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.