Home Sitemap ContactUs News | Investors | Partners | Feedback TRAINING Courses VB.NET ASP.NET C#.NET SQL Server 2005 BizTalk Server 2006 Java & J2EE WebLogic Portal Testing Tools Materials Schedules       1. IINTRODUCTION TO SQL SERVER   Major features   Limits   Editions   Installing SQL Server 2. BASICS OF DATABASE DESIGN   Normalization   Denormalization   Tools for Normalization in SQL Server 3. BUILDING A DATABASE   Introducing SQL Server Management Studio   Databases   Tables   Indexes   Relations   Using T-SQL to build and alter objects 4. T-SQL BASICS   What is SQL?   Reading syntax diagrams   Identifiers   Datatypes   Operators   Wild cards   Variables   Functions   Using sqlcmd 5. SELECT QUERIES   The SELECT clause   The FROM clause   The WHERE clause   Using Joins   ORDER BY   GROUP BY and HAVING   TOP N and TOP N%   OVER   Full-text search 6. ACTION QUERIES   DELETE   TRUNCATE TABLE   UPDATE   INSERT   SELECT INTO 7. LOCKING AND SHOWPLANNING   What is Locking?   Monitoring and tuning Locking   Deadlocks   Application Locks   Tuning Queries with ShowPlan 8. VIEWS, STORED PROCEDURES AND FUNCTIONS   Partitioning and Joining Tables with Views   Updateable views   Indexed Views   Information Schema Views   Catalog Views   Stored Procedures   Functions 9. ADVANCED TRANSACT-SQL   Transactions   Distributed Transactions   Rowset Functions   Ranking Functions   Cursors   Structured Error Handling 10. XML and SQL Server   Using FOR XML   Using XQuery   HTTP SOAP access to data 11. TRIGGERS   INSERT triggers   DELETE triggers   UPDATE triggers   INSTEAD OF triggers   Recursive triggers   DDL triggers 12. REPLICATION   Replication Models   Setting up Replication   Snapshot publishing   Transaction publishing   Merge publications   Monitoring replication   Heterogeneous replication 13. .NET INSIDE OF SQL SERVER   Understanding .NET and the CLR   Using CLR objects in SQL Server   Using the Sql namespace 14. SMO and RMO Programming   What is SMO?   The SMO Object Model   Sample SMO tasks   Sample RMO tasks 15. Analysis Services   Understanding Analysis Services   Introducing BIDS   Creating a Data Cube   Exploring a Data Cube 16. SQL Server Integration Services   SSIS Architecture   SSIS Tasks   SSIS in action 17. Notification Services   The Notification Services Architecture   Using Notification Services 18. Reporting Services   The Reporting Services Architecture   Building Reports   Managing Reporting Services 19. Service Broker   The Service Broker Architecture   Using Service Broker 20. Security and SQL Server   Security modes and authentication   Fixed server roles   Database user accounts   Permissions   Database roles   Ownership chains   Functions 21. Conclusion

© Tonetics, Inc. All Rights Reserved. Privacy Statement | Terms