Ebook Download | Murach's Oracle SQL and PL/SQL | Murach books have a reputation for accessibility to the novice user. Murach's Oracle SQL and PL/SQL is just as accessible to the novice, but also contains plenty to assist other Oracle users.The first section is truly non-threatening and is possibly too basic to be of real use in the context of the whole book. It is a short introduction to databases and the Oracle tools but doesn't contain much depth. The second section digs deeper into interacting with databases and is primarily aimed at standard and Oracle-specific SQL syntax. Section 3 introduces good (and essential) database practices such as normalisation, user and role management, indexes, foreign keys and other aspects of database design. Section 4 covers some PL/SQL basics and finally Section 5 covers the more complicated data types.
I mention all of that since I found the name of the book slightly misleading, but in a good way. The focus of the book is on building and maintaining the skills required for running Oracle SQL and PL/SQL and while Sections 3 and 5 could have been omitted, the book is better because of the inclusion.
Sections 2 and 4 are the main sections and both are well written for both teaching and reference resources, and Section 2 in particular highlights the important information for each piece of knowledge.
The result is a book that is great for Oracle novices, although possibly not if you are a complete database novice, but also great for intermediate users casual users like myself. Personally I use the database dictated by clients, so I look forward to having this on hand when making the next switch back to the Oracle database. It won't get you an Oracle DBA job, but it will help you get more out of your database.
Tidak ada komentar:
Posting Komentar