OCA Oracle Database 12c: SQL Fundamentals I Exam Guide (Exam 1Z0-061) : [complete Exam Preparation]

ISBN-10
0071820264
ISBN-13
9780071820264
Category
Electronic data processing personnel
Pages
550
Language
English
Published
2014
Author
Roopesh Ramklass

Description

Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the test and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including: - Data retrieval using the SQL SELECT statement - Restricting and sorting data - Single-row functions - Using conversion functions and conditional expressions - Reporting aggregated data with the group functions - Displaying data from multiple tables with joins - Using subqueries to solve problems - Using the set operators - Manipulating data with DML statements - Using DDL statements to create and manage tables

Similar books

  • Windows 98 MCSE xue xi zhi nan
    By 刘易斯, Morris Lewis, 库珀

    从入门到精通自学教材 MCSE考试教材

  • CCNA Routing and Switching Complete Deluxe Study Guide
    By Todd Lammle

    In this Deluxe edition, you will also get 20% off a year subscription and free access to a premium Cisco Switch Lab from the experts at ITProTV.

  • MCSE.: TCP/IP for NT Server 4 study guide
    By Todd Lammle, James Chellis, Monica Lammle

    Book includes authoritative coverage of exam topics. First CD includes an exam-preparation program, and the second CD includes live expert MCSE video instruction with hands-on exercises.

  • MCSE: TCP/IP for NT Server 4 Study Guide
    By Todd Lammle, James Chellis, Monica Lammle

    TCP/IP is the defacto protocol of the internet and a key component to Microsoft's enterprise networking strategy.

  • CCNA Routing and Switching ren zheng jiao zhan shou ce
    By Todd Lammle, William Tedder

    CCNA Routing and Switching ren zheng jiao zhan shou ce

  • CCNA Cisco certified network associate
    By Todd Lammle

    It was designed to follow along with Todd Lammle's best- selling CCNA: Cisco Certified Network Associate Study Guide published by Sybex. Todd Lammle is an industry-recognized expert in the field of network certification. \ \ \ ...

  • Cisco Networking Academy Program Fundamentals of Voice and Data Cabling Companion Guide
    By Cisco Networking Academy Program, Cisco Systems, Inc

    This book will help students learn how to do the following: read network design documentation, set up part lists and purchase components, pull and mount cable, choose wiring closets, install jacks, and perform cable testing.

  • CCNP Cisco Networking Academy Program: Multilayer Switching Companion Guide
    By Cisco Networking Academy Program, Cisco Systems, Wayne Lewis

    This companion guide supplements the most current Web-based curriculum for the Networking Academy, providing intermediate-level students with the knowledge and skills needed to pass the switching certification exam and to further their ...

  • Fundamentals of Java Programming Lab Companion
    By Cisco Networking Academy Program, Cisco Systems, Inc

    This lab manual supplements the Companion Guide and allows the student the opportunity to perform all the lab tasks related to the course, including the individual course project.

  • MCSE Windows 2000 Server 70-215
    By Kenneth C. Laudon

    Pearson Prentice HallTM is a trademark of Pearson Education , Inc. Pearson® is a registered trademark of Pearson ... of Pearson Education , Inc. PEARSON Prentice Hall 10 9 8 7 6 5 4 3 2 1 To our families , for their love , patience ,.