Murach's SQL Server 2008 for Developers
As the 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 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, DELETE, and MERGE statements with the
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, database security, XML
integration, and BLOBs (including the 2008 FILESTREAM
storage feature). And section 5 has three chapters on
how to use the CLR integration feature to create database
objects from Visual Studio with a language like C# or
Visual Basic.
Training aids available in the book itself: Practice exercises
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; the databases used in
the examples and the exercises.
Instructor's CD
The Instructor's CD for this book includes these materials:
- Instructional objectives for each chapter of the book
- Test banks in ExamView, Blackboard, and RTF formats
- Solutions to the chapter exercises in the book
- PowerPoint slides for classroom presentations
- 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.
|
|
