Oracle Database 11g : Hands-On Sql & Pl/sql

2010 Database management

Author : Satish Asnani
Release : 2010
Genre : Database management
Kind : eBook
Book Rating : 205/5 ( reviews)

GET EBOOK

Book Synopsis Oracle Database 11g : Hands-On Sql & Pl/sql by : Satish Asnani

Download or read book Oracle Database 11g : Hands-On Sql & Pl/sql written by Satish Asnani. This book was released on 2010. Available in PDF, EPUB and Kindle. Book excerpt: The book teaches the basics of the Oracle database from a beginner s perspective to the advanced concepts using a hands-on approach. Each and every concept has been elaborated with suitable practical examples along with code for clear and precise understanding of the topic. Using a practical approach, the book explains how to retrieve, add, update and delete data in the Oracle database using SQL, SQL*PLUS and PL/SQL. In the process, it discusses the various data types and built-in functions of Oracle, as well as the sorting of records and the table operations. The text also includes coverage of advanced queries using special operators, Oracle security, indexing, and stored functions and procedures. The book is suitable for undergraduate engineering students of Computer Science and Information Technology, B.Sc. (Computer Science/IT), M.Sc. (Computer Science/IT) and students of Computer Applications (BCA, MCA, PGDCA, and DCA). Besides, the book can be used as a reference by professionals pursuing short-term courses on Oracle Database and students of Oracle Certified Courses.

Oracle Database 11g PL/SQL Programming Workbook

2010-02-10 Computers

Author : Michael McLaughlin
Release : 2010-02-10
Genre : Computers
Kind : eBook
Book Rating : 410/5 ( reviews)

GET EBOOK

Book Synopsis Oracle Database 11g PL/SQL Programming Workbook by : Michael McLaughlin

Download or read book Oracle Database 11g PL/SQL Programming Workbook written by Michael McLaughlin. This book was released on 2010-02-10. Available in PDF, EPUB and Kindle. Book excerpt: Ramp Up Your PL/SQL Programming Skills Master PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will benefit from this practical resource. Understand the Oracle development architecture and the mechanics of connections Work with data types, structures, blocks, cursors, and PL/SQL semantics Write, deploy, and use functions, procedures, and packages Manage transactions and more Use dynamic SQL statements in real-world applications Support online transaction processing and data warehousing applications with external tables Find syntax samples and best practices to solve problems Write, deploy, and use object types For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Oracle Db 11G Pl/Sql Prog.

2010-03

Author : Michael Mclaughlin
Release : 2010-03
Genre :
Kind : eBook
Book Rating : 264/5 ( reviews)

GET EBOOK

Book Synopsis Oracle Db 11G Pl/Sql Prog. by : Michael Mclaughlin

Download or read book Oracle Db 11G Pl/Sql Prog. written by Michael Mclaughlin. This book was released on 2010-03. Available in PDF, EPUB and Kindle. Book excerpt: This book teaches all the Oracle PL/SQL skills needed through hands on, real-world labs, extensive examples, exercises, and projects. The workbook provides detailed examples and problems that supplement and leverage material presented in Oracle Database 11g PL/SQL Programming, and uses the same video store example throughout. The book can be used as a stand-alone learning tool filled with practical examples or in combination with the programming title. All of the enhancements and improvements made to PL/SQL with the release of Oracle Database 11g are covered in the book. Even experienced Oracle professionals will benefit from this practical guide.

Oracle 11G

2014-06-25 Computers

Author : Joan Casteel
Release : 2014-06-25
Genre : Computers
Kind : eBook
Book Rating : 029/5 ( reviews)

GET EBOOK

Book Synopsis Oracle 11G by : Joan Casteel

Download or read book Oracle 11G written by Joan Casteel. This book was released on 2014-06-25. Available in PDF, EPUB and Kindle. Book excerpt: ORACLE 11G: SQL is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.

Oracle PL/SQL by Example

2008-08-15 Computers

Author : Benjamin Rosenzweig
Release : 2008-08-15
Genre : Computers
Kind : eBook
Book Rating : 705/5 ( reviews)

GET EBOOK

Book Synopsis Oracle PL/SQL by Example by : Benjamin Rosenzweig

Download or read book Oracle PL/SQL by Example written by Benjamin Rosenzweig. This book was released on 2008-08-15. Available in PDF, EPUB and Kindle. Book excerpt: This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example , Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers. One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice. This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes • Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL’s role in PL/SQL • Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements • Efficiently handling errors and exceptions • Working with cursors and triggers, including Oracle 11g’s powerful new compound triggers • Using stored procedures, functions, and packages to write modular code that other programs can execute • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced PL/SQL capabilities • Handy reference appendices: PL/SQL formatting guide, sample database schema, ANSI SQL standards reference, and more

Popular eBooks

Oracle Database 11g : Hands-On Sql & Pl/sql

Oracle Database 11g PL/SQL Programming Workbook

Oracle Db 11G Pl/Sql Prog.

Oracle 11G

Oracle PL/SQL by Example

You may also like...