Ebook Oracle 11G: SQL, by Joan Casteel
Get the perks of reading practice for your lifestyle. Schedule Oracle 11G: SQL, By Joan Casteel notification will certainly always connect to the life. The reality, expertise, scientific research, health, faith, enjoyment, as well as more can be found in created publications. Lots of writers offer their experience, science, research, and all things to show you. Among them is via this Oracle 11G: SQL, By Joan Casteel This e-book Oracle 11G: SQL, By Joan Casteel will provide the required of message and also declaration of the life. Life will certainly be completed if you understand much more things with reading books.
Oracle 11G: SQL, by Joan Casteel
Ebook Oracle 11G: SQL, by Joan Casteel
Oracle 11G: SQL, By Joan Casteel. One day, you will certainly discover a new experience and also understanding by spending more cash. However when? Do you believe that you have to get those all needs when having significantly money? Why do not you try to get something basic initially? That's something that will lead you to know even more regarding the globe, adventure, some locations, history, amusement, as well as more? It is your very own time to proceed checking out habit. Among guides you can delight in now is Oracle 11G: SQL, By Joan Casteel here.
This book Oracle 11G: SQL, By Joan Casteel is anticipated to be among the very best vendor publication that will make you really feel satisfied to acquire as well as review it for finished. As recognized could common, every publication will certainly have certain things that will make an individual interested so much. Also it originates from the author, type, material, and even the publisher. Nevertheless, many individuals additionally take guide Oracle 11G: SQL, By Joan Casteel based upon the theme as well as title that make them amazed in. and here, this Oracle 11G: SQL, By Joan Casteel is really advised for you due to the fact that it has fascinating title and also style to review.
Are you truly a fan of this Oracle 11G: SQL, By Joan Casteel If that's so, why don't you take this publication now? Be the initial individual which like as well as lead this publication Oracle 11G: SQL, By Joan Casteel, so you could obtain the factor and also messages from this book. Never mind to be confused where to get it. As the various other, we share the connect to visit as well as download and install the soft documents ebook Oracle 11G: SQL, By Joan Casteel So, you might not bring the printed book Oracle 11G: SQL, By Joan Casteel anywhere.
The existence of the on the internet publication or soft data of the Oracle 11G: SQL, By Joan Casteel will certainly reduce people to obtain the book. It will additionally conserve even more time to just look the title or author or publisher to get up until your book Oracle 11G: SQL, By Joan Casteel is exposed. Then, you can go to the web link download to see that is supplied by this website. So, this will certainly be a great time to start appreciating this publication Oracle 11G: SQL, By Joan Casteel to review. Consistently great time with publication Oracle 11G: SQL, By Joan Casteel, constantly great time with money to spend!
ORACLE 11G: SQL is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.
- Sales Rank: #158290 in Books
- Brand: Cengage Learning
- Published on: 2009-06-25
- Ingredients: Example Ingredients
- Original language: English
- Number of items: 1
- Dimensions: 1.30" h x 7.40" w x 9.10" l, 2.30 pounds
- Binding: Paperback
- 608 pages
- Used Book in Good Condition
Review
1. Overview of Database Concepts. 2. Basic SQL SELECT Statements. 3. Table Creation and Management. 4. Constraints. 5. Data Manipulation and Transaction Control. 6. Additional Database Objects. 7. User Creation and Management. 8. Restricting Rows and Sorting Data. 9. Joining Data from Multiple Tables. 10. Selected Single-Row Functions. 11. Group Functions. 12. Subqueries and Merge. 13. Views. 14. Formatting Readable Output. 15. Exploring SQL Topics in Application Development. Appendices. A. Tables for the Justlee Database. B. SQL Plus & ISQL Plus User's Guide. C. SQL Sytax Guide. D. Introductoin to Third Party Tool (TOAD). E. Oracle 11g Practice Exams. F. Oracle Resources. G. SQL Loader.
About the Author
Joan E. Casteel combines more than 15 years of hands-on experience in application development in various business environments with strong teaching skills to clarify important application and software concepts for today's readers. An award-winning instructor, Ms. Casteel serves as associate professor of information technology and business at Tidewater Community College, where she has been an integral part of the Database Specialist curriculum. She has joined a newly formed team at the college in charge of building a campus ID card program to encompass four campuses, using a recently deployed Oracle-based system. In addition the team is developing new Oracle APEX applications to improve college-wide financial services support. Ms. Casteel has been recognized by her colleagues for her professional accomplishments, including creating an Oracle virtual machine image for students and handling recruitment efforts for database specialist career studies. Ms. Casteel is the author of two successful books on Oracle from Course Technology, part of Cengage Learning, covering SQL and PL/SQL which serve as the introductory course sequence in the college's database career path.
Most helpful customer reviews
10 of 10 people found the following review helpful.
Best SQL text ever
By janne
I was dubious about another thick, high cost textbook. I have enough incomprehensible database and SQL books - this text is different - it's so well written, it's understandable, the examples are useful, and the author points out all the little idiosyncrasies that trip up newbies. Highly recommend this book for anyone starting to learn SQL or who had trouble with SQL with another text. The datafiles on the companion website are easy to work with and it's a very practical, hands on text. Well worth the high cost.
14 of 16 people found the following review helpful.
The best SQL book I've read yet!
By Coder
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.
If you buy this text used, make sure you buy the online access, especially if you do not want to install Oracle on your computer. Access includes a sandbox where you can view sample databases (if your teacher has set them up), or run SQL scripts to install them (downloaded from the website or copied from the CD). This allows you to practice simple beginner-level queries or to create entire databases as you please. If you follow along with examples and cases, you will occasionally need to run scripts to alter the sample databases, anyway.
This book is *superb* both in its chapter content, exercises, examples, and cases.
A few gripes:
1) The tests (or rather the test system) often re-numbers answers so that whenever you have a choice of "both a & b" the correct answers are actually a & c or some other combination. Whenever 2 answers are correct, just always pick the one that says "a & b" and you'll be fine!
2) One of the questions about joins, which I got during the "review" (which didn't count, thank goodness), was wrong in both the wording of the question and the answer.
3) When you play *online* with "bind variables" (used to store user input from an HTML form, and submit it to the database), you must change your syntax for "Oracle Express"! The book says to precede the variable name with an ampersand ("&"); however, you must use a colon (":")!
Even though I use MySQL and this textbook covered Oracle's flavor of SQL, it is the most *enlightening* relational-database textbook I have EVER, EVER read!!!
6 of 6 people found the following review helpful.
Good & Easy Oracle
By Maria Feli
This book is very easy to understand. It goes step by step on how to create a database. It has print screens about the topic that shows how to do it.
Oracle 11G: SQL, by Joan Casteel PDF
Oracle 11G: SQL, by Joan Casteel EPub
Oracle 11G: SQL, by Joan Casteel Doc
Oracle 11G: SQL, by Joan Casteel iBooks
Oracle 11G: SQL, by Joan Casteel rtf
Oracle 11G: SQL, by Joan Casteel Mobipocket
Oracle 11G: SQL, by Joan Casteel Kindle
No comments:
Post a Comment