Description

Intro to SQL training course description

A hands on course focusing on the use of SQL. In
particular this course does not concentrate on any
particular version of SQL but rather enables delegates
to recognise the differences found in SQL on different
platforms.

What will you learn

Explain the difference between standard SQL and different flavours.

Use SQL statements to query databases.

Use SQL statements to define databases.

Intro to SQL training course details

Who will benefit:

Anyone working with databases.

Prerequisites:

None.

Duration

2 days

Intro to SQL training course contents

What is SQL?

What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends.

Database basics

RDBMS, Tables.

Hands on Investigating a database.

Basic SQL commands

SQL Overview: SQL DML, SQL DDL, SQL
queries. SELECT, WHERE and ORDER BY
clauses. Combining conditions. IN, LIKE and
BETWEEN.

Hands on Querying a database from existing
tables.

SQL data retrieval

Scalar functions.

Hands on Selecting data from an existing database.

More SQL data retrieval

Scalar functions, variations. Aggregate functions,
GROUP BY. HAVING.
Hands on Selecting data from an existing database.

Table joins

Multiple tables, joins, keys, inner joins, left joins,
right joins.

Hands on Selecting data from an existing database.

SQL basic data manipulation

INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK.

Hands on Modifying data in tables.

SQL Data Definition

USE, CREATE, DROP, TRUNCATE, ALTER.

Hands on Managing new tables and columns.

Data control

GRANT, REVOKE.
Hands on Defining permissions.

Course Images

Introduction to SQL

By Systems & Network Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews