Instructor Led Databases Training in Canada

Introduction to PHP In this course, students will learn how to create dynamic and interactive websites using PHP and how to manage databases with PHP. Students will learn to authenticate users, manage sessions, manage emails, manipulate files, validate forms and work with PEAR: DB module. Prerequisites: Students should have some HTML experience  more...

Microsoft Excel - Advanced ... how to import and export data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web. Learning Objectives: Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare  more...

SQL Server 2008 Integration Services This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and  more...

SQL Server 2005 - Additional Topics ...-availability, stability, reliability, and scalability of databases, plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging, and working with XML. LEARNING OBJECTIVES Learn about disaster recovery options Understand high availability concepts See how to implement SQL Server high-availability features: failover  more...

SQL Server 2008 Transact SQL (T-SQL) ...mplex data structures and processes, and how to make your databases more scalable through partitioning. SQL Server 2008 includes a rich set of tools that go beyond the basics of querying and manipulating data. You will learn how to take advantage of the user-friendly management console that integrates both authoring and administrative tasks. You will learn how to take advantage of SQL  more...

SQL Server 2008 for developers ...the principals of database design are used in creating of databases and then how to apply server tables to them. The course continues with SQL Server Management Studio and how to build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. Learn how to make your databases more scalable through partitioning and how to use .NET languages like Visual C# and  more...

Oracle 10g 11g Advanced SQL ...cessary to design and code complex queries against Oracle databases. You will learn to use many advanced SQL coding techniques such as coding analytic functions for data warehouse and decision support queries, using partition outer join to "densify" data, the Oracle10g MODEL clause ("spreadsheet-like capability directly from the database"), Oracle10g regular expressions for pattern  more...

Oracle 10g 11g Introduction to SQL ...w how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING OBJECTIVES Describe the principal features of a relational database Describe the  more...

Windows Presentation Foundation (WPF) Using C# and Visual Studio 2010 ...isual data binding using Visual Studio 2010 and accessing databases using the Entity Data Model. The course also covers styles, templates, skins and themes. The course is hands-on with many example programs and lab exercises. LEARNING OBJECTIVES Gain an understanding of the philosophy and architecture of WPF Create Windows applications using the classes provided by WPF  more...

ASP.NET Using Visual Basic with VS2010 ...n using configuration, security, and caching Access databases using ADO. NET and LINQ Implement rich client applications using ASP. NET AJAX Create Web applications using the Model-View-Controller design pattern Audience: This course is designed for experienced application developers and architects responsible for Web applications in a Microsoft environment.  more...

ASP.NET Using C# with VS2010 ...n using configuration, security, and caching Access databases using ADO. NET and LINQ Use newer features in ASP. NET Implement rich client applications using ASP. NET AJAX Create Web applications using the Model-View-Controller design pattern Audience: This course is designed for experienced application developers and architects responsible for Web applications  more...

Object-Oriented Programming in Visual Basic .NET is a revolutionary advance in programming technology that greatly simplifies application development. Microsofta ™s popular Visual Basic programming language has been upgraded to take advantage of the new .NET features. Visual Basic has become a fully object-oriented programming language with capabilities comparable to C++, Java, and Microsofta ™s new language C#. This course  more...

ASP.NET MVC 3 Using C# ...nt using ASP. NET MVC and Visual Studio 2010 Access databases using ADO. NET, LINQ, and Entity Framework 4. 1 Perform automated testing of Web applications created using ASP. NET MVC Implement security in ASP. NET MVC applications Combine ASP. NET MVC and Web Forms when appropriate Deploy ASP. NET MVC applications Prerequisites: The student should have a  more...

Access 20072010 Introduction 2 Days This course is intended as a starting point for Access beginners, or people who use databases created by others. The main focus is to learn how to create tables and queries. A brief look at forms and reports is also covered.  more...

Microsoft Office Access 2010 Level 1 In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft ® Office Access ™ 2010 relational database application.  more...

5050 Recovering Messaging Servers and Databases Using MS Exchange Server 2007 This one-day course teaches messaging specialists to recover Exchange mailboxes and servers in a variety of disaster scenarios.  more...

3rd edition - SQL - Fundamentals of Querying You have access to company databases & your job may require you to retrieve data from these databases. Retrieval of information from a database is dependent on precisely ordered logic & specific information. This course will help you use SQL as a tool..  more...

Microsoft Access 2003 Beginner Available in French and English Discover the fascinating MiS Access environment. Learn to create custom databases to optimize the management of your business information. Control your inventory, purchases, & expenses using forms, queries and reports that are simple to use yet powerful  more...

MS Access Level 1 Training Seminar This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and  more...

Dreamweaver Intermediate 2 Days - cp This course looks at some of the more advanced features in Dreamweaver, as well as creating a database-driven site. Topics include: basic use of Access databases and tables, basic HTML, & in Dreamweaver: creating forms, rollovers & navigation bars..  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-03-20 List Price: $199 Offered Price: $139.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series You will also receive a certificate of  more...

System Manager - Report 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 Topics Include: * Creating and activating new company databases * Navigating around the Sage Accpac for Windows program * Using the SmartFinder * Activating other installed modules  more...

Access Advanced Level 2-3 Days Location: Toronto Date: 2007-04-25 List Price: $825 Offered Price: $575.00 Seats Available: 5 This course takes an in-depth look at sharing databases on a network, using Access with other programs, using Access and the Internet, optimizing a database, and setting defaults.  more...

Access Intermediate Level 1-3 Days Location: City of Mississauga Date: 2007-04-18 List Price: $825 Offered Price: $525.00 Seats Available: 5 This course builds on the two-day Introduction course. The objective is to learn enough about Access to start developing databases. The Introduction course begins this process by seeing how to create tables and queries. This course illustrates how to create a relational database and  more...

MS Access Level 1 Training Seminar Location: City of Mississauga Date: 2007-04-25 List Price: $495 Offered Price: $346.00 Seats Available: 2 This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with  more...

MS Access Level 1 Training Seminar Location: City of Mississauga Date: 2007-07-16 List Price: $495 Offered Price: $346.00 Seats Available: 2 This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-04-07 List Price: $199 Offered Price: $139.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call  more...

Microsoft Access Level 1 Training Seminar (2 Days) ...begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential integrity, how to integrate data with other applications, modify table design to control data entry, find data, filters, queries, customize forms and reports, and create data access pages. For more  more...

Microsoft Access 2003 - Level 2 As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-05-09 List Price: $199 Offered Price: $159.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call  more...

Access 2003 Intermediate Level 1 (3 Days) This course builds on the two-day Introduction course. The objective is to learn enough about Access to start developing databases. The Introduction course begins this process by seeing how to create tables and queries. This course illustrates how to create a relational database and how to design forms and reports. This course is classroom style instruction: Instructor-led, hands-on  more...

Access 2003 - Level 1 (1 day) This course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records,  more...

Access 2007 - New Features (Half-Day) You have worked with Microsoft® Office Access™ 2003 (or earlier), and you now need to be aware of the additional features in the latest release of the software for improving the management, presentation, and distribution of your databases. In this course, you will be introduced to the new features available in Microsoft® Office Access™ 2007.  more...

Microsoft Excel XP 2003 Level 2 (1 Day) Location: Vancouver Date: 2008-05-14 List Price: $199 Offered Price: $159.00 Seats Available: 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series For more information please call  more...

Access 2007 - Level 2 (1 Day) As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database  more...

Access Introduction - Level 1 This course provides competency in database fundamentals, working with Access objects, creating databases and tables, working with table data and structure, locating information, working with related tables, using select queries and advanced query features, and creating advanced queries.  more...

Access Intermediate - Level 2 This course provides competency in creating and using forms and sub forms, using advanced form features, creating and using reports, using advanced report features, enhancing forms and reports, using data access pages, managing databases, and importing and exporting data.  more...

Microsoft Access 2003 - Level 1 (2 Days) This course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records,  more...

