Instructor Led Administrative Training in Canada

SQL Server 2008 Integration Services ...e use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an  more...

SQL Server 2008 Transact SQL (T-SQL) ...dly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. LEARNING OBJECTIVES Understand the differences between the available editions of SQL Server 2008. Create a SQL Server database based on sound design principles. Create constraints, triggers, and indexes.  more...

SQL Server 2008 for developers ...dly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL Server's tools for analyzing and tuning your databases. You'll also learn about integration servers, implementing security, and Microsoft's new Business Intelligence (BI) suite. nsole that integrates both authoring and administrative tasks. You will learn how to take  more...

SQL Server 2008 Reporting Services In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. Youa ™ll then explore tabular and list reports that employ datasets and data regions. As you progress youa ™ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL  more...

Oracle 10g Administration ...f the Oracle Data Dictionary and Oracle 10g architecture; Administrative Users; Instances; Initialization Parameter Files; creating and managing Users; Password management; Auditing; Security; creating & managing Tablespaces, Heap Tables and Constraints; B-Tree Tables; managing Undo, Redo Logs and Control Files; backup and recovery with Oracle RMAN; SQL*Loader; an introduction to Oracle  more...

Fundamentals of Project Management - Evening Class 12 CEUs ...recasting 4. Closing Processes Scope Verification and Administrative closure Post-mortem Benefits tracking Upon Completion Of This Workshop Participant Will Be Able To: Understand the need to create a project charter during project initiation by filling out its basic components through a practical example Understand the advantages and disadvantages of different contracts  more...

50400A Designing Optimizing and Maintaining a Database Administrative Solution for Microsoft SQL Server 2008 MS Certification This five-day instructor-led course provides the knowledge and skills to design, optimize, and maintain a database administrative solution for Microsoft SQL Server 2008.  more...

RH033 Red Hat Linux Essentials An introduction to fundamental end-user and administrative tools in Red Hat Enterprise Linux, designed for students with little or no command-line Linux or UNIX experience.  more...

Microsoft Access 2007 Level 3 Advanced Topics Upon completion, participants will: Understand macro concepts, Create & use switchboard forms, Set Access defaults, apply Startup options, & customize the Navigation Pane, Acquire information about running administrative functions in Access and more  more...

System Manager - Report Writer ...rse you learn how to define Common Services, and setup up Administrative Services Topics Include: * Creating and activating new company databases * Navigating around the Sage Accpac for Windows program * Using the SmartFinder * Activating other installed modules * Activating the Common Services and Administrative Services * Setting up  more...

The Sole Practitioner as a Thriving Enterprise This 3-hour workshop is designed for professionals who have chosen to practice as a sole practitioner and who recognize the need for support. Topics covered include: * Focusing on what you do best * Establishing effective systems and procedures * Maximizing valuable billable hours and avoid wasting time on administrative chores * Building an effective support network * How to recognize when  more...

MS 3938 - Updating Exchange Server 2003 to Exchange Server 2007 ...rts, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. 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  more...

Websense Essentials WE for Websense Security Suite ...hould be familiar with basic Websense functionality, core administrative tasks, and report generation. In particular, students will learn how to: create and maintai n policies, utilize advanced filtering techniques, and generate valuable reports. Optional modules include high level technical topics such as: advanced configurations, logging settings, and database administration to name a few.  more...

Skills for the Administrative Assistant Understand the importance of professional presence on the job; learn how to self-manage to become more effective & efficient; Improve their communications skills, including listening, questioning, & being more assertive; Increase their effectiveness...  more...

ZENworks 10 Configuration Management Administration Course Overview Novell ZENworks Configuration Management features a unique policy-based approach to automate software setup, updates, healing and desktop migration in your enterprise. Through policy-based automation, you can reduce IT efforts, relax IT skill requirements and optimize the value of your IT assets. The key to using Novell ZENworks Configuration Management is understanding what  more...

Microsoft Windows SharePoint Services 30 Level 2 - nexient This course is designed for existing SharePoint site owners with basic SharePoint administrative skills who need to perform more advanced site owner or site administrator tasks.  more...

Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services This 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.  more...

Sage Accpac for Windows System ManagerReport Writer The System Manager is the central module for your Sage Accpac for Windows system. In this course you learn how to define Common Services, and setup up Administrative Services  more...

Maintaining a Microsoft SQL Server 2008 Database - nexient Upon completion, students will: Install & configure SQL Server 2008; Manage database files; Backup & restore databases; Manage security; Transfer data into & out of SQL Server; Automate administrative tasks; Replicate data between SQL Server instances..  more...

Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - nexient This course is intended for systems administrators who use Windows-based computers and must learn how to develop administrative scripts for their enterprise networks.  more...

Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services - newera This instructor-led course discusses how to use the Analysis Services development tools to create an Analysis Services database & an OLAP cube, how to use the Analysis Services management & administrative tools to manage an Analysis Services solution.  more...

6236A Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services This 3-day instructor-led 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.  more...

Administrering Novell Open Enterprise Server 2 for Linux This course teaches networking professionals to perform common administrative tasks using the services provided in Novell ® Open Enterprise Server 2. You will install Novell Open Enterprise Server 2 & perform tasks often required of employees who...  more...

Visual Basic Script and Windows Script Host Essentials This course is intended for systems administrators who use Windows-based computers and must learn how to develop administrative scripts for their enterprise networks.  more...

Acess 2003 Advanced Designed to cover advanced topics of Access to users who use or will use Access on a regular basis. Upon completion, participants will understand macro concepts, switchboard forms, Access defaults, administrative functions, security and replication.  more...

Novell ZENworks 10 Configuration Management Advanced Administration Perform many advanced administrative tasks such as migrating traditional ZENworks 7 Desktop Management & implementing the patch management services in a virtual environment containing SUSE Linux Enterprise, Windows XP & Windows Vista machines.  more...

Essential Management Strategies for the Administrative Assistant This is a two-day workshop intended to help those in support positions understand their roles and responsibilities. They will discuss new strategies for handling their workload, through enhancing organization skills and ability to prioritize.  more...