Tel.: 020792 88995, Skype: lw-academy | | join us | | join us |
Write a review

Next Dental Nursing NEBDN course in September 2013, registration lines are now open.

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

Fees  - £3,200  (Overseas students)

           £750 (UK/EU students)


Duration  - 1 year

Location  – 103 Waterloo Road, London, SE1 8UL
Waterloo Station (opposite station, next door to Sainsbury’s)

...........................................................

  • 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
103, Waterloo Road, London,  SE1 8UL,
Tel.: 020792 88995,

info@waterlooacademy.co.uk
Company registered in England
and Wales No: 7110539
Ethics Policy Terms and Condition
www.waterlooacademy.co.uk