Advanced Search

Home | Help | Contact Us

	Shopping Cart
	0 courses

Customer Login | Register

Training Provider Login

Home > Search Results > Course Details

Microsoft Training

Refine By Category

Active Directory Training (36)

Azure Platform (4)

Biztalk Training (16)

Commerce Server (13)

Desktop Optimisation (12)

LCS Live Comms Server (4)

Microsoft Configuration Manager (17)

Microsoft Dynamics CRM Training (47)

Microsoft Exchange Server 2003 training (38)

Microsoft Exchange Server 2007 training (188)

Microsoft Exchange Server 2010 Training (85)

Microsoft Forefront (13)

Microsoft Office Communications Server OCS (4)

Microsoft Online Services (4)

Microsoft Operations Manager MOM (9)

Microsoft Security (26)

Microsoft Training (59)

MS Softgrid Application Virtualisation (9)

Performance Point Server (5)

Project Server (5)

SBS Training (25)

SharePoint Training (78)

Silverlight (58)

SMS Systems Management Server (4)

Solutions Framework MSF (23)

SQL Training (1493)

Systems Center (16)

Team Foundation Training (3)

Virtual Environments (9)

Visual Studio Training (1364)

Windows 2000 Training (8)

Windows 7 Training (47)

Windows Embedded (8)

Windows Essential business Server 2008 (8)

Windows Media (9)

Windows Power Shell (8)

Windows Presentation Foundation (33)

Windows Server 2003 Training (77)

Windows Server 2008 training (748)

Windows Vista training (50)

Windows Workflow Foundation Training (8)

Windows XP training (17)

Refine By Location

ACT (747)

NSW (2840)

QLD (331)

VIC (770)

Brisbane QLD 4000 (318)

Canberra ACT 2600 (747)

Cleveland QLD 4163 (13)

Melbourne VIC 3000 (770)

Parramatta NSW 2150 (440)

Parramatta Westfield NSW 2150 (30)

Sydney NSW 2000 (2370)

Refine By Provider

Advanced Training (109)

CEO Training Pty Ltd (1187)

CTS Training Pty Ltd (6)

Intelligent Decisioning Pty Ltd (13)

IT Futures (2)

MIS Global Technologies (30)

New Horizons (312)

New Horizons Learning Centres (659)

New Horizons Learning Centres NSW (2370)

Refine By Course Type

Classroom (4679)

Correspondence (9)

SQL Training available in Sydney Melbourne Brisbane Perth Canberra. SQL Training, Implementing a Microsoft SQL Server 2008 Database, Maintaining a Microsoft SQL Server 2008 Database, Writing Queries Using Microsoft SQL Server 2008 Transact –SQL, Tuning and Optimizing Queries Using Microsoft SQL Server 2005 Training courses will ensure you attain all the necessary skills and qualifications to implement a Microsoft SQL Server database. Courses focus on teaching individuals how to use SQL Server product features and tools related to implementing a database.

Book your course to become skilled and qualified in SQL today! Check below for a range of courses or call 1300 728 102 and we can find the right SQL course for you.

Book your place on this SQL Training course with CTS Training Pty Ltd through startnextweek.com.au now and get instant confirmation!

SQL - Advanced

Book your place now

Course Details

Course Id: 339918

Delivery Method: Classroom Course
Dates:	Times: 9:00 AM - 4:30 PM

Duration:	2 Days - 1 Week Apart


Location:	CTS Training, Level 8, 40 Creek Street, Brisbane, QLD 4000 View map


Places:	0



Price:	$ 1100 (Price includes GST)



Email a friend

About This Training Course

This 2 day SQL - Advanced Training Course will suit Database Administrators, Application Developers and other users who require access to their database in an efficient manner.

Subjects Covered

This SQL - Advanced Training Course covers the following:

LEARNING OUTCOMES

• Be able to write complex SQL Queries
• Understand Performance implications when writing SQL
• Be able to interrupt QEPs and generate better SQL
• Gain a thorough understanding of the syntax and semantics of SQL statements
• Be able to use the Open Ingres interactive terminal monitor

PREDICATES
• Comparison
• Like Predicates
• Between Predicates
• In Predicates
• Any All or Some Predicates
• Using Sub queries effectively
• Sub query Rules
• Correlated Sub queries
• EXISTS Predicate
• Scalar Functions

JOINS
• Why Join Tables
• Unions
• Types of Joins
• Formulation of Join
• Outer Joins
• Caveats
• Self Joins
• Limitations of Joins

SUMMARISING DATA
• Aggregate Functions
• Aggregate Queries
• Aggregate Quotes
• Set Functions
• Grouping

MANAGING DATA SEQUENTIALLY
• Cursors
• Cursor Solution
• Select Cursor

MANAGING TABLES
• Creating Tables
• Changing Tables
• Deleting Tables
• Ownership

QUERY OPTIMISATION
• Indexes
• Statistics
• Query Flattening
• Disjunctive Normal Form
• Function Queries

Training Course Outcomes

Teaches users how to write SQL effectively, taking into account performance considerations.

LEARNING OUTCOMES

• Be able to write complex SQL Queries
• Understand Performance implications when writing SQL
• Be able to interrupt QEPs and generate better SQL
• Gain a thorough understanding of the syntax and semantics of SQL statements
• Be able to use the Open Ingres interactive terminal monitor

PREDICATES
• Comparison
• Like Predicates
• Between Predicates
• In Predicates
• Any All or Some Predicates
• Using Sub queries effectively
• Sub query Rules
• Correlated Sub queries
• EXISTS Predicate
• Scalar Functions

JOINS
• Why Join Tables
• Unions
• Types of Joins
• Formulation of Join
• Outer Joins
• Caveats
• Self Joins
• Limitations of Joins

SUMMARISING DATA
• Aggregate Functions
• Aggregate Queries
• Aggregate Quotes
• Set Functions
• Grouping

MANAGING DATA SEQUENTIALLY
• Cursors
• Cursor Solution
• Select Cursor

MANAGING TABLES
• Creating Tables
• Changing Tables
• Deleting Tables
• Ownership

QUERY OPTIMISATION
• Indexes
• Statistics
• Query Flattening
• Disjunctive Normal Form
• Function Queries

Prerequisites

To successfully understand the content and complete activities students must have proficient knowledge of Windows and a basic understanding of SQL is recommended.

If you need more information contact Startnextweek.com.au on 1300 728 102

To find out more about this course complete your details below and select Submit

Subject:*

First name*

Surname*

I am a:

Company:

Email Address*

Phone:*

Mobile:

* These fields are required

Microsoft Training

Refine By Category

Refine By Location

Refine By Provider

Refine By Course Type

SQL - Advanced

About This Training Course

Subjects Covered

Training Course Outcomes

Prerequisites

To find out more about this course complete your details below and select Submit

Sydney

Melbourne

Brisbane

Perth

Adelaide

Canberra

Hobart

Darwin

Customer Information

Contact Us

Terms and Conditions

Privacy Policy

Advertise With Us

Site Map