Introduction to SQL Programming

Introduction to SQL Programming

Duration:
2 Days

(this course can be customised and delivered as a 1 day course)

Aims:

This course is designed for those who need to manipulate data held in a standard relational database using basic SQL.

Objectives:

On completion of this course, attendees will be able to retrieve and manipulate data held within relational databases using the SQL querying language.

Pre-Requistites

There are no pre-requisites, however, delegates would be assumed to have good general IT skills.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Introduction to SQL
  • - History of the SQL language, where it came from and its different variants.
Relational Databases
  • - Overview of relational database design and its different forms.
  • - 1st Normal Form
  • - 2nd Normal Form
  • - 3rd Normal Form
Select Statement
  • - How to retrieve data from the database in the form of a query.
  • - Distinct
  • - Top
Where Clause
  • - How to filter your retrieved data.
  • - Operators
  • - IN
  • - LIKE
  • - BETWEEN
  • - AND
  • - OR
Order By
  • - How to sort your retrieved data ascending or descending.
Insert Into
  • - How to insert new data into and existing table.
Update
  • - How to update existing table data.
Delete
  • - How to delete data from and existing table.
Truncate
  • - How to truncate data from and existing table.
Joins
  • - How to retrieve data from multiple tables using a join.
  • - Inner
  • - Left
  • - Right
  • - Outer
Union
  • - How to join data from two different datasets.
SQL Functions
  • - Overview of SQL Functions and an overview of the most commonly used ones.
  • - Substring
  • - Left
  • - Right
  • - Replace
  • - Charindex
  • - Getdate
Group By
  • - How to group and aggregate the results for your retrieved data.
  • - Aggregation functions
  • - Max
  • - Min
  • - Avg
  • - Sum
  • - Count
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot