Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Oracle Database 11g SQL

Buy
Oracle Database 11g SQL, 9780071498500 (0071498508), McGraw-Hill, 2007
Today’s database management systems are accessed using a standard language known as Structured Query Language, or SQL. Among other things, SQL allows you to retrieve, add, update, and delete information in a database. In this book, you’ll learn how to master SQL, and you’ll find a wealth of practical examples. You can also get all the scripts and programs featured in this book online (see the last section, “Retrieving the Examples,” for details).

With this book, you will
  • Master standard SQL, as well as the extensions developed by Oracle Corporation for use with the specific features of the Oracle database.
  • Explore PL/SQL (Procedural Language/SQL), which is built on top of SQL and enables you to write programs that contain SQL statements.
  • Use SQL*Plus to execute SQL statements, scripts, and reports; SQL*Plus is a tool that allows you to interact with the database.
  • Execute queries, inserts, updates, and deletes against a database.
  • Create database tables, sequences, indexes, views, and users.
  • Perform transactions containing multiple SQL statements.
  • Define database object types and create object tables to handle advanced data.
  • Use large objects to handle multimedia files containing images, music, and movies.
  • Perform complex calculations using analytic functions.
  • Use all the very latest Oracle Database 11g features such as PIVOT and UNPIVOT, flashback archives, and much more.
  • Implement high-performance tuning techniques to make your SQL statements really fly.
(HTML tags aren't allowed.)

Bio-MEMS: Technologies and Applications
Bio-MEMS: Technologies and Applications
Microelectromechanical systems (MEMS) are evolving into highly integrated technologies for a variety of application areas. Add the biological dimension to the mix and a host of new problems and issues arise that require a broad understanding of aspects from basic, materials, and medical sciences in addition to engineering. Collecting the efforts of...
Reproductive Biology of Plants
Reproductive Biology of Plants

Reproductive biology is the basis of species improvement and a thorough understanding of this is needed for plant improvement, whether by conventional or biotechnological methods. This book presents an up to date and comprehensive description of reproduction in lower plants, gymnosperms and higher plants. It covers general plant biology,...

Foundation Adobe Edge Animate: for HTML5, CSS3, and JavaScript Development
Foundation Adobe Edge Animate: for HTML5, CSS3, and JavaScript Development

Foundation Adobe Edge Animate is a project-oriented book that will walk you through the features of Edge Animate - Adobe's exciting new motion and interaction tool for web standards development. Edge Animate is an application that allows web designers and developers to make full use of many of the features of CSS3,...


Macromedia Flash MX Fast & Easy Web Development
Macromedia Flash MX Fast & Easy Web Development
Don't spend your time wading through manuals to learn Macromedia Dreamweaver MX. Spend it doing what you do best-creating Web pages! Design, develop, and deliver Web pages like a pro. Integrate graphics, animations, or documents into your Web pages with ease. Combining easy-to-understand instructions with visual examples, Macromedia Dreamweaver MX...
Computer Architecture, Fifth Edition: A Quantitative Approach (The Morgan Kaufmann Series in Computer Architecture and Design)
Computer Architecture, Fifth Edition: A Quantitative Approach (The Morgan Kaufmann Series in Computer Architecture and Design)

The computing world today is in the middle of a revolution: mobile clients and cloud computing have emerged as the dominant paradigms driving programming and hardware innovation today. The Fifth Edition of Computer Architecture focuses on this dramatic shift, exploring the ways in which software and technology in the cloud are accessed...

Head First Algebra
Head First Algebra
Having trouble understanding algebra? Do algebraic concepts, equations, and logic just make your head spin? We have great news: Head First Algebra is designed for you. Full of engaging stories and practical, real-world explanations, this book will help you learn everything from natural numbers and exponents to solving systems of equations...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy