Cargando…
Beginning Oracle SQL for Oracle Database 18c : from novice to professional /
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 ex...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[New York, NY] :
Apress,
[2019]
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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 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
- 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
- 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
- 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