My Courses » Oracle-1
Oracle-1
LINKS
Oracle Academy
Oracle Application Express
Oracle 1 Course
Order of Units
Oracle Database Design
Unit 1: 1 Design
1-Introduction to Oracle Academy (8/26)
2-Data vs. Information (8/26)
3-History of the Database
4-Major Transformation in Computing
Unit 2:
2 Design
1-Conceptual and Physical Models
2-Entities, Instances, Attributes, Identifiers
3-ERMs
3 Design
1-Identifying Relationships
2-ER Diagramming Conventions
3-Speaking ERDish
4-Matrix Diagrams
Unit 3:
16 Design
1-Anatomy of a SQL Statement
2- Oracle DB Environment
3-Using Applications
4-Relational Database Technology
Unit 4:
4 Design
1-Supertypes and Subtypes
2-Documenting Business Rules
5 Design
1-Relationship Tranferability
2-Relationship Types
3-Resolving M:M Relationships
4-Understanding CRUD Requirements
Unit 5:
17 Design
1-Working with Columns, Characters and Rows
2-Limit Rows Selected
3-Comparison Operators
18 Design
1-Logical Comparisons and Precedence Rules
2-Sorting Rows
4-Intrduction to Functions
Unit 6:
6 Design
1-Artificial, Composite and Secondary UIDs
2-1NF
3-2NF
4-3NF
7 Design
1-Arcs
2-Hierarchies and Recursive Relationships
Unit 7:
12 Design
1-Introduction to Relational DB Concepts
2-Basic Mapping
3-Relationship Mapping
4-Subtype Mapping
ERD Project (15D)
Oracle Programming
Unit 1
1 Programming
1-Case and Character Manipulation
2-Number Functions
3-Date Functions
2 Programming
1-Conversion Functions
2-NULL Functions
3-Conditional Expressions
Unit 2:
3 Programming
2-Cartesian Products and Join Operations
3-Non-equijoins
4-Outer Joins
5-Self Joins
4 Programming
2-Cross Joins and Natural Joins
3-Join Clauses
4-Inner vs. Outer Joins
Unit 3:
5 Programming
1-Review of Joins
2-Group Functions
3-Count, Distinct and NVL
Unit 4:
6 Programming
1-Group By and Having Clauses
2-Inner queries (aka subqueries)
3-Single-Row Subqueries
4-Multiple-Row Subqueries
Unit 5:
7 Programming
1-INSERT Statement
2-Updating Column Values and Deleting Rows
3-DEFAULT Values and the MERGE Statement
8 Programming
1-Creating Tables
2-Using Data Types
3-Modifying a Table
Unit 6:
9 Programming
1-Defining NOT NULL and UNIQUE Constraints
2-PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
3-Managing Constraints
10 Programming
1-Creating Views
2-DML Operations and Views
3- Managing Views
Unit 7:
11 Programming
2-Sequences
3-Indexes and Synonyms
12 Programming
2-Controlling User Access
3-Creating and Revoking Object Privileges
14 Programming
1-Database Transactions
NEED HELP DOWNLOADING:
doc file: You need the Microsoft Word program, a free Microsoft Word viewer, or a program that can import Word files in order to view this file. To learn more about the free Microsoft Word Viewer, visit the Microsoft Word website .
Mrs. Reddy
