Oracle 11G: SQL Author: | Language: English | ISBN:
B00B6DDYQM | Format: PDF
Oracle 11G: SQL Description
ORACLE 11G: SQL is an introduction to the fundamental SQL language used in all relational databases today. This textbook is not simply a study guide; it is written for those who have just a basic knowledge of databases and can be used in a course on this latest implementation of SQL from Oracle. Learning these concepts and techniques prepares students for the first exam in both the Oracle Database Administrator and Oracle Developer Certification Exam paths and offers a solid understanding of using Oracle 11g SQL effectively. The first part of ORACLE 11G: SQL focuses on creating database objects, including tables, constraints, indexes, sequences, synonyms, and users, and manipulating data. The second part explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views. Several advanced query topics, such as ROLLUP, CUBE, and TOP-N analysis, are also introduced. To help students bridge these SQL topics to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases (MS SQL Server and MySQL), and explain how to embed SQL in applications (ASP.NET). An overview of the two Oracle connection interface tools, SQL Developer and SQL Plus, is also provided.
Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version. - File Size: 20021 KB
- Print Length: 608 pages
- Publisher: Cengage Learning; 2 edition (September 24, 2013)
- Sold by: Cengage Learning
- Language: English
- ASIN: B00B6DDYQM
- Text-to-Speech: Not enabled
X-Ray for Textbooks:
- Lending: Not Enabled
- Amazon Best Sellers Rank: #389,777 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
I typically do not have much enthusiasm for technical books published by the big "textbook publishers." Too many errors, too much "intro/overview," and bad information/advice. However, this book is a gem!
I will apologize straightaway for not writing a detailed review. I am too busy to do one. However, I think it's better that I review it now, than forget to review it at all.
Already I own several MySQL books (and some PHP/MySQL books), including Wrox and O'Reily books. Lately, however, I've only used them as a basic "reference" when building websites. Back when I tried to go through each book chapter-by-chapter, I was disappointed when I tried anything complicated for a "newbie," such as joins and virtual tables. Nothing ever worked the way the books said they would! But truly, the concepts behind joins were not explained clearly *at all* and so I was not capable of troubleshooting the problems myself.
"Oracle 11g: SQL" shines in this regard! The explanations of what happens "behind-the-scenes" when you create a join or query a virtual table are so exceptionally accurate and well-explained, that not only could I create complex joins, I was even able to find and correct errors in the online tests that were part of our "web-enhanced" college course!
Aside from the lucidity of the text, the chapter was filled with practical "cases" that at least begin to hint at some of the complex ERDs one would have to create in real life. Once in a while, the instructions for the case in one chapter did not exactly match up with what had been done to the case database in another chapter, but such errors were rather obvious and did not cause problems.
Oracle 11G: SQL Preview
Link
Please Wait...