About this Course. What are the things that we are going to go through in this course, an introduction to Oracle 11g. What is a relational database from the logical perspective? A relational database has things to put data in called tables; those tables have structure applied within them that allows you to break things up into pieces. You can also organize those tables and link them together into related tables which is why it's called a relational database. Those tables are also known as relations. Essentially relational databases use very basic set theory in mathematics in order to join tables together and join information together and split it up into pieces that make logical sense. You'll see as we go through it. Architecture, the architecture of Oracle. Oracle Database has a very specific architecture which is not completely dissimilar to other databases but Oracle Database itself does have some specifics. You may have heard of things called Table Spaces and Data Files and Redo Logs and Archive Logs. Some of them apply to all types of relational databases; some of them are specific to Oracle Database. Installation, I will show you how to install Oracle software from both the Client-side and the Server-side and then how to configure it, the basics, nothing too complicated. Configuration, configuration is a part of installation but you can also change your configuration at a later stage, many months or years after your installation has been done and completed. There are various basic factors that we can go through that I can show you how to do. They're very important when on the job. There are various tools that you can use to work with Oracle Database both on the server and on the client, such as a tool called Oracle Enterprise Manager for monitoring the database. A tool called SQL Plus for changing things in the database and SQL Developer and so on and so forth. We will go through all those and then we get to tables and SQL, tables and the Structured Query Language. A table as I already said in discussing the relational database is a thing that is used in a relational database to store data. SQL is the Structured Query Language which is the language that is used to read data from those tables. So what do you do with tables in SQL? You read data with SQL, you can also filter the information that you pull from tables. In other words you actually tell it well I only want to retrieve this data and not all of it. You can sort data which means that when you read data from the database, you can actually change the order in which it's output. You can summarize so you can aggregate data and produce summary or aggregation sets of data based on all the data that you've read. So in other words, you summarize and get less data than you would normally do if you didn't aggregate. Joining, we will talk about joining and how you actually join the data in different tables together based on the relational structure between the different tables. And also there's management of the database. Management of the database involves basic configuration, installation, start up, shutdown, et cetera. The simple stuff.
| 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 |