Duration: 3 Months

Download: OracleSql pdf ,OraclePL/SQLpdf


A company’s data is critical. The storage, retrieval and security of that data is key to an organization’s success. Efficient and intelligent use of databases is vital. Companies rely on people who are able to provide analytical, technical and administrative support for their data. During the database course you’ll learn to understand the planning, documentation and management of databases. You’ll also learn how to convert tech speak into something more meaningful so that you can work with your clients or employers to design and deliver data systems that really give them what they need. This course track will provide you with the knowledge and skills to become a Database Professional. It will also give you the industry recognized IT certifications that will demonstrate your competence to employers, peers and customers.- Writing SQL select Statements
– Restricting and Sorting Data
– Using Single Row Functions to Customize Output
– Reporting Aggregated Data using the Group Functions
– Displaying Data from Multiple Tables
– Using Sub-queries to Solve Queries
– Using the SET Operators
– Manipulating Data
– Using DDL Statements to Create and Manage Tables
– Creating Other Schema Objects
– Managing Objects with Data Dictionary Views
– Controlling User Access
– Controling User Access
– Manage Schema Objects
– Manipulating Large Data Sets
– Generating Reports by Grouping Related Data
– Managing Data in Different Timezones
– Searching Data Using Advanced Sub Queries
– Hierarchal Retrieval
-Regular Expression Support
– Introduction to 10g Administration Workshop II
– Configuring Recovery Manager
– Using Recovery Manager
– Oracle Secure Backup
– Recovering from Non-critical Losses
– Incomplete Recovery
– Flashback
– Dealing with Database Corruption
– Monitoring and Managing Memory
– Automatic Performance Management
– Monitoring and Managing Storage I
– Monitoring and Managing Storage II
– Automatic Storage Management
– Managing Resources
– Automating Tasks with the Scheduler
– Database Security
– Data Movement
– Using Globalization Support
– Workshop Methodology, requirements, and setup