SQL Training Courses

  • SQL Introduction to Querying - 2 days

    Learn to: Use SQL and databases, Use SELECT statements. Use aggregate functions , Use the WHERE clause, Search for specific data, Write queries for aggregrate data, and Write multi-table queries. Use advanced queries, Query with subqueries, Add data to a database, Change and delete data from a database, Create, alter, and delete tables, Create, use, and delete views, Create and delete indexes, Use transactions, and Create and drop databases.

  • Relational Database Design - 1 day

    Learn to: Analyze client requirements, Create a preliminary design, Implement the database design, Generate reports, and Customize a database.

  • SQL Fundamentals of Querying - 1 day

    Learn to: Understand relational database concepts and SQL, Use SQL SELECT statements. Use aggregate functions, column aliases, and mathematical expressions in a query statement, Use the WHERE clause to select specific rows of information from a database, Search for specific character strings or numeric data in a database, Write queries that return both aggregate and non-aggregate data, and Write multi-table queries.

  • SQL Advanced Querying - 1 day

    Learn to: Use advanced techniques for querying a database, Query with subqueries, Add data to a database, Change and delete data from a database, Create, alter, and delete tables, Create, use, and delete views, Create and delete indexes, Manage how data is altered through the use of transactions, and Create and drop databases.

  • MySQL Database Fundamentals - 1 day

    Learn to: Identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements, Create a preliminary database design, Apply normalization techniques to a database, Use SQL commands to execute simple queries, Use SQL compound statements to query efficiently, Manage databases by creating views, indexes, and transactions, and Administer and maintain a database.

  • SQL Server 2008 Reporting Services - 3 days

    Learn how to use SQL Server 2008 Reporting Services in this 3 day course covering the Report Designer, Data Access, Report Management, Report Execution and Subscriptions and Report Rendering.

  • SQL Server 2008 Enterprise Implementation and Maintenance - 4 days

    This course for SQL administrators covers all the key areas of administration of the SQL Server 2008 Enterprise version. Practical hands-on labs ensure that theory is suppported by practice.

  • SQL Server 2008 Standard Edition Implementation and Maintenance - 2 days

    This course for SQL administrators targets all the key areas of administration of the SQL Server 2008 Standard Edition which is does not some of the extra facilities of the Enterprise Edition. Practical hands-on labs ensure that theory is suppported by practice.

  • SQL Server 2008 Introduction to Querying - 2 days

    Learn to: Understand SQL Server databases, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Combine and Limit Result Sets, Work with Subqueries, and Insert, delete and update data in tables.

  • SQL Server 2008 Administration - 5 days

    Learn to: Install and Configure SQL Server 2008, Create, Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Create and Manage Partitions, Use SQL Server 2008 Security, Implement Policy-Based Management, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, Monitor SQL Server, Maintain High Availability, Troubleshoot and Performance Tune, and Setup Replication.

  • SQL Server 2008 Administration Fundamentals - 3 days

    Learn to: Install and Configure SQL Server 2008, Create Configure and Manage Databases, Create and Manage Tables, Implement and Manage Data Integrity, Create and Manage Indexes, Configure SQL Server 2008 Security, Transfer Data, Make Backups and Recovery, Harness SQL Server Automation, and Monitor SQL Server.

  • SQL Server 2008 Programming - 5 days

    Learn to: Use SQL Server Management Studio, Undertand SQL and Transact-SQL concepts, Use the SELECT Statement to Retrieve Data, Retrieve Specific Rows of Data Using the WHERE Clause, Format and Sort Result Sets, Query Data from Multiple Tables by Using Joins, Summarize Data Using Aggregate Functions, Rank Grouped Data, Combine and Limitg Result Sets, Work with Subqueries, Optimise Queries, Use Crosstab Queries, Use Common Table Expressions, Insert, delete and update data in tables, Work with SQL Server Date and Time Data, Use Transactions and Locking, Query XML Data, Implement Views, Use Stored Procedures, Handling Errors, Implement User Defined Functions and Use Triggers.

  • SQL Server 2005 Reporting Services - 2 days

    Learn how to use SQL Server 2005 Reporting Services in this 2 day course covering the Report Designer, Data Access, Report Management, Report Execution, Subscriptions and Report Rendering.

  • SQL Server 2005/2008 Basic SQL Querying - 2 days

    This course covers all the fundamentals of SQL Querying including database theory, data retrieval, tables, data types, integrity and additonal query techniques.

  • SQL Server 2005 Implementation and Maintenance - 4 days

    This course for SQL administrators covers all the key areas of administration of the SQL Server 2005. Hands-on labs ensure that theory is suppported by practice.

  • SQL Server 2005/2008 Advanced Querying - 2 days

    Following on from the Basic Querying course this 2 day course examines data retrieval in more depth, modifying data, data integrity, additional query techniques and tuning queries and indexes.

  • SQL Server 2005 Development - 2 days

    This course for developers working with SQL Server 2005 covers all the main areas of SQL server programming.

  • SQL Server 2005/2008 Analysis Services - 2 days

    There are four main section covered in this course. Analysis services introduces the main concepts during which you build your first cube. Design fundamentals, advanced design and production management complete a comprehensive treatment of the subject.

  • SQL Server 2005/2008 Integration Services - 2 days

    After the introduction to Integration Services we cover the design of packages, the management of packages and how SSIS can be applied to data warehousing to give you a thorough grounding in Integration Services.

  • SQL Server Developer: 2005/2008 Update - 2 days

    This course is designed to ensure that you do not miss out on the powerful new features that were introduced with SQL Server 2005/2008. These can dramatically improve query performance.

  • SQL Server 2005/2008 Using XML Data - 1 day

    This one day course focuses how to use XML Data with SQL Server 2005/2008 in a productive manner. The conversion between XML Data and relational data is covered using several different techniques.

  • SQL Server 2005/2008 Report Builder 2.0 - 1 day

    This covers the use of Report Builder 2.0 and complete reports are built using charts, parameters, drillthrough and reports are saved to the report server.