Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
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
Requirements
- Computer literacy
- Knowledge of any operating system
14 Hours
Testimonials (3)
Once again, we are attending a training session with Mr. Daniel Brzózka, and we will certainly return. The way the training is conducted and the knowledge shared by Mr. Brzózka is positively received by all of us, and when choosing the training, we specifically wanted this trainer.
KAROLINA - Santander
Course - SQL in MySQL
Machine Translated
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
A professional and accessible way of imparting knowledge, as well as support provided during the training and exercises.
Michal Bialek
Course - Język SQL w bazie danych MySQL
Machine Translated
