SQL Server
School: American Career Institute Woburn Campus
Venue: Boston
Tel.: 781.939.0607Ready to upgrade your skill set from software developer to enterprise solutions developer? Exploring Massachusetts and Maryland programming certification programs? Our Enterprise Solutions Developer certificate program is designed for you.
You’ll explore the Microsoft .Net framework with concentration on C# as well as the J2EE environment. This intense program educates students on the architectural approaches used in enterprise projects and the technical skills needed to build, support an...
Full archival course description>>
|
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>>
|
