SQL in MySQL Training Course
Course
In City Of London
Price on request
Description
-
Type
Course
-
Location
City of london
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?
Facilities
Location
Start date
City Of London
(London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS
Start date
On request
Reviews
Have you taken this course?
Subjects
- Transactions
- Options
- MySQL
- Database
- SQL
- Database training
- Primary
- Syntax
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
SQL in MySQL Training Course
Price on request