Oracle Database Introduction Training

by Transmedia

This course is aimed at application developers and database administrators. Delegates to the course will learn the fundamentals of the PL/SQL programming language, writing stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Transmedia Logo

img Duration

3 Days

Course Details

This course is aimed at application developers and database administrators. Delegates to the course will learn the fundamentals of the PL/SQL programming language, writing stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle.

Students will also learn programming, management and some of the security issues associated with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features. The course is applicable to Oracle 9i, Oracle 10g and Oracle 11g users.

 

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
  • Bristol Branch

    10 Park Street, Bristol
  • London Branch

    Stone House 277 Greenwich High Rd, London
  • London Branch

    85 Tottenham Court Road, London

Check out more Oracle courses in UK

London IT Training Logo

Teradata Training

Teradata is a data warehousing solution used to handle massive data warehouse operations. Participants will obtain in-depth knowledge of Teradata’s database architecture, as well as the product’s capabilities and benefits, throughout this Teradata certification course.

by London IT Training [Claim Listing ]
London IT Training Logo

Oracle Training

R 12 is an Oracle E-business suite in Oracle Cloud. Version 12 of Oracle E-business suite is an internet-enabled product that can easily be managed by a particular site. 

by London IT Training [Claim Listing ]
Elite Training Logo

M20462 – Administering Microsoft® SQL Server® Databases

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

by Elite Training [Claim Listing ]
Training Dragon Logo

OCP Oracle Certified Professional 11g Database Training

This 4 weekdays or 4 weekends OCP Oracle Certified Professional 11g Database course is designed to provide delegates with the necessary knowledge to pursue Oracle Certified Professional 11g Database (OCP) certification.

by Training Dragon [Claim Listing ]
London IT Training Logo

Apache Cassandra Training

Apache Cassandra Training is offered by London IT Training.London IT Training offer a spectrum of courses that have been designed by experts to give you the most sought after IT skills within the UK jobs market.

by London IT Training [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy