STANDARD COURSES Access ACT! Dreamweaver Excel Flash FrontPage Illustrator InDesign Office 2007 Outlook Photoshop Powerpoint Project Soft Skills Technical Skills Introduction to SQL Small Business Server 2003 SQL Reporting Services Visio Windows Vista Word Course Fees	TECHNICAL SKILLS INTRODUCTION TO SQL Duration: 3 days Prerequisites Prior knowledge of simple database fundamentals would be an advantage. We recommend that attendees have some experience with either the Unix or Windows operating system before undertaking this course. COURSE CONTENT     Introduction Defining Structured Query Language Introduction to relational databases Tables, Rows and Columns Interactive SQL environments General SQL guidelines Developing Queries The SELECT statement The WHERE clause Specifying conditions - relational and logical operators Pattern matching with LIKE Other operators The ORDER BY clause The GROUP BY and HAVING clauses Computed values. Null values Selecting information from more than one table Data Manipulation Inserting new data Modifying existing rows Deleting data that is no longer required Database Definition Table creation Specifying data types for columns Examples of data types Changing, removing tables Creating indexes Indexing strategies Controlling Access to the Database Privileges and Permissions Privilege management The GRANT and REVOKE statements Advanced SQL features Aggregate functions Nested queries Outer Joins Views SMALL BUSINESS SERVER 2003 Duration: 3 days Prerequisites Before attending this course, students must have a working knowledge of: Sharing folders. Stopping and starting services. Working with the Microsoft Management Console (MMC). Creating and managing user accounts. Assigning permissions. The purpose and some of the implementations of Transmission Control Protocol/Internet Protocol (TCP/IP) services such as Domain Name System (DNS) and Dynamic Host Configuration Protocol (DCHP) (although students will not need to know how to implement these services in a Microsoft Windows Server 2003 environment). Working knowledge of Active Directory® directory service. Working knowledge of Group Policy Objects (GPOs). In addition, students should have these certifications: A+ and Net+ Delegates will learn how to Manage messaging and collaboration in Windows Small Business Server 2003 Secure a Windows Server 2003, Standard Edition network Expand a Windows Small Business Server 2003 network Design a networking solution for a small or medium-sized business, based on a given scenario Manage and monitor Windows Small Business Server 2003 Configure Windows Server 2003, Standard Edition Manage Windows Server 2003, Standard Edition Install or upgrade to Microsoft Windows® Small Business Server 2003 Configure Windows Small Business Server 2003 by completing the tasks on the To-Do List Install or upgrade to Microsoft Windows Server™ 2003, Standard Edition Outline Module 1: Windows Small Business Server 2003, Windows Server 2003, Standard Edition and mixed environments Module 2: Installing and Upgrading to Windows Small Business Server 2003 Module 3: Initial Configuration using the To-Do List Module 4: Managing Microsoft Exchange and the POP3 Connector in Small Business Server 2003 Module 5: Managing and Monitoring Windows Small Business Server 2003 Module 6: Installing or Upgrading to Windows Server 2003, Standard Edition Module 7: Configuring Windows Server 2003, Standard Edition Module 8: Configuring Security in a Windows Server 2003, Standard Edition Network Module 9: Managing Windows Server 2003, Standard Edition SQL REPORTING SERVICES Duration: 3 days This course provides students with the knowledge and skills to create, deploy, and manage reports using Microsoft SQL Server Reporting Services. Students should leave the course with. Objectives: To give delegates a good understanding of how to apply reporting services to problems within a business context. COURSE CONTENT     An Overview of Reporting Services Phases of Report deployment: Development, Deployment to the Server, Execution and Delivery Usage Scenarios Reporting Services Architecture Creating Simple Reports Simple table reports using wizards Formatting report pages Enhancing Reports Data Regions: Lists, Tables, Matrixes and Charts Dynamic Visibility, Drill Down, Drill Through and Document Maps Using Expressions: Built-in collections Conditional formatting Using Multiple Data Sets and Parameters Using Query Parameters to return restricted result sets Query Parameters vs Filter Parameters Deploying, Executing and Delivering Reports Configuring Project properties and deploying Individual Reports, Projects, Solutions and Data Sources to the server Choosing and configuring Delivery Methods: On-demand or by scheduled e-mail and fileshare Subscriptions Improving performance with Cached Instances and Snapshots. Configuring snapshot history. Administering the Reporting Server Reporting Services Configuration Files Monitoring Performance and Reliability using Performance Counters and Trace Logs Administration of the Databases, including backup of the Databases and Encryption Key. Conditional macros Security Administration: ensuring appropriate access through role-based security Advanced Development Embedding reports in the company intranet using URL access Using RS Web services to script administrative tasks Writing custom functions for use in reports Managing and accessing reports through custom Windows applications		"Our reputation is for professionalism, quality and excellent standards of training and for trainers who always go the extra mile".