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 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
Let's Get Digital for ESOL (ICT)
Level 1 Certificate Digital Skills
Level 2 Certificate Understanding Data Protection & Data Security
Level 2 Certificate Digital Skills
SQL 2 - Intermediate
SQL 1 - Introduction
Introduction to Python
Introduction to Digital Photography
Advanced Essential Digital Skills
Level 3 Information Communications Technician Apprenticeship
Level 3 Data Technician Apprenticeship
Level 2 Certificate Digital & IT Skills
Level 1 Award Cybersecurity
Next Steps in Essential Digital Skills
Introduction to Javascript
Level 2 Certificate Principles of Cyber Security
Next Steps in Digital Photography
Introduction to Essential Digital Skills
Level 2 Certificate Digital Photography
