Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge
Management Sales Technology training courses, Dublin Belfast Cork Ireland, Beckinridge

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

 

« Back to last page

Why Choose Us?

ILM Qualifications

Beck-Bites

Team Building

Public Schedule


© web design by redrhino

Privacy Policy