Microsoft SQL Server 2008 for dummies
If you're a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company's data management - read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build pow...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, NJ :
Wiley
2008.
|
| Edición: | 1st edition |
| Colección: | --For dummies.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627531606719 |
Tabla de Contenidos:
- Microsoft SQL Server 2008; Table of Contents; Introduction; Part I Welcome to SQL Server 2008; Chapter 1 Introducing SQL Server 2008; Starting Off on the Right Foot; Understanding the Basic Components of SQL Server; Implementing Databases with SQL Server 2008; What's New in SQL Server 2008; Chapter 2 Building Your SQL Server; Installing SQL Server 2008; Upgrading an Existing SQL Server Installation; Configuring Database Mail; Using SQL Server's Built-In Databases; Chapter 3 Working with SQL Server Tools; Using SQL Server Configuration Manager
- Managing Your Server with SQL Server Management StudioWorking from the Command Line; Part II Building SQL Server 2008 Databases; Chapter 4 Planning Your Database; Introducing Database Design Concepts; Understanding the Elements of a Database; Organizing a Database; Diagramming Your Database; Staying Fit and Trim with Normalization; Choosing Data Types for Your Tables; Working with NULL Values; Chapter 5 Creating Databases and Tables; Creating a Database; Specifying Files and Filegroups; Creating a Table; Chapter 6 Imposing Constraints and Relationships; Introducing Constraints
- Controlling Database Contents Using ConstraintsEnforcing Database Integrity; Part III Retrieving Data from Databases; Chapter 7 Constructing Simple Database Queries; Retrieving Data with SELECT Statements; Organizing Query Results; Chapter 8 Joins and Other Advanced Queries; Joining Data from Multiple Tables; Taking SELECT to the Next Level; Using Database Views; Chapter 9 Turning Data into Information with SQL Server Reporting Services; Setting up SQL Server Reporting Services; Creating an SSRS Report with Report Builder; Working with Deployed (Published) Reports
- Part IV Inserting and Manipulating Your DataChapter 10 Inserting, Updating, and Deleting Data; Inserting Small Quantities of Data; Modifying and Deleting Data; Importing Large Quantities of Data; Working with SQL Server Integration Services; Chapter 11 Saving Time with Functions, Stored Procedures, and Triggers; Reusing Logic with Functions; Leveraging SQL Server's built-in functions; Creating Your Own Functions; Reusing SQL Code with Stored Procedures; Updating Data Automatically with Triggers; Modifying and Deleting Functions, Stored Procedures, and Triggers
- Part V SQL Server AdministrationChapter 12 Keeping Your SQL Server Running Smoothly; Indexing Data to Improve Query Performance; Improving Performance with Partitions; Updating Database Statistics; Managing File Sizes; Checking Database Integrity; Governing Resource Consumption; Chapter 13 Automating SQL Server 2008 Administration; Scheduling Tasks with SQL Server Agent; Implementing Database Maintenance Plans; Alerting Administrators about Database Events; Chapter 14 Troubleshooting SQL Server 2008 Problems; Understanding the Inner Workings of SQL Server Queries; Reviewing Log Records
- Monitoring Your Server with Performance Studio
