Introduction to Oracle 9i: SQL

  
Oracle 9i DBA Track-4 Exams
  
OCA
  
Exam #1Z0-007 Introduction to Oracle 9i: SQL
  
Exam #1Z0-031- Oracle 9i Database Fundamentals I
  
OCP
  
Exam #1Z0-032- Oracle 9i Database Fundamentals II
  
Exam #1Z0-033- Oracle 9i Database: Performance Tuning
  
Introduction to Oracle 9i: SQL
  
Writing Basic SQL Select statements
  
                List the capabilities of SQL SELECT statements
  
                Execute a basic SELECT statement
  
                Differentiate between SQL statements and SQL *Plus commands
  
Restricting and sorting Data
  
                Limit the rows retrieved by a query
  
                Sort the rows retrieved by a query
  
Single Row Functions
  
                Describe various types of functions available in SQL
  
                Use character, number and date functions in SELECT statements
  
                Use conversion functions
  
Displaying data from multiple tables
  
                Write SELECT statements to access data from more than one table using equality and non-equality joins
  
                View data that generally does not meet a join condition by using outer joins 
  
                Join a table to it-self using a self-join
  
Aggregating data using group functions 
  
                Identify the available group functions 
  
                Use group functions 
  
                Group data by using the GROUP BY functions
  
                Include or exclude grouped rows by using the HAVING clause
  
Sub queries
  
                Describe the types of problems that sub-queries can solve
  
                Define subqueries
  
                List the types of subqueries
  
                Write single row and multiple rows subquries
  
Producing Readable output with iSQL*Plus
  
                Produce queries that require a substitution variable
  
                Produce more readable output
  
                Create and execute script files
  
Manipulating data
  
                Describe each DML statement
  
                Insert rows into a table
  
                Update rows from a table
  
                Delete rows from a table
  
                Merge rows from a table
  
                Control transactions
  
Creating and managing tables
  
                Describe the main database objects
  
                Create tables
  
                Describe the data types that can be used when specifying column definition
  
                Alter table definitions
  
                Drop, rename ad truncate tables
  
Including constraints
  
                Describe constraints
  
                Create and maintain constraints
  
Creating views
  
                Describe a view
  
                Create, alter the definition and drop a view
  
                Retrieve data through a view
  
                Insert update and delete data through a view
  
                Create and use an inline view
  
                Perform TOP ‘N’ Analysis
  
Creating other database objects
  
                Create, maintain and use sequences
  
                Create and maintain indexes
  
                Create private and public synonyms
  
Controlling user access
  
                Create users
  
                Create roles to ease setup and maintenance of the security model
  
                Use the GRANT and REVOKE statements to grant and revoke object privileges
  
 
  
 
  
                
  

how to communicate any ug general 8 i learn dj workshop how technology co key functions instructor up business and IT pattern security internet and awk mining synthesis joins effects cs3 training module 2 14 hours Build it com project canadian Made sap is if required reports 8 ms windows network hr new no.3 ladder safety design- sumif communication skills the company microsoft NT over 20 release 11 5 cross culture april 6th p2 foundation Pentium payroll and accounts Creative and innovation we complete tips of dreamweaver 40 their take the class datawarehouse the training any other Lean 5s drawing quality a it organization s not 0 system organization s enable it IS STANDARDS keep you from expectations body s 25 years t find open source technologies how to do personal trainer bd software the quality management 3 levels help prepare you job server Imap4 ba analysis Filmmaking form validation ecc programs the design requirement are being focus how georgia management boston 4 week Supervisory Management the needs the delivery of advanced lr life and health CE the processes The Formatting Toolbars arena use of -- manual Phi what are your support training emulator nt tools PLC CCNA Oracle Java QTP excel software testing CPR english quickbooks IATA MCSE networking computer AutoCAD management informatica electrical Tally forklift ABAP hvac safety scada pds piping Finance ITIL project management spoken english acls PHP communication insurance sas pmp embedded siebel ERP peoplesoft pdms soft skills welding telecom marketing animation AS400 train the trainer fico photoshop payroll phlebotomy six sigma Cognos J2EE UNIX asp net chennai sap fico solidworks electronics housekeeping plumbing CCNP free anger management vlsi mortgage matlab personality development gsm bookkeeping banking nursing hardware plastering first aid sharepoint american heart association cpr dot net Ndt embedded systems NLP software ielts Cisco Flash OSHA aix Powerpoint mobile dba Design access business objects Oracle Dba engineering india data warehousing db2