SQL Querying school training courses in Allentown, PA.
An index of public, in-house or online SQL Querying training programs in Allentown
United States
Worldwide > United States > Pennsylvania > Allentown

SQL Querying school training courses in Allentown, PA (public, in-house or online)



SQL Querying

School: New Horizons Scranton, Wilkes-Barre, Allentown, Reading
Venue: Allentown, Reading, Scranton
Tel.: 610-867-4002, 610-685-1313, 570-270-2700

In this course, students will compose SQL queries to retrieve desired information from a database.

Objective :
Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, an...

Full archival course description>>

Microsoft SQL Server 2008 Transact-SQL
Format: Online

School: Solartech, Inc.
Venue: New York City, Parsippany
Tel.: 877-SOLARTECH

After completing this Microsoft SQL Server 2008 training course at Solartech, students will be able to:

�

Describe the uses of and ways to execute the Transact-SQL language.


�

Use querying tools.


�

Write SELECT queries to retrieve data.


�

Group and summarize data by using Transact-SQL.


�

Join data from multiple tables.


�

Write queries that retrieve and modify data by usi...

Full archival course description>>





Querying Microsoft SQL Server 2012
Format: Online

School: Solartech, Inc.
Venue: New York City, Parsippany
Tel.: 877-SOLARTECH

This 5-day SQL Server 2012 training from Solartech teaches you how to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Official Website: http://www.solartechnj.com/
DB2 SQL
Format: Online

School: ExitCertified USA
Venue: Houston, Las Vegas, Philadelphia, Phoenix, New York City, Sacramento, San Francisco, San Jose
Tel.: 1.800.803.3948

Discuss basic relational database concepts
Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
Create tables, views and indexes
Use referential integrity, check constraints and triggers
Use outer joins, and join tables to themselves
Use CASE expressions, and the CAST function
Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables
Use complex subqueries
Use a greater number of scalar SQL functions
Use adv...

Full archival course description>>



SQL Querying job vacancies in Allentown
DB2 SQL
Format: On-site

School: Beacon Training Services
Venue: Dallas
Tel.: (972) 404-0069

This 2-day course is for programmers, analysts, managers and users who will be using SQL for queries and reports. It will cover such topics as:

Table Names

Basic SELECT statement

Sorting

WHERE Clause Predicates

Grouping Data

BUILT-IN Functions

INSERT, UPDATE, DELETE

JOINS

SUBQUERIES

Correlated SUBQUERIES

UNIONS

Building and Maintaining Data Structures

Referential Integrity

Views

Official Website: http://www.beacontraining.com/

Allentown vacation & tour packages

     Page Number: 1 2