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.
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.