Introduction to SQL Programming

Duration: 2 Days (this course can be customised and delivered as a 1 day course)
Costs: Open courses: N/A
In-house: Price on application - request a quote >>
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-requisites: There are no pre-requisites, however, delegates would be assumed to have good general IT skills.

Course Outline

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

In-House Training

If you have a number of people in your organisation with the same training need, in-house training programmes are an ideal solution.

We pride ourselves on delivering training that is relevant to your business – ensuring staff see the benefits and how they can save time and work more efficiently.

We can deliver both tailored training sessions or the more traditional Foundation, Intermediate and Advanced levels.

Delivery Methods

Training can be delivered at your offices or we can help to select a suitable venue. We can deliver training in various different ways with the more popular being:

  • Group classroom training
  • 1-to-1 training sessions to address individual needs
  • Webinars/Online training

Laptop Hire

Laptop hire is available for most of our courses. We provide PC laptops with the appropriate software pre-loaded as well as projectors, mice and power extension leads.

Pre-Course Skills Assessments

Our focus is always on providing the most relevant training for each client. Before any course we offer pre-course assessments in order for us to ascertain your exact requirements, so you don't waste any time or money on training that isn't right for you and your business.

Course Materials

We provide electronic step by step training reference manuals and issue attendance certificates on completion of the training. That way once we finish, you'll still have everything you've learned at your fingertips.

Post Training Support

In order to make sure you get the best service and expertise from TrainingU, we offer unlimited lifetime post training support giving you peace of mind, should you need help with anything.

{tab Open Course Dates}

Please contact us to find out when the next most suitable date is for this course – 0333 344 6630