Скачать через торрент Sams Teach Yourself - Balter A. - Microsoft SQL Server 2005 Express in 24 Hours бесплатно torrent (книга, аудиокнига, журнал, комикс
Внимание!!! AdBlock блокирует показ некоторых скриншотов. Пожалуйста, все вопросы к разработчкикам
Автор
Сообщение
Galfimbul
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
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))
