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.
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
Managing Databases and Files
Disaster Recovery
Managing Security
Establishing Client Connectivity
Automating Administrative Tasks
Monitoring SQL Server
An Introduction To Troubleshooting and Performance Tuning
An Overview of Other Services
As a digital consultancy, solving our clients' most complex training and software development requirements is what we do, day in day out. We know business can be complicated and your time is precious.
You need clear choices and concise advice that can be tailored to your exact specifications. We will collaborate with you and advise you with clarity and confidence. Our core service areas are: Training, Digital Consultancy & Development and Claris FileMaker.
This course covers all the skills needed to use Oracle Database in professional work. Structured knowledge of SQL can be an asset to business analysts, report writers, application developers in the RAD environments (Oracle Forms, Oracle Fusion and even Microsoft Access)
Learn how to write SQL (Structured Query Language) to access, extract, organise & manipulate the data stored in your relational database.
This excellent SQL Queries course familiarises you with the most essential and daily used statement of SQL..
This Oracle Database 19c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.
Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy