Book Description
Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features wanted mostincluding in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, and more.
Book Description
Get in-depth training and practice with the skills measured by the core exams for Microsoft Certified IT Professional: Database Administrator certificationall in one box! Covering Exams 70-431, 70-443, and 70-444, these three training kits include exam prep and practice tests to help you maximize your performance. You get official Microsoft study guides, plus practice tests on CD to help you assess your skills. They come packed with the tools and features that exam candidates want mostincluding in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. They also provide real-world case scenarios and practice exercises for skills and expertise you can apply to the job.
Customer Reviews:
Lots of information for DBAs.......2007-09-11
I purchased this for the 70-431 training, and since it was a good deal for the remaining two books, I got this package. Thsi was not a weekend study guide for me, but a two week adventure. The book is a good read, especially with the authors' real world experience. I have used the information in my consulting practice, and it has paid dividends. With this book and other resources included, I scored 940 on the 70-431 test.
Satisfatory..........2007-08-18
The kit provides the necessary tools to prepare for the exam. I'm a little disappointed with some of the rudimentary database topics covered (for example - T-SQL, Creating Tables). Someone preparing to be a certified DBA would already know most of this basic material. If they don't - it's a little late to start learning. However that seems to be status quo with most training kits out on the market.
Nothing more to add.......2007-07-27
Superb tri-pack for Microsoft SQL Server 2005 DBAs. It is almost you have to know to provide serious MS SQL server 2005 administration and maintenance.
Good Resource & Study Book.......2007-07-20
This book is very good in the fact that it steps you through real world examples. The examples in this book can be used for the real world work place.
Some of the many examples from the ground up are Clustering, Database Mirroring, Log Shipping and much more.
It helped me so much for the Exam 70-443.
Good stuff!
MCITP.......2007-07-18
The book lack illustration and examples. From a point of view it does prepared you for the exams, however, there is nothing new in compared to others programs.
Book Description
A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced querying techniques using Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples.
Customer Reviews:
Pedantic.......2007-09-20
The MS SQL books have dramatically risen in quality in a few short years. When SQL 7 and 2000 were released, there were may be 1-3 book which were truly outstanding. For SQL 2005, however, there are at least 5-10 books which are truly worthwhile and this is one of them.
The reason why the quality of books has risen is the expertise of the authors. For this book, the authors are either MS SQL MVP or have been involved with the creation of MS SQL at Microsoft.
Generally speaking, the book has high level expert description of the underlying MS SQL 2005 architecture and T-SQL commands. But it lacks a nice flowing writing style which hempers the understanding to a willing reader. This book is an another example of authors who are inept at explaining the subject matter which they are an expert much like a professor who can't teach.
I also felt some parts of the book were sloppy or not as detailed. For example, the authors state that one of the steps of T-SQL query tuning is the need to correlate wait stats with problematic queries. Yet they never provide an adequate example (other than providing a useless query of SYS.DM_OS_PERFORMANCE_COUNTERS table) of how to connect wait stat with a specific transaction. This is a huge missing link.
PROS:
1)Awesome details on Indexes and Query plans
2)Solid advice on how to improve T-SQL for better performance.
Cons:
1)Not for the beginners. The book goes straight to the harder subjects (PIVOT, APPLY, complex joins etc).
2)Does not cover simple or fundamental subject matters.
Excellent.......2007-09-20
Normally I don't write a review but I liked this book enough to do so. I am a programmer not an SQL developer. I knew the basics but not the details and I had to write complex queries in SQL 2005 so I researched books for couple days before I bought this one. I have never heard of CTE, APPLY, ROW_NUMBER or PIVOT to mention few. This book at the beginning gives you the basics to understand how queries are processed internally, the difference between the types of indexes and how to read the execution plans. Then it dives into the language. Each example is well thought. The example goes over the syntax, performance and also optimization. I read all of it and did most of the examples.
Not a handy reference book.......2007-09-19
Coming from an Oracle shop over to a MSS shop I was looking for a book that would provide me with the features of T-SQL, as well as act as a handy reference. The book is likely good as a teaching resource, albeit the English usage is horrible. As a quick reference, though, it's less handy than navigating the M$ online resources.
A must for every MSS dba's desk? Nah. Not even close. I have a doctorate in MIS and this is exactly the kind of convoluted writing that makes practitioners wince when they see someone with a Ph.D.
A Timely Release & A Great Resource.......2007-09-17
This book fits perfectly between SQL Books Online and the deeper T-SQL Programing books. For me the detailed theory of operation behind how T-SQL runs queries and making note of that flow as it applies to each type of query through out the book makes it all "Click".
If this is your style too and you don't want to just copy and tweak queries THIS is the book for you.
very very good book.......2007-08-26
Deep inside the way sqlserver compile and compute the tsql
very good for semi - new users
Tal g
Book Description
SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.
To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.
Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed:
- The history of the computerized database
- SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete
- SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints
- How data sets can interact with queries
- The importance of subqueries
- Data conversion and manipulation via SQL's built-in functions
- How conditional logic can be used in Data Statements
Best of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL.
Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.
Customer Reviews:
Only for MySQL, not for Microsoft SQL Server.......2007-07-19
Buy instead the excellent book by Ben Forta "SQL in 10 Minutes", which is a bit more simplistic but better.
This book is geared towards an older version of MySQL, ver 4.x. Despite my best efforts, and I have several books on SQL and am not entirely a beginner, I could not entirely translate the MySQL script source code associated with this book to MS SQL Server 2005 SQL.
Also, some of the "foreign keys" in the sample database have confusing names--a minor point but annoying.
Avoid this book, unless you want to use it (as I do) as a training exercise (since I have other SQL books) rather than a book you can learn from.
Not for a true novice.......2007-06-22
I bought this book thinking I could learn SQL as a true novice. This book is not intended for a real beginner, but for developers/programmers that probably already know at least one language. For a real beginner's book see Forta's MYSQL Crash Course or Teach Yourself SQL. This book, Learning SQL, would probably be your next book.
If you want to or have to use SQL, this is the book.......2007-05-07
I needed a book to get one started with SQL programming from the basics to professional use of the language. After reading a few books (thanks to our great Public Libraries system), I concluded that this book is the one.
It has the right size (size is important not to scare people off), makes the right assumptions about the reader, gives lots of examples (cases) and it is, mainly, DB agnostic.
Get it and READ it.
Excellent Book to Learn SQL Quickly!.......2007-04-04
Being an IT Professional i have seen many books till now and this is one of the best books i have seen. Price is not a matter if you get worth of the book and the way the author explains is impressive. Definitely a must have book for SQL Developers.
Learning SQL.......2007-01-10
Very good book for beginning. Plenty of examples, and explanations.
Plus author writes in very good manner, so you feel like having teacher sitting next to you
Average customer rating:
- The most comprehensive text on MySQL
- Just another half-hearted attempt at a book
- Excellent starting point for a new user
- MySQL Class In A Book
- All levels need the tutorials herein which guarantee nothing is lost in the cracks.
|
Learning MySQL (Learning)
Seyed M.M. (Saied) Tahaghoghi , and
Hugh Williams
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback
 Data Warehousing
