Understanding SQL Tools

New Horizons Learning Centres of Australia
Sydney, Brisbane, Melbourne, Perth, Newcastle, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This SQL course has been structured to provide an introduction to SQL and the concepts used in working with SQL databases. Through this course you will get a good grounding in all the skills needed to understand basic SQL, and enable you to start using the language in your work environment.
Learning Outcomes:
The aim of this course is for each student to be able to:
Design a Relational Database
Create and work with the appropriate Tables
Write essential SQL statements
Use essential Functions
Join Tables
Use simple Subqueries
Who should attend:
Those attending this course are expected to be familiar with the mouse and keyboard, starting Windows 95 and applications and be comfortable with using Windows 95 features such as maximise, minimise, scroll bars, editing etc.
An understanding of general programming concepts would be useful before attending this course.
Outline:
Introduction to the SQL Course
- The Course Structure
- The SQL Trainer Application
Introduction to Relational Databases
- The Relational Model
- A Table
- Designing a Database
- Determining the Purpose of the Database
- Defining the Data Items for a Database
- Deciding on the Tables Needed in Your Database
- Normalisation
- Types of Tables
- Creating Table Links
- Primary Keys
- Foreign Keys
- The Carpool Database
Introduction to SQL & the Select Statement
- Structured Query Language (SQL)
- History of SQL
- Implementing SQL Statements
- The Select Statement
- The Where Clause
- Testing for Equality
- Testing for Inequality
- Logical Operators
- The Between Operator
- The Null Keyword
- The in Operator
- Sorting the Result Table
- The Like Operator
Calculating Values Grouping Aggregate Functions
- Aggregate Functions
- The Count Function
- The Distinct Keyword
- Using Distinct and Count
- The Sum Function
- Using Calculation in Summary Functions
- Grouping Records
- The Having Clause
Multi Table Queries
- Joining Two Tables
- Table Aliases
- The Cartesian Product
- Joining More Than Two Tables
- Outer Joins
Subqueries
- Single Row Subqueries ...''

Phone:+61 2 8263 5900

School Address:

Level 6, St. Martins Tower
31 Market Street
Sydney NSW 2000 Australia
Level 4, 200 Creek Street,
Brisbane, QLD 4000
Level 2, 31 Queen Street,
Melbourne, VIC 3000

Jobs & Resumes: Sydney, Brisbane, Melbourne, Perth, Newcastle
Houses & Roommates: Sydney, Brisbane, Melbourne, Perth, Newcastle

Citrix MetaFrame XP Presentation Server Feature Release 3 Administration
Citrix Presentation Server 4.0: Administration
A+ Certification - Core Hardware (2003 Objectives)
A+ Certification - Operating Systems
Network+ Certification
Security+
Certified Ethical Hacker
Crystal Reports 10
IT Project+
Programming in the Unix Shell
Unix Introduction
CIW-Java Programming Series
JavaScript Fundamentals
Linux Fundamentals
Linux+ Certification
IBM Lotus Domino Designer 6
Exchanging and Transforming Data Using XML and XSLT
Introduction to C# Programming for the Microsoft .NET Platform
Developing Secure Web Applications

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.