SQL Querying school training courses in Columbia, SC (public, in-house or online)

This advanced course on SQL provides critical information necessary for writing advanced database queries using complex databases. You will learn how to:
â—?Use advanced techniques for querying a database
â—?Design sub-queries
â—?Use data dictionaries
â—?Establish database security
â—?Create and manage sequences and indexes
â—?Create stored procedures

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