Course not currently available
SQL Fundamentals
Training
In Plymouth ()
Price on request
Description
-
Type
Training
-
Class hours
14h
Suitable for: Anyone
Reviews
Have you taken this course?
Subjects
- Syntax
- Microsoft Access
- Primary
- Database
- Transactions
- Server
- Access
- SQL
- Database Administration
- Database training
Course programme
DBMS (Relational DataBase System) Relational Operators as Declarative Syntax Sublanguages DQL, DML, DDL, DCL DQL (Data Query ) 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 Modification ) Overview
- Inserting rows (INSERT)
- Inserting rows using subquery
- Updating rows (UPDATE)
- Deleting rows (DELETE)
- DDL (Data Definition ) 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
- Dialects Overview
- Microsoft Access and Server
- and PostgreSQL
SQL Fundamentals
Price on request