Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
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
Requirements
Basic computer skills.
Testimonials
adapting the material to the knowledge, interests and needs of the interested; a small group of trainers helped in learning more quickly; nice way of conducting, trivia, conversation
Łukasz Madej
A lot of exercises, examples, recalling and discussing cases of practical applications of the issue
- UBS Business Solutions Poland Sp. z o.o.
The training was conducted thoroughly from basic to very advanced ones. Friendly trainer, happy to answer questions.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
the knowledge gained from the training can be used in the job for which he was asked, the code written in VBA certainly no one will remember, so sending this message in the email is useful
- UBS Business Solutions Poland Sp. z o.o.
Related Courses
Microsoft Access - download the data
14 hours
SQL in SQL Server
14 hours
Transact SQL Basic
14 hours
Transact SQL Advanced
7 hours
SQL language in MSSQL
14 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
SQL in MySQL
14 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Oracle SQL Language
14 hours
Oracle SQL for beginners
21 hours
Oracle SQL Advanced
14 hours