Course not currently available
SQL in MySQL Training Course
Course
In Plymouth ()
£ 2,050
VAT inc.
Description
-
Type
Course
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?
About this course
Computer literacy
Knowledge of any operating system
Reviews
Have you taken this course?
Subjects
- 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
- 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
- Inserting rows (INSERT clause)
- Inserting rows by request
- Variation of the rows (UPDATE)
- Delete rows (DELETE)
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
- Options NULL and NOT NULL
- CONSTRAINT clause
- ENUM type
- type SET
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
- The command COMMIT, ROLLBACK, SAVEPOINT
Additional information
14 hours (usually 2 days including breaks)
SQL in MySQL Training Course
£ 2,050
VAT inc.