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)
|