Beginning Oracle SQL for Oracle Database 18c : from novice to professional
(eBook)
Author
Published
[New York, NY] : Apress, [2019].
Format
eBook
ISBN
1484244303, 1484244311, 9781484244302, 9781484244319
Physical Desc
1 online resource
Status
Description
Loading Description...
Also in this Series
Checking series information...
Subjects
LC Subjects
More Details
Language
English
UPC
10.1007/978-1-4842-4430-2, 10.1007/978-1-4842-4
Notes
General Note
Includes index.
Description
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 Who This Book Is For Those new to Oracle who are planning to develop software using Oracle as the back-end data store. The book is also for those who are getting started in software development and realize they need to learn some kind of database language. Those who are learning software development on the side of their normal job, or learning it as a college student, who are ready to learn what a database is and how to use it also will find this book useful.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Brumm, B. (2019). Beginning Oracle SQL for Oracle Database 18c: from novice to professional . Apress.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Brumm, Ben. 2019. Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional. Apress.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Brumm, Ben. Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional Apress, 2019.
MLA Citation, 9th Edition (style guide)Brumm, Ben. Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional Apress, 2019.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
4861d809-90b4-81eb-9956-7ef9dc534e0a-eng
Grouping Information
| Grouped Work ID | 4861d809-90b4-81eb-9956-7ef9dc534e0a-eng |
|---|---|
| Full title | beginning oracle sql for oracle database 18c from novice to professional |
| Author | brumm ben |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-28 03:09:09AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Sep 7, 2024 |
| Last Used | Sep 7, 2024 |
Marc Record
| First Detected | Jul 29, 2024 04:04:46 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:40:13 PM |
MARC Record
| LEADER | 07296cam a2200541 i 4500 | ||
|---|---|---|---|
| 001 | on1111975756 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 190817s2019 nyu o 001 0 eng d | ||
| 015 | |a GBB9E8496|2 bnb | ||
| 016 | 7 | |a 019500085|2 Uk | |
| 019 | |a 1111789886|a 1117286059|a 1117776684|a 1121274740|a 1122608349|a 1125762375|a 1126187058|a 1156368538 | ||
| 020 | |a 1484244303|q (electronic book) | ||
| 020 | |a 1484244311 | ||
| 020 | |a 9781484244302|q (electronic book) | ||
| 020 | |a 9781484244319|q (print) | ||
| 020 | |z 148424429X | ||
| 020 | |z 9781484244296 | ||
| 024 | 7 | |a 10.1007/978-1-4842-4430-2|2 doi | |
| 024 | 8 | |a 10.1007/978-1-4842-4 | |
| 035 | |a (OCoLC)1111975756|z (OCoLC)1111789886|z (OCoLC)1117286059|z (OCoLC)1117776684|z (OCoLC)1121274740|z (OCoLC)1122608349|z (OCoLC)1125762375|z (OCoLC)1126187058|z (OCoLC)1156368538 | ||
| 037 | |a com.springer.onix.9781484244302|b Springer Nature | ||
| 040 | |a EBLCP|b eng|e rda|e pn|c EBLCP|d YDXIT|d GW5XE|d EBLCP|d OCLCF|d OTZ|d YDX|d UKMGB|d LQU|d UMI|d OCLCQ|d VT2|d TOH|d OCLCQ|d COO|d OCLCQ|d UKAHL|d CPO|d BRF|d OCLCQ|d OCLCO|d COM|d OCLCQ|d OCLCO|d OCLCL|d OCLCQ | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a QA76.9.D3|b B78 2019 | |
| 082 | 0 | 4 | |a 005.75/65|2 23 |
| 100 | 1 | |a Brumm, Ben,|e author. | |
| 245 | 1 | 0 | |a Beginning Oracle SQL for Oracle Database 18c :|b from novice to professional /|c Ben Brumm. |
| 264 | 1 | |a [New York, NY] :|b Apress,|c [2019] | |
| 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 | ||
| 347 | |b PDF | ||
| 500 | |a Includes index. | ||
| 505 | 0 | |a Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Setting Up; Chapter 1: What is a Database?; Alternatives to Databases; Tables; Rows; Columns; Query; SQL; Indexes; Vendors; Summary; Chapter 2: Setting Up; What Tools Do We Need?; Versions; Download Oracle Express; Windows, Linux, and What About Mac?; Install Oracle Express; Download Oracle SQL Developer; Run Oracle SQL Developer; Download the JDK; Create a Connection; Create a New User; Create a Connection with New User; Create a Table; Insert Some Data; LiveSQL; Summary | |
| 505 | 8 | |a Part II: Viewing Data; Chapter 3: Retrieving Data; How Can You See the Data?; What Is the SELECT Statement?; A Few Things to Note; Our First SELECT Statement; Running a Statement in SQL Developer; Results; Run Script; Errors in SQL; Missing Keyword; Table Does Not Exist; Summary; Chapter 4: Selecting Specific Columns; Selecting a Single Column; Selecting Multiple Columns; Selecting All Columns; SELECT Columns or SELECT *?; Summary; Chapter 5: Restricting the Results; Why Restrict Data?; What is the WHERE Clause?; Example with a Text Value; Example with a Number Value | |
| 505 | 8 | |a Finding Rows Not Equal to a Value Greater Than; Greater Than or Equal To; Less Than; Less Than or Equal To; Best Practices; Specify Columns on the Left; Select Only What You Need; Summary; Chapter 6: Comparing Data; What Is a Partial Match?; Syntax of LIKE; The Percent Wildcard Character; The Underscore Wildcard Character; Searching for Wildcard Characters; Performance; Summary; Chapter 7: Applying Multiple Filters; Why Use Multiple Filters?; The AND Keyword; Finding Records That Match a Last Name and a Salary; Finding Records that Match Greater Than and Less Than on Two Columns | |
| 505 | 8 | |a The OR Keyword; Finding Records that Match a Last Name or a Salary; Finding Records that Match Greater Than or Less Than on Two Columns; More Than Two Conditions; Multiple AND Conditions; Multiple OR Conditions; Combining Multiple AND and OR Conditions; Specifying the Order with Multiple Conditions; Summary; Chapter 8: Working with Nulls; Missing Data; What is NULL?; How Should NULL Be Treated?; Examples of Working with NULL; Adding More Data; Selecting the Records; Restricting the NULL Values; Hiding Null Values; Multiple Queries in One SQL Window; Summary | |
| 505 | 8 | |a Chapter 9: Removing Duplicate Results; Add New Records; Select the Data; What is DISTINCT?; Finding Unique Last Name Values; Finding Unique Salary Values; Finding Unique Combinations of Values; Summary; Chapter 10: Applying Filters on Lists and Ranges of Values; Too Many Conjunctions; The IN Keyword; Example of Using IN; A Longer Value List; Using IN with Text Values; Using IN with Other Clauses; IN with AND?; IN with LIKE?; Filtering on Ranges of Values; The BETWEEN Operator; Using Between with Two Salary Values; Using BETWEEN When Values Don't Match; Using BETWEEN with Text Values | |
| 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 Who This Book Is For Those new to Oracle who are planning to develop software using Oracle as the back-end data store. The book is also for those who are getting started in software development and realize they need to learn some kind of database language. Those who are learning software development on the side of their normal job, or learning it as a college student, who are ready to learn what a database is and how to use it also will find this book useful. | ||
| 588 | 0 | |a Online resource; title from digital title page (viewed on August 26, 2019). | |
| 650 | 0 | |a Database management.|0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 776 | 0 | 8 | |i Print version:|a Brumm, Ben.|t Beginning Oracle SQL for Oracle Database 18c : From Novice to Professional.|d Berkeley, CA : Apress L.P., ©2019|z 9781484244296 |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |