Course not currently available

SQL in Microsoft Access Training Course

Name: SQL in Microsoft Access Training Course
Brand: Nobleprog Limited
Price: 1750 GBP

Nobleprog Limited

Course

Online

£ 1,750 VAT inc.

Description

Type

Course

Methodology

Online

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.

About this course

Requirements

Basic computer skills.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Reviews

Subjects

Access
Transactions
Server
MySQL
SQL
Database training
Primary
Syntax
Writing
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

DML (DataManipulationLanguage) 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

Additional information

14 hours (usually 2 days including breaks)

SQL in Microsoft Access Training Course

£ 1,750 VAT inc.

Contact us

SQL in Microsoft Access Training Course

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

SQL in Microsoft Access Training Course

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.