Return to home page
Searching: Muskingum library catalog
Record 40 of 850
  Previous Record Previous Item Next Item Next Record
  Reviews, Summaries, etc...
Author Dewson, Robin.
Title Beginning SQL server 2005 for developers : from novice to Professional / Robin Dewson.
Imprint Berkeley, CA : Apress, 2006.

View online
View online
Author Dewson, Robin.
Series The expert's voice in SQL server
Expert's voice in SQL server.
Subject SQL server.
Database management.
Data transmission systems.
Client/server computing.
Description 1 online resource (xxiii, 508 pages) : illustrations.
polychrome rdacc
Access Use copy Restrictions unspecified star
Reproduction Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2010.
System Details Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Contents SQL Server 2005 Overview and Installation -- SQL Server Management Studio -- Database Design and Creation -- Security -- Defining Tables -- Creating Indexes and Database Diagramming -- Database Backups, Recovery, and Maintenance -- Working with the Data -- Building a View -- Stored Procedures -- T-SQL Essentials -- Advanced T-SQL -- Triggers -- SQL Server 2005 Reporting Services.
Summary SQL Server 2005 is the next generation of the SQL Server database. It is the number one relational database for the Windows platform and represents a great leap forward for SQL server developers in terms of programming options, productivity, database management, and analysis. So if you have some basic knowledge of relational databases, and are looking to start a development career using SQL Server, then this book is the ideal first step. Assuming no prior knowledge of SQL Server, it teaches a database novice the core jobs and roles involved in developing for a SQL Server database for the SQL Server 2000 and 2005. It comes with a free CD containing an evaluation edition of SQL Server 2005 that you can install and then use to work through all of the tutorials, which cover: SQL for querying, inserting, updating, and deleting data; How to build a complete databases, from fundamentals of relational database design, to creating tables, relationships, indexes, and so on; Coverage of how to back up and restore databases to get you started with basic database administration in SQL Server; How to program in T-SQL, SQL Server's implementation (and extension) of the SQL programming language and Effective programming techniques using stored procedures and triggers. This book also provides practical advice, answers typical questions that you'll encounter from managers and DBAs, and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that mark you out as a competent developer from the very start.
Note English.
Print version record.
ISBN 9781430201243
1590595882 (Paper)
9781590595886 (Paper)
ISBN/ISSN 10.1007/978-1-4302-0124-3
OCLC # 262691703
Additional Format Print version: Dewson, Robin. Beginning SQL server 2005 for developers. Berkeley, CA : Apress, 2006 1590595882 9781590595886 (OCoLC)63526984