SQL in MySQL Training Course

Nobleprog (uk) Limited
In Plymouth, Exeter, Belfast City (Northern Ireland) and 12 other venues

£2,050
Want to speak to an Advisor about this course?

Important information

Typology Course
Start At 15 venues
Start Flexible
Description

How to build a query?
What opportunities has the SQL in a MySQL database?
What is a relational database?
What is the structure and SQL commands?

Important information
Venues

Where and when

Starts Location
Flexible
Aberdeen
Aberdeen City, Scotland
See map
Flexible
Belfast City
County Antrim, Northern Ireland
See map
Flexible
Bradford
West Yorkshire, England
See map
Flexible
Cambridge
Cambridgeshire , England
See map
Flexible
Cardiff
Cardiff, Wales
See map
See all (15)
Starts Flexible
Location
Aberdeen
Aberdeen City, Scotland
See map
Starts Flexible
Location
Belfast City
County Antrim, Northern Ireland
See map
Starts Flexible
Location
Bradford
West Yorkshire, England
See map
Starts Flexible
Location
Cambridge
Cambridgeshire , England
See map
Starts Flexible
Location
Cardiff
Cardiff, Wales
See map
Starts Flexible
Location
Coventry
West Midlands, England
See map
Starts Flexible
Location
Exeter
Devon, England
See map
Starts Flexible
Location
Leeds
West Yorkshire, England
See map
Starts Flexible
Location
Oxford
Oxfordshire, England
See map
Starts Flexible
Location
Plymouth
Devon, England
See map
Starts Flexible
Location
Portsmouth
Hampshire, England
See map
Starts Flexible
Location
Sheffield
South Yorkshire, England
See map
Starts Flexible
Location
Southampton
Hampshire, England
See map
Starts Flexible
Location
Swansea
Swansea, Wales
See map
Starts Flexible
Location
York
North Yorkshire, England
See map

Frequent Asked Questions

· Requirements

Computer literacy Knowledge of any operating system

What you'll learn on the course

MySQL
Database
SQL
Database training

Course programme

Relational database models
  • Relational operators
  • Characteristics of declarative SQL language
  • SQL syntax
  • Division language DQL, DML, DDL, DCL
Data Query Language
  • SELECT queries.
  • Aliases columns of tables
  • Service date (DATE types, display functions, formatting)
  • Group Features
  • Combining internal and external tables (JOIN clause)
  • UNION operator
  • Nested Subqueries (the WHERE clause, the table name, column name)
  • Correlated subqueries
Data Modification Language
  • Inserting rows (INSERT clause)
  • Inserting rows by request
  • Variation of the rows (UPDATE)
  • Delete rows (DELETE)
Data Definition Language
  • Creating, altering and dropping objects (CREATE, ALTER, DROP)
  • Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS
  • Options NULL and NOT NULL
  • CONSTRAINT clause
  • ENUM type
  • type SET
  • PRIMARY KEY condition
  • UNIQUE condition
  • FOREIGN KEY condition
  • DEFAULT clause
Transactions
  • The command COMMIT, ROLLBACK, SAVEPOINT

Achievements for this centre

Additional information

14 hours (usually 2 days including breaks)

Students that were interested in this course also looked at...
See all