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

SQL training courses and schools
SQL Programming

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 Queries for Oracle Databases
Course Format: Classroom
You Will Learn How To Formulate complex queries with Oracle SQL Apply the full range of complex query types Use the analytic OLAP functions of Oracle Test SQL queries completely Select the most efficient solution to complex SQL problems Choose between Oracle and ANSI style joins Course Benefits SQL forms the cornerstone of all relational database operations. Taking full advant...
 

Oracle PL/SQL
Course Format: Classroom
You Will Learn How To Develop efficient PL/SQL programs to access Oracle databases Create stored procedures and functions for maximum reuse and minimum code maintenance Design modular applications using packages Manage data retrieval for front-end applications Bulk bind collections to increase the speed of data movement operations Invoke native dynamic SQL to develop high-level abs...
 

SQL Language
Course Format: Classroom
You Will Learn How To Write SQL code based on ANSI/ISO standards to build and maintain database structures Update database content with SQL and transaction handling Retrieve data from single or multiple tables Process data with row and aggregate functions Manipulate data with correlated and non-correlated subqueries Apply views to break down problems and enhance security Course...
 

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...
 

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