Du er ikke logget ind
Beskrivelse
This book brings SQL to life and quirky, in just a short time, you can learn how to use SQL to design, and develop. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials from the ground up. Clear full-color instructions and practical, hands-on examples show you how to interact data with SQL.
this book teaches main SQL skills and step-by-step guidance to know coding. In this comprehensive guide draws on SQL knowledge to make the topic of relational database management accessible, easy to understand, and highly actionable.
From the essence of practice, vividly cultivate programming interest, this book easy and quickly learn Oracle SQL.
1. Oracle Installation
2. Data Manipulation Language
3. Tablespace
4. User
5. Insert Data
6. Update Data
7. Delete Data
8. Transaction
9. Constraints
10. One to One Association Table
11. One to Many Association Table
12. Many to Many Association Table
13. Constraint Management
14. Data Type
15. Function
16. Group By
17. Inner Join
18. Multi-table Equivalent Join
19. Outer Join
20. Seft Join
21. GROUP BY and HAVING
22. Sub Query
23. Multi Row SubQuery
24. Get Top N Rows
25. Paging Query
26. Collection
27. View
28. SEQUENCE
29. Procedure
30. PL/SQL
30.1 IF Statement
30.2 Case Statement
30.3 While Loop
30.4 For Loop
31. Cursor
31.1 For Loop Cursor
31.2 Fetch Cursor
32. Trigger