Muutke küpsiste eelistusi

Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional 1st ed. [Pehme köide]

3.00/5 (6 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 431 pages, kõrgus x laius: 254x178 mm, kaal: 868 g, 138 Illustrations, black and white; XXVI, 431 p. 138 illus., 1 Paperback / softback
  • Ilmumisaeg: 06-Aug-2019
  • Kirjastus: APress
  • ISBN-10: 148424429X
  • ISBN-13: 9781484244296
Teised raamatud teemal:
  • Pehme köide
  • Hind: 53,33 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 62,74 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 431 pages, kõrgus x laius: 254x178 mm, kaal: 868 g, 138 Illustrations, black and white; XXVI, 431 p. 138 illus., 1 Paperback / softback
  • Ilmumisaeg: 06-Aug-2019
  • Kirjastus: APress
  • ISBN-10: 148424429X
  • ISBN-13: 9781484244296
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781484244296.html
Märksõnad:
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. 

About the Author xvii
About the Technical Reviewer xix
Acknowledgments xxi
Introduction xxiii
Part I: Setting Up 1(50)
Chapter 1 What is a Database?
3(6)
Alternatives to Databases
4(1)
Tables
4(1)
Rows
5(1)
Columns
5(1)
Query
5(1)
SQL
6(1)
Indexes
6(1)
Vendors
6(1)
Summary
7(2)
Chapter 2 Setting Up
9(42)
What Tools Do We Need?
9(1)
Versions
10(1)
Download Oracle Express
10(6)
Windows, Linux, and What About Mac?
16(1)
Install Oracle Express
17(4)
Download Oracle SQL Developer
21(2)
Run Oracle SQL Developer
23(1)
Download the JDK
24(4)
Create a Connection
28(3)
Create a New User
31(5)
Create a Connection with New User
36(1)
Create a Table
37(3)
Insert Some Data
40(4)
LiveSQL
44(5)
Summary
49(2)
Part II: Viewing Data 51(130)
Chapter 3 Retrieving Data
53(12)
How Can You See the Data?
53(1)
What Is the SELECT Statement?
53(1)
A Few Things to Note
54(1)
Our First SELECT Statement
55(1)
Running a Statement in SQL Developer
56(4)
Results
60(1)
Run Script
61(1)
Errors in SQL
62(2)
Missing Keyword
62(1)
Table Does Not Exist
63(1)
Summary
64(1)
Chapter 4 Selecting Specific Columns
65(12)
Selecting a Single Column
66(5)
Selecting Multiple Columns
71(2)
Selecting All Columns
73(2)
SELECT Columns or SELECT *?
75(1)
Summary
76(1)
Chapter 5 Restricting the Results
77(12)
Why Restrict Data?
77(1)
What is the WHERE Clause?
78(1)
Example with a Text Value
78(3)
Example with a Number Value
81(1)
Finding Rows Not Equal to a Value
82(1)
Greater Than
83(1)
Greater Than or Equal To
84(1)
Less Than
85(1)
Less Than or Equal To
86(1)
Best Practices
87(1)
Specify Columns on the Left
87(1)
Select Only What You Need
87(1)
Summary
88(1)
Chapter 6 Comparing Data
89(10)
What Is a Partial Match?
89(1)
Syntax of LIKE
90(1)
The Percent Wildcard Character
90(2)
The Underscore Wildcard Character
92(3)
Searching for Wildcard Characters
95(1)
Performance
96(1)
Summary
97(2)
Chapter 7 Applying Multiple Filters
99(10)
Why Use Multiple Filters?
99(1)
The AND Keyword
100(2)
Finding Records That Match a Last Name and a Salary
100(1)
Finding Records that Match Greater Than and Less Than on Two Columns
101(1)
The OR Keyword
102(2)
Finding Records that Match a Last Name or a Salary
102(1)
Finding Records that Match Greater Than or Less Than on Two Columns
103(1)
More Than Two Conditions
104(4)
Multiple AND Conditions
104(1)
Multiple OR Conditions
105(1)
Combining Multiple AND and OR Conditions
105(1)
Specifying the Order with Multiple Conditions
106(2)
Summary
108(1)
Chapter 8 Working with Nulls
109(18)
Missing Data
109(2)
What is NULL?
111(1)
How Should NULL Be Treated?
111(1)
Examples of Working with NULL
112(11)
Adding More Data
112(6)
Selecting the Records
118(2)
Restricting the NULL Values
120(2)
Hiding Null Values
122(1)
Multiple Queries in One SQL Window
123(2)
Summary
125(2)
Chapter 9 Removing Duplicate Results
127(10)
Add New Records
128(2)
Select the Data
130(1)
What is DISTINCT?
131(1)
Finding Unique Last Name Values
132(3)
Finding Unique Salary Values
133(1)
Finding Unique Combinations of Values
134(1)
Summary
135(2)
Chapter 10 Applying Filters on Lists and Ranges of Values
137(14)
Too Many Conjunctions
137(2)
The IN Keyword
139(3)
Example of Using IN
139(1)
A Longer Value List
140(1)
Using IN with Text Values
141(1)
Using IN with Other Clauses
142(1)
IN with AND?
142(1)
IN with LIKE?
143(1)
Filtering on Ranges of Values
144(1)
The BETWEEN Operator
145(4)
Using Between with Two Salary Values
146(1)
Using BETWEEN When Values Don't Match
147(1)
Using BETWEEN with Text Values
147(1)
An Example of an Inclusive and Exclusive Check
148(1)
Should You Use BETWEEN?
149(1)
Summary
149(2)
Chapter 11 Ordering Your Data
151(12)
Results Are Not Ordered
151(1)
Ordering Results with ORDER BY
152(1)
ORDER BY Examples
153(8)
Order by a Text Value
153(1)
Order by a Number Value
154(2)
Order by a Column Not in the SELECT Clause
156(1)
Order by a Number
156(2)
ORDER BY and NULLs
158(1)
Order by Multiple Columns
159(2)
Do You Really Need to Order Your Data?
161(1)
Summary
162(1)
Chapter 12 Applying Table and Column Aliases
163(18)
What is a Table Alias?
163(1)
Example of a Table Alias
164(1)
Intellisense or AutoComplete
165(2)
Longer Table Aliases
167(1)
What If I Don't Use a Table Alias?
168(1)
What Is a Column Alias?
168(1)
Example of a Column Alias
169(2)
The AS Keyword
171(1)
Mathematical Operations and Column Aliases
172(6)
Addition
173(2)
Subtraction
175(1)
Multiplication
176(1)
Division
177(1)
Column Aliases with Table Aliases
178(1)
Summary
179(2)
Part III: Adding, Updating, Deleting Data 181(70)
Chapter 13 Understanding the Data Types
183(14)
What is a Data Type?
183(1)
Why Do We Have Different Data Types?
184(1)
What Are the Different Data Types?
185(1)
Text Data Types
185(4)
CHAR
186(1)
VARCHAR2
186(1)
NCHAR
187(1)
NVARCHAR2
188(1)
RAW
189(1)
LONG RAW
189(1)
Number Data Types
189(3)
NUMBER
190(1)
INTEGER
190(1)
FLOAT
191(1)
DECIMAL
191(1)
BINARY FLOAT
191(1)
BINARY DOUBLE
192(1)
Date Data Types
192(2)
DATE
192(1)
TIMESTAMP
192(1)
TIMESTAMP WITH TIME ZONE
193(1)
TIMESTAMP WITH LOCAL TIME ZONE
193(1)
INTERVAL YEAR TO MONTH
193(1)
INTERVAL DAY TO SECOND
194(1)
Other Data Types
194(1)
BLOB
194(1)
CLOB
195(1)
Data Type Recommendations
195(1)
Summary
195(2)
Chapter 14 Creating a Table
197(16)
Creating Tables Using SQL Code
197(1)
The CREATE TABLE Statement
198(1)
Our Employee Table
199(1)
Storing Office Details
200(3)
The Office Table
203(3)
The Sales Meeting Table
206(1)
Primary Key
206(3)
Recording the Employee Again
209(1)
Foreign Key
209(3)
Summary
212(1)
Chapter 15 Adding Data to a Table
213(12)
The INSERT Statement
213(1)
Running an INSERT Statement
214(2)
Inserting More Data
216(2)
Inserting Date Values
218(3)
Saving and Undoing Changes
221(2)
Best Practices for Inserting Data
223(1)
Summary
224(1)
Chapter 16 Updating and Removing Data
225(14)
The UPDATE Statement
225(1)
Update to a New Value
226(2)
Checking an Update Statement Before Running It
228(1)
Update a NULL Value
229(1)
Update Based on Existing Value
230(1)
Update a Date Value
231(1)
Viewing and Updating the Date Format
232(1)
Update Two Columns
233(1)
Update Without WHERE Clause
234(1)
Removing Data from a Table
235(1)
Deleting a Record
236(1)
Check What Records Will Be Deleted
237(1)
Delete All Records in a Table
238(1)
Summary
238(1)
Chapter 17 Updating or Deleting a Table
239(12)
Why Update the Structure of a Table?
239(1)
The ALTER TABLE Statement
240(1)
Example: Adding a Column
241(1)
Example: Change a Data Type
242(1)
Example: Add a Primary Key
243(2)
Example: Add a Foreign Key
245(1)
Example: Rename a Column
246(1)
Example: Remove a Column
247(1)
Example: Rename a Table
248(1)
Removing a Table with DROP TABLE
249(1)
Summary
250(1)
Part IV: Joining Tables 251(50)
Chapter 18 Inner Join
253(10)
Multiple Tables
253(1)
What is a Join?
254(1)
An Example of a Join
255(2)
Joins, Formatting, and Table Aliases
257(3)
An INNER JOIN
260(2)
Summary
262(1)
Chapter 19 Outer Join
263(12)
What is an Outer Join?
263(1)
Writing a Left Outer Join
264(2)
Showing All Employees with a Left Outer Join
266(2)
Writing a Right Outer Join
268(2)
When Would You Use a Right Outer Join?
270(1)
Writing a Full Outer Join
270(2)
Using a Full Outer Join on Our Tables
272(1)
Summary
273(2)
Chapter 20 Other Join Types
275(16)
The USING Keyword
275(1)
Updating the Office Table
276(1)
Writing a Query with the USING Keyword
277(3)
What is a Natural Join?
280(1)
Writing a Query with a Natural Join
280(2)
What is a Cross Join?
282(2)
Using a CROSS JOIN
284(1)
Alternative Join Syntax
285(4)
Inner Join
285(1)
Outer Join
286(2)
Why You Shouldn't Use the Alternative Join Syntax
288(1)
Summary
289(2)
Chapter 21 Joining Many Tables
291(10)
Joining Three Tables
291(2)
Joining Our Tables Together
293(1)
Using Outer Join Types
294(2)
Mixing Join Types
296(1)
Joining Four or More Tables
297(2)
Summary
299(2)
Part V: Functions 301(90)
Chapter 22 Using functions in SQL
303(28)
What is a Function?
303(1)
Where Can You Use Functions?
304(1)
Simple Numeric Calculations
304(4)
The DUAL Table
308(3)
Number Functions
311(3)
Concatenation of Strings
314(3)
String Functions
317(6)
Changing Case
317(2)
Checking for Matches on the Same Case
319(3)
Getting Part of a String
322(1)
Calculations on Dates
323(4)
Date Functions
327(3)
Current Date and Time
327(1)
Adding Months
328(2)
Summary
330(1)
Chapter 23 Writing Conditional Logic
331(16)
The CASE Statement
331(2)
Simple Case Statement
333(4)
Searched Case Statement
337(5)
The DECODE Function
342(2)
CASE or DECODE?
344(1)
Summary
345(2)
Chapter 24 Understanding Aggregate Functions
347(18)
Aggregate Functions
348(1)
The SUM Function
348(3)
A Simple SUM Example
349(1)
SUM with WHERE
350(1)
SUM with Expression
350(1)
SUM with DISTINCT
351(1)
The COUNT Function
351(6)
Counting All Records
352(1)
Count a Specific Column
352(2)
Count with DISTINCT
354(2)
Count with WHERE
356(1)
The AVG Function
357(3)
Average of All Values
357(1)
Average with DISTINCT
358(1)
Average with WHERE
359(1)
The MIN Function
360(2)
Minimum of All Records
360(2)
Minimum with WHERE
362(1)
The MAX Function
362(2)
Maximum of All Records
362(1)
Maximum with WHERE
363(1)
Summary
364(1)
Chapter 25 Grouping Your Results
365(14)
Grouping Your Data
365(2)
The GROUP BY Keyword
367(3)
GROUP BY with a Join
370(1)
GROUP BY and SUM
370(1)
GROUP BY with WHERE
371(1)
Restricting Results After Grouping
372(2)
The HAVING Clause
374(2)
GROUP BY, HAVING, and SUM
376(1)
Finding Duplicate Records
376(2)
Summary
378(1)
Chapter 26 What Are Indexes?
379(12)
What Is an Index?
379(1)
How to Create an Index
380(1)
Example of Creating an Index
380(4)
Why Is Performance Important?
384(1)
Web Application
384(1)
Overnight Batch Jobs
384(1)
Reporting System
385(1)
Index Using a Join
385(3)
Creating an Index
387(1)
The Disadvantages of Indexes
388(1)
Best Practices for Creating Indexes
388(1)
Summary
389(2)
Part VI: Command Line 391(20)
Chapter 27 Using the Command Line
393(18)
What is SQL*Plus and Why Would You Use It?
394(1)
It's Fast
394(1)
It's Easy to Run Scripts
394(1)
It's Available on Every Oracle Database
395(1)
You Don't Always Have Access to SQL Developer
395(1)
How to Start SQL*Plus
395(2)
Alternative Login Syntax
397(2)
Login with Two Steps
397(1)
Log in with One Step
398(1)
Running a Query in SQL*Plus
399(2)
Formatting Output in SQL*Plus
401(3)
Copy and Paste into SQL*Plus
404(1)
The Forward Slash Character
404(1)
Exiting SQL*Plus
405(1)
What About SQLcI?
406(1)
How to Download and Run SQLcI
407(3)
Summary
410(1)
Part VII: Appendixes 411(12)
Appendix: How to Find and Navigate the Oracle SQL Reference
413(10)
Finding the Oracle SQL Reference
413(2)
The Oracle SQL Reference
415(2)
Find What You Need Using Table of Contents
417(2)
Find What You Need Using Search
419(4)
Index 423
Ben Brumm is a software developer and business analyst with over 11 years of experience. Based in Melbourne, Australia, he has been working with databases and SQL both during his full-time job, and as the founder of the DatabaseStar dot com site where he teaches Oracle database topics. His passion for software and databases began when he started computer classes in high school in the late 1990s and it has only grown since then.