[Plus Plus Pty Ltd]

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:

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

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 ]

Copyright © 1998-2016 Plus Plus Pty Ltd [www.plusplus.com.au]