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

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

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

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.

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

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