Oracle 10g Database Administration
This ORACLE 10g DBA (Database Administration) contains 21 Units and each Unit contains 150 slides in it. (Complete Oracle 10g Database Administration)
Contents…
• List the features of Oracle10g
• Discuss the theoretical and physical aspects of a relational database
• Describe the Oracle implementation of RDBMS and ORDBMS
• List the capabilities of SQL SELECT statements
• Execute a basic SELECT statement
• Identify and use the key features of Oracle SQL Developer
• Limit the rows that are retrieved by a query
• Sort the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at run time
• Describe various types of functions that are available in SQL
• Use character, number, and date functions in SELECT statements
• Describe the use of conversion functions
• Identify the available group functions
• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause
• Write SELECT statements to access data from more than one table using equijoins and non-equijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by using outer joins
• Generate a Cartesian product of all rows from two or more tables
• Define sub-queries
• Describe the types of problems that sub-queries can solve
• List the types of sub-queries
• Write single-row and multiple-row sub-queries
• Describe set operators
• Use a set operator to combine multiple queries into a single query
• Control the order of rows returned
• Describe each data manipulation language (DML) statement
• Control transactions
• Categorize the main database objects
• Review the table structure
• List the data types that are available for columns
• Create a simple table
• Explain how constraints are created at the time of table creation
• Describe how schema objects work
• Create simple and complex views
• Retrieve data from views
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms
• Use the data dictionary views to research data on your objects
• Query various data dictionary views
• Add constraints
• Create indexes
• Create indexes using the CREATE TABLE statement
• Creating function-based indexes
• Drop columns and set column UNUSED
• Perform FLASHBACK operations
• Create and use external tables
• Manipulate data using sub-queries
• Describe the features of multi-table INSERTs
• Use the following types of multi-table INSERTs
• Unconditional INSERT
• Pivoting INSERT
• Conditional ALL INSERT
• Conditional FIRST INSERT
• Merge rows in a table
• Track the changes to data over a period of time
• Use the ROLLUP operation to produce subtotal values
• Use the CUBE operation to produce cross-tabulation values
• Use the GROUPING function to identify the row values created by ROLLUP or CUBE
• Use GROUPING SETS to produce a single result set
• Use the below all System Defined Functions
• TZOFFSET
• FROMTZ
• TOTIMESTAMP
• TOTIMESTAMPTZ
• TOYMINTERVAL
• TODSINTERVAL
• CURRENTDATE
• CURRENT_TIMESTAMP
• LOCALTIMESTAMP
• DBTIMEZONE
• SESSIONTIMEZONE
• EXTRACT
• Write a multiple-column sub-query
• Use scalar sub-queries in SQL
• Solve problems with correlated sub-queries
• Update and delete rows using correlated sub-queries
• Use the EXISTS and NOT EXISTS operators
• Use the WITH clause
• Interpret the concept of a hierarchical query
• Create a tree-structured report
• Format hierarchical data
• Exclude branches from the tree structure
• Use regular expression support in SQL to search, match, and replace strings in terms of regular expressions.