MySQL for Beginners

OCA MySQL for Beginners SQL-4401 - Exam number: 1Z0-870 Formerly Sun Certified MySQL Associate (SCMA)

Upcoming Class
18 Jun 2018
8
Day(s) course
18:30 pm - 21:30 pm
950per person
807.50 (when you book any 3 courses *)
This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Database Administrator
Career Programme

Looking for a 2-12 months training?

Choose

Database Administrator career programme

Upcoming dates

Date Day(s) Course Session Time Price
18 Jun 2018 8 Mon & Thu 18:30 - 21:30 £950 Reserve
02 Jul 2018 3 Mon to Wed 10:00 - 17:00 £950 Reserve
15 Jul 2018 3 Sun 10:00 - 17:00 £950 Reserve
31 Jul 2018 8 Tue & Fri 18:30 - 21:30 £950 Reserve
18 Aug 2018 3 Sat 10:00 - 17:00 £950 Reserve
18 Jun 2018
Mon to Thu
18pm - 21pm
8 day(s)
£950.00
02 Jul 2018
Mon to Wed
10am - 17pm
3 day(s)
£950.00
15 Jul 2018
Sun
10am - 17pm
3 day(s)
£950.00
31 Jul 2018
Tue to Fri
18pm - 21pm
8 day(s)
£950.00
18 Aug 2018
Sat
10am - 17pm
3 day(s)
£950.00

Course Outline

MySQL for Beginners course overview

Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool.

Delegates will learn:

  • Understand the features and benefits of MySQL
  • Be able to install and start the MySQL server
  • Understand the basics of Relational Databases
  • Understand the SQL and MySQL languages
  • Understand Data/Column types with regard to efficient database design
  • Be able to view a database design structure/content
  • Create a database design using an efficient structure
  • Be able to extract basic database information using the SELECT command
  • Be able to troubleshoot syntax and understand typical warnings and errors
  • Be able to delete or modify a database, and table row data
  • Grouping query data with Aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use of Simple Functions (String, Date, Numerical)
  • Describe MySQL connectors, their major features and differences
  • Understand MySQL storage engines, transactions and features of the common engines

This short MySQL course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public MySQL wtraining course is given on training dragon website.


Who is MySQL for Beginners training for?

Students who can benefit from this course:

  • New or existing users of MySQL, who have little or no previous experience with a relational database management system.


Prerequisites for MySQL for Beginners course

Required Prerequisites:

  • Basic computer literacy is required

Suggested Prerequisites:

  • Previous experience with any command-line program
  • Knowledge of database concepts


What will I get?

  • Training from professional MySQL certified trainers:

    Training Dragon consultants have been implementing professional MySQL Server Database solutions across a range of companies for many years. Those consultants write and teach our MySQL training courses, so their experience directly informs course content.

  • Practical Projects:

    This MySQL training is designed to prepare you not only for MySQL certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical MySQL related exercises in this MySQL course. This will ensure that you can apply the knowledge gained from this course to your work environment.

  • Course Material and Practice exams:

    MySQL electronic notes are included in this course. You will also take practice exams as part of the course.

  • Course Completion Certificate:

    After completing this training you will receive MySQL course completion certificate.

  • Support and Careers Advice:

    After the course if you have any problems or questions regarding MySQL, do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.

  • Pass Guarantee and Train again for Free:

    We are sure that you will pass your MySQL certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.

  • Official Course Curriculum:

    This MySQL certification course is based on the official Microsoft recommended course syllabus.


MySQL for Beginners Course Contents

Introduction

  • Features and Benefits of MySQL
  • MySQL Products and Service
  • Community vs. Enterprise
  • MySQL Certification Program
  • MySQL Certification Program
  • MySQL Website
  • MySQL Architecture
  • Install and Start MySQL

Database Basics

  • SQL Language and MySQL
  • Database Design
  • Database Modeling
  • Keys
  • Normalization
  • Data Types
  • What is NULL?
  • Viewing Database Structure

Database Creation

  • Create a New Database Structure
  • Creating a Database
  • Creating a Table

Basic Queries

  • The SELECT Command
  • MySQL Query Browser
  • Troubleshooting

Database Maintenance

  • Delete an Entire Database
  • Maintaining Tables
  • Maintaining Columns
  • Indexes and Constraints
  • Data Manipulation

Delete/Modify Table row Data

  • The INSERT Command
  • The REPLACE Command
  • The UPDATE Statement
  • The DELETE Command

Functions

  • Simple Functions
  • Grouping With Functions

Joining Tables

  • Combining Multiple Tables
  • Inner Joins
  • Outer Joins

Exporting/Importing Data

  • Exporting Data
  • Importing Data

Sub queries

  • What is a Sub query?
  • Categories of Sub queries
  • Sub query Types
  • Placing Sub queries
  • Other Sub query Uses
  • Other Sub query Uses

Supplementary Information

  • Creating VIEWs
  • Transactions
  • Storage Engines
  • Retrieving Metadata

Conclusion

  • Course Review
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • QA Session

View Complete Course outline

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

10:00 11:30 11:45 13:00 14:00 15:30 15:45
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Lunch
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Video Placeholder

Looking for a
2-12 months
training?

Choose

Database Administrator career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them