25,000+ Courses Nationwide
0345 4506120

MySQL Intermediate

MySQL is an open-source relational database management system (RDBMS).
MySQL is open-source software, under the terms of the GNU General Public License. MySQL is available for use free of charge and is also available under a variety of proprietary licenses. MySQL is owned by Oracle Corporation. In 2010, Oracle forked the open-source MySQL project to create MariaDB.
Interesting to know, its name combines "SQL", the abbreviation for Structured Query Language and "My", the name of co-founder Michael Widenius's daughter.

WHAT IS INCLUDED IN THE MYSQL COURSES:

  • MySQL Course Certificate on completion
  • MySQL Course notes
  • Practical MySQL Course exercises, MySQL Code Examples
  • After the course, 1 free session for questions online MySQL Course via Gotomeeting.com.
  • Max group size, online and in classroom, on this MySQL Course is 4.

Select specific date to see price, venue and full details.

Learning Objectives

In this MySQL Course you will learn how to get valuable information, trends, summaries, statistics and insights from your company data using SQL.This course is ideal for managers and data analysts who need to get business intelligence from data.

Course Content

Session 1: Database Concepts

To assist with the MySQL aspects of the MySQL Course, we also cover database basics. What is a database? Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

Session 2: Using the MySQL client

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

Session 3: Basic MySQL SELECT statement

The MySQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and MySQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”), Precedence of operators

Session 4: LIMIT / TOP, UNION Queries and MySQL AGGREGATE Functions

The LIMIT and TOP clauses, Aggregate (Sum, Average, Maximum, Minimum, Count), Group By, Rollup with Group By, Having.

Session 5: Joins

MySQL Cartesian products,
MySQL Joins (Inner join, Left join, Right join, Full join) Table aliases,
Natural joins, Multi-table joins.
Union, Union All, Except/Minus, Simulating join with Intersect.

Session 6:

MySQL Subqueries, Nested Subqueries, Correlated and uncorrelated subqueries. Global and Local Temp Tables.

Session 7:

MySQL Built-in Functions: Numeric Functions (ABS, SIGN, MOD, etc.)
and String Functions (Locate, Left, Right, Concat, etc),
DATE and TIME functions.

Session 8:

MySQL Views (Create, alter and drop), Stored Procedures (Create, alter and drop, Input and Output parameters); Custom Functions (Create, alter and drop).

Session 9: Managing Data

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

Session 10:

MySQL Indexes (Create, alter and drop).

Session 11:

Creating Databases and Tables (Create, alter and drop); Constraints (Add, alter and drop).

Session 12:

Import data into MySQL and Export from MySQL.
Exporting using MySQL, Importing using MySQL.

Exams & Certification

MySQL Course Certificate on completion

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best