Plus Plus Pty Ltd
SQL - 1 day
This course covers a basic understanding of database design, and how to use SQL to select and update data.
Upon successful completion of this course you will be able to:
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)
The Relational Database model
Methods of accessing data
DDL and DML
SQL and what it's for.
Display data from a table
Choose particular data to display (field (column) names)
Selecting specific records with conditions
Updating existing data
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
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.
Copyright © 1998-2022 Plus Plus Pty Ltd [www.plusplus.com.au]