000890479 000__ 03731cam\a2200457Ki\4500 000890479 001__ 890479 000890479 005__ 20230306150105.0 000890479 006__ m\\\\\o\\d\\\\\\\\ 000890479 007__ cr\cn\nnnunnun 000890479 008__ 190518s2019\\\\nyu\\\\\o\\\\\001\0\eng\d 000890479 019__ $$a1101279661$$a1103607320$$a1105174625 000890479 020__ $$a9781484245170 000890479 020__ $$a1484245172 000890479 020__ $$z1484245164 000890479 020__ $$z9781484245163 000890479 0247_ $$a10.1007/978-1-4842-4 000890479 035__ $$aSP(OCoLC)on1101790330 000890479 035__ $$aSP(OCoLC)1101790330$$z(OCoLC)1101279661$$z(OCoLC)1103607320$$z(OCoLC)1105174625 000890479 040__ $$aEBLCP$$beng$$erda$$cEBLCP$$dYDX$$dTEFOD$$dEBLCP$$dZ5A$$dGW5XE$$dTEFOD$$dOH1$$dUMI$$dYDXIT$$dLQU$$dC6I 000890479 049__ $$aISEA 000890479 050_4 $$aQA76.9.D3$$bH45 2019 000890479 08204 $$a005.75/65$$223 000890479 1001_ $$aHeller, Jon,$$eauthor. 000890479 24510 $$aPro Oracle SQL development :$$bbest practices for writing advanced queries /$$cJon Heller. 000890479 264_1 $$a[New York, New York] :$$bApress,$$c[2019] 000890479 300__ $$a1 online resource (611 pages) 000890479 336__ $$atext$$btxt$$2rdacontent 000890479 337__ $$acomputer$$bc$$2rdamedia 000890479 338__ $$aonline resource$$bcr$$2rdacarrier 000890479 500__ $$aIncludes index. 000890479 50500 $$gPart I.$$tLearn How to Learn : --$$g1.$$tUnderstand Relational Databases --$$g2.$$tCreate an Efficient Database Development Process --$$g3.$$tIncrease Confidence and Knowledge with Testing --$$g4.$$tFind Reliable Sources --$$g5.$$tMaster the Entire Stack --$$gPart II.$$tWrite Powerful SQL with Sets and Advanced Features : --$$g6.$$tBuild Sets with Inline Views and ANSI Join Syntax --$$g7.$$tQuery the Database with Advanced SELECT Features --$$g8.$$tModify Data with Advanced DML --$$g9.$$tImprove the Database with Advanced Oracle Schema Objects --$$g10.$$tOptimize the Database with Oracle Architecture --$$gPart III.$$tWrite Elegant SQL with Patterns and Styles : --$$g11.$$tStop Coding and Start Writing --$$g12.$$tWrite Large SQL Statements --$$g13.$$tWrite Beautiful SQL Statements --$$g14.$$tUse SQL More Often with Basic Dynamic SQL --$$g15.$$tAvoid Anti-Patterns --$$gPart IV.$$tImprove SQL Performance : --$$g16.$$tUnderstand SQL Performance with Algorithm Analysis --$$g17.$$tUnderstand SQL Tuning Theories --$$g18.$$tImprove SQL Performance --$$gPart V.$$tSolve Anything with Oracle SQL : --$$g19.$$tSolve Challenging Problems with Arcane SQL Features --$$g20.$$tUse SQL More Often with Advanced Dynamic SQL --$$g21.$$tLevel Up Your Skills with PL/SQL --$$gPart VI.$$tAppendices : --$$gAppendix A.$$tSQL Style Guide Cheat Sheet --$$gAppendix B.$$tComputer Science Topics. 000890479 506__ $$aAccess limited to authorized users. 000890479 520__ $$aPro 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. 000890479 63000 $$aOracle (Computer file) 000890479 650_0 $$aDatabase management$$xComputer programs. 000890479 650_0 $$aSQL/ORACLE (Computer program language) 000890479 77608 $$iPrint version:$$aHeller, Jon$$tPro Oracle SQL Development : Best Practices for Writing Advanced Queries$$dBerkeley, CA : Apress L. P.,c2019$$z9781484245163 000890479 852__ $$bebk 000890479 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-4517-0$$zOnline Access$$91397441.1 000890479 909CO $$ooai:library.usi.edu:890479$$pGLOBAL_SET 000890479 980__ $$aEBOOK 000890479 980__ $$aBIB 000890479 982__ $$aEbook 000890479 983__ $$aOnline 000890479 994__ $$a92$$bISE