SQL Introduction

Document Sample
SQL Introduction Powered By Docstoc
					                                         SQL Introduction

  SQL Introduction
       1 day

Course Objectives                                   Getting Started
                                                    • Relational Database Concepts
To give delegates an introduction to the features   • The role of SQL
and capabilities of Structured Query Language
(SQL). The course covers elements of ANSI           Writing Basic SQL Statements
SQL using SQL Server or Oracle as an example        • Selecting data
database.                                           • SELECT statement syntax

Prerequisites                                       Restricting and Sorting Data
                                                    • Limiting the rows returned by a query
It is recommended that students have good           • The WHERE Clause
experience of windows and some of using             • Sorting the rows
relational databases.
                                                    Single Row Functions
Exercises
                                                    • The types of functions available in SQL
                                                    • Using Character, Number and Date
This course is instructor led, involving the
                                                       functions in SELECT statements
utilisation of examples and exercises in a
workshop environment.                               • Conversion functions and their uses
                                                    • Column aliases
                                                    • Performing calculations

                                                    Getting data from multiple tables
                                                    • Joining multiple tables in a SELECT
                                                       statement
                                                    • Different join types
                                                    • Using INNER Join and WHERE to create
                                                       Joins

                                                    Grouping Data
                                                    • Aggregate functions
                                                    • COUNT Vs Count(*)
                                                    • HAVING Clause
                                                    • GROUP BY




         The Surrey Technology Centre • 40 Occam Road • Guildford • Surrey GU2 7YG
                            Tel: 01483 688488 Fax: 01483 573704
               E-mail: info@acuitytraining.co.uk Web: www.acuitytraining.co.uk