SQL Fundamentals Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
how to write SQL queries
what relational databases are and how we can use them
what are relations and how to create them
the structure of data
differences between SQL dialects (Oracle, T-SQL, ANSI)
practical skills for writing queries
This SQL course deals with generic ANSI SQL. It can be used in any database, including Oracle, MySQL, Microsoft Access, Microsoft SQL Server, DB2, Informix, PostgreSQL any other relational databases.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Access
- Transactions
- Server
- HTML
- MySQL
- Database
- SQL
- Database training
- DB2
- Animation
- Syntax
- Graphics
- Project
- Microsoft Access
Course programme
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
- Inserting rows (INSERT)
- Inserting rows using subquery
- Updating rows (UPDATE)
- Deleting rows (DELETE)
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
- NULL i NOT NULL
- CONSTRAINT clause
- ENUM type
- SET type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- DEFAULT clause
- COMMIT
- ROLLBACK
- SAVEPOINT
- Implicit and explicit rollbacks and commits
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
SQL Fundamentals Training Course