Cargando…
OCA Oracle database 11g : SQL fundamentals I exam guide (exam 1Z0-051) /
"Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill,
©2008.
|
| Colección: | McGraw Hill professional.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_ocn233972234 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 080715s2008 nyu o 001 0 eng d | ||
| 010 | |a 2008018686 | ||
| 040 | |a N$T |b eng |e pn |c N$T |d OCLCQ |d YDXCP |d OCLCQ |d B24X7 |d OCLCQ |d MERUC |d CCO |d E7B |d TEFOD |d IDEBK |d QE2 |d UMI |d CEF |d DEBSZ |d FVL |d OCLCQ |d OCLCO |d OCLCA |d OCLCF |d OCLCQ |d OCLCO |d OCL |d OCLCO |d OCLCQ |d OCLCO |d TEFOD |d NNO |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d BRL |d TOH |d VT2 |d UKAHL |d EBLCP |d OCLCQ |d HS0 |d INARC |d S2H |d TWCYT |d OPV |d OCLCO | ||
| 019 | |a 277086598 |a 471127864 |a 560654215 |a 646743307 |a 670428511 |a 722662737 |a 728034927 |a 746503674 |a 815567401 |a 1037512631 |a 1103259644 |a 1129338204 |a 1153016550 |a 1288250474 |a 1339038548 |a 1395780487 | ||
| 020 | |a 9780071643801 |q (electronic bk.) | ||
| 020 | |a 007164380X |q (electronic bk.) | ||
| 020 | |a 1281332852 | ||
| 020 | |a 9781281332851 | ||
| 020 | |z 9780071597869 |q (alk. paper) | ||
| 020 | |z 0071597867 |q (alk. paper) | ||
| 020 | |a 9786611332853 | ||
| 020 | |a 6611332855 | ||
| 029 | 1 | |a AU@ |b 000053252159 | |
| 029 | 1 | |a DEBSZ |b 355393840 | |
| 029 | 1 | |a HEBIS |b 291467253 | |
| 035 | |a (OCoLC)233972234 |z (OCoLC)277086598 |z (OCoLC)471127864 |z (OCoLC)560654215 |z (OCoLC)646743307 |z (OCoLC)670428511 |z (OCoLC)722662737 |z (OCoLC)728034927 |z (OCoLC)746503674 |z (OCoLC)815567401 |z (OCoLC)1037512631 |z (OCoLC)1103259644 |z (OCoLC)1129338204 |z (OCoLC)1153016550 |z (OCoLC)1288250474 |z (OCoLC)1339038548 |z (OCoLC)1395780487 | ||
| 037 | |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 037 | |a B9107C58-A65A-41AE-B7CB-6B2C99D7CBAE |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.3 |b .W3566 2008eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 072 | 7 | |a K |2 bicssc | |
| 082 | 0 | 4 | |a 005.75/65 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Watson, John, |d 1946 April 5- | |
| 245 | 1 | 0 | |a OCA Oracle database 11g : |b SQL fundamentals I exam guide (exam 1Z0-051) / |c John Watson, Roopesh Ramklass. |
| 260 | |a New York : |b McGraw-Hill, |c ©2008. | ||
| 300 | |a 1 online resource | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a McGraw Hill professional | |
| 500 | |a Title from PDF title page (viewed July 15, 2008). | ||
| 500 | |a Excludes information from CD-ROM that accompanied the print version of the book. | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a Cover -- Contents -- Introduction -- 1 Oracle Server Technologies and the Relational Paradigm -- Position the Server Technologies -- The Oracle Server Architecture -- The Oracle Application Server -- Oracle Enterprise Manager -- Grid Computing -- Exercise 1-1: Investigate Your Database and Application Environment -- Development Tools and Languages -- Understand Relational Structures -- Rows and Tables -- Data Normalization -- Exercise 1-2: Perform an Extended Relational Analysis -- Summarize the SQL Language -- SQL Standards -- SQL Commands -- A Set-oriented Language -- Use the Client Tools -- SQL*Plus -- SQL Developer -- Create the Demonstration Schemas -- Users and Schemas -- The HR and OE Schemas -- Demonstration Schema Creation -- Two-Minute Drill -- Q & A: Self Test -- Lab Question -- Self Test Answers -- Lab Answer -- 2 Data Retrieval Using the SQL SELECT Statement -- List the Capabilities of SQL SELECT Statements -- Introducing the SQL SELECT Statement -- The DESCRIBE Table Command -- Exercise 2-1: Describing the Human Resources Schema -- Capabilities of the SELECT Statement -- Execute a Basic SELECT Statement -- Syntax of the Primitive SELECT Statement -- Rules Are Meant to be Followed -- Exercise 2-2: Answering Our First Questions with SQL -- SQL Expressions and Operators -- NULL Is Nothing -- Exercise 2-3: Experimenting with Expressions and the DUAL Table -- Two-Minute Drill -- Q & A: Self Test -- Lab Question -- Self Test Answers -- Lab Answer -- 3 Restricting and Sorting Data -- Limit the Rows Retrieved by a Query -- The WHERE clause -- Comparison Operators -- Exercise 3-1: Using the LIKE Operator -- Boolean Operators -- Precedence Rules -- Sort the Rows Retrieved by a Query -- The ORDER BY Clause -- Exercise 3-2: Sorting Data Using the ORDER BY Clause -- Ampersand Substitution -- Substitution Variables -- Define and Verify -- Exercise 3-3: Using Ampersand Substitution -- Two-Minute Drill -- Q & A: Self Test -- Lab Question -- Self Test Answers -- Lab Answer -- 4 Single-Row Functions -- Describe Various Types of Functions Available in SQL -- Defining a Function -- Types of Functions -- Use Character, Number, and Date Functions in SELECT Statements -- Using Character Case Conversion Functions -- Exercise 4-1: Using the Case Conversion Functions -- Using Character Manipulations Functions -- Exercise 4-2: Using the Case Manipulation Functions -- Using Numeric Functions -- Working with Dates -- Using Date Functions -- Exercise 4-3: Using the Date Functions -- Two-Minute Drill -- Q & A: Self Test -- Lab Question -- Self Test Answers -- Lab Answer -- 5 Using Conversion Functions and Conditional Expressions -- Describe Various Types of Conversion Functions Available in SQL -- Conversion Functions -- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions -- Using the Conversion Functions -- Exercise 5-1: Converting Dates into Characters Using the TO_CHAR Function -- Apply Conditional Expressions in a SELECT Statement -- Nesting Functions -- Exercise 5-2: Using NULLIF and NVL2 for Simple Conditional Logic -- Conditional Functions -- Exercise 5-3: Using the DECODE Function -- Two-Minute Drill -- Q & A: Self Test -- Lab Q. | |
| 520 | |a "Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference"--Resource description page | ||
| 546 | |a English. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Oracle (Computer file) |x Examinations. |
| 630 | 0 | 7 | |a Oracle (Computer file) / Examinations. |2 blmlsh |
| 630 | 0 | 7 | |a Oracle (Computer file) |2 fast |
| 650 | 0 | |a Electronic data processing personnel |x Certification |v Study guides. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Electronic data processing personnel |x Certification |x Study guides. |2 blmlsh | |
| 650 | 7 | |a Electronic data processing personnel |x Certification |2 fast | |
| 655 | 7 | |a examination study guides. |2 aat | |
| 655 | 7 | |a Examinations |2 fast | |
| 655 | 7 | |a Study guides |2 fast | |
| 655 | 7 | |a Study guides. |2 lcgft | |
| 655 | 7 | |a Guides de l'étudiant. |2 rvmgf | |
| 700 | 1 | |a Ramklass, Roopesh. | |
| 776 | 0 | 8 | |i Print version: |a Watson, John. |t OCA Oracle database 11g. |d New York : McGraw-Hill, ©2008 |w (DLC) 2008018686 |
| 830 | 0 | |a McGraw Hill professional. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780071597869/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH25200960 | ||
| 938 | |a Books 24x7 |b B247 |n bks00026824 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6254854 | ||
| 938 | |a EBSCOhost |b EBSC |n 228450 | ||
| 938 | |a YBP Library Services |b YANK |n 2848486 | ||
| 938 | |a Internet Archive |b INAR |n ocaoracledatabas0000wats | ||
| 994 | |a 92 |b IZTAP | ||