This manual is specially written for Students who are interested in understanding Structured Query Language and PL-SQL concepts in the Computer Engineering and Information technology field and wants... More > to gain enhance knowledge about power of SQL Language in Relational Database Management System Development.
The manual covers practical point of view in all aspects of SQL and PL/SQL including DDL, DML,DCL sublanguages, also there are practices for Views, Group by, Having Clause. All PL-SQL concepts like Condition and Loop Structures, Functions and Procedures, Cursor, Triggers, Locks are illustrated using best examples.< Less
Secret ORACLE is the definitive guide to undocumented and partially documented features of the ORACLE database server. This book will improve your efficiency as an ORACLE database administrator and... More > enable you to master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible. Topics covered include:
The MERITS performance optimization method, which extends the state-of-the-art wait event tuning paradigm.
Controlling processes of an ORACLE instance with the fragmentarily documented ORADEBUG command to trace SQL statements as well as wait events and dump process state, call stack, and hang analysis information.
Tracing the cost based optimizer to understand its cost calculations and decisions.
Understanding hidden parameters that govern Automatic PGA Memory Management.
Leveraging undocumented features of the Oracle10g/11g scheduler and other partially or fully undocumented PL/SQL packages, such as DBMS_SYSTEM, DBMS_SUPPORT, and DBMS_UTILITY.< Less
The main motivation behind writing this book is to teach the basic concepts of database systems through concrete and practical knowledge and examples without too many wordy and useless pages. The... More > book is made deliberately concise and short covering the main aspects of databases that you have to master and gain either for industrial or academic purposes. The main chapters includes within this book are: Introduction to Databases, Database Design, SQL : Structured Query Language, SQL : Structured Query Language, SQL Transactions, Procedures & Triggers, Object Relational Databases, Databases & Java Programming, Solutions & Answers. The book website can be accessed at : http://www.LearnDB.com< Less
A4 FORMAT -
The same document is available in Letter format (green cover).
Full 8 page transcription of a short video tutorial on database design,
complete with 15 screenshots from the original... More > presentation.< Less
LETTER (US) FORMAT -
The same document is available in A4 format (brown cover).
Full 8 page transcription of a short video tutorial on database design, complete with 15 screenshots from the original... More > presentation.< Less
1 Introduction to SQL.
2 Introduction to the Query: The SELECT Statement.
3 Expressions, Conditions, and Operators.
4 Functions: Molding the Data You Retrieve.
5 Clauses in SQL.
6... More > Joining Tables.
7 Sub queries: The Embedded SELECT Statement.
8 Manipulating Data.
9 Creating and Maintaining Tables.
10 Creating Views and Indexes.
11 Controlling Transactions.
12 Database Security.
13 Advanced SQL Topics.
14 Dynamic Uses of SQL.
15 Common SQL Mistakes/Error-Resolutions Appendixes.
Who Should Read This Book?
Suddenly a new project on your desk. This project looks just like the others you have been working on except it includes ties to several databases. You have seen terms like SQL, tables, records, queries, and RDBMS, but you don't remember exactly what they all mean. As you begin looking for definitions and sample code to put those definitions into context, you discover this book. This book is for people who want to learn the fundamentals of (SQL)--quickly.< Less
A4 FORMAT - The same document is available in Letter format (green cover).
Full 7 page transcription of a short video tutorial showing how to rewrite an SQL query in a more efficient way,
complete... More > with 10 screenshots from the original presentation.< Less