Developing Web Applications with PHP 5 Full Days Canadian Beaver Training's Ottawa and Gatineau training centers provide concrete, skills based, results driven and adult focussed software training, technical training and business skills training. We use a structured and effective teaching methodology in the development and delivery of all our courses. Canadian Beaver Training's mission to provide comprehensive bilingual training and consulting  more...

Microsoft Excel XP 2003 Level 2 After you complete this course you will be able to do the following: * Name and Reference Cells * Protect Data * Create Links * Use Basic Excel Functions * Create Charts * Create Databases * Work with Data Series ... Participants who complete this course will receive a certificate of completion as well as a course manual ...  more...

Microsoft Access 2007 - Level 1 (2 Days) In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access 2007 relational database application.  more...

Microsoft Access 2003 - Level 3 - English ..., Subreports; Form techniques; ActiveX Controls; Indexes; Databases; Macros; Switchboards; Toolbars; Importing to other Office Suite applications such as Excel and Word; and much more. This course will run for one day, from 9:00 am to 4:00 pm, bilingual instructor-led, in which a training manual as well as a certificate of completion will be offered to participants who complete this course.  more...

Access 2007 - Level 1 (1 Day) This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include designing and creating new databases,  more...

Microsoft Access 2003 - Level 1 2 Days This course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records,  more...

Access 2003 Intermediate Level 1 3 Days This course builds on the two-day Introduction course. The objective is to learn enough about Access to start developing databases. The Introduction course begins this process by seeing how to create tables and queries. This course illustrates how to create a relational database and how to design forms and reports.  more...

Excel 2003 Databases Do you spend a lot of time searching for data in large spreadsheets? Would you like to perform database functions such as filtering, subtotaling, and sorting ? Want to set up an easy-to-use data input form to be used by non-Excel-experts. etc.?  more...

Software Engineers Workshop Practical workshop covering the role of the Business-Systems Analyst. Develop a complete project starting from creating the business case &d the requirements documentation through to the detailed design of the databases & software required to implement.  more...

Microsoft Access 2007 Foundation Learn Microsoft Access 2007 - including what's new in 2007; the trust center, getting help, the new interface; creating databases; adding, deleting and modifying records; tables; forms; queries; reports and much more.  more...

Access 2003 Getting Started with Databases Tables Do you need to learn how to plan a database, determine what information to include in the database, and decide how that information should be organized? Do you know what you need to include in your database but aren't sure how to create it?  more...

Implementing a Microsoft SQL Server 2005 Database - nexient ...mpleting this 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. Implement data integrity in Microsoft SQL Server 2005 by using triggers. Implement views.  more...

Access 2007 - Level 2 1 Day - presidio ...ou need to work with a Microsoft ® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other  more...

Microsoft Access 20022003 Level 1 ontrack Topics included in this 1 day course : Introduction to databases, designing from scratch, database relationships and theory, getting started with Access, tables, forms, queries and reports.  more...

Access 2007 - Level 1 - presidio The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating & maintaining records; locating records; and producing reports based on the information in the database.  more...

Implementing a Microsoft SQL Server 2005 Database 5 day course - Nexient Upon completion, students will: create databases & database files, data types & tables, use XML-related features in Microsoft SQL Server 2005, Plan, create, & optimize indexes, Implement data integrity in Microsoft SQL Server 2005 databases and more.  more...

Updating Your Database Administration Skills to Microsoft SQL Server 2005 This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.  more...

Updating Your Database Development Skills to Microsoft SQL Server 2005 This course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.  more...

Designing Microsoft SQL Server 2005 Databases This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions (beyond structured third normal form [3NF] modeling techniques).  more...

Administering and Automating Microsoft SQL Server 2005 Databases and Servers This course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. Elements of this syllabus are subject to change.  more...

Access 2000 - 2003 Beginner Available in French and English- Synesis ...crosoft Office Access environment. Learn to create custom databases to optimize the management of your business information. Control your inventory, purchases, and expenses using forms, queries and reports that are simple to use yet powerful. Manage client accounts efficiently; obtain a complete list of your clients sorted or filtered by region, major account, or outstanding payment. When using  more...

