Difference between revisions of "Oracle Workbook"

From mi-linux
Jump to navigationJump to search
 
(12 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
== Welcome to the Online Teaching/Learning Resources for Oracle and SQL ==
 
== Welcome to the Online Teaching/Learning Resources for Oracle and SQL ==
  
This workbook is aimed at students studying their first database module, such as 5CI017, or 7CI006, or as a reminder of how to use Oracle and SQL for advanced database modules.
+
This workbook is aimed at students studying their first database module, such as 5CI022, or 7CI006, or as a reminder of how to use Oracle and SQL for advanced database modules.
  
 
{| border="3" cellpadding=3 cellspacing=3
 
{| border="3" cellpadding=3 cellspacing=3
Line 41: Line 41:
 
** [[Oracle:Recursive_Join|4.1.2 Recursive joins]]
 
** [[Oracle:Recursive_Join|4.1.2 Recursive joins]]
 
** [[Oracle:Outer_Join|4.1.3 Outer joins]]
 
** [[Oracle:Outer_Join|4.1.3 Outer joins]]
 +
|-
 +
|Section 5||
 +
*[[Oracle:Functions|5.1 Arithmetic operators, Group BY, Subqueries and Functions]]
 +
**[[Oracle:Arithmetic_Operators|5.1.1 Arithmetic operators]]
 +
**[[Oracle:Group_Functions|5.1.2 Group functions]]
 +
**[[Oracle:Subqueries|5.1.3 Subqueries]]
 +
**[[Oracle:Date_functions|5.1.4 Date functions]]
 +
**[[Oracle:Character_functions|5.5.5 Character functions]]
 +
|-
 +
|Section 6||
 +
*[[Oracle:Misc|6.1 Miscellaneous Features]]
 +
**[[Oracle:Control_Commands|6.1.1 Control commands]]
 +
**[[Oracle:Substitution_Variables|6.1.2 Substitution Variables]]
 +
**[[Oracle:Views|6.1.3 Views]]
 +
**[[Oracle:Indexes|6.1.4 Indexing Tables]]
 +
**[[Oracle:Data_Dictionary|6.1.5 Data Dictionary]]
 +
 +
|-
 +
|Section 7||
 +
*[[Oracle:Advanced_Features|7.1 Advanced Features]]
 +
**[[Oracle:Database_Triggers|7.1.1 Database Triggers]]
 +
**[[Oracle:Database_Procedures|7.1.2 Database Procedures]]
  
 
|-  
 
|-  
Line 53: Line 75:
 
*[[Oracle:Section2|Section 2 Exercises]]
 
*[[Oracle:Section2|Section 2 Exercises]]
 
*[[Oracle:Section3|Section 3 Exercises]]
 
*[[Oracle:Section3|Section 3 Exercises]]
|}
+
*[[Oracle:Section5|Section 5 Exercises]]
 
+
*[[Oracle:Section6|Section 6 Exercises]]
 
 
----
 
  
Please note the workbook is currently under construction so not fully completed yet. In the meantime an electronic copy of the paper version is usually available in your WOLF topic.
+
|}

Latest revision as of 13:25, 15 May 2018

Main Page >> Oracle and SQL >> Workbook

Welcome to the Online Teaching/Learning Resources for Oracle and SQL

This workbook is aimed at students studying their first database module, such as 5CI022, or 7CI006, or as a reminder of how to use Oracle and SQL for advanced database modules.

Section 1
Section 2
Section 3
Section 4
Section 5
Section 6
Section 7
Reference Material
Exercise Answers