Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

SQL Server training courses and schools
SQL Server Administration

School: Premier IT Group
[All Courses]

Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
Course Format: Classroom
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
 

School: Learning Tree International Ltd.
[All Courses]

SQL Server 2005 Reporting Services
Course Format: Classroom
You Will Learn How To Leverage SQL Server 2005 Reporting Services to produce sophisticated reports Author robust reports that extract business intelligence out of your data Extract relevant report data using parameters and filters Render interactive reports with drill-down and drill-through features Deploy reports to a Report Server for centralised access and administration Secure ...
 

SQL Server 2008 Database Administration
Course Format: Classroom
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...
 

SQL Server 2008 Reporting Services
Course Format: Classroom
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...
 

SQL Server High Availability
Course Format: Classroom
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...
 

SQL Server Server-Side Programming with .NET and XML
Course Format: Classroom
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...
 

SQL Server Transact-SQL Programming
Course Format: Classroom
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...
 

SQL Queries for SQL Server
Course Format: Classroom
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...
 

High-Performance SQL Server Databases
Course Format: Classroom
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 ...
 

SQL Server Integration Services
Course Format: Classroom
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...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 [ Popular Topics ] [ Schools Only ]