| Databases
| Computers & Internet
| Subjects
| Books
Relational Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
MySQL & mSQL
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Software Development
| Software Design, Testing & Engineering
| Programming
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
Web Programming
| Programming
| O'Reilly
| By Publisher
| Books
General
| Programming
| O'Reilly
| By Publisher
| Books
Oracle & Database Programming
| Programming
| O'Reilly
| By Publisher
| Books
Look Inside Computer Books
| Trip
| Specialty Stores
| Books
Similar Items:
-
MySQL Cookbook
-
Learning PHP and MySQL (Learning)
-
MySQL Stored Procedure Programming
-
MySQL in a Nutshell (In a Nutshell (O'Reilly))
-
MySQL Crash Course (Sams Teach Yourself in 10 Minutes)
ASIN: 0596008643 |
Book Description
This new book in our popular 'Learning' series offers an easy-to-use resource for newcomers to the MySQL relational database. This tutorial explains in plain English how to set up MySQL and related software from the beginning, and how to do common tasks. The book also provides you with a foundation for more advanced database management. Readers new to the subject will gain a thorough grounding in database concepts and the most reliable ways to use MySQL. You'll learn the basics of Structured Query Language (SQL), which is used to insert and manipulate data, along with ways to:
- Design a database
- Secure a database server
- Get more value out of a database
- Interact with the database through the medium most people prefer: a web server
Learning MySQL is the ideal introduction to relational databases, and MySQL in particular, for the growing number of people who are turning to databases for both large systems and small web-based applications: The perfect tutorial for the fast-growing database market.
Customer Reviews:
The most comprehensive text on MySQL.......2007-10-03
I've read several books on MySQL but believe me this is the best of them. The author has done a fantastic job to bring this subject to such a level that anyone with little or no knowledge of RDBMS can understands it properly. The book covers all vital parts of MySQL.
Just another half-hearted attempt at a book.......2007-09-28
While the content of this book is a basic coverage of MySQL, the editing is absolutely atrocious. The page layout puts graphics for the examples being talked about perpetually two pages ahead of where the example is used in text. Additionally, every time they cover examples of what not to do, or incomplete layout it is corrected to show what you ought to do, then the discussion continues assuming you will use the previously deemed bad example. I also found that every example of a command being issued on the command-line was in it's needlessly long format, neglecting good practice in an attempt to be clear to the absolute beginner at anything.
Overall, I was hoping for a lot more out of this book, especially as it was one of the more recently written books and published by the generally decent O'Reilly company.
I am disappointed.
That said, there's still some good information nested in the excessively wordy paragraphs.
Excellent starting point for a new user.......2007-07-29
As a new user of MySQL with no previous SQL experience I found this book extremely helpful. This book helped me get my project up and running in very little time. I was especially impressed that even though the examples in the book did not directly correlate to what I was trying to accomplish it gave me enough general knowledge of MySQL to easily put together my project.
MySQL Class In A Book.......2007-04-19
The 'Learning' series of books by O'Reilly is one of my favorites by far. The thing the separates 'Learning' books from other ones is the fact that these books (for the most part) assume that the reader has a very limited knowledge of said subject matter and ramps them up in logical succession until the point where they are comfortable and developing/designing like a seasoned pro. A 'Learning' book won't make you into an uber pro overnight, but if you are the type that better learns away from the classroom and would rather spend said time (and a lot less money) sitting in front of a computer at home with a book on your lap, you could do a lot less than this O'Reilly line of books.
With 'Learning MySQL' the tradition most definitely continues. ~600 pages await the reader who picks up this gem and you don't need to have any extensive database experience in order to be able to pick this up and start cracking! From the basics of installation on Linux, Windows and the Mac to basic SQL like writing queries and stored procedures, the foundation is all there. Continuing on to discussing security, performing backups and tuning, this is an exceptional book broken up logically and smoothly into 6 parts and 18 chapters:
01. Intro
02. Installing MySQL
03. Using MySQL Monitor
04. Designing Databases
05. Basic SQL
06. Datbase Structures
07. Advanced Querying
08. More MySQL Goodies
09. Managing Users & Privileges
10. Backups & Recovery
11. Using An Options File
12. Configuring & Tuning The Server
13. Web Database Applications
14. PHP
15. PHP Application Case Study
16. Perl
17. Perl With MySQL
18. Serving Perl Pages To The Web
The chapters on PHP and Perl will show you how you can write web apps to interact with your MySQL database and move far beyond the basics or returning tables and rows to the fun you can really have with MySQL!!!
If you are using MySQL for fun or work, this is a great guide for all new/amateur programmers that want to get working efficiently in no time at all!!
***** HIGHLY RECOMMENDED
All levels need the tutorials herein which guarantee nothing is lost in the cracks........2007-02-03
A range of users are possible for Seyed M.N. Tahaghoghi & Hugh E. Williams's handbook Learning MySQL, from those running a business or keeping membership records to others who are involved in software design. LEARNING MYSQL covers all the basics in introductory chapters - then moves ahead to more advanced uses of SQL, from configuring MySQL for better security to advanced querying. The open source database offers plenty of advanced capabilities but without a book like LEARNING MYSQL, much of these would be lost: all levels need the tutorials herein which guarantee nothing is lost in the cracks.
Book Description
The popular, learn-by-doing tutorialupdated for SQL Server 2005. Teach yourself the fundamental techniques for designing, building, testing, and deploying SQL Server databasesone step at a time.
Customer Reviews:
Mostly focused on SQL statements for developers and DBA's.......2007-09-28
There is nothing in this book that you can not find in another more organized book.
Horrible!.......2007-06-06
I have yet to find a book by Microsoft Press that is well-written, and this one is the worst of them all. It was certainly a waste of my money. There are many other books on SQL 2005 that are far better.
Microsoft SQL Server(TM) 2005: Database Essentials Step by Step (Step By Step (Microsoft)) .......2007-03-08
A very good material for beginers. I would have like to found this material when I first took a DB class...
Really basic.......2007-02-24
This book is oriented towards people with absolutely no prior SQL experience. The first 3 chapters are nothing more than how to install and configure Sql 2005 server. There is a decent background on database design. Overall, its just an ok book. You can learn what this book contains just by spending a little time on the web.
RECOMMENDED.......2007-01-12
This book has been earning its keep from the get-go! Easy to find just what you need and put it into practice, without having to wade through the muck first.
Average customer rating:
- Learning PHP and MySQL
- should not have bought the book
- Good intro into using PHP and MySQL
- Great condition as promised
- Wrong book for me, right book for some
|
Learning PHP and MySQL (Learning)
Michele E. Davis , and
Jon A. Phillips
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Design
| Databases
| Computers & Internet
| Subjects
| Books
MySQL & mSQL
| Specific Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Internet
| Home Computing
| Computers & Internet
| Subjects
| Books
| Internet & Education
| Online Searching
| Web Browsers
| Web for Kids
General
| Programming
| Computers & Internet
| Subjects
| Books
General
| Languages & Tools
| Programming
| Computers & Internet
| Subjects
| Books
PHP
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
General
| Programming
| Web Development
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
Web Programming
| Programming
| O'Reilly
| By Publisher
| Books
General
| Programming
| O'Reilly
| By Publisher
| Books
Oracle & Database Programming
| Programming
| O'Reilly
| By Publisher
| Books
Web Authoring & Design
| Web Development
| O'Reilly
| By Publisher
| Books
Look Inside Computer Books
| Trip
| Specialty Stores
| Books
Similar Items:
-
Web Database Applications with PHP & MySQL, 2nd Edition
-
Learning MySQL (Learning)
-
Learning JavaScript (Learning)
-
PHP in a Nutshell (In a Nutshell (O'Reilly))
-
Learning PHP 5
ASIN: 0596101104 |
Book Description
The PHP scripting language and MySQL open source database are quite effective independently, but together they make a simply unbeatable team. When working hand-in-hand, they serve as the standard for the rapid development of dynamic, database-driven websites. This combination is so popular, in fact, that it's attracting many programming newbies who come from a web or graphic design background and whose first language is HTML. If you fall into this ever-expanding category, then this book is for you.
Learning PHP and MySQL starts with the very basics of the PHP language, including strings and arrays, pattern matching and a detailed discussion of the variances in different PHP versions. Next, it explains how to work with MySQL, covering information on SQL data access for language and data fundamentals like tables and statements. Finally, after it's sure that you've mastered these separate concepts, the book shows you how to put them together to generate dynamic content. In the process, you'll also learn about error handling, security, HTTP authentication, and more.
If you're a hobbyist who is intimidated by thick, complex computer books, then this guide definitely belongs on your shelf. Learning PHP and MySQL explains everything--from basic concepts to the nuts and bolts of performing specific tasks--in plain English.
Part of O'Reilly's bestselling "Learning" series, the book is an easy-to-use resource designed specifically for newcomers. It's also a launching pad for future learning, providing you with a solid foundation for more advanced development.
Customer Reviews:
Learning PHP and MySQL.......2007-07-18
PHP and MySQL are highly adaptive programs that can be used to create a variety of dynamic website potentials. Although fairly simple to use once you understand the basics, the learning curve on these programs is a little high at first. In order to use the capabilities, the user has to not only understand what the programs do and how they work together. However, probably the hardest part of the process is learning all the vocabulary associated with these systems.
Learning PHP & MySQL is a very good reference, especially for this latter challenge. The guide not only defines and explains each of the different concepts but gives examples that better illustrate these aspects while giving the user a glimpse into how they could use them for their own purposes. Especially for the more difficult sections, I really liked that I could replicate the code on my computer and see the results for myself. This aspect gave me a far better idea of how I could use these programs in conjunction to create the effects I want.
should not have bought the book.......2007-07-14
The php part is ok. The mysql, cookie, security chapters are junk. I guess
even the writer does not know what he is talking about. I do not know where
he pulled those chapters from. As a consequence, I had to go to mysql online
tutorial to learn mysql.
My background is computer science so I donot think other readers can understand what the author is talking about.
Good intro into using PHP and MySQL.......2007-05-30
I am a long time programmer (15 years) and wanted to start a new project based on PHP scripts and a MySQL database. This book was quite helpfull in getting me started. It wasn't necessary to read the entire book. I read those sections that were signifigant to what I needed. My background is very heavy on Enterprise products like SAS, Oracle, and DB2. The project I was working on didn't require such huge resources so I picked up this book and setup a linux box with a LAMP configuration to get started.
The book is a good starting point. Paticularly important is the interaction between HTML and MySQL in PHP. You can get a lot of information on just PHP from the PHP documenation. The best value I got out of the book was learning about the interaction between PHP and MySQL.
Great condition as promised.......2007-05-17
Book was received in a timely manor and condition as promised.
Wrong book for me, right book for some.......2007-04-26
I knew I had picked up the wrong book when, in the first or second chapter, the authors said that variable types didn't matter and that they wouldn't bother covering them until late in the book. Admittedly, I can see their point, but the way the statement was written made it apparent that they were aiming this at HTML authors and other people with little to no real programming experience. If you want to pick up the PHP language and already have experience with a real programming language or two, you'd be better off picking up something else. If not, this book actually would be a good way to get started.
Update: Now that I've chewed through a little more of the book, I would no longer recommend this book to even a beginner. Uncommented, and hard to read examples that make poor use of whitespace dominate later chapters. The examples aren't the 3-4 page long beasts you find in some C or Java books, but nonetheless, this book does not demonstrate good coding practices, and should not be used by a new programmer to pick up the ropes.
Average customer rating:
- ottimo libro
- You won't pass the 1Z0-007 exam with just this book.
- Great Book for studying
- This book is very helpful
- Good book - but independent test software needed to pass exam
|
OCA/OCP: Introduction to Oracle9i SQL Study Guide
Chip Dawes , and
Biju Thomas
Manufacturer: Sybex
ProductGroup: Book
Binding: Hardcover
Sybex
| Publisher
| Certification Central
| Computers & Internet
| Subjects
| Books
General
| Certification Central
| Computers & Internet
| Subjects
| Books
OCA & OCP
| Exams
| Certification Central
| Computers & Internet
| Subjects
| Books
Relational Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Management Systems
| Databases
| Computers & Internet
| Subjects
| Books
General
| Oracle
| Databases
| Computers & Internet
| Subjects
| Books
General
| Databases
| Computers & Internet
| Subjects
| Books
Beginning & Introductory
| Databases
| Computers & Internet
| Subjects
| Books
General
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
Study Skills
| Education
| Nonfiction
| Subjects
| Books
Study Guides
| Reference
| Subjects
| Books
Similar Items:
-
OCA/OCP: Oracle9i DBA Fundamentals I Study Guide
-
OCP Developer PL/SQL Program Units Exam Guide
-
Oracle9i PL/SQL Programming
-
OCP Introduction to Oracle9i: SQL Exam Guide
-
OCP: Oracle9i DBA Fundamentals II Study Guide
ASIN: 0782140629 |
Book Description
Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:
* In-depth coverage of official exam objectives
* Practical information on using SQL in a real-world Oracle9i environment
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Writing basic SQL SELECT statements
* Restricting and sorting data
* Displaying data from multiple tables
* Aggregating data using group functions
* Producing readable output with iSQL*Plus
* Creating and managing tables
* Controlling user access
Customer Reviews:
ottimo libro.......2007-07-03
è arrivato un pò oltre i tempi di stima della spedizione, ma nel complesso tutto bene
You won't pass the 1Z0-007 exam with just this book........2007-04-21
I just passed 1Z0-007 a few hours ago making 90% (47 of 52) first try. Trust me, If I ONLY studied this book, I would have failed. This book has so many mistakes that it will make you go crazy. It's completely outdated. It doesn't have the current exam objectives. The wording and content placement of this book is terrible. I should have bought the oracle 9i OCP: sql studyguide by Oracle Press.
Get the Self Test Software. It will save you a retake.
I'm studying Oracle's 10g PL/SQL book and Self Test for the next test.
I can't wait to be an OCA!
Great Book for studying.......2007-03-29
I bought this book and i am still preparing for the certification. So can't really say how useful it will be for the exam. But while reading it, i think it has a great style and really pertinent information.
I am confident this book will help me successfully complete the exam.
This book is very helpful.......2006-07-22
I just passed the 1z0-007 exam yesterday. I dont have a lot of experience with oracle, but this book helped me learn all the important concepts for the exam and helped me pass it in my first attempt.
I recommend this book to anyone who is looking to pass the exam. However, the usefulness of this book ends there. It is not very useful and the explanations are not detailed enough for learning more about the technology itself.
Good book - but independent test software needed to pass exam.......2006-07-21
Good book, very thorough, equally useful for study-reading and reference.
My one complaint was the end-of-chapter tests and practice tests, which were much more detailed and more difficult then the exam itself. I wasted time trying to perfect my knowledge until I purchased an 'Exam-Prep' software kit and found I was getting 90%+ on tests, instead of the 40 and 50%+ with the Sybex tests.
When I took the exam - sure enough 90%+
For the next exam I'm buying the Sybex book and 'Exam-Prep' software kit together!
Book Description
Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.
If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.
Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:
- Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables
- How to customize SQL Server 2005's settings and about SQL Server 2005's functions
- About joins, a common database mechanism for combining tables
- Query development, the use of views and other derived structures, and simple set operations
- Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005
Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.
Customer Reviews:
A Perfect book for beginners and Excellent read for others - Review of Database Administrator SQLAuthority.com.......2007-08-14
SQLAuthority.com Book Review :
Learning SQL on SQL Server 2005 (Learning) [ILLUSTRATED] (Paperback)
by Sikha Bagui, Richard Earp
Short Review:
This books covers simple and complex concept in very easy language with lots of examples. Every beginner can learn a great amount of tips from experienced authors. Whether you are a self-learner, new to databases or in need of SQL refresher, this is good read.
Detail Review:
This book is written by two conceptual strong SQL Server Gurus. SQL Server is growing extremely popular in the area of high-performance data applications. It is very important to learn about new features of SQL Server.
This book truly represents the concept and the motive authors holds while writing the book. The book is written as systematic guide to learning SQL using SQL Server 2005 - a relational and multi-user database.
This book starts with simple SQL concepts of management studio, simple select clauses, creating database and tables from scratch. It starts getting more involving and building difficult concepts on previously addressed easy concepts. Chapters about joins, sub queries, constraints are written with conceptual depth as well as lucid and simple language.
Authors suggest that this book is expected to be used by schools and SQL training organizations. I will add to that this book is for everyone who just wants to enjoy reading about SQL. This book should be read with hands on SQL Server practice. Reader will get most out of this book while doing exercise at the end of the book.
Review questions and exercise at the end of each chapter kept me occupied for long time. Few of them are very simple and few of them I have learned from this book. If you are experienced SQL programmer, I still suggest that you will enjoy reading the review questions. I will list few of those questions here.
When would you use the ROWCOUNT function versus using the WHERE clause?
If you are going to have too many nulls in a column, what would be data type to use?
What is the maximum number of the rows that a self join can produce?
Which function can the WITH TIES option be used with?
Is SELECT INTO allowed in a view? Why or why not?
Not always all the time, everybody wants to learn about difficult subject and in depth analysis. There are few times, when even experienced DBA and developers want to read back to basic concepts. I enjoy reading this book, if you are reader of my blog (www.sqlauthority.com) you will enjoy this book as this book is in agreement of my views of looking at SQL with simple logic but strong concepts.
There are few errors in the book but they are very minor and I was able to catch them easily. Authors seem to have good understanding about ORACLE in addition to SQL Server. That introduced some errors but on good side they are able to unleash few ideas which are not easy for SQL Server DBA to think of.
The chapter I enjoyed most is Joins Versus Subquery. Authors very easily explained their needs and differences. This statement shows the strength of chapter; If information from a table is needed in a result set, then that table can not be buried in a subquery- it must be in the outer query; simple but effective.
I highly recommend this book, if you are interested in learning about SQL in easy way. This book is PERFECT book for beginners and great reference for experience developers.
Rating : 4 and 1/2 stars
In Summary, This is must have book for every SQL student.
Pinal Dave
Principal Database Administrator
(http://www.SQLAuthority.com)
Good, but does have errors.......2006-11-13
This is a good introduction to SQL, using SQL Server 2005, but does have some errors. For example, in describing the BIT data type in section 3.4.1.3, the author states "BIT columns cannot be NULL and cannot have indexes on them". It is true that you cannot have indexes on them, but I have used NULLs in bit fields for a long time on SQL 2000, so why would they drop that feature in SQL 2005? After a quick test, and then a google search on that exact string, you'll quickly find that the statement is true for Oracle databases. You'll find the same sentence, verbatim, in Oracle's T-SQL reference.
Having found this kind of error, it does cast a shadow over some of the book. Verify the statements yourself if you question something, especially if it's sepcific to SQL 2005. They may be wrong. Other than that, the reader should be running the queries themselves and verifying the results (ie, learn by doing.)
Other than that, the chapters on Joins, Sets, Functions, and Subqueries to be good introductions, but not going beyond the basics. But this is a LEARNING book, so don't expect much more than the basics.
VERY VERY HIGHLY RECOMMENDED!!.......2006-07-24
Are you a student who wishes to learn SQL using Microsoft's SQL Server 2005? If you are, then this book is for you! Authors Richard Earp and Sikha Bagui, have done an outstanding job of writing a systematic guide to learning SQL by using SQL Server 2005--a relational and multiuser database.
Earp and Bagui, begin by showing you how to open SQL Server 2005 using SQL Server Management Studio, load the database, and view and perform simple table manipulations. Then, the authors introduce the user/learner to some basic SQL commands in SQL Server. Next, they discuss creating, populating, altering, and deleting tables. The authors then introduce and cover different types of joins--a common database mechanism for combining tables. They continue by covering SQL Server 2005's functions. Then, the authors discuss query development as well as the use of view and other derived structures. Next, they cover simple set operations. The authors then discuss subqueries, aggregate functions, and correlated subqueries. Finally, they present indexes and constraints that can be added to tables in SQL Server 2005.
This most excellent book is expected to be used by schools and SQL training organizations as well as by database and IT professionals who are actively working with SQL Server 2005. More importantly, this book presents every topic, concept, and idea with examples of code and output.
Excellent Way To Learn SQL & SQL Server 2005.......2006-07-18
Learning SQL on SQL Server 2005 by Richard Earp is an outstanding book for those that are new to SQL and want to learn how to use it on the SQL Server 2005 platform. Excellent writing, a compact size that isn't too big or too small (300+ pages), and solid content make this a book for those that want to pick up and excel at using SQL in no time at all.
11 Chapters cover all this needed to get started with the following topics covered:
01. Basics of setting up SQL Server 2005
02. Basic SQL commands
03. Creating, altering, populating tables
04. Joins
05. Functions
06. Developing queries
07. Set Operations
08. Joins versus Subqueries
09. Aggregation
10. Correlated Subqueries
11. Indexes and Constraints
All in all this is an EXCEPTIONAL piece of work that is well worth the price. I absolutely LOVE the 'Learning' line of books that O'Reilly puts out --- no doubt the easiest way for any person to just pick up a text and start getting to work as opposed to reading an 800 page encyclopedia that feels more like a filibustering politican rather than a teaching tool.
***** HIGHLY RECOMMENDED
Book Description
The MCSE SQL 2000 Administration Exam Cram is the premier test preparation title for candidates choosing to take the elective "Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition" exam (70-228). Covers vital exam topics such as creating and managing SQL Server 2000 Databases, performing disaster recovery, troubleshooting Integrity Checks, extracting and transforming data, and SQL Server 2000 Security. Candidates can also complete their total exam preparation with insightful test taking strategies, helpful hints and tips, and realistic case studies and practice questions.
Customer Reviews:
Not Sufficient.......2005-03-03
This book gives you alot of facts to remember and no examples to use. The test was all configuration and security scenario questions and alot of stuff in the book was hardly covered like backup and recovery, DTS, BCP, DBCC statements, replication, maybe one question each on these. No questions at all on steps to take during installation and configuration. I will be looking for something to supplement this with..
Not very useful.......2005-01-08
I read the entire book in 2 days... there is nothing in the book to actually remember... No concepts are described... all you see in this book are the screen shots of Enterprise Manager...
Honestly I don't recommend this book. I didn't try the Microsoft press book.. If I were to choose between this book and the Microsoft press book I would go for the Microsoft press book because I am very sure that any other book will have more information than this book. This book has nothing at all.. believe me.. NOTHING to read for the test.
I have used several Exam Cram books before and all of them turned out to be very useful other than this book. This book is not at all comparable with other books so use other books for your preparation.
GOOD LUCK
Disappointing..........2002-07-01
No, no, no.. This book is a waste of time. It gives an IN DEPTH step by step, excrutiatingly detailed how-to examples on using the installation wizard, and then glosses over the more important details that actually appear on the exam (like the C2 auditing and analyzing the SQL 2000 performance counters). If you're familiar at all with the software, this book has little or nothing to offer you in terms of actually test preparation. Microsoft assumes everybody taking the certification exams already knows when to click the next button.. Don't waste your time or money on this. The Dummies book is much better.
This book was money well spent.......2002-04-03
I passed 70-228 on my first attempt, using this book in conjunction with Transcender and Books Online as my primary study resources.
You won't get all the information you need to pass the real test from this book, but that is not its intent. It works well when used for what it is marketed as, which is a "cram" resource to supplement a sound knowledge of SQL Server 2000 administration. Especially useful for me were the practice questions, the practice test at the end, and the screenshots of Enterprise Manager dialogs. Good to have in the hours immediately before the test!
The contents have a few errors, including referring to the model database as "modal" throughout the book, but that doesn't detract too much from the overall utility of the book.
All in all, a good investment, considering the cost of each attempt on the real test.
RD
Did the job!.......2002-02-01
This book gave me the extra pieces of information I needed to pass the exam. SQL 2000 ROCKS!
Books:
- Microsoft Office Access 2003 Step by Step
- Microsoft Office Outlook 2003 Inside Out
- Microsoft Office Project 2003 Step by Step
- Network+ Exam Cram 2 (Exam Cram N10-003) (2nd Edition) (Exam Cram 2)
- Network+ Guide to Networks, Fourth Edition (Networking)
- Network+ Guide to Networks, Fourth Edition (Networking)
- Network+ Study Guide, 4th Edition
- Office 2003 All-in-One Desk Reference for Dummies
- Office XP for Dummies
- OpenGL(R) Programming Guide: The Official Guide to Learning OpenGL(R), Version 2 (5th Edition) (OpenGL)
Books Index
Books Home
Recommended Books
- WORDS THAT WORK: IT'S NOT WHAT YOU SAY, IT'S WHAT PEOPLE HEAR
- The Measure of a Man: A Spiritual Autobiography
- History: Fiction or Science
- Round Up the Usual Suspects: The Making of Casablanca : Bogart, Bergman, and World War II
- Online Bookselling: A Practical Guide with Detailed Explanations and Insightful Tips
- The Complete Calvin and Hobbes
- The Art of Innovation: Lessons in Creativity from IDEO, America's Leading Design Firm
- The Cultural Shaping of Accounting
- Money in an Unequal World: Keith Hart and His Memory Bank
- Rancher Ferrets on the Range
MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements (Pro Certification)
Microsoft SQL Server(TM) 2005: Database Essentials Step by Step (Step By Step (Microsoft))
MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation
Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam (Exam Cram 2)
