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 Content

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.

« Back to last page