Disqover - Improving Software Quality

“…a comprehensive and entertaining training course.”

Kristian Frost

Team Leader Development QA, Department of Human Services

Introduction to SQL

Public Course Cost: $900AUD exc GST

This course trains the participants in using the Structured Query Language (SQL) to retrieve data from a relational database and to make changes to that same data.

This course focuses on data access and manipulation. While the SQL statements to manage the database schema/structure are mentioned, they are not covered in detail.

Intended For

Anyone who needs to be able to access relational data with SQL.

Learning Outcomes

By the end of this course, participants will be able to create SQL SELECT statements that retrieve any required data and create SQL INSERT, UPDATE and DELETE statements to make changes to that same data.

Content

Relational Databases
An overview of relational database schemas: tables; fields; indices; primary and foreign keys; relationships.

Reading Data
The SQL SELECT statement: reading rows; duplicate values; filtering rows; ordering rows.

Modifying and summarising the data: expressions; aggregate functions; field aliases; grouping values; filtering rows and groups.

Retrieving data from multiple tables: joins; table aliases.

Simplifying queries with nesting: nesting with from; nesting with in; nesting with operators; unions; views.

Adding Data
Inserting new data rows: adding a single record; adding a new table; nested queries.

Changing Data
Modifying existing data: updating all records; updating selected records; updating multiple fields.

Deleting Records
Removing data rows: deleting all records; deleting selected records.

Parameters
Using values picked up at runtime rather than ‘hard-coded’: queries; modifying data.

Database Management
Managing the database schema/structure: managing tables; indices.

Method Used

This is a hands-on course, with participants applying what they learn to access a non-trivial SQL Server or Oracle database. Every participant will have dedicated use of a workstation for the database exercises.

Testimonials

“The best computer course I’ve ever attended”
Jeremy Morris – Jarrett, Introduction to SQL, PNZ

“Excellent course, includes everything required for testing”
Asif Syed, Introduction to SQL, MoE

“This course gives exactly the right amount of knowledge needed to go back to work and start using SQL
Bec Coleman, Introduction to SQL, Close The Loop

“The course content is of high quality and applies to all levels of testing… the trainer was knowledgeable and insightful.

Documentation is well presented and will be useful for future reference.”

Brian Cunningham

Systems Assurance Manager, ANZ Bank

decoration

Home

Why Disqover

Our Courses

Resources

Contact

© 2011 Disqover - Improving Software Quality

section divider

Suite 2, 210 Whitehorse Road
Balwyn 3103, Victoria, Australia
Ph: +61 3 9836 2901
Fax: +61 3 9836 5526

icon decoration Disqover - Improving Software Quality