Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 1

Section A: Introduction - Section B: SQL Server Edition & Graphic Tools - Section C: Enterprise Manager - Section D: Installing SQL Server - Section E: Configuring SQL Server - Section F: Relational Database Design - Section G: Understanding Relationships

Session 2

Section A: Creating a Database - Section B: Creating Tables & Selecting Data Types - Section C: Refining Table Definitions - Section D: Retrieving Data with Select Queries

Session 3

Section A: Sorting & Grouping Data - Section B: Joining Tables - Section C: Inserting Data - Section D: Using & Deleting Data

Session 4

Section A: Introduction - Section B: Using the Query Analyzer - Section C: Programming with Transact-SQL - Section D: More Built-in T-SQL Functions

Session 5

Section A: Flow Control & Error Handling - Section B: Transaction Processing - Section C: What is a View?

Session 6

Section A: Creating Views - Section B: Creating Backup Strategy - Section C: Database Maintenance Plan - Section D: Stored Procedures

Session 7

Section A: Advanced Stored Procedures - Section B: Using the T-SQL Debugger - Section C: Building Triggers - Section D: User-Defined Functions

Session 8

Section A: Advanced Queries - Section B: T-SQL Cursors - Section C: Handling Large Data Sets - Section D: Distributed Queries - Section E: Authentication - Section F: Understanding Roles - Section G: Assigning Permission

Session 9

Section A: Application Roles - Section B: Evaluating Performance - Section C: SQL Server Profiler - Section D: Tuning Queries - Section E: Indexes - Section F: Indexed Views - Section G: Index Tuning Wizard - Section H: Data Caching - Section I: : The System Monitor

Session 10

Section A: Exploring System Objects - Section B: Information Schema Views - Section C: System Store Procedures - Section D: Extended Stored Procedures - Section E: SQL Agent - Section F: Data Transformation Services - Section G: DTS Packages

Session 11

Section A: Creating a DTS Package - Section B: Introduction to Replication - Section C: Implementing Replication - Section D: Publishing to the Web - Section E: Introduction to XML

Session 12

Section A: XML Document Structure & Definition - Section B: SQL Queries with FOR XML - Section C: Using FOR XML EXPLICIT - Section D: Accessing SQL Server Over HTTP - Section E: Creating URL Queries - Section F: Using Annotated Queries & Schema

Session 13

Section A: Using Open XML & Updategrams - Section B: Full Text Search - Section C: Full Text Queries - Section D: Full Text Search with Documents

Session 14

Section A: Building an OLAP Cube - Section B: Query an OLAP Cube - Section C: Data Mining - Section D: Building English Query Models - Section E: Deploying an English Query Application

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 1

Section A: Introduction - Section B: SQL Server Edition & Graphic Tools - Section C: Enterprise Manager - Section D: Installing SQL Server - Section E: Configuring SQL Server - Section F: Relational Database Design - Section G: Understanding Relationships

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 2

Section A: Creating a Database - Section B: Creating Tables & Selecting Data Types - Section C: Refining Table Definitions - Section D: Retrieving Data with Select Queries

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 3

Section A: Sorting & Grouping Data - Section B: Joining Tables - Section C: Inserting Data - Section D: Using & Deleting Data

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 4

Section A: Introduction - Section B: Using the Query Analyzer - Section C: Programming with Transact-SQL - Section D: More Built-in T-SQL Functions

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 5

Section A: Flow Control & Error Handling - Section B: Transaction Processing - Section C: What is a View?

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 6

Section A: Creating Views - Section B: Creating Backup Strategy - Section C: Database Maintenance Plan - Section D: Stored Procedures

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 7

Section A: Advanced Stored Procedures - Section B: Using the T-SQL Debugger - Section C: Building Triggers - Section D: User-Defined Functions

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 8

Section A: Advanced Queries - Section B: T-SQL Cursors - Section C: Handling Large Data Sets - Section D: Distributed Queries - Section E: Authentication - Section F: Understanding Roles - Section G: Assigning Permission

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 9

Section A: Application Roles - Section B: Evaluating Performance - Section C: SQL Server Profiler - Section D: Tuning Queries - Section E: Indexes - Section F: Indexed Views - Section G: Index Tuning Wizard - Section H: Data Caching - Section I: : The System Monitor

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 10

Section A: Exploring System Objects - Section B: Information Schema Views - Section C: System Store Procedures - Section D: Extended Stored Procedures - Section E: SQL Agent - Section F: Data Transformation Services - Section G: DTS Packages

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 11

Section A: Creating a DTS Package - Section B: Introduction to Replication - Section C: Implementing Replication - Section D: Publishing to the Web - Section E: Introduction to XML

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 12

Section A: XML Document Structure & Definition - Section B: SQL Queries with FOR XML - Section C: Using FOR XML EXPLICIT - Section D: Accessing SQL Server Over HTTP - Section E: Creating URL Queries - Section F: Using Annotated Queries & Schema

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 13

Section A: Using Open XML & Updategrams - Section B: Full Text Search - Section C: Full Text Queries - Section D: Full Text Search with Documents

Benefits

• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.

Also available for purchase as individual sessions

Club Training Australia understand that you may already have experience with this product and are looking to expand your knowledge. With this in mind Club Training Australia is proud to offer each of the sessions in this course for sale on a session-by-session basis.Simply select the session that contains the information you wish to learn and select the corresponding number from the drop down list on this page and then click on add to cart.

Sessions

14 Sessions
42 Hours of Interactive Training

Session content

Session 14

Section A: Building an OLAP Cube - Section B: Query an OLAP Cube - Section C: Data Mining - Section D: Building English Query Models - Section E: Deploying an English Query Application