About your course materials
Introduce your students to the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you teach those who have only a basic knowledge of databases how to master the latest SQL and Oracle concepts and techniques. Students gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths.
This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, manipulating data, and more. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins.To help students transition to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus.
Trust ORACLE 12C: SQL, 3E to provide the knowledge students need for Oracle certification testing and the solid foundation for pursuing careers as a database administrator or developer.
Frequently asked questions
How do I enroll in or join my course?
How do I redeem an access code, or what if my code isn't working?
Why can't I access my course?
Where can I find my eBook or textbook?
What if I don't have access to my course materials yet?
About this product
Introduce your students to the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you teach those who have only a basic knowledge of databases how to master the latest SQL and Oracle concepts and techniques. Students gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths.
This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, manipulating data, and more. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins.To help students transition to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus.
Trust ORACLE 12C: SQL, 3E to provide the knowledge students need for Oracle certification testing and the solid foundation for pursuing careers as a database administrator or developer.
CONTENT MAPS TO THE ORACLE CERTIFICATION EXAMS 1Z0-051 AND 1Z0-061. You can help students perform their best on the Oracle Database with the specific content they need to master -- whether they are taking the latest Oracle Database 12c: SQL Fundamentals version of the exam (1Z0-061) or the 11g version of the SQL Fundamentals exam (1Z0-051).
THIS EDITION PRESENTS MOST TOPICS IN ORACLE DATABASE SQL EXPERT EXAM1Z0-047. This edition lays the foundation to start preparing your students for success on the industry-recognized Oracle Database SQL Expert certification.
CLEAR CODING EXAMPLES WITH ASSOCIATED RESULTS DEMONSTRATE CHAPTER CONCEPTS. Students see the practical, hands-on application and value of the topics introduced in each chapter.
WELL-ORGANIZED PRESENTATION EMPHASIZES EARLY UNDERSTANDING OF DATABASE OBJECTS AND DESIGN. To ensure a logical approach to learning, the author provides a structural understanding of database objects and design prior to exploring the many query options.
Table of contents
Chapters
Chapter 1. Overview of Database ConceptsPreview this chapter
Resources
Instructor resources for this title can include manuals, test banks, educator guides, multimedia and companion sites. Sign in to see what is available.
Pricing and formats
Give students more with Cengage Unlimited
Choose the Cengage content and Learning Platform that fit your course while giving students access to Cengage Learning Platforms and our entire eBook library with one subscription.
4-12 month student access
eBook
Give students digital access to textbook content with tools to highlight, bookmark and search as they read.
Paperback

Still need support?




