Add to basket

Course:

Short Course - SQL 1: Queries

Category:

Computer Science and Digital

Duration:

6 WEEKS, 6-8pm

Start Date:

11th Apr 2018

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

Junior Coding with Minecraft Short Course - SQL 2: Database Definition Language Fashion - Garment Construction : An Introduction Short Course - Photography & Imaging Evening Stage 1 Beginners Junior Games Design - Unreal Engine 4 Fashion - Bra Making Short Course - SQL 5: Advanced Queries Short Course - SQL 3: Programmable Objects Fashion - Pattern Cutting Intermediate Short Course - SQL 4: Query Optimisation

Short Course - SQL

1: Queries

Description

This short course covers basic database queries using Microsoft T-SQL 2012.

  • Introduction to Databases
  • Introduction to MS SQL Management Studio tool
  • The SELECT statement
  • Filtering and Sorting Data
  • Data Conversion and Formatting Functions
  • Using Group Functions
  • Joins
  • Sub-queries
  • Ranking Functions
  • SET Operators
  • Derived Tables

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

This course is offered throughout the year on the following dates:

Tuesday, 31st October 2017

Wednesday, 13th December 2017

Wednesday, 11th April 2018

 

 

 

...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.