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.
コース概要
RDBMS (Relational DataBase Management System)
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
- SELECT clause
- Column aliases
- Table aliases
- Date types and Date functions
- Group function
- Table joins
- JOIN clause
- UNION operator
- Nested queries
- Correlated subqueries
DML (Data Manipulation Language) Overview
- Inserting rows (INSERT)
- Inserting rows using subquery
- Updating rows (UPDATE)
- Deleting rows (DELETE)
DDL (Data Definition Language) Overview
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
- NULL i NOT NULL
- CONSTRAINT clause
- ENUM type
- SET type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- DEFAULT clause
Transactions Overview
- COMMIT
- ROLLBACK
- SAVEPOINT
- Implicit and explicit rollbacks and commits
SQL Dialects Overview
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
要求
Basic computer skills.
14 時間
お客様の声 (5)
トレーニングでは、2日間にわたってすべてのモジュールが詳細にカバーされた。
Bernadetta - Urząd Komisji Nadzoru Finansowego
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
コース - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
コース - Oracle SQL Language
The smoothness of the training flow.
Alby Geronimo - Aarki, Inc.
コース - SQL DATABASE MANAGEMENT AND DESIGN - Bespoke
I like fact, that after each section we had exercises. It helps to remember discussed topic.