Outlook 2003 Beginner Available in French and English - Synesis ...crosoft Office Access environment. Learn to create custom databases to optimize the management of your business information. Control your inventory, purchases, and expenses using forms, queries and reports that are simple to use yet powerful. Manage client accounts efficiently; obtain a complete list of your clients sorted or filtered by region, major account, or outstanding payment. When using  more...

MS Access 2007 Level 1 - teksource In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft ® Office Access ™ 2007 relational database application.  more...

MS Access 2007 Level 1 - 2 Day on track In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft ® Office Access ™ 2007 relational database application.  more...

Installing Managing Securing and Recovering Exchange Server 2007 Students will learn how to configure and manage a messaging environment in accordance with technical requirements. Students will learn how to install Exchange Server 2007 and manage routing, client access, and the backup and restore of databases  more...

Recovering Messaging Servers and Databases using Microsoft Exchange Server 2007 - ctc This course provides messaging specialists with the knowledge specialists need to recover Exchange mailboxes & servers in a variety of disaster scenarios. Learn how to perform full & dial-tone recoveries of a mailbox server & repair a mailbox database.  more...

Microsoft Excel 2007 Intermediate Available in French and English The Objective of this 2-day course is to efficiently use workbooks as well as their tools for management and data analysis. Using graphs and databases. Using different Excel functions and their database analysis features.  more...

Microsoft Access 2007 Introduction French instruction English software In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft ® Office Access ™ 2007 relational database application.  more...

Microsoft Access 2003 Intermediate - ITplanit This course provides competency in creating & using forms & subforms, using advanced form features, creating & using reports, using advanced report features, enhancing forms & reports, using data access pages, managing databases, importing & exporting...  more...

Microsoft Access 2007 Level 1 - inet toolbox This course is designed to help students learn relational database concepts, become comfortable working with Access to create databases, and provide students with the ability to effectively manipulate the data they have stored.  more...

Access 2003 Foundation - CIT This course provides competency in database fundamentals, working with Access objects, creating databases & tables, working with table data &structure, working with related tables, using select queries & advanced query features, creating advanced queries  more...

Microsoft Access 2007 Level 2 Advanced Database Design Upon completion, participants will be able to : overview databases, edit documents, enhance tables by creating lookups, create advanced forms & reports, work with & create web-based objects.  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 Access 2007 - Level 1 2 Days newera The Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; & producing reports based on the information in the database.  more...

Microsoft Office 2003 Learn the basics of these 3 MS Office products: Word = Entering text, the File, the Save As command, editing... Excel = working with workbooks, tabs, moving/ copying, formatting... Access = relational databases, creating tables with data, queries...  more...

Developing a Website - CTC In this hands-on course you gain the knowledge you need to develop a well-designed web site. You learn the fundamentals of HTML syntax and layout creating effective web pages configuring a web server and interfacing your web site to databases.  more...

2789B Administering and Automating Microsoft SQL Server 2005 Databases and Servers MS Certification This one-day instructor-led course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information.  more...

5050 Recovering Messaging Servers and Databases using Microsoft Exchange Server 2007 This one-day course teaches messaging specialists to recover Exchange mailboxes and servers in a variety of disaster scenarios. Students will learn how to perform full and dial-tone recoveries of a mailbox server, as well as repair a mailbox database.  more...

MS Access Level 1 Training Seminar 2 Days This course will provide you with the skills necessary to begin using Access. Topics include designing and creating databases, tables, queries, forms and reports. Day 2 focuses intermediate Access skills, including table relationships, referential ...  more...

Developing a Website Level 3 Advanced You will learn the fundamentals of HTML syntax and layout creating effective web pages configuring a web server and interfacing your web site to databases.  more...

Access 2007 Level 1 Introduction In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft ® Office Access ™ 2007 relational database application.  more...

Lotus Approach Level 3 Advanced French Approach is a relational database program designed to store and retrieve information. It allows users to easily create and maintain their databases.  more...

Quattro Pro Level 2 Med Students will learn to efficiently use workbooks as well as tools for management and data analysis. Students will also learn to use graphs and databases.  more...

Access 2007 Level 4 In this course, you will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.  more...