Sale!

Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel

$35.00

-36%

Format: Digital copy DOC DOCX PDF RTF in a “ZIP file.”

Time: Immediately after payment is completed

All the chapters are included.

Need Information: Live Chat

15 in stock

Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel
Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel $55.00 $35.00
Only 15 items left in stock!
Countdown
Guaranteed Safe Checkout

Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel

Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel

Introduce 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 those who have only a basic knowledge of databases master the latest SQL and Oracle concepts and techniques. Learners 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, 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 readers 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. Readers can trust ORACLE 12C: SQL, 3E to provide the knowledge for Oracle certification testing and the solid foundation for pursuing a career as a successful database administrator or developer.

  1. IFC
  2. Title
  3. Statement
  4. Copyright
  5. Dedication
  6. Brief Contents
  7. Table of Contents
  8. Preface
  9. Read This Before You Begin
  10. Ch 1: Overview of Database Concepts
  11. Ch 1: Introduction
  12. Database Terminology
  13. Database Management System
  14. Database Design
  15. Structured Query Language (SQL)
  16. Databases Used in This Textbook
  17. Topic Sequence
  18. Software Used in This Textbook
  19. Ch 1: Chapter Summary
  20. Ch 1: Review Questions
  21. Ch 1: Multiple Choice
  22. Ch 1: Hands-On Assignments
  23. Ch 1: Advanced Challenge
  24. Ch 1: Case Study: City Jail
  25. Ch 2: Basic SQL SELECT Statements
  26. Ch 2: Introduction
  27. Creating the JustLee Books Database
  28. SELECT Statement Syntax
  29. Operations in the SELECT Statement
  30. Ch 2: Chapter Summary
  31. Chapter 2: Syntax Summary
  32. Ch 2: Review Questions
  33. Ch 2: Multiple Choice
  34. Ch 2: Hands-On Assignments
  35. Ch 2: Advanced Challenge
  36. Ch 2: Case Study: City Jail
  37. Ch 3: Table Creation and Management
  38. Ch 3: Introduction
  39. Table Design
  40. Table Creation
  41. Table Creation with Subqueries
  42. Modifying Existing Tables
  43. Deleting a Table
  44. Ch 3: Chapter Summary
  45. Chapter 3: Syntax Summary
  46. Ch 3: Review Questions
  47. Ch 3: Multiple Choice
  48. Ch 3: Hands-On Assignments
  49. Ch 3: Advanced Challenge
  50. Ch 3: Case Study: City Jail
  51. Ch 4: Constraints
  52. Ch 4: Introduction
  53. Creating Constraints
  54. Using the PRIMARY KEY Constraint
  55. Using the FOREIGN KEY Constraint
  56. Using the UNIQUE Constraint
  57. Using the CHECK Constraint
  58. Using the NOT NULL Constraint
  59. Including Constraints During Table Creation
  60. Adding Multiple Constraints on a Single Column
  61. Viewing Constraint Information
  62. Disabling and Dropping Constraints
  63. Ch 4: Chapter Summary
  64. Chapter 4: Syntax Summary
  65. Ch 4: Review Questions
  66. Ch 4: Multiple Choice
  67. Ch 4: Hands-On Assignments
  68. Ch 4: Advanced Challenge
  69. Ch 4: Case Study: City Jail
  70. Ch 5: Data Manipulation and Transaction Control
  71. Ch 5: Introduction
  72. Inserting New Rows
  73. Modifying Existing Rows
  74. Deleting Rows
  75. Using Transaction Control Statements
  76. Using Table Locks
  77. Ch 5: Chapter Summary
  78. Chapter 5: Syntax Summary
  79. Ch 5: Review Questions
  80. Ch 5: Multiple Choice
  81. Ch 5: Hands-On Assignments
  82. Ch 5: Advanced Challenge
  83. Ch 5: Case Study: City Jail
  84. Ch 6: Additional Database Objects
  85. Ch 6: Introduction
  86. Sequences
  87. Indexes
  88. Synonyms
  89. Ch 6: Chapter Summary
  90. Chapter 6: Syntax Summary
  91. Ch 6: Review Questions
  92. Ch 6: Multiple Choice
  93. Ch 6: Hands-On Assignments
  94. Ch 6: Advanced Challenge
  95. Ch 6: Case Study: City Jail
  96. Ch 7: User Creation and Management
  97. Ch 7: Introduction
  98. Data Security
  99. Creating a User
  100. Assigning User Privileges
  101. Managing Passwords
  102. Using Roles
  103. Viewing Privilege Information
  104. Removing Privileges and Users
  105. Ch 7: Chapter Summary
  106. Chapter 7: Syntax Summary
  107. Ch 7: Review Questions
  108. Ch 7: Multiple Choice
  109. Ch 7: Hands-On Assignments
  110. Ch 7: Advanced Challenge
  111. Ch 7: Case Study: City Jail
  112. Ch 8: Restricting Rows and Sorting Data
  113. Ch 8: Introduction
  114. Where Clause Syntax
  115. Comparison Operators
  116. Logical Operators
  117. Treatment of Null Values
  118. ORDER by Clause Syntax
  119. Ch 8: Chapter Summary
  120. Chapter 8: Syntax Summary
  121. Ch 8: Review Questions
  122. Ch 8: Multiple Choice
  123. Ch 8: Hands-On Assignments
  124. Ch 8: Advanced Challenge
  125. Ch 8: Case Study: City Jail
  126. Ch 9: Joining Data from Multiple Tables
  127. Ch 9: Introduction
  128. Cartesian Joins
  129. Equality Joins
  130. Non-Equality Joins
  131. Self-Joins
  132. Outer Joins
  133. Set Operators
  134. Ch 9: Chapter Summary
  135. Chapter 9: Syntax Summary
  136. Ch 9: Review Questions
  137. Ch 9: Multiple Choice
  138. Ch 9: Hands-On Assignments
  139. Ch 9: Advanced Challenge
  140. Ch 9: Case Study: City Jail
  141. Ch 10: Selected Single-Row Functions
  142. Ch 10: Introduction
  143. Case Conversion Functions
  144. Character Manipulation Functions
  145. Number Functions
  146. Date Functions
  147. Regular Expressions
  148. Other Functions
  149. The DUAL Table
  150. Ch 10: Chapter Summary
  151. Chapter 10: Syntax Summary
  152. Ch 10: Review Questions
  153. Ch 10: Multiple Choice
  154. Ch 10: Hands-On Assignments
  155. Ch 10: Advanced Challenge
  156. Ch 10: Case Study: City Jail
  157. Ch 11: Group Functions
  158. Ch 11: Introduction
  159. Group Functions
  160. Grouping Data
  161. Restricting Aggregated Output
  162. Nesting Functions
  163. Statistical Group Functions
  164. Enhanced Aggregation for Reporting
  165. Ch 11: Chapter Summary
  166. Chapter 11: Syntax Summary
  167. Ch 11: Review Questions
  168. Ch 11: Multiple Choice
  169. Ch 11: Hands-On Assignments
  170. Ch 11: Advanced Challenge
  171. Ch 11: Case Study: City Jail
  172. Ch 12: Subqueries and MERGE Statements
  173. Ch 12: Introduction
  174. Subqueries and Their Uses
  175. Single-Row Subqueries
  176. Multiple-Row Subqueries
  177. Multiple-Column Subqueries
  178. NULL Values
  179. Correlated Subqueries
  180. Nested Subqueries
  181. Subquery Factoring Clause
  182. DML Actions Using Subqueries
  183. MERGE Statements
  184. Ch 12: Chapter Summary
  185. Chapter 12: Syntax Summary
  186. Ch 12: Review Questions
  187. Ch 12: Multiple Choice
  188. Ch 12: Hands-On Assignments
  189. Ch 12: Advanced Challenge
  190. Ch 12: Case Study: City Jail
  191. Ch 13: Views
  192. Ch 13: Introduction
  193. Creating a View
  194. Creating a Complex View
  195. Dropping a View
  196. Creating an Inline View
  197. Creating a Materialized View
  198. Ch 13: Chapter Summary
  199. Chapter 13: Syntax Summary
  200. Ch 13: Review Questions
  201. Ch 13: Multiple Choice
  202. Ch 13: Hands-On Assignments
  203. Ch 13: Advanced Challenge
  204. Ch 13: Case Study: City Jail
  205. Appendix A: Tables for the JustLee Books Database
  206. Appendix B: SQL*Plus and SQL Developer Overview
  207. Appendix C: Oracle Resources
  208. Appendix D: SQL*Loader
  209. Appendix E: SQL Tuning Topics
  210. Appendix F: SQL in Various Databases
  211. Glossary
  212. Index
Free Sample Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel

For customer’s satisfaction, we provide free samples for any required Textbook solution or test bank to check and evaluate before making the final purchase..

If you require any further information, let me know. using Live Chat or Contact Us

Test bank for Oracle 12C SQL 3rd Edition by Joan Casteel