DML Atomicity Part2 So, quick overview of the SQL programming language. It can be divided up into five different categories. These are not my categories. I did not design these categories. I think the good folks at Oracle would probably agree with these five categories. This is the way that I learned the sequel programming language, and I think it’ll be a good way for you to learn the sequel programming language. But we’re only going to focus on one relatively simple set of commands within this programming language. So…

DML Atomicity Part1A So one of the downsides to being a DBA is that it’s a really, really good idea, if not necessity, that you also should probably know most, if not all, of the developers job as well. There’s a couple of reasons for that. For whatever reason, we tend to put, maybe I shouldn’t even say it, but we tend to put DBAs at a little bit of a higher level above the developers. Not that we don’t sit kind of in our own little offices somewhere, or…

Critical Storage Files Part2A Here we talk about now. I want to tell you why there is normally not going to be just one table space. Not that you can’t do this, but you really shouldn’t, and Oracle is going to try hard not to let you. You’re almost always going to have at least three table spaces, and I have them listed here. They are the system, system table space, the Sysox table space, and the Temp table space. You could get rid of the temp table space. In…

Critical Storage Files Part1A All right, so there are a couple of files within the database itself that we need to talk about. One set of files, I think, that you will see is obvious to the database itself and the other, a couple of other files that are very important that Oracle must have to make sure that it runs. So you need to be aware of those. And to an extent, you need to be aware of what the contents of those files files are. You may need…

Starting And Stopping DataBase Part1A So in this section we want to talk about something that you would think would be pretty simple, which is running the database and stopping the database. And it is pretty simple, it’s just not that simple. It’s not as easy as say, double clicking on an icon on your desktop or clicking on File exit to shut the program down. Or shut the program down. It’s a little bit more complicated than that, and it can be considerably more complicated than that, but it’s…

Background Processes Part1B Sometimes you can even decide if multiple instances of these background processes exist. Here on the slide I’ve described, one called DVW. Remember, they almost all have four letter abbreviations. I know this one doesn’t have four letters. It has four letters, three letters, and a number. It really does have four letters. Without the numbers there, it’s dbwr. I’ll show you that abbreviation later. Dbwr. That stands for Database Writer. There can be more than one of them, always should be more than one of them,…

Internal Memory Structures Part2B The shared pool is an area of memory, another chunk of Ram. That’s what we’re talking about in this whole section here are different chunks of Ram. Ram is very, very complex in the Oracle system. Very complex. That’s how it gets its speed, has all these things that it can do within Ram. Ram, the shared pool is the place where one, it stores compiled code. So SQL code, for example, once it’s stored, goes into the shared pool, goes into the shared pool section…

Internal Memory Structures Part1B So let’s talk about what goes into the SGA. Here’s just some on this slide of what goes into the SGA. And then we’ll go through this specifically and we’ll talk about what each of these areas are for. Each of these areas will possibly be tested on the exam. Okay, we start out with the database and I will go through each of these areas specifically with you. We start out with the database buffer cache. It’s an area where we’re going to store some…

RF Signal and Antenna Concepts Part1 So in this module, we’re going to talk about the radio frequency signal as it relates to the antennas and the concepts about these antennas. So we’re going to look at a lot of what we can design with antennas to affect the actual signal. That means we’re going to look at azimuth and elevation charts and talk about how they should be read. And then we’re going to talk about some of the different types of antennas, whether they’re omnidirectional, semi directional, highly…

Conclusion Hey, everyone. First of all, congratulations for making it through the course. I know TOGAF is a deep subject. There’s a lot of complexity to it, a lot of information. It’s hard to get it across in a very interesting and read you to digest manner, but hopefully you got a lot of value out of this course. I love hearing the stories. If you come to me, go to the discussion board or send me a personal message, tell me me that you took the test. Tell me…