Oracle Database Querying Fundamentals

Duration: 3 Days

Objectives

This course provides a solid introduction to SQL (Structured Query Language). The course assumes no previous knowledge of SQL and SELECT statements, and takes delegates from simple queries, through to complex queries involving multiple tables, introducing the vast collection of built-in functions along the way. Although it provides an overview of relational database design principals, it does not cover formal database design processes or database and table creation. This course is aimed at developers, report writers, analysts and anyone who needs to extract information from data stored in a relational database. It is appropriate for users of Oracle 9i, Oracle 10g and Oracle 11g.

Pre-requisites

Delegates would benefit from a basic understanding of the concept of relational databases and terms such as table, column, row and relationship, although these concepts will be recapped at the start of the course.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Installing and Configuring SQL Server

  • Preparing to Install SQL Server
  • Installing SQL Server
  • Configuring a SQL Server Installation
  • Configuration Manager
  • Management Studio Server Properties
  • sp_configure

Managing Databases and Files

  • Planning Databases
  • Creating Databases
  • File groups and Data Files
  • Transaction Log Files
  • Managing Databases
  • Options
  • Attaching and detaching

Disaster Recovery

  • Planning a Backup Strategy
  • Backing Up User & System Databases
  • Restoring User Databases
  • Performing Online Restore Operations
  • Recovering Data from Database Snapshots
  • System Databases and Disaster Recovery

Managing Security

  • Overview of SQL Server Security
  • Protecting the Server Scope
  • Protecting the Database Scope
  • Protecting the Server Scope
  • Auditing Security

Establishing Client Connectivity

  • Network Libraries
  • ODBC & OLE-DB connections
  • SQL Native Client
  • Configuring Server Connectivity Settings

Automating Administrative Tasks

  • Automating Administrative Tasks in SQL Server
  • Using SQL Server Agent
  • Creating Maintenance Plans
  • Implementing Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent security

Monitoring SQL Server

  • Viewing Current Activity
  • Using SQL Server Profiler

An Introduction To Troubleshooting and Performance Tuning

  • Troubleshooting SQL Server
  • Performance Tuning in SQL Server

An Overview of Other Services

  • An Overview of Replication Service
  • An Overview of High Availability Services
  • An Overview of Integration Services
  • An Overview of Service Broker
  • An Overview of Common Language Runtime

Course Dates

London CentralLondon GreenwichBristol

The new course schedule is currently being updated and will be ready shortly. Please phone us on 0208 269 4260 or email us for the latest dates.

All our courses run in London and Bristol, or can be tailored to requirements at your own offices. For alternative dates, please email or call us on 0208 269 4260
All prices are per person and are subject to VAT
15% discount for groups of four delegates.
10% discount for groups of three delegates.
(This offer applies for delegates on the same public scheduled course on the same date.)

Related Courses


"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"

Julian Support

"Lovely accommodation and atmosphere. The training was well structured and clear."

Alistair Sawday Publishing

"An excellent presentation, very clearly explained and enjoyable at the same time. Has given me confidence in using this software."

RAF Culdrose



© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260