Sams Teach Yourself - Balter A. - Microsoft SQL Server 2005 Express in 24 Hours [2006, CHM, ENG]

 
Автор Сообщение

TorrentFilm ®

Пол:

Стаж: 2 года 10 месяцев

Сообщений: 7763



Награды: Нет

Торрент-статистика

Создавать темы 25-Дек-2015 00:04

[Цитировать]

Microsoft SQL Server 2005 Express in 24 Hours
Год: 2006
Автор: Balter A.
Жанр: Учебное пособие
Издательство: Sams
ISBN: 0-672-32741-4, 978-0-672-32741-4
Серия: Sams Teach Yourself
Язык: Английский
Формат: CHM
Качество: Изначально компьютерное (eBook)
Количество страниц: 456
Описание: 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.

Примеры страниц

Оглавление

Copyright
About the Author
Acknowledgments
Tell Us What You Think!
Introduction
Conventions Used in This Book
Part 1: Introduction to SQL Server
Hour 1. Basic Relational Database Design
Database Basics
System Versus User Objects
Table Basics
Relational Database Design Concepts
Database Diagram Basics
View Basics
Stored Procedure Basics
User-Defined Function Basics
Trigger Basics
SQL Server Stored Procedures Versus Transact-SQL Statements Stored on Local Computers
Summary
Q&A
Workshop
Activities
Hour 2. SQL Server Basics
Versions of SQL Server 2005 Available
Installing SQL Server Express
Getting Started with the SQL Server Management Studio Express
Summary
Q&A
Workshop
Activities
Hour 3. Getting to Know the SQL Server Management Studio
Microsoft SQL Server Management Studio Express
Creating a SQL Server Database
Summary
Q&A
Workshop
Activities
Part 2: Working with Tables, Views, and Stored Procedures
Hour 4. SQL Server Tables
Creating SQL Server Tables
Working with Constraints
Identity Columns
Working with Computed Columns
Working with User-Defined Data Types
Adding and Modifying Indexes
Summary
Q&A
Workshop
Activities
Hour 5. Working with Table Relationships
An Introduction to Relationships
Working with Database Diagrams
Working with Table Relationships
How to Designate Table and Column Specifications
How to Add a Relationship Name and Description
How to Determine when Foreign Key Relationships Constrain the Data Entered in a Column
Designating Insert and Update Specifications
Summary
Q&A
Workshop
Activities
Hour 6. Getting to Know the SELECT Statement
Introducing T-SQL
Working with the SELECT Statement
Adding on the FROM Clause
Including the WHERE Clause
Using the ORDER BY Clause
Adding the DISTINCT Keyword
Working with the FOR XML Clause
Creating Top Values Queries
Summary
Q&A
Workshop
Activities
Hour 7. Building SQL Statements Based on Multiple Tables
Working with Join Types
Working with the GROUP BY Clause
Including Aggregate Functions in Your SQL Statements
Taking Advantage of the HAVING Clause
Summary
Q&A
Workshop
Activities
Hour 8. Modifying Data with Action Queries
Modifying Data with Action Queries
Summary
Q&A
Workshop
Activities
Hour 9. Getting to Know the T-SQL Functions
Working with Numeric Functions
Taking Advantage of String Functions
Exploring the Date/Time Functions
Working with Nulls
Summary
Q&A
Workshop
Activities
Hour 10. Working with SQL Server Views
An Introduction to Views
Using T-SQL to Create or Modify a View
Summary
Q&A
Workshop
Activities
Hour 11. Creating Complex Views
Creating Views Based on Data in Multiple Tables
Views and Subqueries
Views and Outer Joins
Views and Top Values
Sorting View Results
Views and Functions
Views and Built-in Functions
Using Views to Secure Data
Modifying Data in a View
Modifying Views
Renaming Views
Deleting Views
Indexed Views
Optimizing the Views That You Build
Summary
Q&A
Workshop
Activities
Hour 12. Using T-SQL to Design SQL Server Stored Procedures
The Basics of Working with Stored Procedures
Declaring and Working with Variables
Controlling the Flow
Summary
Q&A
Workshop
Activities
Hour 13. Important Stored Procedure Techniques
The SET NOCOUNT Statement
Using the @@ Functions
Working with Parameters
Modifying Data with Stored Procedures
Errors and Error Handling
Stored Procedures and Transactions
Summary
Q&A
Workshop
Activities
Hour 14. Stored Procedure Special Topics
Stored Procedures and Temporary Tables
Stored Procedures and Security
Building and Working with User-Defined Functions
Creating and Working with Triggers
Summary
Q&A
Workshop
Hour 15. ADO.NET and SQL Server
The History of Data Access
The Basics of ADO.NET
Building Queries That Modify Data
Summary
Q&A
Workshop
Activities
Hour 16. Using VB to Design SQL Server Stored Procedures
Executing a Simple Stored Procedure
Declaring and Working with Variables
Controlling Program Flow
Working with Parameters
Modifying Data with Stored Procedures
Summary
Q&A
Workshop
Activities
Hour 17. Visual Basic .NET Special Topics
Working with Temporary Tables
Including Error Handling in the Stored Procedures that You Build
Using Transactions to Protect Your Data
Summary
Q&A
Workshop
Activities
Hour 18. Using C# to Design SQL Server Stored Procedures
Executing a Simple Stored Procedure
Declaring and Working with Variables
Controlling Program Flow
Working with Parameters
Modifying Data with Stored Procedures
Summary
Q&A
Workshop
Activities
Hour 19. C# Special Topics
Working with Temporary Tables
Including Error Handling in the Stored Procedures That You Build
Using Transactions to Protect Your Data
Summary
Q&A
Workshop
Activities
Hour 20. Debugging the Stored Procedures That You Write
Harnessing the Power of the Immediate Window
Invoking the Debugger
Using Breakpoints to Troubleshoot
Stepping Through Code
Setting the Next Statement to Execute
Viewing the Call Stack
Working with the Locals Window
Working with Watch Expressions
Summary
Q&A
Workshop
Activities
Part 3: Security and Administration
Hour 21. SQL Server Authentication
The Basics of Security
Types of Authentication Available
How to Create Logins
How to Create Roles
Summary
Q&A
Workshop
Activities
Hour 22. SQL Server Permissions Validation
The Types of Permissions Available
Getting to Know Table Permissions
Getting to Know View Permissions
Getting to Know Stored Procedure Permissions
Getting to Know Function Permissions
Implementing Column-Level Security
Summary
Q&A
Workshop
Activities
Hour 23. Configuring, Maintaining, and Tuning SQL Server
Selecting and Tuning Hardware
How to Configure and Tune SQL Server
How to Maintain Your Databases
How to Maintain Tables and Other Objects
Summary
Q&A
Workshop
Activities
Hour 24. Performance Monitoring
Executing Queries in SQL Server Management Studio Express
Displaying and Analyzing the Estimated Execution Plan for a Query
Adding Indexes to Enable Queries to Execute More Efficiently
Setting Query Options
Summary
Q&A
Workshop
Activities
Appendix A. Using the NorthWind Sample Database File
What You Need to Know About Installing the Sample Database Files
Attaching to the NorthWind Sample Database File
Index
[Профиль] [ЛС]
Показать сообщения:    

Текущее время: Сегодня 11:49

Часовой пояс: GMT



Вы не можете начинать темы
Вы не можете отвечать на сообщения
Вы не можете редактировать свои сообщения
Вы не можете удалять свои сообщения
Вы не можете голосовать в опросах
Вы не можете прикреплять файлы к сообщениям
Вы не можете скачивать файлы