close icon
search-2 icon
Provided by London Academy of IT shield-tick icon

SQL Intermediate to Advanced

Further your understanding of structured query language (SQL) with this instructors-led training course

Remember it's important you research your options before selecting a course. Late payments may result in fees and could negatively impact your credit file.

Loading...

What will you

Learn?

Here's what London Academy of IT say about their course...

SQL

Relational Database

A relational database stores data in one or more tables of columns and rows in predefined relationships.

Databases

When information is stored and retrieved digitally in an organized fashion, this is called a database.

What do I get?

  • Setting Up a SQL Server Environment
  • Built-In Functions
  • Date and Time Functions
  • Subqueries
  • Multi-Table Queries
  • Aggregate Functions and Group by
  • Temporary Tables and Table Variables
  • Common Table Expressions (CTE)
  • Dynamic SQL
  • Logical Functions
  • Local & Global variables
  • Control of Flow
  • User-Defined Functions - UDFs
  • Stored Procedures

What do I need?

  • You should have a prior understanding of SQL to attend this course
  • Our Introduction to SQL training course covers all of the prerequisites for this Intermediate to Advanced SQL course.

Knoma’s Take

London Academy of IT pride themselves on their small class sizes. They say that this helps their students focus on their learning. All of their courses are geared to improve employability – they say they take an employer-led approach to their curriculum.

Tom Meehan

CTO Knoma

quote-start icon

The support of Knoma allowed me to focus on my course of study without having to worry about an initial financial burden. Thanks to Knoma, I have been able to retrain as a Software Developer and look forward to an exciting new career.quote-end icon

Testimonial profile image

David

CAREER CHANGER | 2020 - 2021

Now

Software Developer

Previously

Chef

Ready to find your future career? Take our quiz and we'll suggest some career ideas based on your interests and strengths.

Take the quiz

What does the course cost?

Repay over 11 months or more

Repayment period (months)

Learn for 10 payments of

£120

/ month

Pay 0% interest

Check your eligibility

Representative example

£56.15

/ month

Course cost: £1,200

Repayment period: 24 months

Interest rate: 12%

Interest paid: £147.48

Learn more

This interest rate is personalised to your specific circumstances

Secure your place with a Knoma loan

You deserve to progress in a career you love. But learning the skills you need can be expensive. We don’t think that’s fair, so we’re doing something about it.

We partner with industry-leading schools and bootcamps so that you can enrol on your chosen course without paying upfront.

Our ethical finance

Related courses

The Learning People

Code - Full Stack Developer Package

From

£582

/ Month

From £6,995 Total

The Learning People

Software Testing ISTQB Certified

From

£166

/ Month

From £2,000 Total

Mastered

Unreal Developer

From

£650

/ Month

£7,800 Total

FAQs