This course will get you up to speed with the Oracle Database platform in general and the Oracle Database 12c release in particular. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam.
If you want or need to understand Oracle Database 12c, then you've come to the right place. In this course, we have three purposes. We want to (1) Get you up to speed with how Oracle Database works in general from the perspective of the database administrator (DBA); (2) Acquaint you with the new features and enhancements included in the latest 12c release of Oracle Database; and (3) Prepare you to pass the Oracle Certified Administrator (OCA) certification exam. To get the most benefit from this course, you should already have a basic understanding of relational database management systems, the relational model, and using SQL to query databases.
Exploring the Oracle Database 12c Architecture: Part 1 Hello and welcome to Pluralsight. My name is Tim Warner and you're watching Oracle Database 12c Fundamentals. The name of this module is Exploring the Oracle Database 12c Architecture: Part 1. You know, I was doing some research a little bit earlier today on starting salaries, average starting salaries for Oracle database administrators, and did you know that in the United States, Oracle DBAs earn on average $100, 000 a year? That's a pretty comfortable salary and I hope it has you being really excited about being a student in this class and learning how to administer Oracle Database 12c. In this overview module we're going to start with what are your goals as a student and what do you hope to get out of this course and learning path. We'll then get right into the meat and potatoes and discuss what exactly Oracle Database is, what is the difference between a database and an instance, what exactly is client server architecture and how does Oracle fit into that schema, and we'll conclude this lesson with a review of the Oracle Database 12c memory structures. The memory structures and background processes form what's called the instance, but I get a little bit ahead of myself.
Exploring the Oracle Database 12c Architecture: Part 2 Hello and welcome to Pluralsight. My name is Tim Warner and you're watching Exploring the Oracle Database 12c Architecture: Part 2. When my wife and I had our daughter, Zoe, it was fascinating observing her evolution and movement. Those of you who are parents know exactly what I'm talking about. Zoe had to learn to roll around on the floor before she could crawl. Of course she had to master crawling before she could walk and she had to have walking down before she could run and start doing the acrobatics that she's known for now at age 4. Similarly you're probably champing at the bit to get to the "good stuff. " How do I use Oracle to create a database, build my tables, run queries, do backups, and learn how to do all of that day to day DBA work? Well we'll get to that, believe me. But I do want to stress that we have to go through and complete our understanding of the Oracle Database 12c architecture for at least a couple good reasons. Number one, if you want to pass the Oracle certified associate test, you need to know the architectural underpinnings. Also, from a more practical standpoint, you'll find in your troubleshooting work if you understand how Oracle works under the hood, that is definitely going to go a long way towards shortening your troubleshooting time. To that end, in this module we're going to understand the Oracle Database 12c background processes. In effect we're continuing a discussion that we opened in the previous module. We'll then describe and understand the storage structures and we'll complete this module with a consideration of the first-party Oracle management tools, of which there are quite a few. Let's get started.
Introducing the Oracle Database 12c Instance Hello and welcome to Pluralsight. I'm Tim Warner and you're watching the module Introducing the Oracle Database 12c Instance. This module begins our hands-on work with Oracle Database. I thank you in advance for your patience in working through the first two modules in which we learned the Oracle Database 12c architecture. That's a necessary evil and really serves as a foundation for the rest of what we're going to be doing. To wit, we're going to start this module by learning what the initialization parameter file is and how its care and feeding, so to speak, works in Oracle Database. We'll also learn how to use two important SQL*Plus commands, startup and shutdown, that we use to, guess what, startup and shutdown the Oracle instance. We'll do a little bit of troubleshooting here, I'll introduce you to the alert log, this is an excellent way to figure out what's going on under the hood in your Oracle database. Excellent troubleshooting tips there. We'll complete this module with a brief consideration of so-called v$ views, or dynamic performance views, and how they can be used along with the alert log to, like I said, get a handle on what's behind the curtain and what Oracle is actually doing beneath the covers. Let's get started.
Configuring the Oracle Database 12c Network Environment Hello and welcome to Pluralsight. My name is Tim Warner and you're watching Configuring the Oracle Database 12c Network Environment. In this module we're going to get introduced to Oracle Net Services, which represents the under the hood plumbing that's used by Oracle to facilitate client server and server server connections to a database and instance. By the end of this module you'll know not only the architectural underpinnings of Oracle Net Services, but more importantly you'll understand how to use the tools to manage the Oracle network. We're going to finish this module with a brief discussion and demo on the Oracle Client software. Under which specific circumstances is it even required that you install Oracle Client software? If you do need to install it, how do you obtain the binaries and how does installation work? If you've wondered those things, wonder no more because you'll have answers to all of those questions by the time you're finished with this module. Welcome and let's begin.