Course:

Short Course - SQL 5: Advanced Queries

Category:

Computer Science and Digital

Duration:

6 weeks, 6-8pm

Start Date:

21st May 2019

Location:

Learning Exchange

Tuition Fee:

£150.00

Exam Fee:

£0.00

Total Fees:

£150.00

Course Day:

Tuesday
Wednesday

Hours/week:

2

Weeks/yr:

6

Student Ratings

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

Related Courses

Fashion - Garment Construction : An Introduction Short Course - Photography & Imaging Evening Stage 2 Intermediate Sewing Machine Skills Short Course - SQL 3: Programmable Objects Life Drawing Short Course - Photography & Imaging Evening Stage 1 Beginners Art & Design - Pottery Unreal Engine 4, Introduction to Illustrator for Fashion Design Short Course - SQL 1: Queries

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.