Descripción del título

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. *Takes an example-based approach, with clear and authoritative explanations *Introduces both SQL and the query tools used to execute SQL statements *Shows how to create tables, populate them with data, and then query that data to generate business resultsWhat you'll learn *Create database tables and define their relationships *Add data to your tables; change and delete that data *Write database queries that generate accurate results *Avoid common traps and pitfalls in writing SQL queries *Take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more *Get a handle on Oracle Database's support for object types in the databaseWho is this book for? This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed
Monografía
monografia Rebiun35620377 https://catalogo.rebiun.org/rebiun/record/Rebiun35620377 m o d cr cn||||||||| 110214s2009 caua o 001 0 eng d 2011276934 647135448 701369006 708566625 750173214 771434071 771434072 1005777860 1044232006 1056385967 1060873407 1071379359 1087349978 1087415310 1105592320 1162751665 1391180500 1391833486 1413277223 9781430271963 electronic bk.) 1430271965 electronic bk.) 9781430271970 1430271973 AU@ 000048715987 AU@ 000053259456 DEBSZ 396957986 NZ1 13875457 UPVA 996878187003706 UAM 991007634224904211 978-1-4302-7197-0 Springer http://www.springerlink.com GW5XE eng pn GW5XE VLB OCLCQ IAD OCLCQ IAD ORE E7B VT2 N$T OCLCF BEDGE DKDLA QE2 EBLCP MHW DEBSZ OCLCQ UAB MERUC ESU STF CEF B24X7 YDXCP DXU Z5A LIV IOG OCL OCLCQ OCLCO U3W COO OCLCQ OCLCO UWO YOU OCLCQ UKAHL OCLCQ OCLCO AUD OCLCQ BRF OCLCQ COM OCLCO OCLCQ INARC OCLCO OCLCL S9M COM 018000 bisacsh Beginning Oracle SQL Lex de Haan [and others] Berkeley, Calif. Apress New York Distributed to the Book trade in the United States by Springer-Verlag 2009 Berkeley, Calif. New York Berkeley, Calif. Apress New York Distributed to the Book trade in the United States by Springer-Verlag 1 online resource (xxiii, 423 pages) illustrations 1 online resource (xxiii, 423 pages) Text txt rdacontent computer c rdamedia online resource cr rdacarrier The expert's voice in Oracle Introduction -- Relational database systems and Oracle -- Introduction to SQL, AQL*Plus, and SQL developer -- Data definition, part I -- Retrieval: the basics -- Retrieval: functions -- Data manipulation -- Data definition, part II -- Retrieval: multiple tables and aggregation -- Retrieval: some advanced features -- Views -- Writing and automating SQL*Plus scripts -- Object-relational features University staff and students only. Requires University Computer Account login off-campus Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to cover the very latest developments in Oracle's version of the SQL query language. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. *Takes an example-based approach, with clear and authoritative explanations *Introduces both SQL and the query tools used to execute SQL statements *Shows how to create tables, populate them with data, and then query that data to generate business resultsWhat you'll learn *Create database tables and define their relationships *Add data to your tables; change and delete that data *Write database queries that generate accurate results *Avoid common traps and pitfalls in writing SQL queries *Take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more *Get a handle on Oracle Database's support for object types in the databaseWho is this book for? This book is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed Oracle (Computer file) Oracle (Computer file) SQL (Computer program language) SQL*PLUS (Computer program language) Relational databases Database management SQL (Langage de programmation) SQL*PLUS (Langage de programmation) Bases de données relationnelles Bases de données- Gestión COMPUTERS- Data Processing Informatique Database management Relational databases SQL (Computer program language) SQL*PLUS (Computer program language) Haan, Lex de Print version Beginning Oracle SQL. Berkeley, Calif. : Apress ; New York : Distributed to the Book trade in the United States by Springer-Verlag, 2009 9781430271970 (OCoLC)501076199 Expert's voice in Oracle