Course Details close

Course Details

Price:
(inc GST)
$ 495
Application:SQL
Level:Essentials - Data Management
Version:All-Versions
Duration:1 day
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

SQL Essentials - Data Management Course

   (4.73 out of 5)
279 Sql essentials - data management student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 1 day Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 495
Sale Price:
(inc GST)
$

Quick links

SQL Essentials - Data Management Course

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

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Course Dates

Course Date Price Add Course Qty Status
17-Jul-19 (Wed)$495.00 0
16-Aug-19 (Fri)$495.00 0
20-Sep-19 (Fri)$495.00 0
25-Oct-19 (Fri)$495.00 0
08-Nov-19 (Fri)$495.00 0
13-Dec-19 (Fri)$495.00 0
Computer Training Courses

Course Outline

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

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us