SQL Server Training Courses and Workshops
School(s) providing training of SQL Server Administration

SQL Server 2008 Database Administration
Course Format: Classroom
School/Trainer: Learning Tree International Ltd. [>>]
Training Center(s)/Venue(s): Edinburgh, London, United Kingdom

You Will Learn How To Administer SQL Server 2008 with SQL Server Management Studio and Transact-SQL Build databases and upgrade from prior versions Implement login security and authorise database access Manage complex access requirements with permissions and roles Develop backup strategies to recover from disasters Import and export data with SQL Server Integration Services Cou......

Course description>>

 

You Will Learn How To Leverage SQL Server 2008 Reporting Services to extract business intelligence from your data Design reports and display your data graphically with enhanced visualisation features Integrate parameters, filters and interactive components into report design Deploy and deliver relevant reports across the entire enterprise through Report Server and SharePoint Safeguar......

Course description>>

 

You Will Learn How To Leverage SQL Server 2008 technologies to achieve high availability databases Design a Service Level Agreement that matches business requirements Plan, prepare and install a SQL Server 2008 failover cluster Maintain a warm standby server with log shipping Mirror a database to ensure disaster recovery Employ replication as a high availability solution Course......

Course description>>

 

You Will Learn How To Develop server-side database programs for SQL Server databases Retrieve XML data with XQuery Build scalable message-based applications with Service Broker Access data using LINQ Create functions and stored procedures in .NET CLR Persist objects in the database with ADO.NET Entity Framework Course Benefits SQL Server 2005 and 2008 offer development feature......

Course description>>

 

You Will Learn How To Develop database applications for SQL Server databases with Transact-SQL Create modular code using stored procedures Develop reusable code with scalar and table valued functions Handle Transact-SQL runtime errors to create robust software Audit data changes using AFTER triggers Manage concurrency using transactions and locking options Course Benefits Tran......

Course description>>

 

You Will Learn How To Develop complex and robust SQL queries for SQL Server 2005 and SQL Server 2000 Query multiple tables with inner joins, outer joins and self joins Transform data with built-in functions Summarise data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Course Benefits Microsoft’s Transact......

Course description>>

 

You Will Learn How To Design and implement high-performance databases for SQL Server Create indexes that optimise different types of queries Design transactions that maximise concurrency and minimise contention Interpret the data access plans produced by the query optimiser Minimise I/O by designing efficient physical data structures Analyse and cure performance problems using SQL ......

Course description>>

 

You Will Learn How To Migrate and transform data using SQL Server 2005 Integration Services (SSIS) Upgrade DTS packages and perform imports and exports Assemble tasks to perform complex data migrations Enhance package functionality with scripting Extract, Transform and Load (ETL) data Integrate Business Intelligence components Course Benefits In order to improve business intel......

Course description>>

 

You Will Learn How To Leverage SQL Server Analysis Services to produce Business Intelligence solutions Create and deploy multidimensional data cubes Extend hierarchies and exploit advanced dimension relationships Slice and dice your data with advanced dimension hierarchies Make smarter business decisions with data mining techniques Implement Key Performance Indicators (KPIs) to mon......

Course description>>

 

You Will Learn How To Leverage SQL Server Analysis Services to produce Business Intelligence solutions Create and deploy multidimensional data cubes Extend hierarchies and exploit advanced dimension relationships Slice and dice your data with advanced dimension hierarchies Make smarter business decisions with data mining techniques Implement Key Performance Indicators (KPIs) to mon......

Course description>>

 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ...

Argentina - Australia - Austria - Belgium - Canada - Colombia - Denmark - Egypt - France - Germany - Greece - Hong Kong - India - Indonesia - Ireland - Italy - Japan - Luxembourg - Malaysia - Mexico - New Zealand - Nigeria - Norway - Pakistan - Philippines - Singapore - South Africa - Spain - Sweden - Switzerland - The Netherlands - United Arab Emirates - United Kingdom - United States

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.