Course:

Short Course - SQL 1: Queries

Category:

Computer Science and Digital

Duration:

6 WEEKS, 6-8pm

Start Date:

13th Sep 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

Short Course - SQL 3: Programmable Objects Fashion - Pattern Cutting Digital Art (Wacom), Introduction to Short Course - SQL 4: Query Optimisation Short Course - Photography & Imaging Evening Stage 1 Beginners Unreal Engine 4, Introduction to Sewing Machine Skills Life Drawing Short Course - SQL 2: Database Definition Language Short Course - SQL 5: Advanced Queries

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

Course will run one evening per week, day differs depending on when course is started.

 

 

 

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