1Z0-061 cert questions
OracleLogins
| Powerpoint: | Activities (Hands On Practice) | Certification Quizzes (1Z0-061) SQL Fundamentals Exam |
| D64258GC11_Les01 (Introductions) | ActivityGuide |
Official link to exam: https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-061 |
| D64258GC11_Les02 (Select statements) | ActivityGuide |
1Z0-061_Selects |
| D64258GC11_Les03 (Restricting and Sorting) |
ActivityGuide |
1Z0-061_Restrict_Sort |
| D64258GC11_Les04D64258GC11_Les05 (Single Row Functions) |
ActivityGuide |
1Z0-061_SingleRowFunctions |
| D64258GC11_Les06 (Group Functions) | ActivityGuide |
1Z0-061_Aggregate |
| D64258GC11_Les07 (JOINS) | ActivityGuide |
1Z0-061_Joins |
D64258GC11_Les08 (Subqueries) D64258GC11_Les09 (Set operations) |
ActivityGuide |
1Z0-061_Subqueries_Set_Operations |
| D64258GC11_Les10 (DML) D64258GC11_Les12 (Views, Sequences, Indexes, Synonyms) |
ActivityGuide |
1Z0-061_DML_Sequences_Views_Index_synonyms |
| D64258GC11_Les11 (DDL) | ActivityGuide |
1Z0-061_DDL |
Extras (Not Required)
D64258GC11_app_a (Table Descriptions)
D64258GC11_app_b (Using SQL Developer)
D64258GC11_app_c (Using SQL Plus)
D64258GC11_app_d (Using J Developer)
D64258GC11_app_e (Oracle Join Syntax)
Reading (These are the same as powerpoints but in pdf format)
SQL_Volume1
SQL_Volume2
Scripts to Run (not required):
HR_create_tables
HR_populate_tables
HR Schema