MySQL

Harbrook
Bristol, Cirencester, Harrogate, London, Leeds, Maidenhead, Manchester, Reading, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' After completing this course, the student should be able to:

Outline the structure of a MySQL database
Use the MySQL Client Program and other interfaces
Create a MySQL database
Write SQL statements to select data from a MySQL database
Use joins, subqueries, grouping and aggregate functions
Use SQL expressions and basic functions
Insert, update, delete and replace data
Create and alter tables, indexes and views
Use various data types and constraints
Understand how privileges are controlled
Understand the principles of transactions
Export and Import data
Course outline

Client/Server Concepts
Relational Database Principles
The MySQL Client Program
Other MySQL Interfaces
Data Types
Creating Databases
The Basic SELECT Statement
Selecting Data from Multiple Tables using JOIN
Grouping and Sorting Output
Sub-queries
String, Temporal and Numeric Functions
Creating, Altering and Dropping Tables
Creating, Altering and Dropping Views
Primary and Foreign Key Constraints
Creating and Dropping Indexes
Inserting, Updating and Deleting Data
Transactions
Controlling Access
Exporting and Importing Data ...''

Elements of this syllabus are subject to change.

Phone:0845 850 8060

School Address:

Claro Court Business Centre
Claro Road
Harrogate
N Yorks UK
HG1 4BA

Jobs & Resumes: Bristol, Cirencester, Harrogate, London, Leeds, Maidenhead, Manchester, Reading
Houses & Roommates: Bristol, Cirencester, Harrogate, London, Leeds, Maidenhead, Manchester, Reading
Travel Agencies: Bristol, London, Leeds, Manchester,

Search other schools for MySQL training resources.

Advanced Juniper Networks IPSec VPN Implementation
Advanced Juniper Networks Secure Access
Attack Prevention with Juniper Networks Firewalls
Configuring Juniper Networks Firewall/IPSec VPN Products
Configuring Juniper Networks Secure Access
Juniper Security Manager Fundamentals
Operating Juniper Networks Routers in the Enterprise
Operating Juniper Networks WX Application Acceleration Platforms
Linux Essentials
Red Hat Linux
MySQL Database Administration
Oracle Database 10g DBA
Oracle SQL
Oracle SQL Advanced
Oracle SQL PL
Solaris Fundamentals
Solaris System Administration
UNIX
UNIX Shell Programming

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.