Austin - Baltimore - Boston - Charlotte - Chicago - Cleveland - Columbus - Dallas - Denver - Detroit - El Paso - Fort Worth - Houston - Indianapolis - Las Vegas - Los Angeles - Milwaukee - New Orleans - New York - Oklahoma City - Philadelphia - Phoenix - Portland - San Antonio - San Diego - San Francisco - San Jose - Seattle - Tucson - Washington

SQL training courses and schools
SQL Programming

School: AcademyX, Inc.
[All Courses]

SQL
Course Format: Classroom
Inserting, Deleting, and Updating Data using INSERT INTO statements to add new rows to database tables using DELETE FROM statements to remove rows from tables using UPDATE WHERE statements to change existing data Retrieving Data using SELECT to get data from certain fields and establishing aliases for those fields limiting the number of rows returned with WHERE clauses sorting t...
 

School: Unitek Information Systems
[All Courses]

Microsoft SQL Server 2008
Course Format: On-site
Module 1: Introduction to SQL Server 2008 Lessons The Evolution of SQL Server Preparing for SQL Server 2008 Lab 1: Exploring SQL Server Books Online Reviewing the SQL Server Books Online Tutorials Reviewing SQL Server Books Online After completing this module, students will be able to: Describe the evolution of SQL Server. Prepare for SQL Server 2008. Module 2: SQL Se...
 

SQL Server 2005 Reporting Services
Course Format: On-site
After completing this course, students will be able to: Describe SQL Server Reporting Services and its components. Create a Reporting Services report. Enhance a Reporting Services report. Create and manipulate data sets. Use report models to implement reporting for business users. Configure report publishing and execution settings. Implement subscriptions for reports. Administe...
 

SQL Server 2005 Integration Services
Course Format: On-site
After completing this course, students will be able to: Describe SQL Server Integration Services and its tools. Create an Integration Services package. Implement control flow in an Integration Services package. Implement data flow in an Integration Services package. Implement logging in an Integration Services package. Debug and implement error handling in an Integration Services p...
 

SQL Server 2005 Analysis Services
Course Format: On-site
After completing this course, students will be able to: Describe how SQL Server Analysis Services can be used to implement analytical solutions. Create multidimensional analysis solutions with SQL Server Analysis Services. Implement dimensions in an Analysis Services solution. Implement measures and measure groups in an Analysis Services solution. Query a multidimensional Analysis Se...
 

Maintaining a Microsoft SQL Server 2005 Database
Course Format: On-site
After completing the course, students will be able to: Install and configure SQL Server 2005. Manage database files. Manage security. Perform administrative tasks. Backup databases. Restore databases. Monitor SQL Server. Troubleshoot SQL Server. Transfer data. Maintain high availability. Prerequisites Before attending this course, students m...
 

Implementing a Microsoft SQL Server 2005 Database
Course Format: On-site
After completing the course, students will be able to: Create databases and database files Create data types and tables. Use XML-related features in Microsoft SQL Server 2005. Plan, create, and optimize indexes. Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas Implement views. Implement stored procedures and fu...
 

Tuning and Optimizing Queries using Microsoft SQL Server 2005
Course Format: On-site
This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment. At Course Completion After completing this course, students will be able to: Normalize databases. Design a normalized database. Optimize a database design by denormalizing. ...
 

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
Course Format: On-site
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment. Prerequisites Before attending this course, students must have: Have working knowledge of SQL Server 2005 architecture. Such as, indexing, SQL execution plans, SQL Server b...
 

Administering and Automating Microsoft SQL Server 2005 Databases and Servers
Course Format: On-site
Module 1: Managing and Automating Databases and Servers This module provides you with the guidelines and considerations for planning automated systems for databases and servers. This module also provides you with the knowledge required to maintain a run book. Lessons Planning an Automated System for Database Maintenance. Planning an Automated System Server Maintenance. Doc...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ... [ Popular Topics ] [ Schools Only ]