IT4310 Database Admin II
Fall 2021
Instructor
Textbook (Recommended)
Database Systems
SQL
- mySQL
- Postgresql
- Mariadb
- Oracle
- Microsoft SQL
- IBM DB2
- SyBase
- [Firebase ] ()
NO SQL
Desktop
Resources
Tutorials
noSQL Databases
- Video
- Azure
- Object-Databases NoSQL-Databases Key-Value Databases NOSQL Comparision
- CouchBase
- Casandra Datastax Casandra
- MongoDB Video Tutor
OCA Certification
Oracle Academy Foundations
- Introduction 1 2 3 4 5 6
- Modeling 1 2 3 4 5 6
- Physical Modeling 1 2 3 4 5 6 7 8 9
- SQL Developer 1 2
- Mapping 1 2
- SQL 1 2 3 4 5 6 7 8 9
Oracle Academy Design
- Introduction 1 2 3 4
- Entities 1 2 3
- Relationships 1 2 3 4
- Super/Sub Types 1 2
- Fundamentals 1 2 3 4
- Normalization 1 2 3 4
- Arcs 1 2
- Historical Modeling 1 2 3 4
- Mapping 1 2 3 4
Oracle Academy SQL
- Select 1 2 3 4 5 6
- Functions 1 2 3 4 5 6
- Join 1 2 3 4 5 6
- Subtotal 1 2 3 4
- SubSelect 1 2 3 4
- DML 1 2 3
- DDL 1 2 3
- Constraints 1 2 3
- Views
1
2
- Sequence 1 2
- Privileges 1 2
- Regular Expressions 1
- Transactions 1
Oracle Academy plSQL
- Fundamentals 1 2 3
- Variables 1 2 3 4 5 6 7
- Programs 1 2 3 4 5
- Cursors 1 2 3 4 5 6
- SQL 1 2 3 4
- Exceptions 1 2 3 4
- Functions 1 2 3 4 5 6
- Procedures 1 2 3
- Packages 1 2 3 4 5
- Triggers 1 2 3 4 5
- Performance 1 2
- Compiler 1 2 3 4 5
Oracle Admin
- Installation Guide
- Admin Topics www.oracle-dba-online.com
- Oracle Docs docs.oracle.com Online help files
Bob’s Admin Notes
- Installing Oracle Linux Land of Linux HowTo
- Installing Oracle pdf html
- Creating an Oracle Instance (database)
- SQL Plus pdf html
- Creating Users / Tablespaces pdf html
- DataPump (Backup) video pdf html
- SQL Loader (Import) pdf html
- rman (Backup) backup restore
- Exporting Space Delimited Data pdf htm
- Performance Tuning
- Data Warehousing
Misc Resources
Last Updated 07/30/2021