email us
 training@pcworkshopsLondon .co.uk
contact us
 020-7164-6359

MYSQL INTERMEDIATE COURSE, 3 DAYS

£750 - Included - Course Topics - Book the course
MYSQL INTERMEDIATE COURSE, 3 DAYS
Course details

mySQL Course, 3-days

mySQL Course Summary.


Practical mySQL course, to leave you fully conversant with queries, DML and DDL statements.
Hands-on, Practical mySQL course.
PCWorkshops mySQL Course Certificate.
Max 4 people per course, we keep it personalised.

Where is the mySQL Course?
  • Online: Instructor-led.
  • Classroom: Request per email.
mySQL Course Materials
  • mySQL Coding Examples
  • Manuals and Notes: In-depth reference materials
  • Exercises: Practical exercises
Payment Options
  • £750, Follow the booking link
  • Arrange for installments
Included with mySQL Course:
  • mySQL Course Certificate on completion.
  • mySQL Course Manual.
  • Practical mySQL Course exercises, mySQL Code Samples/ mySQL Course Revision work.
  • After the course, 1 free session for questions.
  • Max group size, online and in classroom, on this mySQL Course is 4.
Course Details
MySQL Intermediate Course summary


  • DAY 1:
  • 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. 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.
  • 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. 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.


  • DAY 2:
  • 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).


  • DAY 3:
  • 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.
Book the mySQL Course
About us
DOWNLOAD A CATALOGUE
java Bootcamp uk
Learn Java
What's new in Java 17? Accelerating Java’s Adoption in the Cloud with continuous innovation that address the evolving needs of developers. To accelerate Java adoption in the cloud, Oracle recently introduced the Oracle Java Management Service
What's new in Java 17? Updates and Improvements to Libraries JEP 306: Restore Always-Strict Floating-Point Semantics –
What's new in Java 17? Future Proofing Java Programs JEP 403: Strongly Encapsulate JDK Internals – It will no longer be possible to relax the strong encapsulation of internal elements
What's new in Java 17? Read the Java 17 technical blog : https://blogs.oracle.com/java/post/announcing-java17
sql course london
sql course london

Request a Free mySQL Course Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.
About Us
  • About PCWorkshops
    •
  • Awards
    •
  • Locations
    •
  • Terms and Conditions
    •
  • Contact Us
    •
  • Client Comments
    •
    Quick Links
  • Software development jobs
    •
  • Python Courses
    •
  • Java Courses
    •
  • SQL Courses
    •
  • Database Courses
    •
  • MS Project Courses
    •
    Contact Us
  • Call: 020-7164-6359
  • Email: training@pcworkshopsLondon .co.uk
    • Connect with Us

    Copyright © PCWorkshops 2019. All Rights Reserved.