Oracle Database 10g: A Comprehensive Hands-On IntroductionDeveloping Database Applications with SQL and PL/SQL Course: 593 Type: Hands-On Training Duration: 5 Days You Will Learn How To
- Build, query and manipulate Oracle 10g databases to create powerful applications
- Retrieve and manipulate data efficiently using powerful SQL features
- Create and manage database tables, views and sequences
- Maintain data integrity and enforce security with privileges and roles
- Compose reusable structured PL/SQL code with cursors and procedures
- Enhance performance through indexes and PL/SQL optimisation
Course BenefitsTo efficiently handle today's business-critical information, organisations count on database systems that are reliable and scalable, and on experienced professionals to manage them. In this course, you gain the practical knowledge and skills required to leverage the Oracle Database 10g server. Hands-on exercises provide experience in applying relational database concepts, leveraging the SQL language and programming with PL/SQL.Who Should AttendThose interested in Oracle 10g. Relational database experience and familiarity with basic programming concepts are useful. Oracle experience is not required.Hands-On TrainingExercises provide experience creating robust and powerful applications with Oracle 10g, including:
- Creating tables, views and sequences
- Producing queries using joins, set operators, groupings and subqueries
- Merging large datasets and inserting across multiple tables
- Imposing business rules with declarative constraints
- Enforcing security with roles
- Enhancing performance with indexes
- Controlling logic and handling exceptions
- Building PL/SQL procedures, triggers and packages
Related Courses- 594 Oracle Database 10g Administration
- 518 Oracle Database 10g: Backup, Recovery and Tuning
- 492 Oracle Databases: Application Development & Tuning
- 493 Oracle PL/SQL Programming
- 234 Developing SQL Queries for Oracle Databases
- 137 SQL Server 2008 Comprehensive Introduction
- 138 SQL Server 2008 Database Administration
- 925 SQL Programming Language Introduction
Oracle is a registered trademark of Oracle Corporation. |
|
Upcoming Dates
| 13 - 17 Sep | London | | 10 - 14 Jan | London | | 9 - 13 May | London | 
Attend highlighted events in person or online with Learning Tree AnyWareTM. |
For complete schedule, please visit www.learningtree.co.uk
|