|
 |
 |
Ready to Order? Order
online, call
1-800-578-2062
or
+44(0)1903 740 624 in Europe (UK). |
 |
|
 | Exploring SQL Server 2005 with Don Kiely
|
| View Course Outline | Print Course Outline (.PDF) Want to get up to speed on Microsoft's new SQL Server 2005? SQL Server 2005 is a major upgrade from its very successful predecessor, SQL Server 2000. This course introduces you to the new technological advances in SQL Server 2005 that provide businesses decreased downtime, increased scalability and performance, and set a new standard on data security. You will also learn about many new features that greatly reduce application development time allowing developers to be highly productive. Course includes 9+ hours of total training time... - 6 modules of training
- Over 9 hours of media run time
- Sample code
| SPECIAL OFFER: BUY 1 GET 1 FREE TRAINING! Details...
Hurry, offer ends 9/30/2010. Not valid on printed books. | | Format | Modules | Retail Price | | Exploring SQL 2005 | | CD-ROM | 6 CD-ROMs
ZSQ05-CD-50 | | DVD-ROM | 1 DVD-ROM
ZSQ05-DV-50 | | Multi-User License | Need to train multiple users? Call 800-578-2062 to purchase additional user licenses for your AppDev Product. | | 100% Satisfaction Guaranteed. Details... |
| |
| | Course Outline (Outlines are subject to change.) |
| Exploring SQL Server 2005 |
This course looks at many of the new features within SQL Server 2005 and will give you a first look at Microsoft’s new powerful database server. | Introduction to SQL Server 2005
- Database Engine
- Security
- Analysis Services
- Integration Services
- Reporting Services
- Notification Services
SQL Management Tools
- Management Studio
- Reports
- Template Explorer
- SQL Server Profiler
- Database Tuning Advisor
- Configuration Manager
- Surface Area Configuration
- SQLCMD
Authorization
- Strong Password Policies
- Password Policies
- Changing a Login
- SQL 2005 Principals
- Securable Objects
- Metadata Visibility
Security in Practice
- Execution Contexts
- Ownership Chains
- When to Use Each Option
- Users and Schemas
- Synonyms
Encryption
- Algorithms
- Encryption Hierarchy
- Service Master Key
- Database Master Key
- Use a Certificate
- Asymmetric Keys
- Symmetric Keys
SQLCLR
- Introduction to SQLCLR
- Why Use SQLCLR Code?
- Creating Raw SQLCLR Code
- Create with Visual Studio
- Deploy the UDF
- Deployment Notes
- Data Access in SQLCLR
- User-Defined Functions
- Stored Procedures
More SQLCLR
- Write a SQLCLR Stored Procedure
- User-Defined Aggregates
- Triggers
- User-Defined Types
- Troubleshooting Code
- Security in SQLCLR
- Permission Sets
- Secure Coding Practices
- T-SQL vs SQLCLR
SQL Management Objects
- Management Frameworks
- SMO Object Model
- SMO Class Types
- Code Behind the SMO Demo
- Code to Connect to the Server
- Create a Database
- Delete a Database
- Create a Table
SQL Express & Visual Studio Integration
- Introducing SQL Express
- Client and Management Tools
- Design Time Features
- Create a Database Application
- Deploy the Database Application
- Server Explorer Features
- SQL Reporting Services
ADO.NET Enhancements
- New Data Types
- Multiple Active Result Sets
- Asynchronous Queries
- Asynchronous Methods
- Error Handling
- Query Notifications
- Working with Service Broker
- Setup Database for Service Broker
Client Access Enhancements
- Batch Updates
- Bulk Copy
- Changes to the DataTable
- Stream Data into DT/DS
- DataTable from a DataView
- New Rowstate Features
XML
- XML Data Type
- Typed XML Data
- Indexing XML Data
- Using the XML Schema
- Querying XML
- XML Data Type Methods
- XQuery Limits in SQL Server
T-SQL XML Enhancements
- Retrieving XML
- Path for Returning XML Data
- Include Multiple Paths
- Output Column Data as a TN
- Include an Inline XML Schema
- Nested FOR XML Queries
- OpenXML Enhancements
- XML Bulk Load
Web Services
- Exposing Web Services
- Create a Stored Procedure
- Create a Web Service
- View the WSDL
T-SQL Enhancements - Part 1
- New Data Types
- Using TOP
- Using DML Output
- Pivot/Unpivot Operators
T-SQL Enhancements - Part 2
- Ranking Functions
- Using Other Ranking Functions
- Common Table Expressions
- Using DDL Triggers
| back to top
| | Your Instructor Don Kiely has been using and programming computers since the mid-1970s, when he first punched IBM punch cards for batch processing to solve engineering problems. Now Don is a nationally recognized author, instructor and consultant who travels the country sharing his expertise in SQL Server and security. He has written business software using assembly, C/C++, dBASE, Nantucket Clipper, RPG II, C#, and Visual Basic for a variety of industries, and has taught software and business administration courses at community colleges. Now Don is an author and presenter for AppDev, and a consultant for a variety of companies that develop distributed applications for public and private organizations. Don is also the author or coauthor of several programming books, and a featured speaker at SQL Server conferences. | back to top
|
|
|
