《CBT Nuggets出品甲骨文11g数据库1Z0-051SQL基础考试视频教程》(CBT Nuggets Oracle Database.11g SQL Fundamentals 1 1Z0-051)[光盘镜像]
Oracle Database 11g 第 2 版为 IT 奠定了基础，使其能够成功地以高质量的服务提供更多信息、降低 IT 内部变更的风险，并且更高效地利用 IT 预算。通过将 Oracle Database 11g 第 2 版部署为数据管理基础，企业可以充分利用世界领先数据库的强大功能实现以下目标：
* 服务器成本降至原来的 1/5
* 存储需求降至原来的 1/12
* 任务关键系统性能提高 10 倍
* DBA 工作效率提高 2 倍
* 简化整体 IT 软件组合。
我们根据用户的技术要求提供了几个不同的版本 — 包括快捷版，该版本可以免费使用、开发和分发。此白皮书介绍了这些版本以及每个版本提供的特性。
有关详情，请参见通过 Oracle Database 11g 第 2 版降低 IT 成本 (PDF)。还可以参考这里的视频、音频和其他白皮书。
查看可以扩展 Oracle Database 11g 企业版功能的数据库选件。
Oracle Database 11g 第 2 版企业版基于运行 Windows、Linux 和 UNIX 的集群服务器或单个服务器提供行业领先的性能、可伸缩性、安全性和可靠性。它提供全面的特性，可以轻松管理要求最高的事务处理、业务智能和内容管理应用程序。
Oracle Database 11g 第 2 版企业版还提供众多选件来扩展全球第一的数据库，以帮助企业发展业务并达到用户期望的性能、安全性和可用性服务级别。
CBT Nuggets - Oracle Database 11g SQL Fundamentals 1 1Z0-051
Data, data everywhere.. take control of your database and learn to
manipulate it with the tried-and-true Structured Query Language (SQL) in
Oracle Database 11g. Whether youre an IT pro who wants to add Oracle DBA
and SQL querying to your tool belt, a DBA in another technology who wants
to dive into Oracle, or a newcomer to relational databases who yearns to
learn SQL, this series will give you what you need to reach your goal.
In this course, youll gain SQL proficiency and be able to take control
of your data. Best of all, you can apply the skills you learn not only to
Oracle, but to almost any RDBMS platform! And, trainer Tim Warner gives
you all sorts of cool supplemental learning references all of the SQL
work files can bee downloaded free at nuggetlab.com, and the course is
filled with recommendations for white papers, Web sites and more.
Once you've finished this Nugget series, youll be fully prepared to pass
the 1Z0-051 SQL Fundamentals exam and be ready to move on to the next
in line for the Oracle DBA OCA track. More importantly, youll gain an
extremely useful and portable tool that will help you make the most of
1. Extract the RAR-files.
2. Mount the image.
3. Run it.
1 Course Introduction
In this nugget, we start by defining what Oracle is and how it fits into the concepts of the database, relational database, and relational database management system. Next we perform a deep-dive into the Oracle certification program, learning exactly how the current course maps to the Oracle Certified Associate (OCA) credential. We also provide tips and tricks for getting the most out of the training, and give suggestions on how to pass the 1Z0-051 exam with a minimum of muss or fuss.
2 About SQL
In this nugget, we set the stage for the rest of the training. Here we formally define the Structured Query Language (SQL), explaining its basic modes of operation, as well as how Oracle's implementation of SQL stacks up to the ANSI/ISO standard as well as other vendors' implementations. We complete this nugget with quick-start tutorials on how to use SQL*Plus as well as Oracle SQL Developer.
3 Retrieving Data By Using the SELECT Statement
The SELECT statement is the universal workhorse of SQL. In this nugget we discuss both the theory and practice of using SELECT to retrieve query results from Oracle database.
4 Restricting and Sorting Data
In this nugget we continue our discussion of the SQL SELECT statement, this time learning how to pare down our query results by employing the powerful WHERE clause. We also learn how to sort our query results by leveraging the ORDER BY statement, and finally begin to write more dynamic, interactive SQL by using substitution variables.
5 Using Single-Row Functions to Customize Output
In this nugget we introduce the concept of the function, both from a general mathematics standpoint, and then with sharper focus on Oracle Database 11g. We spend our time learning to master the basic character, number, and date functions that you'll be expected to understand on the SQL Fundamentals certification exam.
6 Reporting Aggregated Data Using the Group Functions
In this nugget we apply many of the function-related principles we picked up in the previous nugget. Here we learn how to aggregate data across multiple table rows by employing both grouping functions as well as the GROUP BY SQL statement. We also will understand how to filter grouped rows by using the HAVING clause.
7 PL/SQL Basics
In this nugget we truly round out our Oracle SQL skills by conducting a survey of PL/SQL, Oracle's procedural programming extensions to the Structured Query Language. By the end of this nugget you will not only understand the basic nomenclature and syntax of PL/SQL, but you'll also be able to write basic PL/SQL blocks, both the anonymous and named varieties.
8 Displaying Data from Multiple Tables
In this nugget we truly begin to see the great beauty of the relational database model. Here we learn how to query across multiple related tables by using joins. In addition to learning all about the supported join types in Oracle Database, we will also flirt around with the concept of constraints, two of which (primary key and foreign key) are crucial to our understanding of the relational model.
9 Using Subqueries
In this nugget we broaden and deepen our usage of the SELECT statement by learning how to embed one SELECT inside of another SELECT; this is called a subquery. As we'll learn, subqueries are useful for data load scenarios as well as when we aren't quite sure which row(s) we need to evaluate in a WHERE clause. By the end of this nugget you will not only understand how subqueries work, but you'll be able to write both single-row and multi-row subqueries in either the simple or correlated processing formats.
10 Using the Set Operators
SQL is a set-oriented database access language. In this nugget we learn various methods of combining multiple result sets. Here we master the use of the UNION, MINUS, and INTERSECT keywords in combining multiple queries into a single result set.
11 Using DDL Statements to Create and Manage Tables
In this nugget we formally treat the subject of creating, altering, and dropping database objects; this collection of SQL commands is formally called Data Definition Language, or DDL. In this nugget we start with a high-level overview of the major database objects. We then follow up with learning how to design and create tables, and then conclude with a consideration of the importance and use of integrity constraints in database tables and views.
12 Creating Other Schema Objects Part 1
In this nugget we continue the discussion we opened in the previous nugget on DDL statements in Oracle Database 11g. Here we learn how to design and implement sequences and views.
13 Creating Other Schema Objects Part 2
Indexes, when properly designed and used, can dramatically speed up query performance in an RDBMS. In this nugget we cover the fundamental points concerning indexes. We also learn just what synonyms are--not in the English grammar context, but instead in the Oracle database nomenclature.
14 Manipulating Data Part 1
Thus far in the course we have covered the use of SELECT and the DDL command suite. Formally speaking, SELECT is actually one of the Data Manipulation Language (DML) statements in SQL. In this nugget we cover two of the major DML players, namely the INSERT and UPDATE statements.
15 Manipulating Data Part 2
In this nugget we "book end" our discussion from Nugget #14, wrapping up our consideration of basic DML by investigating the finer points of the DELETE statement. We also define and discuss what database transactions are as well as how to control their operation in Oracle Database 11g.
16 Basic Oracle Database Security
Relational database security is a huge topic and can constitute a very lucrative career for those who are so talented and interested. In this nugget we survey some of the major principles behind user account security in Oracle Database 11g. In particular, we learn how to create and administer Oracle user accounts. We then delve into access control, learning how to leverage the GRANT and REVOKE statements. We complete this nugget with some best-practice advice on leveraging database roles to make our database security more efficient and effective.
17 Accessing the Data Dictionary
The data dictionary in Oracle Database 11g is a read-only collection of tables that stores metadata about the database. As such, an understanding of the data dictionary is crucial for anyone who presents himself or herself as an Oracle DBA. By the conclusion of this nugget you will not only be able to intelligently discuss the data dictionary, but you will also know how to query the data dictionary views as an ordinary schema (user) and as a DBA.
18 Referencing the Oracle Documentation
While Oracle's documentation library is presented to the public at no charge, Oracle keeps much of the "good stuff" behind a paywall for, well, paying Oracle Support customers. The purpose of this nugget is to deeply familiarize you with the free and excellently written/organized corpus of technical documentation in the Oracle Web site. This is a best-kept secret of Oracle, and you should make the official Oracle Documentation a daily read as you build your skill set up and out.
19 Using Oracle Flashback Query
In the life of the DBA, restoring data that was accidentally or intentionally dropped or deleted can be a fairly regular occurrence. Here we turn to the nifty Flashback technology in Oracle Database 11g to learn first of all how Flashback works, and then how we can leverage Flashback to recover individual rows or entire tables from the ether. We'll also spend some time with the Oracle Recycle Bin.
20 Query Optimization Basics
In this concluding nugget of the series we apply everything we've learned over the course of this training and pick up some practical advice on how to tune and optimize our SQL queries. To start with we will explain how Oracle parses (interprets) SQL. We will then practice using the EXPLAIN PLAN statement to view the fine details of Oracle's query execution plans. Finally, we finish up with a "laundry list" of strategies for customizing how Oracle builds its execution plans.