Sql Server
Basic Sql Server Training:
Training Course No : TSTRN427
Duration : 2 Days ( 16 Hours)
Course Fee : £ 350 + VAT
Topics Covered
• RDBMS Basics: What Makes Up a SQL Server Database?.
• Tools of the Trade.
• The Foundation Statements of T-SQL.
• JOINs
• Creating and Altering Tables.
• Constraints.
• Adding More to Our Queries.
• Being Normal: Normalization and Other Basic Design Issues.
• SQL Server Storage and Index Structures.
• Views.
• Writing Scripts and Batches.
• Stored Procedures.
• User Defined Functions.
• Transactions and Locks.
• Triggers.
• A Brief XML Primer.
• Reporting for Duty, Sir!: A Look At Reporting Services.
• Getting Integrated With Integration Services.
• Playing Administrator.
Book a Course
Advanced Sql Server Training:
Training Course No : TSTRN428
Duration : 5 Days ( 40 Hours)
Course Fee : £ 750 + VAT
Topics Covered
• SQL Server 2000 – Particulars and History.
• RDBMS Basics: What Makes Up a SQL Server Database?
• Tools of the Trade.
• The Foundation Statements of T-SQL.
• Joining Tables.
• Creating and Altering Tables.
• Constraints.
• Normalization and Other Basic Design Issues.
• SQL Server Storage and Index Structures.
• Views.
• Writing Scripts and Batches.
• Stored Procedures.
• User Defined Functions.
• Transactions and Locks.
• Triggers.
• Advanced Queries.
• Distributed Queries and Transactions.
• SQL Cursors.
• A Brief XML Primer.
• Integration of XML into SQL Server .
• The Bulk Copy Program (bcp).
• Introduction to Data Transformation Services.
• Replication.
• Advanced Design.
• Analysis Services.
• Full-Text Search.
• English Query.
• Security.
• Performance Tuning.
• Administration Overview.
• Advanced DTS.
• Scripting Administrative Functions with WMI.
Book a Course
To know more about us, our services and solutions, please click here to send us an enquiry.
Alternatively Call +(44) 845 6440628 or email us : sales[@]tishansoft.co.uk