Tel.: 020 7902 1904, Fax: 020 7921 0014, Skype: lw-academy,   join us

IELTS preparation 4 weeks - £200

ESOL with Citizenship course/exam

 
This course teaches the basics of constructing and manipulating the gold-standard relational database (Oracle). You will learn how to create and populate database components such as Tables and views, and enforce business rules with the use of appropriate constraints.
Software version: Oracle 10g

Course Content
  • Introduction to Relational Database Theory
  • Database Design
  • Entity relationship modelling
  • The Data Dictionary
  • Indexes, Integrity and Constraints
  • Implementing the Design
  • Creating, updating and deleting databases and tables using SQL Server Management Studio
  • Updating tables using SQL Server Management Studio
  • Querying Data
  • Introduction to SQL: the SELECT statement, using WHERE to filter data, sorting using ORDER BY
  • Advanced SQL 1: aggregating data using GROUP BY, aggregate functions
  • Advanced SQL 2: joining tables, nesting queries
  • Introduction to programming SQL Server with T-SQL and the .NET Framework
  • Stored Procedures and User-Defined Functions
  • Server-side programming using .NET assemb

Intensive course, class based training

Duration – 2 weeks, 3 hours a day


Fees - £950 + VAT

Location – 99 Waterloo Road, London, SE1 8UL

Waterloo Station (opposite station, next door to Sainsbury’s)


Student Feedback
Ramesh Magan

I decided to enrol to a Web Design course and to get a new job. I came across an education establishment - London Waterloo Academy and I have spoken to a teacher who gave me a all information regarding this course.

At LWA I gained new skills and new experience which will help me to get a new job.

I would recommend this course to everyone who is interested in the Web Design. London Waterloo Academy is the best place to learn and take your carrier to the next level.

I just want to say to London Waterloo Academy: ‘Thank you for all your support to boost my career`

Student Feedback
Josephine J. Gain

I did my MSc in multimedia at University of Westminster last year and web design was a module in my course. I wanted to specialize on that and was looking for short courses that deal with HTML, CSS, Javascript and other important areas to start as a web designer. I have checked many course providers and course contents and most of them were highly priced. Suddenly I came across London Waterloo Academy through an email which at first attracted me by its course content. And then I spoke to them, visited the office to know more about the course. I had to take the decision; I told myself that it’s now or never. I loved the course content, the hours of classes and the overall environment. Great friendly and helpful people and a very expert tutor. I had the chance to explore different types of real life examples that relate to my lessons. I did the 10 days intensive course which really works well. Also after every class I had unlimited access to use the lab. The whole 2 weeks were superb! I am really glad that I took the right decision at the right time. I do look forward to do more professional IT courses from this academy in future. This course helped me to understand the depth of different scripting languages and a right course can push someone’s skill much more forward in the competitive real world sector. I would highly recommend anyone to join “London Waterloo Academy” for different professional courses.

99, Waterloo Road, London,  SE1 8UL,
Tel.: 020 7902 1904,
Fax: 02079210014,
info@waterlooacademy.co.uk
Company registered in England
and Wales No: 7110539

Ethics Policy Terms and Condition
www.waterlooacademy.co.uk