Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course will give you a basic understanding of the fundamentals of database administration and will concentrate on the "administration" part, and will give you a solid understanding of the database internals which will put you in the right path to being a successful database administrator. And I will immediately dive into the hands-on part after every lecture.
I will primarily use oracle's 11g version but the concepts and techniques apply to past and future versions of Oracle. I will try to use less GUI interface(except in the install) as possible since in the real world, database issues doesn't pop up when your in the office sipping coffee at 2pm, it usually pops up when you are sleeping soundly at 3am, waking up then remotely connecting to your work VPN, where speed is key, you will not be using a GUI to troubleshoot.
I will also share my scripts that I use daily in my 10 years as a production DBA.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Oracle Architecture|
Oracle Architecture and basic definitionsPreview
|Section 2: Software Install and DB creation|
Installing Oracle software part 1Preview
Installing Oracle software part 2Preview
Installing Oracle software part 3Preview
|Section 3: Connect thru sqlplus|
Connecting to the databasePreview
|Section 4: SQL Fundamentals|
Understanding the Basics of executing a SQLPreview
|Section 5: Data Dictionary Views|
DBA Views part 1Preview
DBA Views part 2
DBA Views part 3
DBA Views notes
|Section 6: Creating Tablespace Users Tables and Indexes|
Create a Tablespace
Create a User
Create a Table and an Index
|Section 7: Bounce a database|
Shutdown a Database
Startup a Database
|Section 8: Convert a database from noarchivelog to archivelog|
Convert a database to archive log mode
|Section 9: Backing up a database|
Backing up a database thru RMAN
Dexter is a seasoned Oracle DBA and has been working with Oracle database since 2004 handling mission critical database of multinational telecommunications and banking sector. Aside from oracle he also handles Microsoft SQL Server and IBM DB2 databases. He has handled multi terabyte OLTP and data warehouse database based in the states and Asia. He has the following certifications: Oracle Certified Professional(9i, 10g, 11g), MCP, MCITP:Database Administrator 2005, IBM DB2 9 Associate. He holds a bachelor degree in computer science.
Dexter likes to develop iOS apps for personal use and dabble in VMware/VirtualBox during his free time.