Loading

Join millions using the Alison App – faster, easier, and made for learning on the move... 📲 Learn On The Go With
The Alison App

Course CategoriesExplore CoursesView All Free Courses

Information Technology (IT)

(1,311 Courses)

Health

(1,129 Courses)

Language

Business

(1,803 Courses)

Management

(1,119 Courses)

Personal Development

(1,374 Courses)

Sales & Marketing

Engineering & Construction

Teaching & Academics

(1,684 Courses)

Learn About CareersView All Categories

Health Science

Finance

Information Technology

Education and Training

Business Management and Administration

Marketing, Sales, and Service

Agriculture, Food, and Natural Resources

Hospitality and Tourism

Science, Technology, Engineering, and Mathematics

Architecture and Construction

Government and Public Administration

Law, Public Safety, Corrections, and Security

Manufacturing

Transportation, Distribution, and Logistics

Human Services

Arts, Audio/Video Technology, and Communications

Aptitude Tests & PsychometricsAptitude Tests & Psychometrics

English Proficiency Test

Demonstrate your English language skills

Aptitude Test

Assess your skills and abilities

Workplace Personality Assessment

Discover your strengths & weaknesses

Mental Health Assessment

Assess your mental wellbeing

More Alison ProductsMore Alison Products

Learning Management System

Upskill & empower your team for free

Webinars

Register for upcoming webinars

Resumé Builder

Create your professional resumé

Career Ready Plan

Plan to achieve your career goals

Download Courses

Learn Offline on the Alison App

Get Alison Premium

Alison Graduate Profiles

Read graduate success stories

Gift Cards

Purchase a certificate for others

Blogs

News, insights, tips and stories from Alison

Goals

Earn a Certificate

Explore Courses Find Jobs & Careers Aptitude Tests & Psychometrics More Alison Products

Top Free Courses

Most Popular Searches

Information Systems
Human Resources
Business Management

Your Recent Searches

en

LMS

Are you a business or organisation seeking to train and upskill your employees?

If yes, check out Alison’s Free LMS here!

Become an Alison Affiliate in one click, and start earning money by sharing any page on the Alison website.

Become an Affiliate

en

English
Spanish

Get the Alison App 📲

Scan this QR code to download the app now and learn anywhere, anytime.

Tap below to get the app now and learn anywhere, anytime.

Alison on Android QR Code

Alison on iPhone QR Code

Select Site Language
English
Spanish

Lab instructions and SQL code files

home

Course

Diploma in databases and t sql revised

Resource

Description

These files are to help you work through the Labs for this course

Back to Modules Back to Resources

Download links

Labs Read me doc
Lab 1 – Introduction to Transact-SQL Instructions
Lab 1 – Introduction to Transact-SQL code files
Lab 2 – Querying Tables with SELECT Instructions
Lab 2 – Querying Tables with SELECT code files
Lab 3 – Querying Multiple Tables with Joins Instructions
Lab 3 – Querying Multiple Tables with Joins code files
Lab 4 – Using Set Operators Instructions
Lab 4 – Using Set Operators code files
Lab 5 – Using Functions and Aggregating Data Instructions
Lab 5 – Using Functions and Aggregating Data Code Files
Lab 6 – Using Subqueries and APPLY Instructions
Lab 6 – Using Subqueries and APPLY Code files
Lab 7 – Using Table Expressions Instructions
Lab 7 – Using Table Expressions Code files
Lab 8 – Grouping Sets and Pivoting Data Instructions
Lab 8 – Grouping Sets and Pivoting Data Code files
Lab 9 – Modifying Data Instructions
Lab 9 – Modifying Data Code Files
Lab 10 – Programming with Transact-SQL Instructions
Lab 10 – Programming with Transact-SQL Code Files
Lab 11 – Error Handling and Transactions Instructions
Lab 11 – Error Handling and Transactions Code Files

Empower Yourself For Free

Join our community of 50 million+ learners, upskill with CPD UK accredited courses, explore career development tools and psychometrics - all for free.

Having trouble Logging In? Get in touch

Sign Up

Log In

or

Keep me logged in

Forgot Password?

Don't have an account? Sign Up

Log in to Alison Publishing

Select Language

English

Select Site Language
English
Spanish

or

Already have an account? Log In

By signing up, I accept Alison's Terms & Conditions

Forgot Password?

Forgot Password? No worries, we will send reset instructions to your email address.

Reset password form here

CERTIFIED
COURSES

Business
Engineering & Construction
English
Health
Information Technology (IT)
Language
Management
Personal Development
Sales & Marketing
Teaching & Academics

ABOUT
ALISON

Our Story
Board of Directors
Our Team & Culture
Our Unique HQ
Open Positions
Our Course Creators
Learning on Alison
Blog
Press Room
Alison in Africa
Alison Programmes

QUALITY
LEARNING

Accreditation
All Certificates
All Diplomas
All Free Courses
Alison Testimonials
Graduate Profiles
Hubs
Premium Learning
Purchase a Gift Card

CAREER
RESOURCES

Build Your Resumé
Explore Job Vacancies
Alison Career Guide
Career Ready Plan
Psychometric Tests
Aptitude Test
Well-being Test (Welliba)
Work Place Personality Test
English Proficiency Test

DISCOVER
MORE

Access Free LMS
Affiliate Programme
Alison Profile
Create Courses on Alison
Download App & Learn Offline
Integrate Alison’s API
Learn With Gamification
Refer a Friend
TechEquity Partnership
UK Immigration Requirements
Upcoming Webinars

FAQs
Customer Support

© Alison 2026
Privacy
Terms
Cookie Policy
Sitemap

Enter your friend's email address