Training Course

Introduction to MySQL

Download Course PDF

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Duration

3 Days

Introduction to MySQL Course Overview

The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.

Course Prerequisites

    • There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.

Course Objectives

    • Create and alter a MySQL database and query and modify data held within such a database

Course Certification

Together with the MySQL for Developers course, this course covers the major topics required for the MySQL 5.6 Developer Certified Professional Exam(1Z0-882).

Together with theMySQL Database Administration course, this Introduction to MySQL course will teach the major topics required for the delegate to work towards achieving the MySQL 5.6 Database Administrator Certified Professional Exam(1Z0-883).

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Target Audience for this Course

    • Anyone who needs to access and work with a MySQL Database.

Skills Gained from this Training

    • Using client programs to access a MySQL database
    • Creating, altering and dropping a MySQL database
    • Writing SQL statements to select data from a MySQL database
    • Writing joins and subqueries
    • Using SQL expressions
    • Using SQL aggregate functions and scalar functions
    • Inserting, updating, deleting and replacing rows
    • Creating and altering tables, indexes and views
    • Using transactions
    • Granting and revoking access privileges on tables and views
    • Exporting and importing data

Included with this course

    • Comprehensive course materials and exercises

Introduction to MySQL Course Content

  • DATABASE CONCEPTS

    What is a database?
    Database management systems
    Tables, rows and columns
    Indexes, primary keys, unique constraints and foreign keys
    Client-Server architecture
    Supported data types
    Storage engines and table types
    The Information_Schema and MySQL Databases

  • USING THE MySQL CLIENT

    What is the MySQL client?
    Getting started and Logging in
    Selecting a database
    Client commands
    Entering and executing SQL statements
    Retrieving previous commands
    Creating, editing and executing SQL files
    Redirecting output into a file
    Command line execution of MySQL Scripts

  • BASIC SELECT

    The SQL SELECT statement
    Case sensitivity
    Quotes
    Statement terminator
    Syntax conventions
    The select clause
    The FROM clause
    Conditions and the WHERE clause
    Logical operators
    The ORDER BY clause
    Column aliases
    Arithmetic expressions
    Precedence of operators

  • LIMIT, UNION AND AGGREGATE FUNCTIONS

    The LIMIT clause
    UNION
    UNION ALL
    Aggregate functions
    The GROUP BY clause
    Using Rollup with GROUP BY
    The HAVING clause

  • SUBQUERIES AND JOINS

    Subqueries
    Cartesian products
    Joins with original syntax
    Table aliases
    Natural joins
    Join using
    Join on
    Multi-table joins

  • NUMERIC AND CHARACTER FUNCTIONS

    Function types
    Testing functions
    Numeric functions
    Character functions

  • DATE, TIME AND OTHER FUNCTIONS

    Date and time column types
    Date and time formats
    The date format function
    Functions to return date time
    Functions to extract components from date time
    Date time arithmetic
    Miscellaneous functions

  • DATABASES AND TABLES

    Creating a database
    Selecting a database
    Creating tables
    Auto_increment
    Show create table
    Column operations
    Constraint operations
    Copying tables
    Renaming tables
    Changing engine for tables
    Dropping tables
    Temporary tables

  • INDEXES AND VIEWS

    What is an index?
    Creating an index
    Reviewing indexes
    Dropping indexes
    What is a view?
    Creating views
    View restrictions
    Dropping views

  • MANAGING DATA

    Inserting rows
    Replacing rows
    Updating rows
    Deleting rows
    The truncate statement
    The COMMIT and ROLLBACK commands
    Savepoints
    Implicit commits

  • ACCESS CONTROL

    Creating users
    Renaming users
    Dropping users
    Granting privileges
    Revoking privileges

  • IMPORT AND EXPORT

    Exporting using SQL
    Importing using SQL
    Exporting from the command line
    Importing from the command line

 

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Introduction to MySQL Course Options
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
  • Virtual Training

Which part of the course did you find particularly valuable Section around categorising tasks by importance and urgency

A.H. Credit Services Association, Time Management

Following this training what are you going to do differently Use Excel more often for valuable shortcuts to tasks that would otherwise take me a long time.

J. , Excel Level 2

Which part of the course did you find particularly valuable All of the course. A lot of these are tips that I will use every now and then, and some i.e. quick paths are ones I will begin using regularly.

C. Gachet, Outlook Working more Efficiently

Really good. Tailored to meet the needs of our group.

E.G. NHSBSA, PowerPoint Essentials

Following this training what are you going to do differently I will be using excel in a completely different way. But data validation is going to really improve my efficiency. And then conditional formatting is something I think I will be able to use in all parts of my life.

N.B. Public scheduled, Excel Level 2

Which part of the course did you find particularly valuable Extremely knowledgeable training and very clear, consistent teaching style of the trainer. Very beneficial and informative training session.

Y.B. EGGER UK, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

Our tutor was fantastic really knowledgeable and enthusiastic

K.J. Direct Rail Services, Minute Taking

Was good that the trainer recognised how I felt and took that on board and was great with it

R.S. Newcastle City Council, Train the Trainer Training Skills for the Workplace

+ View More Training Reviews

 

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your Introduction to MySQL course, we have many solutions available to ensure you receive the best training possible.
 You can choose your learning path and delivery style.  Courses can be delivered at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Introduction to MySQL course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master SQL, please contact us to book a place or request a quote for your Introduction to MySQL course.

General Information

MySQL Introduction Course in Newcastle, Durham, Washington, Gateshead, Darlington, Leeds, Middlesbrough and throughout the North East of England. Introduction to MySQL - MySQL Training Course Available Throughout The North East.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:9/9/2024 1:54:58 AM