SQL ESSENTIALS - DATA MANAGEMENT

Course Overview

This training course builds on the SQL Essentials training course and focuses on using the SQL language to manage backend data using SQL server. This training course was developed for students wanting to learn how to manipulate data such as Insert, update, and delete records from a relational database, create views and stored procedures and learn how to traverse data with various cursors using SQL.

Course Prerequisites

SQL Essentials Course or equivalent

Raising the Bar

1300 937 782

www.rtb.com.au

Inserting Data

Understanding Data Insertions
Inserting Complete Rows
Inserting Partial Rows
Copying From One Table To Another

Updating and Deleting Data

Updating Data
Deleting Data
Guidelines For Updating And Deleting Data

Creating and Manipulating Tables

Creating Basic Tables
Working With Null Values
Specifying Default Values
Updating Tables
Deleting Tables
Renaming Tables
Renaming Tables

Using Views

Understanding Views
Why Use Views
View Rules and Restrictions
Creating Views
Using Views to Simplify Complex Joins
Using Views to Filter Unwanted Data
Using Views with Calculated Fields
Using Views to Reformat Retrieved Data

Working with Stored Procedures

Understanding Stored Procedures
Why Use Stored Procedures
Executing Stored Procedures
Creating Stored Procedures
Using Rollback
Using Commit
Using Savepoints

Using Transaction Processing

Understanding Transaction Processing
Controlling Transactions

Using Cursors

Understanding Cursors
Working With Cursors
Creating Cursors
Using Cursors
Closing Cursors

Understanding Advanced SQL Features

Understanding Constraints
Primary Keys
Foreign Keys
Unique Constraints
Check Constraints
Understanding Indexes
Understanding Triggers
Database Security