Beginning Oracle SQL for Oracle Database 18c : from novice to professional /: from novice to professional. ([2019])

• Record Type: Book
• Further Information: Note: Ben Brumm.
• Authors: Brumm, Ben
• Contents: 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 Part II: Viewing DataChapter 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 Finding Rows Not Equal to a ValueGreater 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 The OR KeywordFinding 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 Chapter 9: Removing Duplicate ResultsAdd 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
• Publisher Details: New York, NY : Apress
• Publication Date: 2019
• Extent: 1 online resource
• Subjects: 005.75/65; Database management; Electronic books
• Languages: English
• ISBNs: 9781484244302; 1484244303
• Notes: Note: Description based on online resource; title from digital title page (viewed on August 26, 2019).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.