Accessibility toolbar toggle - click here for accessibility features
Language toolbar toggle - click here for additional languages
College news - click here for the college
Life at the college Apply Student benefits

SQL 3: Programmable Objects (December start)

Digital, Games Development and ICT

Course ID: 163773

Course Year: 21/22

Course Details

  • No specific entry requirements.
  • Short, informative course.
  • Ideal for students who wish to pursue a career in the IT industry.
  • Access support and guidance from our dedicated and experienced teaching team.
  • Utilise our fantastic facilities at the college and reach your full learning potential.
  • Gain a new skill and expand your computer knowledge.

What to expect from the course

This short course covers SQL Programming using Microsoft T-SQL 2012.

• Creating Batches
• Flow Control Statements
• Cursors
• Stored Procedures
• Error Handling
• Transactions
• Transaction Isolation levels
• Scope and Type of Locks
• User Defined Functions

Qualifications

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



Why study with us?

Student Benefits

A baker decorating pastries.
Academy Bakery

The Academy Bakery is located on the Duke Street campus, producing a range of first class baked goods daily. These include artisan breads, patisserie and biscuits, as well as special occasion/novelty cakes by award-winning master-bakers. Students are offered a range of discounts throughout the year.

The Academy Bakery
A woman getting a nail treatment on her hands.
Academy Hair and Beauty Salons

Duke Street is also home to The Academy Hair and Beauty salons. They offer generous student discounts on a wide range of hair and beauty treatments, at a fraction of high-street prices. These include styling, cutting, perming, highlights, facials, manicures, electrolysis and traditional and homeopathic massage.

The Academy Salons
A chef preparing a dish.
Academy Restaurant

Duke Street campus is also home to the College’s Academy Restaurant. Often referred to by it’s customers as Liverpool’s hidden gem, the restaurant serves top class cuisine, at highly competitive prices. Food is expertly prepared by professional chef/tutors and young chefs in training and offers students a range of discounts at different times of the year.

The Academy Restaurant
An illustration of students using Office 365.
Microsoft Office 365 - Free

When you become a student of the College you’ll receive full access to Microsoft Office 365. This allows you to install the software on your own computer and other devices at home, completely free of charge.

A gym, including treadmills and exercise bikes.
Onsite Sports Facilities/Fitness Suite

The college has excellent sports and fitness facilities at its Roscoe Street campus. Students pay a one-off membership fee for all year round usage of weekly supervised gym sessions, as well as access to a number of sporting clubs and events.


Career pathways

Work in the IT Industry

We're here to help...

Contact us to discuss your application or find out more:

 : 0151 252 3000
 : enquiry@liv-coll.ac.uk

Entry Requirements

No specific requirements, although most students will have completed SQL1 & SQL2 in advance, or be working at a relevant level of experience.

If you are unsure of the entry requirements, or if you don't meet the criteria, please contact our Careers Advice and Guidance team who will be happy to help you find the best option for you. Email careersadvice@liv-coll.ac.uk or call 0151 252 3607.

Fees

This course is only available to learners aged 19 and over. Fees are payable by all students unless sponsored by an employer.

Fee for21/22 is 210.00
In future years this fee may be subject to change.


Apply Now »

College Videos