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

 Introduction to SQL

  Course Code: GN-330  Duration: 1 Day

This one day course provides a good introduction to SQL, particularly for people new to the subject or those who wish to get a good feel for SQL in as short a time as possible. It concentrates on querying existing data but does include examples of updating and inserting new data. It's a very 'hands-on' course with exercises on all the subjects covered.

 
   

 Course Outline

 
   

Introduction

  • Relational Databases.
  • IDs and Keys.
  • Primary and Foreign Keys.
  • Entity-Relationship Modelling - ERM. T-SQL.
  • How SQL Server Works.
  • System Databases.
  • SQL Server Management Studio.
  • SQLCMD.
  • SQL Server Configuration Manager.
  • Other Tools.

Overview of Data Types

  • Designing a Table.
  • Storing Scripts.
  • Numeric Data Types.
  • Characters and Text.
  • Other Main Data Types.
  • Identity Columns.
  • The Primary Key.
  • Nulls.

Selecting Data

  • The Select Statement.
  • Selecting Columns.
  • Ordering.
  • Aliases.
  • Combining Columns.
  • Distinct.
  • Filtering Using Where.
  • Using Not, And and Or.
  • Matching using Like. Between and In.

Action Queries

  • Insert Into. Delete. Update.
  • Updating Multiple Rows.
  • Insert ... Select.
  • Select Into.

Joins

  • Relationships.
  • Using Foreign Keys.
  • Inner Joins.
  • Outer Joins.
  • Disambiguation and abbreviation.
  • Database Diagrams.

Calculation

  • Aggregate Functions.
  • Group By and Having.
  • Having and Where.
  • Rollup, Cube and Grouping Sets.
  • Dates and Times.
  • The Convert Function.
  • String Functions.
 

© Beckinridge Ltd. | Privacy 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