We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Introduction to Oracle 11g Tutorials
Oracle Installation & Configuration / Finding Things in Oracle Docs
Subtitles of the Movie (Introduction to Oracle 11g / Oracle Installation & Configuration / Finding Things in Oracle Docs)
Finding things in Oracle Documentation. So I have the documentation downloaded and installed onto my Notebook, I'm going to double-click this and it's all in a browser and this is what comes up. So there's a lot of things in here as you can see. Now for instance this 2 day guides, which give you a very quick overview of what's goes on with different things, I wouldn't go into those too much unless you want to do something like certification. And we've got certain supporting documentation, there are general things that they think that people are going to use on the front page. This is how I like to use the documentation, again there's another menu here. It's trying to give you a, a drilled down list, performance, installation, et cetera, et cetera, et cetera. I like to click on this think here called the Master Book List. What this gives you is all the books in the Oracle Documentation. Now if I want to find about something say performance, now bear in mind I actually know a lot about this documentation so I know where to find things, it finds that, it finds that, it also finds this. This is the primary performance tuning guide and this gives you everything about performance tuning. There's all sorts of information in there that you don't really want to go into in a course that is an introduction to Oracle, I'm just showing you the different books. PL SQL Language Reference, anything to do with writing PL SQL code. PL SQL Packages, Types and References, anything to do with Oracle provided PL SQL Packages such as the DBMS underbar Packages. To look at SQL code, specifically, you want to look at the SQL Language Reference guide. To look at things such as views that allow you to look at structures inside the database, typically database administrators use this guide, is the Reference Guide. The book that you will use mostly in a course like this is going to be the SQL Language Reference Guide or perhaps to it's certain extent, the Quick Reference. I tend not to use the Quick Reference it's a little bit too summarized for me but the plus side for me is I know where to look for things. So I'm going to click on the HTML version of the SQL Language Reference, I prefer to use the HTML version because I find it more easily searchable and it's much faster. And here's the SQL Language Reference Guide. Now what I don't want to do in chapter two in a movie like this, is to jump the gun and introduce concepts and phrases and words and reserve stuff in Oracle that you don't know what they are. When writing a book, one is supposed to introduce things and then talk about them afterwards. Bit difficult because I need to show you how to use the book. So there are some very basics here, SQL is essentially a language that reads the database, it reads data. You have functions and expressions, kind of similar mathematically. Operators are things like plus signs and minus signs, there are ways to do those in Oracle. There are certain conditions, queries and subqueries. What I don't like about a lot of this stuff is it's kind of generic and unless you actually know what to look for, you might find it quite difficult to find things. What I like is this section here, this says all SQL statements in alphabetical order from Alter Cluster to Alter Java, A to A, down here it's Create Cluster to Create Java. If I'm looking for something specific to SQL called the Select Statement, spelt S-E-L-E-C-T, I can find it between Savepoint, S and Update, U. So I click this link right here and here I have the Select Statement and I get, when I get to it, descriptions and syntax diagrams called the Select Statement. I will explain all this stuff later on in the course but what I'm trying to show you now is how and where to find things. You're not going to remember from this movie exactly what to look for but I'm showing you the general structure. If I want to find an Insert Statement which is a statement in Oracle SQL that's used to add new data to tables, I for Insert, between D for Drop and R for Rollback. And here we have the Insert Statement, click the link. And if I scroll down through the description information, I get the syntax diagrams. Don't worry about the detail at this stage, just remember that you're going to mostly need to use the SQL Language Reference and when you go into the SQL Language Reference, you're going to look within this alphabetical list here to find specific statements and clauses that are added to those statements that I'm going to talk about throughout this course. We're not going to go through all the material in this, in this, in this particular course, there's just way too much. Oracle is enormous as you can see from all this information here. There are so many things in here that you simply can't learn it all at once, takes years but don't worry about it. It can be done, I've done it and many thousands of Oracle DBAs and Developers have done before you as well.
Tutorial Information
| Course: | Introduction to Oracle 11g |
| Author: | Gavin Powell |
| SKU: | 34312 |
| ISBN: | 978-1-61866-042-8 |
| Release Date: | 2012-04-28 |
| Duration: | 11.5 hrs / 139 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
