Basic computer skills.
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. 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 Microsoft Access dialect of SQL.
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
United Arab Emirates - SQL in Microsoft Access
Qatar - SQL in Microsoft Access
Egypt - SQL in Microsoft Access
Saudi Arabia - SQL in Microsoft Access
South Africa - SQL in Microsoft Access
Brasil - SQL in Microsoft Access
Canada - SQL in Microsoft Access
Österreich - SQL in Microsoft Access
Schweiz - SQL in Microsoft Access
Deutschland - SQL in Microsoft Access
Czech Republic - SQL in Microsoft Access
Denmark - SQL in Microsoft Access
Estonia - SQL in Microsoft Access
Finland - SQL in Microsoft Access
Greece - SQL in Microsoft Access
Magyarország - SQL in Microsoft Access
Ireland - SQL in Microsoft Access
Luxembourg - SQL in Microsoft Access
Latvia - SQL in Microsoft Access
España - SQL en Microsoft Access
Italia - SQL in Microsoft Access
Lithuania - SQL in Microsoft Access
Nederland - SQL in Microsoft Access
Norway - SQL in Microsoft Access
Portugal - SQL in Microsoft Access
România - SQL in Microsoft Access
Sverige - SQL in Microsoft Access
Türkiye - SQL in Microsoft Access
Malta - SQL in Microsoft Access
Belgique - SQL in Microsoft Access
France - SQL in Microsoft Access
Australia - SQL in Microsoft Access
Malaysia - SQL in Microsoft Access
New Zealand - SQL in Microsoft Access
Philippines - SQL in Microsoft Access
Singapore - SQL in Microsoft Access
Thailand - SQL in Microsoft Access
Vietnam - SQL in Microsoft Access
India - SQL in Microsoft Access
Argentina - SQL en Microsoft Access
Chile - SQL en Microsoft Access
Costa Rica - SQL en Microsoft Access
Ecuador - SQL en Microsoft Access
Guatemala - SQL en Microsoft Access
Colombia - SQL en Microsoft Access
México - SQL en Microsoft Access
Panama - SQL en Microsoft Access
Peru - SQL en Microsoft Access
Uruguay - SQL en Microsoft Access
Venezuela - SQL en Microsoft Access
Polska - SQL in Microsoft Access
United Kingdom - SQL in Microsoft Access
South Korea - SQL in Microsoft Access
Pakistan - SQL in Microsoft Access
Sri Lanka - SQL in Microsoft Access
Bulgaria - SQL in Microsoft Access
Bolivia - SQL en Microsoft Access
Indonesia - SQL in Microsoft Access
Kazakhstan - SQL in Microsoft Access
Moldova - SQL in Microsoft Access
Morocco - SQL in Microsoft Access
Tunisia - SQL in Microsoft Access
Kuwait - SQL in Microsoft Access
Oman - SQL in Microsoft Access
Slovakia - SQL in Microsoft Access
Kenya - SQL in Microsoft Access
Nigeria - SQL in Microsoft Access
Botswana - SQL in Microsoft Access
Slovenia - SQL in Microsoft Access
Croatia - SQL in Microsoft Access
Serbia - SQL in Microsoft Access
Bhutan - SQL in Microsoft Access