Murach's Oracle SQL and PL SQL (Training & Reference) PDF
Preview Murach's Oracle SQL and PL SQL (Training & Reference)
murach’s Oracle SQL and PL/SQL TRAINING & REFERENCE murach’s Oracle SQL and PL/SQL works with all versions through 11g Joel Murach ‘Mike Muracu & Associates, INc. 1800221508 «($59) 409071 «Fx: (559) MOOBES mu ch.com + wane murach com Joel Muraet ‘Mike Murach Zytka Design ‘Tom Murach Cynthia Vasquez Books for Java developers Murach’s Java SE 6 ‘Murach’s Java Servlets and JSP, Second Ealtion Books for .NET developers -Murach's C# 2008 ‘Murach’s ASP.NET 3.5 Web Programming with C# 2008 Murach's Visual Basic 2008 Murach's ASP.NET 3.5 Web Programming with VB 2008 -Murach’s ADO.NET 2.0 Database Programming with VB 2005 -Murach's SQL Server 2005 for Developers Books for IBM mainframe programmers Murach's 08/390 and 2/08 ICL. ‘Murach’s Mainframe COBOL ‘Murach’s CICS forthe COBOL Programmer DB2 for he COBOL Programmer, Part 1 For more on Murach books, please visit us at www.murach.com (© 2008, Mike Murach & Associates, Inc. All rights reserved, Printed inthe United States of America 10987654321 ISBN: 978-1-890774-50-9 Contents Section 1 An introduction to SQL pte Beni Ear kee ed ad Wot chee sale karl Section 2 The essential SQL skills Wier 8 hens ed ah eh pier be tei Posen we ee haat Tee cacao ovat Wear Tees stele a oth hte i ple a ua hae Bee tha op rh ccrnlinnd os Section 4. The essential PL/SQL skills Iter 8 Shes eesti BLE hte hee gro beets teat bet hae Ie ee ne np cekess mE ama a Sh ater i be Section § Advanced data types ch pier “ Hs Pe skaap abr ats hoa SI Walaa te Reference Soc st Ih Wotan atbins ey be vndis Ws iy Sah Pepe iba tie Expanded contents Section 1 An introduction to SQL Chapter 1 An introduction to relational databases and SQL Chapter 2 How to use Oracle SQL Developer and other tools oss to war 80, 4 Section 2 The essential SQL skills, Chapter 3 How to retrieve data from a single table Chapter + ve data from two or more tables Expanded contents How to work With UNION snnnnnnnnsnnnnnnnnninnnns 160 ‘Thesynun of non aa?) Unio tt combine a fm ita aes ‘Union that combine a fo the same ale How to he MINUS an INTERSECT operator Perspective. How to code summary queries How to work with aggregate func erernnennonnsnnnenenmee 160 How to code agree into... (Queries ta use epee fnctions How to group and summarize data. How cote he GROUP BY and HAVING cs. (Queries tatu the GROUP BY ané HAVING ier Hw he HAVING clase compare tothe WHERE case Hoo code complex serch coos. How to summarize data using Oracle extensions ow o oe he ROLLUP operate ‘ow owe he CUBE opera Perspective. How to code subqueries [An introduction to subqueries How o ase sbguees 7 ow hur compart is. How to code subqueries In search condtions How ose subgues wh he IN operator How to compare the eral ogy wih an os se Hom the ALL Keyword . Sse ow he ANY 99 SOME Keyword a 1% How code cewete uberis SS wa ‘How owe he EXISTS operator ‘ther ways to use subqueries How code sbgueis in tbe FROM case . 196 ‘ow code susie inthe SELECT ease 96 “Two more ake for Working With eubqUet8 on nnencnnnrn 204 How code ahgury atorng le ‘ow cote a heart query on Perspective. Chapter 7 spanded contents How to Insert, update, and delete data How enateacopyofathe, 0 ow to omit nd rotbeck changes ow sconce’ ov olin corer How ltt aglow onan ‘Hom ne deta vas od ol laos cose How owe a ibqury to ine mip rows How oops tot ween vem 2 ow ea nbgeoryins DELETE werent ~ 6 How to work with data types and functions How the common charter fsa ae ‘How to unt aang ooo oqse ooo cist ow aor meds colus alphas sequen at How to work wth numerte data. How othe common namere non Tse How er lenin pi aes. ~ 28 Section 3 Database design and implementation Chapter 9 Chapter 10 How to design a database How to create tables, indexes, and sequences oa W use SOL Delage Perepeones
The list of books you might like
