Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the
Master SQL Server’s Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and addr
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle’s power in implementing business logic, thereby maxim
本書通過對Oracle 12c和SQL Server 2016對應內容的對比講解，使相關技術人員能夠快速適應從Oracle到SQL Server或從SQL Server到Oracle的轉變，並對兩者的運作方式及體系結構有較深的理解。主要內容包括用戶端工具、SQL 語言、體系結構、事務及鎖、備份恢復等資料庫技術人員所需的各種必備知識。本書適合Oracle技術人員學習SQL Server或SQL Se
SQL tuning improvements existing execution plans. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution
This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12cThis comprehensive study guide from Oracle Press e
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put that theory into practice. In this book, Chris Date explai
An Oracle ACE Director reveals how to design world-class databases on any platform with this powerful, free tool.Oracle SQL Developer Data Modeler for Database Design Mastery provides best practices f
Learn Essential SQL and Database SkillsKnowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programm
Written by a Senior Database Administrator who has worked with the Oracle RDBMS for thirty years, this is a book which teaches the skill of SQL Tuning for the Oracle Database. Not a list of one-off tr
This exclusive Oracle Press certification exam guide prepares you for the SQL Fundamentals I exam.Ideal as both an exam guide and on-the-job reference, OCA Oracle Database 12c: SQL Fundamentals I Exam
