Course not currently available
SQL in MySQL Training Course
Course
Online
Description
-
Type
Course
-
Methodology
Online
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
Subjects
- MySQL
- Database
- SQL
- Database training
Course programme
- 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
SQL in MySQL Training Course