Add to basket

Course:

Short Course - SQL 5: Advanced Queries

Category:

Computer Science and Digital

Duration:

6 weeks, 6-8pm

Start Date:

22nd May 2018

Location:

Learning Exchange

Tuition Fee:

£150.00

Exam Fee:

£0.00

Total Fees:

£150.00

Course Day:

Wednesday

Hours/week:

2

Weeks/yr:

6

Student Ratings

There are currently no reviews for this course, be the first!

Related Courses

Short Course - SQL 1: Queries Fashion - Pattern Cutting Short Course - Photography & Imaging Evening Stage 2 Intermediate Short Course - SQL 2: Database Definition Language Junior Coding with Minecraft Fashion - Pattern Cutting Intermediate Art & Design - Pottery Short Course - SQL 3: Programmable Objects Junior Character Animation Fashion - Millinery

Short Course - SQL

5: Advanced Queries

Description

This short course covers advanced querying techniques using Microsoft T-SQL 2012. 

  • PIVOT / UNPIVOT

  • Analytic functions: LEAD, TAG etc.

  • Grouping Sets ,ROLLUP and CUBE

  • Filtering with the TOP and OFFSET-FETCH

  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Using Temporary Tables

  • Table Variables and Table Types

  • Dynamic SQL

  • How to Query and Manage XML data

 This course also constitutes part 5 of 5 of the preparation for the Microsoft Certification - Querying Microsoft SQL Server 2012 (Exam 70-461).

...More

Course Images

Course Location

Student Reviews

Add Review

There are currently no reviews for this course, be the first!

Add a Review

Rating:

Add Review

Courses Selected

Course Bundle Lookup

Course bundles are designed for 16 - 18 year olds only.

Career Coach is designed to help you find a good career by providing the most current local data on wages, employment, job postings, and associated education and training.