1 option
Sams teach yourself Microsoft SQL Server 2005 Express in 24 hours
- Format:
- Book
- Author/Creator:
- Balter, Alison, Author.
- Series:
- Sams Teach Yourself
- Sams teach yourself
- Sams teach yourself Sams teach yourself Microsoft SQL Server 2005 Express in 24 hours
- Language:
- English
- Subjects (All):
- SQL server.
- Relational databases.
- Client/server computing.
- Physical Description:
- 1 online resource (436 p. ) ill. + 1 CD-Rom (4 3/4 in.).
- Edition:
- 1st edition
- Other Title:
- SQL server 2005 Express
- Place of Publication:
- [Place of publication not identified] Sams Publishing 2006
- Language Note:
- English
- System Details:
- text file
- Summary:
- Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize: SQL Server stored procedures Functions Triggers using T-SQL, VB.NET, and C# You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005.
- Contents:
- Intro
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- Tell Us What You Think!
- Introduction
- Part I: Introduction to SQL Server
- Hour 1 Basic Relational Database Design
- Hour 2 SQL Server Basics
- Hour 3 Getting to Know the SQL Server Management Studio
- Part II: Working with Tables, Views, and Stored Procedures
- Hour 4 SQL Server Tables
- Hour 5 Working with Table Relationships
- Hour 6 Getting to Know the SELECT Statement
- Hour 7 Building SQL Statements Based on Multiple Tables
- Hour 8 Modifying Data with Action Queries
- Hour 9 Getting to Know the T-SQL Functions
- Hour 10 Working with SQL Server Views
- Hour 11 Creating Complex Views
- Hour 12 Using T-SQL to Design SQL Server Stored Procedures
- Hour 13 Important Stored Procedure Techniques
- Hour 14 Stored Procedure Special Topics
- Hour 15 ADO.NET and SQL Server
- Hour 16 Using VB to Design SQL Server Stored Procedures
- Hour 17 Visual Basic .NET Special Topics
- Hour 18 Using C# to Design SQL Server Stored Procedures
- Hour 19 C# Special Topics
- Hour 20 Debugging the Stored Procedures That You Write
- Part 3: Security and Administration
- Hour 21 SQL Server Authentication
- Hour 22 SQL Server Permissions Validation
- Hour 23 Configuring, Maintaining, and Tuning SQL Server
- Hour 24 Performance Monitoring
- Appendix A: Using the NorthWind Sample Database File
- Index.
- Notes:
- Bibliographic Level Mode of Issuance: Monograph
- Description based on publisher supplied metadata and other sources.
- ISBN:
- 9786610848775
- 9780132715553
- 0132715554
- 9781280848773
- 1280848774
- 9780768666922
- 0768666929
- OCLC:
- 1027159568
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.