Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

  Beck-Bites
Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

 Programming with SQL

  Course Code - MC-104   Duration - 3 Days

SQL is the industry standard language used to manipulate and retrieve data from relational databases. This course provides an overview of what a relational database is and describes the origins of SQL and the significant role it plays in the relational database arena. The course will teach delegates how to use SQL to create and maintain relational databases.

 

 Objectives

 
 

- Writing SQL queries
- Adding, removing and updating data in a relational database
- Performance implications when writing queries
- Writing efficient SQL scripts

Throughout this course, hands-on exercises will give delegates the opportunity to practice SQL. The exercises provided cover all components of the language providing experience in using joins, sub-queries and other complex queries to maximise system performance.

Two standards organisations;
the American National Standards Institute (ANSI) and the International Standards Organisation (ISO), currently promote SQL standards to industry.  The ANSI-92 SQL standard is used throughout this course although some common extensions to the standard 
are also discussed.

 

 Who Should Attend?

 
 

This course is valuable for developers, database analysts and designers
who are or will be developing applications using SQL.

 

 Prerequisites

 
 

Attendance on the course 'Relational Database Design' ('MC-101') would be useful, though not essential. Prior knowledge of SQL is not required.

 

 Course Content

 
 

Introduction to Relational Databases
- What is a Database?
- What is a Database Management 
  System?
- What is a Relational Database 
- Management System?
- Relational Database Components
   - Relations, Columns, Rows, 
     Primary and Foreign Keys
   - Organising data into Tables

Structured Query Language
- What is SQL?
- Main components of SQL
- The power of SQL

Data Manipulation Language
- SELECT Statement
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- WHERE Clause -  Expressions and 
  Conditions
- ORDER BY Clause
- Functions - Aggregate, Character, 
  Numeric, Date
- Joins - Inner, Outer, Self,
  Cartesian Product
- Sub-Queries - Simple and 
  Correlated
- GROUP BY and HAVING Clauses

Data Definition Language
- Creating and removing Tables
- Primary and Foreign Keys
- Referential Integrity
- Creating and removing Views
   - Restricted Row View
   - Restricted Column View
   - Join View
- Creating and Removing 
  Indexes

Data Control Language 
- Granting and Revoking 
  Privileges
- Manipulating Privileges via 
  Roles
- Schemas and the Data 
  Dictionary

Tuning SQL
- Designing Tables with 
  performance in mind
- Optimising SQL Queries



© Beckinridge Ltd.

Privacy Policy | Quality Policy

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development