Acend Corporate Learning Toronto - Mississauga are computer training centers located in Toronto and Mississauga, ON. This computer training facility in the Greater Toronto Area (GTA) of Ontario provides computer classes and computer certifications like Microsoft and Cisco certification classes and courses to the Toronto, North York, Richmond Hill, and Markham areas.

Our centers in Toronto and Mississauga, ON are also close to: Hamilton, London, Brampton, Markham, Windsor, Kitchener, Vaughan, Burlington, Oakville, Oshawa, Richmond Hill, St. Catharines, Cambridge, Guelph, Barrie, Whitby, Pickering, Waterloo, Brantford, Niagara Falls, Ajax, Peterborough, Clarington, Newmarket, Caledon, Welland, Halton Hills, Georgina, Innisfil and Orangeville, Ontario Canada..

Microsoft SQL Server Courses

Course Categories > Microsoft SQL Server

> View ALL Upcoming Microsoft SQL Server Courses



Learn about Microsoft SQL querying and database design & administration. Transact SQL and SQL Server 2000 & 2005 installation, implementation and administration are covered.

Course Title Location Duration
2030: Creating Reporting Solutions Using Microsoft® SQL Server™ 2000 Reporting ServicesThis learning product will teach database professionals and developers to successfully author, deploy, and manage reports in their organization using MS Reporting Services.
Price: $998		 Toronto 2 Day(s)
2030: Creating Reporting Solutions Using Microsoft® SQL Server™ 2000 Reporting ServicesThis learning product will teach database professionals and developers to successfully author, deploy, and manage reports in their organization using MS Reporting Services.
Price: $998		 Mississauga 2 Day(s)
2071: Querying Microsoft® SQL Server™ 2000 with Transact-SQLThe goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.
Price: $998		 Toronto 2 Day(s)
2071: Querying Microsoft® SQL Server™ 2000 with Transact-SQLThe goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.
Price: $998		 Mississauga 2 Day(s)
2072: Administering a Microsoft SQL Server 2000 DatabaseThis course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product.
Price: $2,495		 Toronto 5 Day(s)
2072: Administering a Microsoft SQL Server 2000 DatabaseThis course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000. Course 2072 is a revision of Course 832, System Administration for Microsoft SQL Server 7.0. The course content is being revised to reflect changes in the product.
Price: $2,495		 Mississauga 5 Day(s)
2073: Programming a Microsoft SQL Server 2000 DatabaseThis course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000.
Price: $2,495		 Toronto 5 Day(s)
2073: Programming a Microsoft SQL Server 2000 DatabaseThis course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000.
Price: $2,495		 Mississauga 5 Day(s)
2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft® SQL Server 2000™ Analysis Services.
Price: $2,495		 Toronto 5 Day(s)
2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000This course provides students with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft® SQL Server 2000™ Analysis Services.
Price: $2,495		 Mississauga 5 Day(s)
2092: Populating a Data Warehouse with Microsoft® SQL Server™ 2000 Data Transformation ServicesThis course provides students with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server™ 2000.
Price: $2,495		 Toronto 5 Day(s)
2092: Populating a Data Warehouse with Microsoft® SQL Server™ 2000 Data Transformation ServicesThis course provides students with the knowledge and skills necessary to design a data warehouse and to populate data marts by using Data Transformation Services (DTS) in Microsoft SQL Server™ 2000.
Price: $2,495		 Mississauga 5 Day(s)
2093: Implementing Business Logic with MDX in Microsoft® SQL Server™ 2000This course provides students with the knowledge and skills necessary to use multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to a Microsoft SQL Server™ 2000 Analysis Services cube by using SQL Server 2000.
Price: $1,497		 Toronto 3 Day(s)
2093: Implementing Business Logic with MDX in Microsoft® SQL Server™ 2000This course provides students with the knowledge and skills necessary to use multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to a Microsoft SQL Server™ 2000 Analysis Services cube by using SQL Server 2000.
Price: $1,497		 Mississauga 3 Day(s)
2591: Implementing Replication Using Microsoft® SQL Server™ 2000This three-day instructor-led course provides students with the knowledge and skills to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot, transactional, and merge replication as well as topics related to Enterprise-level replication.
Price: $1,497		 Toronto 3 Day(s)
2591: Implementing Replication Using Microsoft® SQL Server™ 2000This three-day instructor-led course provides students with the knowledge and skills to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot, transactional, and merge replication as well as topics related to Enterprise-level replication.
Price: $1,497		 Mississauga 3 Day(s)
2723: Microsoft® SQL Server™ 2000 for Experienced Database ProfessionalsThis three-day course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server™ 2000 and how it works. The primary focus of this course is to give experienced database professionals a jump-start to better understanding SQL Server 2000. This is not an advanced course or a how-to course.
Price: $1,497		 Toronto 3 Day(s)
2723: Microsoft® SQL Server™ 2000 for Experienced Database ProfessionalsThis three-day course will teach database professionals who are already proficient in the implementation and maintenance of enterprise databases about the core architecture of Microsoft SQL Server™ 2000 and how it works. The primary focus of this course is to give experienced database professionals a jump-start to better understanding SQL Server 2000. This is not an advanced course or a how-to course.
Price: $1,497		 Mississauga 3 Day(s)
2779: Implementing a Microsoft SQL Server 2005 DatabaseThis course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Price: $2,495		 Toronto 5 Day(s)
2779: Implementing a Microsoft SQL Server 2005 DatabaseThis course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Price: $2,495		 Mississauga 5 Day(s)
2779+2780 Accelerated: 2779 Implementing a Microsoft SQL Server 2005 Database AND 2780 Maintaining a Microsoft SQL Server 2005 DatabaseThis accelerated course provides students with product knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing and maintaining a database.
Price: $3,495		 Toronto 10 Day(s)
2779+2780 Accelerated: 2779 Implementing a Microsoft SQL Server 2005 Database AND 2780 Maintaining a Microsoft SQL Server 2005 DatabaseThis accelerated course provides students with product knowledge and skills needed to implement and maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing and maintaining a database.
Price: $3,495		 Mississauga 10 Day(s)
2780: Maintaining a Microsoft SQL Server 2005 DatabaseThis course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Price: $2,495		 Toronto 5 Day(s)
2780: Maintaining a Microsoft SQL Server 2005 DatabaseThis course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.
Price: $2,495		 Mississauga 5 Day(s)
2781: Designing Microsoft SQL Server 2005 Server-Side SolutionsThis course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL ServerT 2005. It focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.
Price: $1,497		 Toronto 3 Day(s)
2781: Designing Microsoft SQL Server 2005 Server-Side SolutionsThis course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL ServerT 2005. It focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.
Price: $1,497		 Mississauga 3 Day(s)
2782: Designing Microsoft SQL Server 2005 DatabasesThis 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). Students will also learn to incorporate security requirements throughout their design.
Price: $998		 Toronto 2 Day(s)
2782: Designing Microsoft SQL Server 2005 DatabasesThis 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). Students will also learn to incorporate security requirements throughout their design.
Price: $998		 Mississauga 2 Day(s)
2783: Designing the Data Tier for Microsoft SQL Server 2005This clinic provides students with the knowledge and skill to design the data tier for Microsoft® SQL ServerT 2005.
Price: $499		 Toronto 1 Day(s)
2783: Designing the Data Tier for Microsoft SQL Server 2005This clinic provides students with the knowledge and skill to design the data tier for Microsoft® SQL ServerT 2005.
Price: $499		 Mississauga 1 Day(s)
2784: Tuning and Optimizing Queries Using Microsoft SQL Server 2005This workshop provides database developers working in enterprise environments using Microsoft SQL ServerT 2005 the knowledge and skills to evaluate and improve queries and query response times.
Price: $1,497		 Toronto 3 Day(s)
2784: Tuning and Optimizing Queries Using Microsoft SQL Server 2005This workshop provides database developers working in enterprise environments using Microsoft SQL ServerT 2005 the knowledge and skills to evaluate and improve queries and query response times.
Price: $1,497		 Mississauga 3 Day(s)
2786: Designing Microsoft SQL Server 2005 Infrastructure and ServicesThis course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure.
Price: $998		 Toronto 2 Day(s)
2786: Designing Microsoft SQL Server 2005 Infrastructure and ServicesThis course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 2005 database infrastructure.
Price: $998		 Mississauga 2 Day(s)
2787: Designing Security for Microsoft SQL Server 2005This course enables database administrators in enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. It covers business needs, regulatory requirements and network systems, and database design considerations.
Price: $998		 Toronto 2 Day(s)
2787: Designing Security for Microsoft SQL Server 2005This course enables database administrators in enterprise environments to design security for database systems using Microsoft SQL Server 2005. It covers business needs, regulatory requirements and network systems, and database design considerations.
Price: $998		 Mississauga 2 Day(s)
2788: Designing a High Availability Database Solutions Using Microsoft SQL Server 2005The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization.
Price: $1,497		 Toronto 3 Day(s)
2788: Designing a High Availability Database Solutions Using Microsoft SQL Server 2005The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization.
Price: $1,497		 Mississauga 3 Day(s)
2789: Administering and Automating Microsoft SQL Server 2005 Databases and ServersThis 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.
Price: $499		 Toronto 1 Day(s)
2789: Administering and Automating Microsoft SQL Server 2005 Databases and ServersThis 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.
Price: $499		 Mississauga 1 Day(s)
2790: Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting.
Price: $998		 Toronto 2 Day(s)
2790: Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL ServerT 2005. The primary focus of this workshop is to teach the overall process of troubleshooting.
Price: $998		 Mississauga 2 Day(s)
2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting ServicesThis three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The 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.
Price: $1,497		 Toronto 3 Day(s)
2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting ServicesThis three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The 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.
Price: $1,497		 Mississauga 3 Day(s)
SQL Querying - Level 1 Fundamentals of QueryingOverview In this course, students learn how to compose SQL queries to retrieve information from the database. Next Steps SQL Querying - Level 2 Advanced Querying
Price: $499		 Toronto 1 Day(s)
SQL Querying - Level 1 Fundamentals of QueryingOverview In this course, students learn how to compose SQL queries to retrieve information from the database. Next Steps SQL Querying - Level 2 Advanced Querying
Price: $499		 Mississauga 1 Day(s)
SQL Server 2005 New FeaturesTransition learning for SQL Sever 2000 professionals to SQL Server 2005.
Price: $1,497		 Toronto 3 Day(s)
SQL Server 2005 New FeaturesTransition learning for SQL Sever 2000 professionals to SQL Server 2005.
Price: $1,497		 Mississauga 3 Day(s)
SQL: Advanced Querying (Second Edition)In the course SQL: Fundamentals of Querying (Second Edition), you examined the fundamentals of SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables. In this course, SQL: Advanced Querying (Second Edition), you will create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.
Price: $499		 Toronto 1 Day(s)
SQL: Advanced Querying (Second Edition)In the course SQL: Fundamentals of Querying (Second Edition), you examined the fundamentals of SQL querying. Because of various business conditions and requirements, in addition to querying the database, you may need to restructure and index tables. You may also need to manipulate the data in the tables. In this course, SQL: Advanced Querying (Second Edition), you will create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.
Price: $499		 Mississauga 1 Day(s)
SQL: Fundamentals of Querying (Second Edition)You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions. Course Objective: You will learn how to compose SQL queries to retrieve information from the database.
Price: $499		 Toronto 1 Day(s)
SQL: Fundamentals of Querying (Second Edition)You have access to company databases and your job may require you to retrieve data from those databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. This course will help you to use Structured Query Language (SQL) as a tool to implement that logic and define instructions. Course Objective: You will learn how to compose SQL queries to retrieve information from the database.
Price: $497		 Mississauga 1 Day(s)
top