Course not currently available

SQL Fundamentals Training Course

Nobleprog Limited

Course

Online

£ 1,750 VAT inc.

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

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.

About this course

Basic computer skills.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

Subjects

  • Access
  • Server
  • MySQL
  • Database Management
  • Database
  • SQL
  • Database training
  • DB2
  • Syntax
  • 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 (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

Additional information

14 hours (usually 2 days including breaks)

See related categories

SQL Fundamentals Training Course

£ 1,750 VAT inc.

The best Oracle courses

See all

See all