國立高雄大學圖資館 |

Language: English

Back

Pro Oracle SQL developmentbest pract...

Heller, Jon.

Pro Oracle SQL developmentbest practices for writing advanced queries /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Pro Oracle SQL developmentby 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 managementComputer programs.
Online resource:	https://doi.org/10.1007/978-1-4842-4517-0
ISBN:	9781484245170$q(electronic bk.)

Pro Oracle SQL developmentbest 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$q(electronic bk.)

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

Oracle (Computer file)
Subjects--Topical Terms:

202306
Database management
--Computer programs.

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

Dewey Class. No.: 005.7565

Pro Oracle SQL developmentbest practices for writing advanced queries /
LDR:02587nmm a2200325 a 4500 001 559208
003 DE-He213
005 20191107152139.0
006 m d
007 cr nn 008maaau
008 191219s2019 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 842131
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 200209
650 0 $a Database management $x Computer programs. $3 202306
650 0 $a SQL/ORACLE (Computer program language) $3 535857
650 1 4 $a Database Management. $3 273994
710 2 $a SpringerLink (Online service) $3 273601
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)