Powerful Queries With Sequel (SQL)

Need to exract useful, accurate data from your database? Spending too much time on cleaning up the results? Is your database controlling you? Don`t know where to find the data you need? Then this coursewill show you how to make your database work for you. The techniques taught can be applied to any database using the SQL language-including MS Access, SQL Server, Oracle, MySQL and many others.

Duration: One day 

Target Audience: Anyone needing to extract data fom their database system (payroll,stores,customer records, CD/DVD collection lists etc.

Objectives: By the end of the course you will be able to:

  • know what data you have and why it`s the way it is
  • extract specific data from one or more tables
  • group and aggregate data
  • create and manipulate sub-queries
  • maintain your database

Content

  • what is an RDBMS (Tables, Records, Fields, Keys, Relationships and Schemas
  • the SELECT statement
  • sorting and grouping
  • joins, self-joins and aliases
  • counting, totalling and aggregate functions
  • handling dates
  • strings and data conversion functions
  • UPDATE, INSERT and DELETE statements
  • data definition statements 

Date:      2 March 2006

Time:     10.00am to 5.00 pm

Venue:   Aros, Portree

Pre-requisites: Must know the basics of Excel and have used MS Access.

Pre-course activity:   None

Cost: £50