Plus Plus Pty Ltd

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, and export data from, a database
Create, modify and delete a table and a database.

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. (Although the information in this course is very useful to programmers of database systems)

Prerequisites

None.

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
Views.

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 Python (2 days)

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