Developing SQL Queries for Oracle Databases
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You 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 advantage of its power requires an in-depth understanding of the language. In this co...
Full archival course description>>
|
SQL Server Server-Side Programming with .NET and XML
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You 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 features that fully support the requirements of small- and large-scale organizations. ...
Full archival course description>>
|
SQL Programming Language Introduction
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You 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 noncorrelated subqueries
Apply views to break down problems and enhance security
Course Benefits
SQL forms the cornerstone of all relational database operations. The ...
Full archival course description>>
|
SQL Server Analysis Services
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You 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
Build custom solutions with MDX
Implement Key Performance Indicators (KPIs) to monitor business objectives
Make smarter business decisions with data mining techniques
Course Benefits
With the current explosion of data in today’s enterprise ...
Full archival course description>>
|
SQL Server Integration Services
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Migrate and transform data using SQL Server 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 intelligence capabilities, organizations must effectively and securely manage data migrat...
Full archival course description>>
|
