國立虎尾科技大學 |

Pro Oracle SQL development = best practices for writing advanced queries /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Pro Oracle SQL development/ by Jon Heller.
Reminder of title:	best practices for writing advanced queries /
Author:	Heller, Jon.
Published:	Berkeley, CA :Apress : : 2019.,
Description:	xxxv, 596 p. :ill., digital ; : 24 cm.;
Contained By:	Springer eBooks
Subject:	Database management - Computer programs. -
Online resource:	https://doi.org/10.1007/978-1-4842-4517-0
ISBN:	9781484245170

Pro Oracle SQL development = best practices for writing advanced queries /
Heller, Jon.

Pro Oracle SQL developmentbest practices for writing advanced queries /[electronic resource] :by Jon Heller. - Berkeley, CA :Apress :2019. - xxxv, 596 p. :ill., digital ;24 cm.

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 practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL. Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and covers advanced topics and shows you how to become an Oracle expert. What You'll Learn: Understand the power of Oracle SQL and where to apply it Create a database development environment that is simple, scalable, and conducive to learning Solve complex problems that were previously solved in a procedural language Write large Oracle SQL statements that are powerful, simple, and fast Apply coding styles to make your SQL statements more readable Tune large Oracle SQL statements to eliminate and avoid performance problems.

ISBN: 9781484245170

Standard No.: 10.1007/978-1-4842-4517-0doiSubjects--Uniform Titles:

Oracle (Computer file)
Subjects--Topical Terms:

574148
Database management
--Computer programs.

LC Class. No.: QA76.9.D3 / H455 2019

Dewey Class. No.: 005.7565

Pro Oracle SQL development = best practices for writing advanced queries /
LDR:02587nam a2200325 a 4500 001 940802
003 DE-He213
005 20191107152139.0
006 m d
007 cr nn 008maaau
008 200417s2019 cau s 0 eng d
020 $a 9781484245170 $q (electronic bk.)
020 $a 9781484245163 $q (paper)
024 7 $a 10.1007/978-1-4842-4517-0 $2 doi
035 $a 978-1-4842-4517-0
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.9.D3 $b H455 2019
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.7565 $2 23
090 $a QA76.9.D3 $b H477 2019
100 1 $a Heller, Jon. $3 1227647
245 1 0 $a Pro Oracle SQL development $h [electronic resource] : $b best practices for writing advanced queries / $c by Jon Heller.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2019.
300 $a xxxv, 596 p. : $b ill., digital ; $c 24 cm.
520 $a 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 practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most out of Oracle SQL. Pro Oracle SQL Development is for anyone who already knows Oracle SQL and is ready to take their skills to the next level. Many developers, analysts, testers, and administrators use Oracle databases frequently, but their queries are limited because they do not have the knowledge, experience, or right environment to help them take full advantage of Oracle's advanced features. This book will inspire you to achieve more with your Oracle SQL statements through tips for creating your own style for writing simple, yet powerful, SQL. It teaches you how to think about and solve performance problems in Oracle SQL, and covers advanced topics and shows you how to become an Oracle expert. What You'll Learn: Understand the power of Oracle SQL and where to apply it Create a database development environment that is simple, scalable, and conducive to learning Solve complex problems that were previously solved in a procedural language Write large Oracle SQL statements that are powerful, simple, and fast Apply coding styles to make your SQL statements more readable Tune large Oracle SQL statements to eliminate and avoid performance problems.
630 0 0 $a Oracle (Computer file) $3 569317
650 0 $a Database management $x Computer programs. $3 574148
650 0 $a SQL/ORACLE (Computer program language) $3 815769
650 1 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer eBooks
856 4 0 $u https://doi.org/10.1007/978-1-4842-4517-0
950 $a Professional and Applied Computing (Springer-12059)