Plus Plus Pty Ltd

Introduction to SQL - 1 day

Objectives

This course covers a basic understanding of database design, and how to use SQL to select and update data.

Expected outcomes

Upon successful completion of this course you will be able to:

Describe a relational database
Describe database normalisation
Describe what SQL is and what it's for
Use SQL commands to:

Display data
Choose particular data to display
Create sophisticated queries to join tables, and group and total data
Update data
Import data into an export data from a database
Optimise performance of an SQL database
Create, modify and delete a database and table

Audience

This course is aimed at people who want to learn the basics of database design and SQL.
Experience with SQL or programming is not necessary. (The information in this course is very useful to programmers of database systems)

Prerequisites

Basic computer ability with a keyboard and mouse is needed.

Outline

Database design

Storing data
The Relational Database model
Database normalisation
Methods of accessing data
DDL and DML
SQL and what it's for

Selecting data

Display data from a table
Choose particular data to display (field (column) names)
Selecting specific records with conditions
Sorting

Updating data

Inserting data
Updating existing data
Deleting data

Sophisticated selections

Limiting a resultset size
Using domain aggregate functions
Create sophisticated queries to group and total data
Joining multiple tables
Left joins and Right joins, Inner and Outer joins, Cartesian product
Subqueries
Unions
Optimisation

Working with database structure

How to create a new database
How to create a table
How to modify a table's structure
Import and exporting data
Deleting a table
Deleting a database

Also available

Introduction to Programming (1 day)
Introduction to Perl (2 days)
Introduction to Python (2 days)

[ home ] [ training ] [ consulting ] [ development ] [ contact ]