Easy Learning Oracle SQL: SQL for Beginner's Guide (Easy learning Java and Design Patterns and Data Structures and Algorithms) - Softcover

Hu, Yang

Softcover

ISBN 10: 1094789100 ISBN 13: 9781094789101

Publisher: Independently published, 2019

Synopsis

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

Edition details

• Publisher: Independently published
• Publication date: 2019
• ISBN 10: 1094789100
• ISBN 13: 9781094789101
• Binding: Paperback
• Language: English
• Number of pages: 99