SQL

Topics: 4

Length: 11 hours

Location: Online

This course is designed to give you a rounded understanding of Structure Query Language. The basic tasks of creating a new table as well as managing and deleting it. It also includes details of database objects, views, storage groups, indexes, and databases. It also includes an introduction to query techniques.

Topic 1: Database Maintenance

How to use SQL to create and maintain tables in a database. You will gain a basic understanding of terms relating to database design as well as SQL statements used to format tables and data.

Topic 2: Database Objects

Here you will learn what database objects are and how to create change and delete them. You will also learn how to use the SQL System Catalogue.

Topic 3: Query Techniques

You will gain an understanding of the basic query techniques available.

Topic 4: Joining Tables

This topic will show you how tables can be joined in SQL.