SQL

Silicon Beach Training Ltd.
Brighton, East Sussex, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' SQL is an industry-standard language for accessing mainframe, midrange and LAN-based, multi-user relational databases. This SQL training course will teach the student how to read and write good SQL for querying, updating and maintaining SQL databases. This SQL training course progresses through the elements of the language to build a thorough appreciation and understanding of SQL’s capabilities and power. It covers ANSI-standard SQL and some of the common extensions.

This SQL training course is made up of a mix of theory and practical sessions. You will complete a series of exercises that cover all the important components of the language and allow you to practise your SQL.

Structured Query Language (SQL) Training Course Objectives
On completion, delegates will be able to:

describe where the SQL language came from and its set-based mode of operation
write SQL statements to create and manipulate database objects and data
read SQL effectively
write queries to join many related tables
use the features of the language to safeguard the data and its value to the user
recognise the dangers inherent in the language that may return the right result but would be fatally flawed with different data
Structured Query Language (SQL) Training Course Content
Introduction to Relational Databases
The need for an SQL standard
The ANSI standards
What is a database?
What is a relational database?
Components of a relational database
Normalised data
Anatomy of a table
Primary and foreign keys
Joins
Components of SQL
Data Manipulation Language
SELECT operations
DISTINCT
Virtual columns
Column aliases
Functions
Restricting the rows returned
Multiple conditions
Ordering data
Inserting rows
Updating rows
Deleting rows
Joining tables
The theory of joining tables
Cross, Inner, Outer, Full, Left and Right
Composite joins
Table aliases
SQL92 and SQL89 Join syntax
Data Definition Language
Data types
Column attributes
Create table
Primary and foreign keys
Referential integrity
Alter and drop tables
Views
Defining simple views
Views with virtual columns
Restricted-column views
Joined-table views
Restricted-row views
View restrictions
Summarised Queries
Table aggregates
GROUP BY and aggregates
The HAVING clause
Subqueries
Using simple Subqueries
EXISTS
Correlated Subqueries
Further Data Manipulation Language
Unions
Self joins
Data Control Language
Identifying users
Setting privileges
GRANT and REVOKE ...''

Elements of this syllabus are subject to change.

Phone:+44 (0)1273 622272

School Address/Venue(s):

86 Gloucester Road
Brighton
East Sussex
BN1 4AP
UK

Jobs & Resumes: Brighton
Houses & Roommates: Brighton

Search other schools for SQL training resources.

Visio
Crystal Reports
Sage Instant Accounting
Sage Line 50
VBA For Access
Access API
ACT
Publisher
FrontPage
Ruby on Rails
SQL Server
VB.NET
ADO.NET
ASP.NET
CCNA
PHP
PHP MySQL
MySQL Database Administration
MySQL

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.