|
Crash Course in Microsoft SQL Server 2005 on 3 CD-ROMs |  | From: Silico-Magnetic Intelligence Corp.
Category: Software
List Price: $395.00
Buy New: $245.00
as of 9/10/2010 13:39 CDT details
You Save: $150.00 (38%)
Seller: eMediaGrand
Sales Rank: 16797
Format: CD
Platform: Windows
Media: CD-ROM
Operating System: Windows
Shipping Weight (lbs): 5
Dimensions (in): 9 x 1 x 12
UPC: 850171001081
EAN: 0850171001081
ASIN: B000MPP3N2
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | Video/Audio Introduction to Microsoft SQL Server 2005 | | • | Three Day Course: 1 CD a Day, Includes Reference Book | | • | Database Design, the SELECT Statement, T-SQL | | • | Advanced SQL Queries & Database Administration | | • | Overview of Data Warehousing & Business Intelligence |
| |
| Editorial Reviews:
Product Description
CD-ROM 1 1. Welcome Aboard
2. Relational Database Systems & Design
3. Client-Server Architecture 4. SQL: Structured Query Language
5. Systems Analysis: Entity-Relationship Modeling
6. Data Integrity in the Enterprise
7. SQL Server 2005 New Features
8. Query Editor Primer
9. Management Studio: Database Administration
10. The AdventureWorks Sample Database
11. SELECT: Writing Simple SQL Queries
12. Exploring & Managing Database Objects
13. Transact-SQL Identifiers and Comments
14. Transact-SQL Keywords and Data Types
15. Numeric, Date and String Functions
16. DDL - Data Definition Language
CD-ROM 2
1. ROW_NUMBER, Ranking & Tiling Functions
2. Subqueries & Common Table Expressions(CTE)
3. GROUP BY Clause and Aggregate Functions
4. Joining Tables with Primary and Foreign Keys
5. Correlated Subqueries, PIVOT and Temporary Tables
6. Populating Tables: INSERT, UPDATE & DELETE
7. Transact-SQL IF and WHILE Statements
8. Stored Procedures and User-Defined Functions
9. Views
10. Table Indexing and Query Optimization
11. UNION, ROLLUP and CUBE
12. AFTER Triggers and INSTEAD OF Triggers
13. Transactions, Blocking and Deadlocks
14. SQLCMD, bcp, & osql Utilities
15. Database Backup and Restore
16. SSIS: SQL Server Integration Services
CD-ROM 3 1. SQL Server Agent: Job Scheduling & Execution
2. TRY-CATCH for Application Error Control
3. Troubleshooting & Debugging
4. Dynamic Management Views & Functions
5. Column-Level Encryption of Sensitive Data
6. Application Performance Tuning
7. Books Online for Quick Reference
8. DB Operation Monitoring: SQL Server Profiler
9. Data Replication Across Servers
10. XML Datatype & XQuery
11. SSIS Import and Export Wizard
12. Data Warehouse, Data Mart & Data Mining
13. The AdventureWorksDW Sample Data Warehouse
14. Analysis Services: OLAP Cubes & Mining Structures
15. Business Intelligence Development Studio
16. Success Secrets to SQL Server 2005 Programming
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
