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
Location At 15 venues
Start Different dates available
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?

Venues

Where and when

Starts Location
Different dates available
Aberdeen
Aberdeen City, Scotland
See map
Different dates available
Belfast City
County Antrim, Northern Ireland
See map
Different dates available
Bradford
West Yorkshire, England
See map
Different dates available
Cambridge
Cambridgeshire , England
See map
Different dates available
Cardiff
Cardiff, Wales
See map
See all (15)
Starts Different dates available
Location
Aberdeen
Aberdeen City, Scotland
See map
Starts Different dates available
Location
Belfast City
County Antrim, Northern Ireland
See map
Starts Different dates available
Location
Bradford
West Yorkshire, England
See map
Starts Different dates available
Location
Cambridge
Cambridgeshire , England
See map
Starts Different dates available
Location
Cardiff
Cardiff, Wales
See map
Starts Different dates available
Location
Coventry
West Midlands, England
See map
Starts Different dates available
Location
Exeter
Devon, England
See map
Starts Different dates available
Location
Leeds
West Yorkshire, England
See map
Starts Different dates available
Location
Oxford
Oxfordshire, England
See map
Starts Different dates available
Location
Plymouth
Devon, England
See map
Starts Different dates available
Location
Portsmouth
Hampshire, England
See map
Starts Different dates available
Location
Sheffield
South Yorkshire, England
See map
Starts Different dates available
Location
Southampton
Hampshire, England
See map
Starts Different dates available
Location
Swansea
Swansea, Wales
See map
Starts Different dates available
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

Additional information

14 hours (usually 2 days including breaks)

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