Your browser is unsupported and may have security vulnerabilities! Upgrade to a newer browser to experience this site in all it's glory.
Skip to main content

SQL 2 - Intermediate

Subject Area

Digital & IT

Student Type

Adults

Study Mode

Part Time

Course Type

Adult Further Education

What is the course about?

This course is an extension to the introductory SQL 1 course. SQL (Structured Query language) is a programming language designed to manage data stored in relation databases. This course will continue with SQL commands and databases and will enable you to develop a more in depth and detailed knowledge. This course comprises of tutor lead sessions with plenty of opportunities to practice and implement what you have learnt to develop SQL skills and put this into practice.

Why should I choose the course?

SQL is used widely across web frameworks and data base applications, and understanding SQL allows you to handle structured data by accessing and manipulating databases. This course will allow you to continue applying SQL to database management. The SQL programming language is versatile and is one of the simplest to learn due to its natural language structure. SQL is one of the most in demand programming languages available, and anyone that utilises modern relational databases will need to have an understanding in using SQL. SQL use is predominant across data driven industries. All large companies implement databases and so utilise SQL as a part of their data mining activities. The SQL language can be used across many different software platforms, and so continuing your learning of SQL will give you the skills for SQL usage across many systems.

What will I learn?

Initially, you will learn how to design and create simple multi table relational databases. You will also cover the important concepts of database normalisation. The SQL content will continue with a brief recap on prior knowledge, before progressing to more detailed concepts, such as further multi-table queries, nested queries, aggregation, unions, grouping by, cases, Joins and sub queries. There is also an opportunity to practice what you have learnt within a practical scenario-based project.

What will the course lead on to?

Completion of this course will allow you to undertake the SQL 3 (Advanced) course where you can investigate the different platforms that can be used with SQL. The course will also support your career progression within IT & Computing.

Are there any links with industry and university?

The college works with employers such as ABB Ltd, Draw and Code, Apple, 10:10 Games and Vizbox. The Advanced Creative & Digital Skills Centre is proud to work with a wide range of local and national employers who will deliver industry-specific skills and knowledge during the course, offer learners the chance to take part in competitions or live briefs and often talent spot for their next employees.

What support is available?

We have a team of staff dedicated to providing learning support if required, as well as a Welfare Team that is on hand to offer guidance, support and help when needed. Additionally, eligible students can access a wide range of finance and funding support to help them during their time at college.

Click here for learning support: https://wvr.ac.uk/college-life/learning-support

Click here for finance support: https://wvr.ac.uk/college-life/financial-support

Why should I choose to study the course at Warrington & Vale Royal College?

We have a team of staff dedicated to providing learning support if required, as well as a Welfare Team that is on hand to offer guidance, support and help when needed. Additionally, eligible students can access a wide range of finance and funding support to help them during their time at college.

Click here for learning support: https://wvr.ac.uk/college-life/learning-support

Click here for finance support: https://wvr.ac.uk/college-life/financial-support

What are the entry requirements?

You should have completed the SQL 1 - Introduction course or have relevant skill and experience to undertake this intermediate level course.

What are my funding options?

For further information about funding, please contact our Learner Services Team on 01925 494400 or learner.services@wvr.ac.uk.

Are there any additional costs associated with the course?

There are no additional costs.

Careers Information

Course options

16/04/2024

Duration
8 Weeks
Class Times
09:15 - 12:15
Location
Warrington Campus
Day(s)
Tue
Adult Fee
320
16-18 Fee
Contact College

Course Enquiry

Please complete this form if you would like any other information about this course

Other similar courses

These courses may be more suited to your interests or needs

Lets Get Digital for ESOL
Let's Get Digital for ESOL (ICT)
Digital & IT
Adults
Part Time
Leisure
Digital IT Adult 1
Level 1 Certificate Digital Skills
Digital & IT
Adults
Distance Learning
Adult Further Education
Digital IT Adult 1
Level 2 Certificate Understanding Data Protection & Data Security
Digital & IT
Adults
Distance Learning
Adult Further Education
Digital IT Adult 1
Level 2 Certificate Digital Skills
Digital & IT
Adults
Distance Learning
Adult Further Education
Digital IT Adult 1
SQL 2 - Intermediate
Digital & IT
Adults
Part Time
Adult Further Education
Digital IT Adult 1
SQL 1 - Introduction
Digital & IT
Adults
Part Time
Adult Further Education
Digital IT Adult 1
Introduction to Python
Digital & IT
Adults
Part Time
Leisure
Photography
Introduction to Digital Photography
Digital & IT
Adults
Part Time
Leisure
Digital IT Adult 1
Advanced Essential Digital Skills
Digital & IT
Adults
Part Time
Leisure
Digital IT
Level 3 Information Communications Technician Apprenticeship
Digital & IT
Students aged 16-18
Part Time
Apprenticeship
Digital IT
Level 3 Data Technician Apprenticeship
Digital & IT
Students aged 16-18
Part Time
Apprenticeship
Digital IT Adult 1
Level 2 Certificate Digital & IT Skills
Digital & IT
Adults
Part Time
Adult Further Education
Digital IT Adult 1
Level 1 Award Cybersecurity
Digital & IT
Adults
Part Time
Adult Further Education
Digital IT Adult 1
Next Steps in Essential Digital Skills
Digital & IT
Adults
Part Time
Leisure
Digital IT Adult 1
Introduction to Javascript
Digital & IT
Adults
Part Time
Leisure
Digital IT Adult 1
Level 2 Certificate Principles of Cyber Security
Digital & IT
Adults
Distance Learning
Adult Further Education
Photography
Next Steps in Digital Photography
Digital & IT
Adults
Part Time
Leisure
Digital IT Adult 1
Introduction to Essential Digital Skills
Digital & IT
Adults
Part Time
Leisure
Photography
Level 2 Certificate Digital Photography
Digital & IT
Adults
Part Time
Adult Further Education
Photography
Level 1 Award Digital Photography
Digital & IT
Adults
Part Time
Adult Further Education
Warrington & Vale Royal College Logo
Back
Back