HARTMANN software group

Fundamentals of MySQL Training in Norfolk

Enroll in or hire us to teach our Fundamentals of MySQL class in Norfolk, Virginia by calling us @303.377.6176. Like all HSG classes, Fundamentals of MySQL may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Fundamentals of MySQL may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  
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.
Course Length: 2 Days
Course Tuition: $790 (US)

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

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.