جستجوي كتاب

 

جستجوي مقالات

 

جستجوي فروشگاه
فروشگاه كتاب من
  دانلود نرم افزار
    اخبار سايت
راه اندازي وب سايت ‌Iran-eBook .....
سايت در حال بارگذاري و تكميل اطلاعات مي باشد !.
  آمار بازديد
 كاربران آنلاین:

12


 بازدید كل:

2473381

 آی پی شما:

54.224.166.141

 اطلاعات بیشتر:

جستجوهاي رايج:

Mastering Oracle SQL

بازديد: 2547
دفعات دانلود: 35

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle , and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of whats possible with Oracle , creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.

Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracles implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.

Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just dont explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

  1.      Chapter 1 Introduction to SQL

1.      What Is SQL?

2.      A Brief History of SQL

3.      A Simple Database

4.      DML Statements

5.      So Why Are There 17 More Chapters?

2.      Chapter 2 The WHERE Clause

1.      Life Without WHERE

2.      WHERE to the Rescue

3.      WHERE Clause Evaluation

4.      Conditions and Expressions

5.      WHERE to Go from Here

3.      Chapter 3 Joins

1.      What Is a Join Query?

2.      Join Conditions

3.      Types of Joins

4.      Joins and Subqueries

5.      DML Statements on a Join View

4.      Chapter 4 Group Operations

1.      Aggregate Functions

2.      The GROUP BY Clause

3.      The HAVING Clause

4.      Nested Group Operations

5.      Chapter 5 Subqueries

1.      What Is a Subquery?

2.      Noncorrelated Subqueries

3.      Correlated Subqueries

4.      Inline Views

5.      Subquery Case Study: The Top N Performers

6.      Chapter 6 Handling Temporal Data

1.      Time Zones

2.      Temporal Data Types in Oracle

3.      Literals of Temporal Types

4.      Getting Temporal Data In and Out of a Database

5.      Date and Time Formats

6.      Manipulating Temporal Data

7.      Chapter 7 Set Operations

1.      Set Operators

2.      Precedence of Set Operators

3.      Comparing Two Tables

4.      Using NULLs in Compound Queries

5.      Rules and Restrictions on Set Operations

8.      Chapter 8 Hierarchical Queries

1.      Representing Hierarchical Information

2.      Simple Hierarchy Operations

3.      Oracle SQL Extensions

4.      Complex Hierarchy Operations

5.      Restrictions on Hierarchical Queries

6.      Enhancements in Oracle Database 10g

9.      Chapter 9 DECODE and CASE

1.      DECODE, NULLIF, NVL, and NVL2

2.      The Case for CASE

3.      DECODE and CASE Examples

10.     Chapter 10 Partitioning

1.      Partitioning Concepts

2.      Partitioning Tables

3.      Partitioning Indexes

4.      Partitioning Methods

5.      Specifying Partitions

6.      Partition Pruning

11.     Chapter 11 PL/SQL

1.      What Is PL/SQL?

2.      Procedures, Functions, and Packages

3.      Calling Stored Functions from Queries

4.      Restrictions on Calling PL/SQL from SQL

5.      Stored Functions in DML Statements

6.      The SQL Inside Your PL/SQL

12.     Chapter 12 Objects and Collections

1.      Object Types

2.      Collection Types

3.      Collection Instantiation

4.      Querying Collections

5.      Collection Unnesting

6.      Collection Functions

7.      Comparing Collections

8.      Manipulating Collections

9.      Multilevel Collections

13.     Chapter 13 Advanced Group Operations

1.      Multiple Summary Levels

2.      Pushing the GROUPING Envelope

3.      The GROUPING_ID and GROUP_ID Functions

14.     Chapter 14 Advanced Analytic SQL

1.      Analytic SQL Overview

2.      Ranking Functions

3.      Windowing Functions

4.      Reporting Functions

5.      Summary

15.     Chapter 15 SQL Best Practices

1.      Know When to Use Specific Constructs

2.      Avoid Unnecessary Parsing

3.      Consider Literal SQL for Decision-Support Systems

16.     Chapter 16 XML

1.      What Is XML?

2.      Storing XML Data

3.      Generating XML Documents

4.      Summary

17.     Chapter 17 Regular Expressions

1.      Elementary Regular Expression Syntax

2.      Advanced Function Options

3.      Advanced Regular Expression Syntax

18.     Chapter 18 Model Queries

1.      Basic Elements of a Model Query

2.      Cell References

3.      Rules

4.      Iterative Models

5.      Reference Models

1.      Appendix A Oracle s Old Join Syntax

1.      Old Inner Join Syntax

2.      Old Outer Join Syntax

3.      Advantages of the New Join Syntax

       
گروه بندي: کامپيوتر/بانکهای اطلاعاتی
       
نام : Mastering Oracle SQL نوع فايل : كتاب
       
نويسنده : Alan Beaulieu, Sanjay Mishra زبان: انگليسي
       
مترجم: ساختار فايل: Zip
       
تاريخ انتشار: 2002 تاريخ بارگذاري: 1391/08/21
       
بارگذاري توسط: مدير سايت اندازه فايل: 322.68 KB
       
دفعات بازديد: 2547 دفعات دانلود: 35
       
رمز فايل: www.iran-ebook.com
   

ارسال به دوستان
اضافه كردن به كتابخانه شخصي
پرسش و پاسخ:0
اضافه کردن به سبد خرید
  ورود كاربران
نام كاربري:
   
نالمه عبور:
   
عبارت پايين را تايپ کنيد :
CAPTCHA Image
رمز عبور را فراموش كرده ام!
ارسال كتاب به ایمیل

شما هم به جمع ما بپیوندید!

با وارد كردن آدرس ایمیل خود هر كتاب وارد شده به ایران ایبوك را در ایمیل خود مشاهده كنید .

آدرس ایمیل:

لیست دوستان و همكاران