國立虎尾科技大學 |

Beginning Oracle SQL for Oracle Database 18c = From Novice to Professional /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	Beginning Oracle SQL for Oracle Database 18c/ by Ben Brumm.
其他題名:	From Novice to Professional /
作者:	Brumm, Ben.
面頁冊數:	XXVI, 431 p. 138 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Database management. -
電子資源:	https://doi.org/10.1007/978-1-4842-4430-2
ISBN:	9781484244302

Beginning Oracle SQL for Oracle Database 18c = From Novice to Professional /
Brumm, Ben.

Beginning Oracle SQL for Oracle Database 18cFrom Novice to Professional /[electronic resource] :by Ben Brumm. - 1st ed. 2019. - XXVI, 431 p. 138 illus.online resource.

Introduction -- Part I. Setting Up -- 1. What Is A Database? -- 2. Setting Up -- -- Part II. Viewing Data -- 3. Retrieving Data -- 4. Selecting Specific Columns -- 5. Restricting the Results -- 6. Comparing Data -- 7. Applying Multiple Filters -- 8. Working with NULLs -- 9. Removing Duplicate Results -- 10. Applying Filters on Lists and Ranges of Values -- 11. Ordering Your Data -- 12. Applying Table and Column Aliases -- Part III. Adding, Updating, Deleting Data -- 13. Understanding the Data Types -- 14. Creating A Table -- 15. Adding Data to A Table -- 16. Updating and Removing Data -- 17. Updating or Deleting a Table -- Part IV. Joining Tables -- 18. Inner Join -- 19. Outer Join -- 20. Other Join Types -- 21. Joining Many Tables -- Part V. Functions -- 22. Using Functions in SQL -- 23. Writing Conditional Logic -- 24. Understanding Aggregate Functions -- 25. Grouping Your Results -- 26. What Are Indexes? -- Part VI. Command Line -- 27. Using the Command Line -- Part VII. Appendixes -- 28. Appendix. How to Find and Navigate the Oracle SQL Reference.

Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. You'll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download. A marquee feature of Beginning Oracle SQL for Oracle Database 18c is the small chapter size. Content is divided into easily digestible chunks that can be read and practiced in very short intervals of time, making this the ideal book for a busy professional to learn from. Even just a 15-20 minute block of free time can be put to good use. Author Ben Brumm begins by helping you understand what a database is, and getting you set up with a sandbox in which to practice the SQL that you are learning. From there, easily digestible chapters cover, point-by-point, the different aspects of writing queries to get data out of a database. You’ll also learn about creating tables and getting data into the database. Crucial topics such as working with nulls and writing analytic queries are given the attention they deserve, helping you to avoid pitfalls when writing queries for production use. What You'll Learn: Create, update, and delete tables in an Oracle database Add, update, delete data from those database tables Query and view data stored in your database Manipulate and transform data using in-built database functions and features Correctly choose when to use Oracle-specific syntax and features.

ISBN: 9781484244302

Standard No.: 10.1007/978-1-4842-4430-2doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Beginning Oracle SQL for Oracle Database 18c = From Novice to Professional /
LDR:04190nam a22003975i 4500 001 1003602
003 DE-He213
005 20200705174855.0
007 cr nn 008mamaa
008 210106s2019 xxu| s |||| 0|eng d
020 $a 9781484244302 $9 978-1-4842-4430-2
024 7 $a 10.1007/978-1-4842-4430-2 $2 doi
035 $a 978-1-4842-4430-2
050 4 $a QA76.9.D3
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.74 $2 23
100 1 $a Brumm, Ben. $e author. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1296992
245 1 0 $a Beginning Oracle SQL for Oracle Database 18c $h [electronic resource] : $b From Novice to Professional / $c by Ben Brumm.
250 $a 1st ed. 2019.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2019.
300 $a XXVI, 431 p. 138 illus. $b 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 $b PDF $2 rda
505 0 $a Introduction -- Part I. Setting Up -- 1. What Is A Database? -- 2. Setting Up -- -- Part II. Viewing Data -- 3. Retrieving Data -- 4. Selecting Specific Columns -- 5. Restricting the Results -- 6. Comparing Data -- 7. Applying Multiple Filters -- 8. Working with NULLs -- 9. Removing Duplicate Results -- 10. Applying Filters on Lists and Ranges of Values -- 11. Ordering Your Data -- 12. Applying Table and Column Aliases -- Part III. Adding, Updating, Deleting Data -- 13. Understanding the Data Types -- 14. Creating A Table -- 15. Adding Data to A Table -- 16. Updating and Removing Data -- 17. Updating or Deleting a Table -- Part IV. Joining Tables -- 18. Inner Join -- 19. Outer Join -- 20. Other Join Types -- 21. Joining Many Tables -- Part V. Functions -- 22. Using Functions in SQL -- 23. Writing Conditional Logic -- 24. Understanding Aggregate Functions -- 25. Grouping Your Results -- 26. What Are Indexes? -- Part VI. Command Line -- 27. Using the Command Line -- Part VII. Appendixes -- 28. Appendix. How to Find and Navigate the Oracle SQL Reference.
520 $a Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. You'll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download. A marquee feature of Beginning Oracle SQL for Oracle Database 18c is the small chapter size. Content is divided into easily digestible chunks that can be read and practiced in very short intervals of time, making this the ideal book for a busy professional to learn from. Even just a 15-20 minute block of free time can be put to good use. Author Ben Brumm begins by helping you understand what a database is, and getting you set up with a sandbox in which to practice the SQL that you are learning. From there, easily digestible chapters cover, point-by-point, the different aspects of writing queries to get data out of a database. You’ll also learn about creating tables and getting data into the database. Crucial topics such as working with nulls and writing analytic queries are given the attention they deserve, helping you to avoid pitfalls when writing queries for production use. What You'll Learn: Create, update, and delete tables in an Oracle database Add, update, delete data from those database tables Query and view data stored in your database Manipulate and transform data using in-built database functions and features Correctly choose when to use Oracle-specific syntax and features.
650 0 $a Database management. $3 557799
650 1 4 $a Database Management. $3 669820
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484244296
776 0 8 $i Printed edition: $z 9781484244319
856 4 0 $u https://doi.org/10.1007/978-1-4842-4430-2
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)