Course Details close

Course Details

Price:
(inc GST)
$ 495
Sale Price:
(inc GST)
* Selected Courses ONLY
$ 450*
Application:SQL
Level:Essentials - Data Management
Version:All-Versions
Duration:1 day
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
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.77 out of 5)
342 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)
$ 450

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

With each course we provide you with a comprehensive course manual for you to practice post course.

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.

View Course Dates

Face to Face (public course dates)

Online via Webinar (via Microsoft Teams)

Public Course Dates

Course Date Price Add Course Qty Status
20-Jan-25 (Mon)$495.00 0
18-Feb-25 (Tue)$495.00 0
21-Mar-25 (Fri)$495.00 0
24-Apr-25 (Thu)$495.00 0
09-May-25 (Fri)$495.00 0
27-Jun-25 (Fri)$495.00 0

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
20-Jan-25 (Mon)$450.00 0
ON SALE
18-Feb-25 (Tue)$495.00 0
21-Mar-25 (Fri)$495.00 0
24-Apr-25 (Thu)$495.00 0
09-May-25 (Fri)$495.00 0
27-Jun-25 (Fri)$495.00 0

Courses start
from $450 (inc GST).
Limited seats.
Book today!

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

Student Comments

  • SQL Essentials - Data Management training course
    Great course and definitely recommended to others to assist with daily activities with SQL.
    - Tarik
  • SQL Essentials - Data Management training course
    Course is simply great to have full view across SQL and useful in the work area
    - Vishaa
  • SQL Essentials - Data Management training course
    Craig is an excellent trainer. He is very knowledgeable and helpful.
    - Carmel
  • SQL Essentials - Data Management training course
    Craig explained everything very well and in simple terms. Was really easy to follow through.
    - Nima
  • SQL Essentials - Data Management training course
    Very well presented course.
    - Elisa
  • SQL Essentials - Data Management training course
    Great and clear presentation of all the ideas.
    - Ronald
  • SQL Essentials - Data Management training course
    Very Good
    - Michael
  • SQL Essentials - Data Management training course
    Tom did a great job. I have learnt a lot from this course. Thank you
    - Joanna
  • SQL Essentials - Data Management training course
    Thanks Craig awesome
    - Fay
  • SQL Essentials - Data Management training course
    Creating views and manipulating data were both really interesting.
    - Joanna
  • SQL Essentials - Data Management training course
    Great extra content
    - Karen
  • SQL Essentials - Data Management training course
    Craig was very knowledgeable. His explanations were easy to understand.
    - Petro
  • SQL Essentials - Data Management training course
    Perfectly concise course and all explanations were well-rounded
    - Jonathan
  • SQL Essentials - Data Management training course
    Thanks very much
    - Tim
  • SQL Essentials - Data Management training course
    All parts of the course was useful as I have seen all the knowledge gained can be applied in the workplace.
    - Benjamin
  • SQL Essentials - Data Management training course
    Course information was well presented and provided great knowledge to make use of in future endeavors using SQL
    - Brady
  • SQL Essentials - Data Management training course
    Great course
    - Belinda
  • SQL Essentials - Data Management training course
    I found it very useful!
    - Victoria
  • SQL Essentials - Data Management training course
    Good content and well presented
    - Ondrea
  • SQL Essentials - Data Management training course
    Functions such as Cursor and Transactions, that was awesome and all new to me!
    - Christie
  • SQL Essentials - Data Management training course
    The pace was just perfect
    - Cate
  • SQL Essentials - Data Management training course
    Craig's been great. Cheers
    - Sandeep
  • SQL Essentials - Data Management training course
    Great broad knowledge of the presenter and well organised. Clear and concise in presenting. Hands on application
    - Dianne

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us