SQL school training courses in Alexandria, LA (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

Structured Query Language (SQL) is a powerful way to organize and extract information from relational databases. This class will teach you how to write queries using SQL, and techniques for effective and efficient database design. In this course you will learn how to:
â—?Design relational databases
â—?Use the proper syntax for SQL statements
â—?Analyze and organize data
â—?Retrieve, insert, update, and delete data
â—?Use aggregate functions
â—?Write queries from multiple tables...

Full archival course description>>

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement reporting solutions by using Microsoft SQL Ser...

Full archival course description>>

This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

Audience
This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2008 Integration Services.

At Course Completion
After complet...

Full archival course description>>

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

Audience
The primary audience for this course is individuals who design and maintain business intelligence solutions for thei...

Full archival course description>>