Murach's SQL Server 2005 for Developers
As its title implies, this book presents all of the
SQL Server skills that application developers need on
the job. As such, it can be used as the primary text
in a SQL course or as a supplementary text in a database
programming course. It can also be used as a real-world
supplement to the primary text in a more theoretical
database course.
Unlike most database or SQL Server books, the first
8 chapters of this book show how to use the Select,
Insert, Update, and Delete statements with the 2005
Management Studio to work with an existing database.
That gives the students a solid understanding of how
a database works.
With that as background, the three chapters in section 3 show how to design and implement a new database using either SQL statements or the Management Studio. We believe that this presentation sequence works much better than the traditional sequence, and many instructors have told us that they agree.
Then, section 4 shows how to use advanced features
like views, stored procedures, functions, triggers,
cursors, transactions, locking, and database security,
plus the 2005 XML integration feature. And section 5
has three chapters on how to use the 2005 CLR integration
feature, which lets you create database objects from
Visual Studio with a language like C# or Visual Basic.
Training aids available in our Downloads section: Source code for all the coding examples in the book, including both C# and Visual Basic code for the examples in the CLR integration section
Instructor's CD
The Instructor's CD for this book includes these materials:
- Instructional objectives by chapter
- PowerPoint slides for classroom presentations
- A question bank in both RTF and ExamView formats (though we can provide it in WebCT or Blackboard format as well)
- Practice exercises with test databases, and exercise solutions
- Source code and databases for all the examples in the book (for the CLR integration examples, we provide Visual Basic code as well as the C# code shown in the book)
For a detailed look at these materials and how you can use them in your
course, please view
the Instructor's Summary that we've prepared (it's
a PDF document). Then, if you like what you see, you
can request a review copy of
the book and its Instructor's CD. Or, for more information,
you can email us at murachbooks@murach.com
or call us at 1-800-221-5528.
|
|
