Learning Tree International Ltd.
Edinburgh, London, United Kingdom
http://www.learningtree.co.uk/

SQL Programming Language

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

You Will Learn How To Design, build and query a relational database Capture the structure of an existing database with a CASE tool Develop a data model to describe an application’s data Apply normalisation to data for effective, stable database design Build a relational database from the logical database design Access data in a relational database using simple SQL queries ......
 

You Will Learn How To Achieve an end-to-end business intelligence solution using the Microsoft toolset Consolidate enterprise data into SQL Server Analysis Services cubes Perform data mining with Microsoft Office Excel Build dashboards, scorecards and KPIs for easy visualisation of business performance Map business processes into a cycle of monitoring, analysing and planning with Per......
 

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

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

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

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

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

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

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

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

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

You Will Learn How To Maintain, troubleshoot and secure Windows Server 2008 Implement key security components to protect your server Develop and deploy a patch management strategy Leverage built-in components to create a highly available infrastructure Optimise and tune system performance for greater responsiveness Recover from system failures with troubleshooting tools and techniq......
 

You Will Learn How To Apply Windows Server 2008 features to secure your infrastructure Deploy a Windows-based Public Key Infrastructure (PKI) as a foundation for security services Enhance access controls with policy-based multifactor authentication Build a scalable encryption solution that assures recovery of protected data Install and configure Network Access Protection (NAP) to exc......
 

You Will Learn How To Implement and administer Terminal Services in your Windows Server 2008 enterprise Install and manage Terminal Servers and Remote Desktop clients Enhance a Terminal Services environment with TS Gateway, TS RemoteApp, and TS Web Access Troubleshoot and optimise Terminal Servers and clients Manage Terminal Services network infrastructure requirements Secure Termi......
 

You Will Learn How To Implement Hyper-V to consolidate servers for optimised resource utilisation and availability Effectively plan and deploy virtual machines and virtual networks Roll out highly available services and applications through clustering and quick migrations Centralise management of virtual machines with System Center Virtual Machine Manager (SCVMM) Optimise, monitor an......
 

You Will Learn How To Leverage new SQL Server 2008 features and tools to support database administration and development Simplify server-side programming with new Transact-SQL commands Enforce standards to ensure compliance with policy-based management Monitor and log data changes for auditing compliance Enhance security and high availability through improved encryption and replicati......
 

You Will Learn How To Deploy ethical hacking to expose weaknesses in your organisation and select countermeasures Gather intelligence by employing reconnaissance, published data and scanning tools Probe and compromise your network using hacking tools to test and improve your security Discover how malicious hackers exploit weaknesses to "own" the network Protect against priv......
 

You Will Learn How To Implement a computer forensics incident-response strategy Lead a successful investigation from the initial response to completion Conduct disc-based analysis and recover deleted files Identify information-hiding techniques Reconstruct user activity from e-mail, temporary Internet files and cached data Assess the integrity of system memory and process architect......
 

You Will Learn How To Secure wireless networks against threats and attacks Implement the WPA2 and 802.11i security standards to protect your Wi-Fi network Encrypt wireless traffic using Temporal Key Integrity Protocol (TKIP) or Advanced Encryption Standard (AES) Leverage 802.1X and EAP authentication within an enterprise WLAN Build Wi-Fi auditing and accounting infrastructures Depl......
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.