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 2012 Courses




Course Title Location Duration
10774 A: Querying Microsoft SQL Server 2012This 5-day course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Windows Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud. This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers. After completing this course, students will be able to: • Write SELECT queries • Query multiple tables • Use built-in functions • Use subqueries • Execute stored procedures • Use set operators • Implement error handling • Implement transactions • Use table expressions • Sort and filter data • Use window ranking, offset and aggregate functions • Query SQL Server metadata • Program with T-SQL • Improve query performance
Price: $2,895
Toronto 5 Day(s)
10774 A: Querying Microsoft SQL Server 2012Course Overview This 5-day course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Windows Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud. Your instructor should be able to provide a current list of Windows Azure enabled labs. Objectives After completing this course, students will be able to: • Write SELECT queries • Query multiple tables • Use built-in functions • Use subqueries • Execute stored procedures • Use set operators • Implement error handling • Implement transactions • Use table expressions • Sort and filter data • Use window ranking, offset and aggregate functions • Query SQL Server metadata • Program with T-SQL • Improve query performance Audience This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.   Prerequisites Before attending this course, students must have: • Working knowledge of relational databases. • Basic knowledge of the Microsoft Windows operating system and its core functionality. Before attending this course, students should have: • Basic understanding of virtualization technology (Classroom labs utilize virtual machines) To help you prepare for this class, review the following resources: • Book: T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure • MCTS Self Paced Training Kit 70-461
Price: $3,215
Virtual 5 Day(s)
10775 A: Administering Microsoft SQL Server 2012 DatabasesThis five-day course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462 All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. After completing this course, students will be able to: •Plan and install SQL Server. •Describes the system databases, the physical structure of databases and the most common configuration options related to them. •Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server. •Create SQL Server Backups. •Restore SQL Server databases. •Use the import/export wizards and explain how they relate to SSIS. •Work with SQL Server security models, logins and users. •Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles. •Work with permissions and the assignment of permissions. •Work with SQL Server Audit. •Work with SQL Server Agent, jobs and job history. •Implement SQL Server agent security, proxy accounts and credentials. •Configure database mail, alerts and notifications. •Create database maintenance plans. •Work with SQL Profiler and SQL Trace stored procedures. •Introduce DMVs and the configuration of data collection. •Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications. •Troubleshoot SQL Server databases.
Price: $2,895
Toronto 5 Day(s)
10775 A: Administering Microsoft SQL Server 2012 DatabasesCourse Overview This five-day course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the exam 70-462. All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. Your instructor should be able to provide a current list of Azure enabled labs. Below are the some of the new features of SQL Server that are discussed in this course • Discussion around servicing SQL Server (Service Packs, Cumulative Updates, Hotfixes)  Understanding the relationship between the different levels of updates to the SQL Server product is very important for those working with it. The course now covers details on how hotfixes, cumulative updates and service packs are related and when to apply each type of update. • SQL Server use of automated update  SQL Server can now utilize Windows Update for servicing. The course shows how to enable automated updates and when the use of these updates should and should not be used. • Partial database containment  A significant challenge when migrating databases between servers is the management of objects such as logins that are not contained within the database. The course now discusses the partial containment options that are provided by SQL Server 2012. In particular, authentication-related changes are discussed. • Users with passwords (contained users)  The course shows how SQL Server 2012 allows users to be authenticated at the database level, rather than at the server level. This is an important first step in for database containment. • User-defined server roles  In earlier versions of SQL Server, user-defined roles could be created at the database level but not at the server level. In SQL Server 2012, user-defined roles can also be defined at the server level. This can help to increase the security of systems. Having the ability to configure more fine-grained permissions lets logins be assigned only the permissions that they need to do their work.   • In-place upgrades of data-tier applications  In earlier versions of SQL Server, an upgrade of a data-tier application involved migrating all the data within a database to a new database. In SQL Server 2012 this is no longer needed and the course shows how data-tier applications can be upgraded much more quickly, and using less system resources. • Appendix with intro to AlwaysOn, High Availability and Replication concepts  Students who will be attempting the certification exam that is relevant to this course require knowledge of high availability and replication. In earlier versions of this course, none of these details were covered. In this version of the course, an appendix that covers the core concepts for high availability (including SQL Server 2012 AlwaysOn technologies) and replication is provided. Objectives After completing this course, students will be able to: • Plan and install SQL Server. • Describes the system databases, the physical structure of databases and the most common configuration options related to them. • Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server. • Create SQL Server Backups. • Restore SQL Server databases. • Use the import/export wizards and explain how they relate to SSIS. • Work with SQL Server security models, logins and users. • Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles. • Work with permissions and the assignment of permissions. • Work with SQL Server Audit. • Work with SQL Server Agent, jobs and job history. • Implement SQL Server agent security, proxy accounts and credentials. • Configure database mail, alerts and notifications. • Create database maintenance plans. • Work with SQL Profiler and SQL Trace stored procedures. • Introduce DMVs and the configuration of data collection. • Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications. • Troubleshoot SQL Server databases. Audience The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. Prerequisites In addition to their professional experience, students who attend this training should already have the following technical knowledge: • Basic knowledge of the Microsoft Windows operating system and its core functionality. • Working knowledge of Transact-SQL. • Working knowledge of relational databases. • Some experience with database design. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012
Price: $3,215
Virtual 5 Day(s)
10776 A: Developing Microsoft SQL Server 2012 DatabasesAbout This Course This 5-day course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this course helps you prepare for the Exam 70-464 All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. Your instructor should be able to provide a current list of Azure enabled labs. To acquire a trial Windows Azure account click here. Below are the some of the new features of SQL Server that has been discussed in this course • Use of SC collations  versions of Windows support extended Unicode collations known as supplementary (or SC) Current collations. Earlier versions of SQL Server did not support the use of these collations. The course provides details on SQL Server support for these additional collations. • Use of TRY_PARSE, TRY_CONVERT  SQL Server 2012 introduces a number of new functions. The demonstrations in the course utilize many of these new functions such as TRY_PARSE and TRY_CONVERT. • Detailed discussion on IDENTITY constraints  A new more detailed topic on IDENTITY constraints has been added to the course. • Working with SEQUENCES  SQL Server 2012 introduces the concept of sequences. The course now includes a topic and demonstration on the use of sequences. • Slight course reordering to improve overall flow  The course has been reordered from 6232B to improve the overall flow. In particular, constraints are discussed immediately after the initial discussion on logical table design. The course layout offers a more unified experience for the students with each day having a particular flavor. • Use of THROW and comparisons to RAISERROR  SQL Server 2012 enhances the available error-handling options in T-SQL. The module on error-handling has been expanded to show how to use THROW in place of RAISERROR and also to show how to rethrow errors (including system errors) within CATCH blocks using the THROW statement. • Full-globe and arc support in spatial  SQL Server 2012 adds support for geography data-type objects that span more than a single hemisphere. The course discusses the new full globe support and along with new support for curved arc objects. • Customizable nearness in full-text  The course covers how full-text indexing in SQL Server 2012 offers a more customizable and flexible proximity operation than earlier versions of SQL Server. Audience Profile The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012 product features and technologies for implementing a database.   Prerequisites In addition to their professional experience, students who attend this training should already have the following technical knowledge: • Knowledge of writing T-SQL queries. • Knowledge of basic relational database concepts. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012 At Course Completion After completing this course, students will be able to: • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts. • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types. • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered). • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints. • Determine appropriate single column and composite indexes strategies. • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure. • Read and interpret details of common elements from execution plans. • Design effective non-clustered indexes. • Design and implement views • Design and implement stored procedures. • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses. • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues). • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency. • Use both traditional T-SQL error handling code and structured exception handling. • Design and implement DML triggers • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server. • Store XML data and schemas in SQL Server. • Perform basic queries on XML data in SQL Server. • Work with the GEOGRAPHY and GEOMETRY data types • Implement and query a full-text index
Price: $2,895
Toronto 5 Day(s)
10776 A: Developing Microsoft SQL Server 2012 DatabasesCourse Overview This 5-day course introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course. Also this course helps you prepare for the exam 70-464. All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Azure database in the cloud. Your instructor should be able to provide a current list of Azure enabled labs. Below are the some of the new features of SQL Server that has been discussed in this course • Use of SC collations  Current versions of Windows support extended Unicode collations known as supplementary (or SC) collations. Earlier versions of SQL Server did not support the use of these collations. The course provides details on SQL Server support for these additional collations. • Use of TRY_PARSE, TRY_CONVERT  SQL Server 2012 introduces a number of new functions. The demonstrations in the course utilize many of these new functions such as TRY_PARSE and TRY_CONVERT. • Detailed discussion on IDENTITY constraints  A new more detailed topic on IDENTITY constraints has been added to the course. • Working with SEQUENCES  SQL Server 2012 introduces the concept of sequences. The course now includes a topic and demonstration on the use of sequences. • Slight course reordering to improve overall flow  The course has been reordered from 6232B to improve the overall flow. In particular, constraints are discussed immediately after the initial discussion on logical table design. The course layout offers a more unified experience for the students with each day having a particular flavor. • Use of THROW and comparisons to RAISERROR  SQL Server 2012 enhances the available error-handling options in T-SQL. The module on error-handling has been expanded to show how to use THROW in place of RAISERROR and also to show how to rethrow errors (including system errors) within CATCH blocks using the THROW statement. • Full-globe and arc support in spatial • SQL Server 2012 adds support for geography data-type objects that span more than a single hemisphere. The course discusses the new full globe support and along with new support for curved arc objects.  Customizable nearness in full-text • The course covers how full-text indexing in SQL Server 2012 offers a more customizable and flexible proximity operation than earlier versions of SQL Server. Objectives After completing this course, students will be able to: • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts. • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types. • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered). • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints. • Determine appropriate single column and composite indexes strategies. • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure. • Read and interpret details of common elements from execution plans. • Design effective non-clustered indexes. • Design and implement views • Design and implement stored procedures. • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses. • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues). • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency. • Use both traditional T-SQL error handling code and structured exception handling. • Design and implement DML triggers • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server. • Store XML data and schemas in SQL Server. • Perform basic queries on XML data in SQL Server. • Work with the GEOGRAPHY and GEOMETRY data types • Implement and query a full-text index. Audience The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2012 product features and technologies for implementing a database.   Prerequisites In addition to their professional experience, students who attend this training should already have the following technical knowledge: • Knowledge of writing T-SQL queries. • Knowledge of basic relational database concepts. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • 10774A: Writing T-SQL Queries for Microsoft SQL Server 2012
Price: $3,215
Virtual 5 Day(s)
10777 A Implementing a Data Warehouse with Microsoft SQL Server 2012Course Overview Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day course focuses on teaching individuals how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for exam 70-463. Objectives After completing this course, students will be able to: • Describe data warehouse concepts and architecture considerations. • Select an appropriate hardware platform for a data warehouse. • Design and implement a data warehouse. • Implement Data Flow in an SSIS Package. • Implement Control Flow in an SSIS Package. • Debug and Troubleshoot SSIS packages. • Implement an SSIS solution that supports incremental data warehouse loads and changing data. • Integrate cloud data into a data warehouse ecosystem infrastructure. • Implement data cleansing by using Microsoft Data Quality Services. • Implement Master Data Services to enforce data integrity. • Extend SSIS with custom scripts and components. • Deploy and Configure SSIS packages. • Describe how information workers can consume data from the data warehouse. Audience This course is intended for database professionals who need to fulfill a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include: • Implementing a data warehouse. • Developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL). • Enforcing data integrity by using Master Data Services. • Cleansing data by using Data Quality Services. Prerequisites Before attending this course, student should have: • At least 2 years’ experience of working with relational databases, including:  Designing a normalized database.  Creating tables and relationships.  Querying with Transact-SQL. • Some exposure to basic programming constructs (such as looping and branching). • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Price: $3,215
Virtual 5 Day(s)
10777 A: Implementing a Data Warehouse with Microsoft SQL Server 2012About This Course Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day course focuses on teaching individuals how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for exam 70-463. Audience Profile This course is intended for database professionals who need to fulfill a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include: • Implementing a data warehouse. • Developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL). • Enforcing data integrity by using Master Data Services. • Cleansing data by using Data Quality Services. Prerequisites Before attending this course, student should have: • At least 2 years’ experience of working with relational databases, including: o Designing a normalized database. o Creating tables and relationships. o Querying with Transact-SQL. • Some exposure to basic programming constructs (such as looping and branching). • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable. At Course Completion After completing this course, students will be able to: • Describe data warehouse concepts and architecture considerations. • Select an appropriate hardware platform for a data warehouse. • Design and implement a data warehouse. • Implement Data Flow in an SSIS Package. • Implement Control Flow in an SSIS Package. • Debug and Troubleshoot SSIS packages. • Implement an SSIS solution that supports incremental data warehouse loads and changing data. • Integrate cloud data into a data warehouse ecosystem infrastructure. • Implement data cleansing by using Microsoft Data Quality Services. • Implement Master Data Services to enforce data integrity. • Extend SSIS with custom scripts and components. • Deploy and Configure SSIS packages. • Describe how information workers can consume data from the data warehouse.
Price: $2,895
Toronto 5 Day(s)
10778 A: Implementing Data Models and Reports with Microsoft SQL Server 2012About This Course This 5-day course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466. The Beta version of this course (10778AB) utilizes pre-release software in the virtual machine for the labs. Microsoft® SQL Server® 2012 Release Candidate 0 (RC0) is used in this course. Some of the exercises in this course are SQL Azure enabled. Audience Profile The primary audience for this course are database professionals who need to fulfill BI Developer role to create analysis and reporting solutions. Primary responsibilities will include: • Implement reporting solutions by using SQL Server Reporting Services • Implementing multidimensional databases by using SQL Server Analysis Services • Creating tabular semantic data models for analysis by using SQL Server Analysis Services • Create visualizations of data by using Power View • Create data mining solutions by using SQL Server Analysis Services Prerequisites In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course: • 10774A: Writing Queries with Microsoft SQL Server Transact-SQL At Course Completion • Describe the components, architecture, and nature of a BI solution. • Create reports with Reporting Services. • Create reusable report items that simplify self-service reporting. • Manage a reporting infrastructure. • Create a multidimensional database with Analysis Services. • Implement dimensions in a cube. • Implement measures and measure groups in a cube. • Use MDX Syntax. • Customize a cube. • Implement a Tabular Data Model in PowerPivot. • Use DAX to query a tabular model. • Implement a Tabular Database. • Use Power View to create interactive data visualizations. • Use Data Mining for predictive analysis.
Price: $2,895
Toronto 5 Day(s)
10778 A: Implementing Data Models and Reports with Microsoft SQL Server 2012Course Overview Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution. This five-day course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466. Objectives After completing this course, students will be able to: • Describe the components, architecture, and nature of a BI solution. • Create reports with Reporting Services. • Create reusable report items that simplify self-service reporting. • Manage report execution and delivery. • Create a multidimensional database with Analysis Services. • Implement dimensions in a cube. • Implement measures and measure groups in a cube. • Use MDX Syntax. • Customize a cube. • Implement a Tabular Data Model in PowerPivot. • Use DAX to query a tabular model. • Implement a Tabular Database. • Use PowerView to create interactive data visualizations. • Use Data Mining for Predictive Analysis. Audience This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include: • Implementing reporting solutions by using SQL Server Reporting Services. • Implementing multidimensional databases by using SQL Server Analysis Services. • Creating tabular semantic data models for analysis by using SQL Server Analysis Services. • Create visualizations of data by using PowerView. • Create data mining solutions by using SQL Server Analysis Services.   Prerequisites Before attending this course, the student should have: • At least 2 years’ experience of working with relational databases, including:  Designing a normalized database.  Creating tables and relationships.  Querying with Transact-SQL. • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).  Some exposure to basic programming constructs (such as looping and branching).  An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Price: $3,215
Virtual 5 Day(s)
20465 B: Designing Database Solutions for Microsoft SQL Server 2012Course Overview This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability. This course maps to skills and knowledge measured by Microsoft Exam 70-465, and in conjunction with on-the-job experience, can help prepare your for the exam. Objectives After completing this course, students will be able to: • Design an appropriate database server infrastructure for a given business application scenario • Design a logical schema for a database based on application requirements • Design the physical implementation of a database for a given set of requirements • Evaluate options for including binary large object data in a database design • Plan and manage indexes to optimize performance • Describe the key considerations for designing security for SQL Server instances and databases • Plan policy-based management to manage server instances, databases, and other SQL Server 2012 objects more efficiently • Plan SQL Server health monitoring • Implement SQL Server health monitoring by using SQL Server Utility • Identify and implement the appropriate backup strategy for a given scenario • Plan and manage multi-server maintenance and automation • Understand the benefits of using PowerShell to manage SQL Server 2012 • Design an optimal replication strategy from a given set of business and technical requirements • Plan and implement a high availability solution Audience This course is intended for individuals who design database solutions for organizations and have experience with database development and administering SQL Server databases. These individuals design databases as their primary area of responsibility. They are responsible to plan and design database structure, storage, objects, and servers. They also create the plan for the environment in which the database solution runs.   Prerequisites In addition to their professional experience, students who attend this training should already have the following technical knowledge: • Experience with Transact-SQL • Familiarity with SQL Server 2012 components and tools • Familiarity with objects in a SQL Server database • Familiarity with enterprise Windows network and security architecture Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • MCSA: SQL Server 2012 Or attend • Course 10774: Querying Microsoft SQL Server 2012 • Course 10775: Administering a Microsoft SQL Server 2012 Databases • Course 10776: Developing Microsoft SQL Server 2012 Databases with Microsoft SQL Server 2012
Price: $3,215
Virtual 5 Day(s)
20467 B: Designing Business Intelligence Solutions with Microsoft SQL Server 2012About This Course This five-day course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform. This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam. Audience Profile This course is intended for BI professionals such as BI Architects or database professionals who need to design BI solutions. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use. In addition, their responsibilities include Online Analytical Processing (OLAP) cube design and integration with Microsoft SharePoint or line-of-business applications. Prerequisites Before attending this course, students must have: • A basic understanding of dimensional modeling (star schema) for data warehouses. • The ability to create Integration Services packages that include control flows and data flows. • The ability to create a basic multidimensional cube with Analysis Services. • The ability to create a basic tabular model with PowerPivot and Analysis Services. • The ability to create Reporting Services reports with Report Designer. • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services. • Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • 10777A: Implementing a Data Warehouse with Microsoft SQL Server 2012 • 10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012 At Course Completion After completing this course, students will be able to: • Plan the components of a BI solution. • Plan a BI infrastructure. • Design a data warehouse. • Design an ETL solution. • Plan analytical data models. • Plan a BI delivery solution. • Design a Reporting Services solution. • Design an Excel reporting solution. • Plan a SharePoint Server BI solution. • Monitor and optimize a BI solution. • Plan for BI operations.
Price: $2,895
Toronto 5 Day(s)
20467 B: Designing Business Intelligence Solutions with Microsoft SQL Server 2012Course Overview This five-day course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform. This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam. Objectives After completing this course, students will be able to: • Plan the components of a BI solution. • Plan a BI infrastructure. • Design a data warehouse. • Design an ETL solution. • Plan analytical data models. • Plan a BI delivery solution. • Design a Reporting Services solution. • Design an Excel reporting solution. • Plan a SharePoint Server BI solution. • Monitor and optimize a BI solution. • Plan for BI operations. Audience This course is intended for BI professionals such as BI Architects or database professionals who need to design BI solutions. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use. In addition, their responsibilities include Online Analytical Processing (OLAP) cube design and integration with Microsoft SharePoint or line-of-business applications. Prerequisites Before attending this course, students must have: • A basic understanding of dimensional modeling (star schema) for data warehouses. • The ability to create Integration Services packages that include control flows and data flows. • The ability to create a basic multidimensional cube with Analysis Services. • The ability to create a basic tabular model with PowerPivot and Analysis Services. • The ability to create Reporting Services reports with Report Designer. • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services. • Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel. Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills: • 10777A: Implementing a Data Warehouse with Microsoft SQL Server 2012 • 10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012
Price: $3,215
Virtual 5 Day(s)
40008 A: Updating your Database Skills to Microsoft SQL Server 2012Course Overview This three-day course provides existing SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2012. Objectives After completing this course, students will be able to: • Describe key new and enhanced features in SQL Server 2012. • Install SQL Server 2012. • Use enhanced tools and PowerShell support to manage SQL Server 2012. • Use enhanced Transact-SQL and storage capabilities to develop SQL Server 2012 databases. • Use new and enhanced performance capabilities to optimize a SQL Server 2012 database. • Use new availability and data recovery technologies to provide high availability. • Use new and enhanced security capabilities in SQL Server 2012. • Use SQL Azure. • Describe new Business Intelligence (BI) capabilities in SQL Server 2012. Audience This course is intended for database professionals with experience of using SQL Server 2008 R2. Prerequisites Before attending this course, students must have: • Experience of creating and managing database solutions in SQL Server, including basic Transact-SQL programming.
Price: $2,065
Virtual 3 Day(s)
40009 A: Updating your Business Intelligence Skills to Microsoft SQL Server 2012Course Overview This three-day course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012. Objectives After completing this course, students will be able to: • Describe key new and enhanced features for BI in SQL Server 2012. • Use new and enhanced features in SQL Server Integration Services. • Manage data quality by using SQL Server Data Quality Services. • Manage master data by using new and enhanced features of SQL Server Master Data Services. • Use new and enhanced features of SQL Server Reporting Services. • Create tabular data models with PowerPivot and DAX. • Implement a tabular data model in SQL Server Analysis Services. • Use Power View to create interactive data visualizations. • Integrate Microsoft cloud technologies into a BI solution. Audience This course is intended for BI professionals with experience of using SQL Server 2008 R2. Prerequisites Before attending this course, students must have: • Experience of creating database solutions in SQL Server, including basic Transact-SQL programming. • Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting.
Price: $2,065
Virtual 3 Day(s)
55005A Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 201255005A Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 Course Overview Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release. The course covers the Report Builder 3.0 wizards, basics of report design, intermediate reports with report parameters and report expressions, report visualizations including graphs, charts, images and gauges, advanced reporting including the utilization of maps, interactive reports, report parts and Sub-Reports. The course concludes with a special module that includes over 100 tips and tricks for Report Builder 3.0 with step-by-step instructions. All of the examples are available as a take-away for the students after the course. Objectives After completing this course, students will have been taught information about how to: Plan your reports Utilize Report Builder 3.0 Wizards Create an embedded data source Create an embedded data set Create shared data sources and data sets Use report parameters Use report expressions Create report gauges Create report graphs Use images in reports Use report lists Use report tables Use the matrix Create maps in reports Create sub reports Use report parts Create interactive reports Use keyboard shortcuts Audience This course is intended for Power Users, Developers and IT Professionals that will be involved with the design, development and maintenance of reports created with Report Builder 3.0 Prerequisites Before attending this course, students must have: A basic understanding of relational databases.
Price: $1,375
Virtual 2 Day(s)
Advanced T-SQL Querying, Programming and Tuning for SQL Server 2005, 2008 and 2012Course Overview The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2005, 2008 and 2012. In this course you will learn the details and capabilities of T-SQL in the following areas: Logical Query Processing; Query Tuning; Subqueries, Window Ranking and Offset Functions, Joins and Set Operations; Aggregating and Pivoting Data; Window Aggregate Functions; TOP, OFFSET-FETCH and APPLY; Data Modification; Working with Date and Time; Programmable Objects (Dynamic SQL, Views, User Defined Functions, Stored Procedures, Triggers, Transactions and Concurrency, Exception Handling); Graphs, Trees and Hierarchies. Along the course you will learn how to use T-SQL to solve practical problems such as: Relational Division, Ranking and Offsets, Missing and Existing Values (Gaps and Islands), Separating Elements, Running Totals, Pivoting and Unpivoting, Custom Aggregations, Dynamic Analysis of Grouping Sets, TOP and OFFSET-FETCH Problems, Top N Per Group, Paging, Aggregate over Columns, Data De-duplication, Handling Sequences, Treatment of Temporal Intervals (Overlaps, Max Concurrent, Packing), Dynamic Filtering, and more. You will learn how to tune your queries, how to develop efficient routines including user defined functions, stored procedures and triggers, work in multi-user environments with transactions and isolation levels, and use dynamic SQL securely and efficiently. You will also learn how to maintain and query hierarchical data. You will learn what graphs, trees and hierarchies are, what the common requests against graphs are, and how to write T-SQL code to handle those requests. Several different solutions will be presented including: Enumerated Paths, Nested Sets, Nested Iterations using Recursive Queries, and using the HIERARCHYID datatype. The course provides a dedicated module focusing on query tuning. The module covers internals and index tuning, index access methods, temporary tables, set vs. cursors, and query tuning using query revisions. Moreover, query tuning is in the heart of this course and is incorporated in the different modules throughout the course. With each querying/programming problem the discussions will revolve around logical aspects, set-based vs. procedural programming and optimization of the solutions   Objectives Upon completion of this course, the student will: • Understand logical query processing • Understand SQL Server's internal data structures • Be able to analyze and tune query performance • Be able to analyze query execution plans • Be able to solve complex querying and programming problems • Think in terms of sets • Be able to compare set based and cursor based solutions • Use window functions to improve solutions • Handle date and time data including intervals • Describe performance problems related to use of user defined functions and possible workarounds • Understand execution plan caching and reuse • Understand transactions and concurrency aspects of database programming • Know how to handle hierarchical data and write recursive queries • Describe T-SQL enhancements in SQL Server 2008 and 2012 Audience This course is intended for: • T-SQL Programmers, DBAss, Architects, and Analysts • Those that need to write or review T-SQL code in SQL Server 200 05, 2008 and 2012 Prerequisites Before attending this course, it is recommended that students have the following skills: • At least one year of T-SQL querying and programming experience in SQL Server
Price: $4,595
Virtual 5 Day(s)
Building Reports with Report Builder 3.0Course Overview This 1 day course provides students with the knowledge and skills to create various types of reports using SQL Server 2008 Reporting Services Report Builder 3.0. The course focuses on teaching individuals how to use Report Builder 3.0 product features and tools. Objectives After completing this course, students will be able to: • Create a shared data source. • Create a report using the Table and Matrix wizard. • Enhance Report using Richly Formatted Text. • View Report from the server. • Add Charts to the report. • Add Gauges to reports. • Create reports manually. • Use Query, Parameter, and Filter to limit data in report. Audience This course is intended for information workers with the need to connect to various data sources and create ad hoc reports against them. Prerequisites Before attending this course, students must have: • Basic knowledge of the Microsoft Windows operating system and its core functionality. • An understanding of the data being accessed and how we want to display that data.
Price: $685
Virtual 1 Day(s)
Data Mining with Server SQL 2012Course Overview In this course, attendees will learn how to use data mining to find advanced patterns in their data and perform predictions based on the patterns found using SQL Server 2012 Analysis Services. This is an advanced course, enabling students to go beyond simple usage of wizards. In-depth understanding of the data mining algorithms, how they are built and how do they work, is provided. Objectives Upon completion of this course, the student will be able to: • Describe what data mining is and what business questions can it answer • Explain the process of a data mining project • Explore and understand your data using descriptive statistics, OLAP cubes, reports and other tools • Prepare the data to make better models • Understand the data mining algorithms, and when to use them • Create data mining models and browse them • Evaluate models to find the one that gives best results • Use SQL Server 2012 Integration Services data mining tasks • Do text mining with Integration Services and with Full-Text and Semantic Search • Understand and use the Data Mining Extensions (DMX) language • Deploy data mining models in production using custom application, OLAP cubes or reports developed with SQL Server 2008 Reporting Services Audience Business intelligence application developers, advanced database administrators, and advanced analysts. Prerequisites Before attending this course, it is recommended that students have the following skills: • At least moderate experience with data warehousing, reporting and On-Line Analytical Processing • Familiarity with T-SQL Language • Knowledge of a .NET language like C# or VB.NET
Price: $2,703
Virtual 3 Day(s)
LearnBlock: SQL: Fundamentals of Querying ICourse Overview You have access to company databases and your job may require you to retrieve data from these databases. Retrieval of information from a database is dependent on precisely ordered logic and specific information. The course, SQL: Fundamentals of Querying will help you use Structured Query Language (SQL) as a tool to implement logic and define instructions. Objectives • connect to the SQL Server database and execute a simple query • include a search condition in a simple query • use various functions based on the data types to perform calculations on data • organize the data obtained from the query before it is displayed on the screen • retrieve data from tables • format the output, save the result, and generate a report This Course Includes: Sixty days of access to Post Class Support for instant help regarding the topics and tasks covered in your class. Post Class Support provides you with 24/7 support from certified experts via chat, phone and multimedia, including live demonstration, collaborative learning and step-by-step instruction. Audience Any person with basic computer skills, familiar with concepts related to database structure and terminology, and wants to use SQL to query databases. Prerequisites To ensure your success, we recommend you first take the following Element K course, or have equivalent skills and knowledge of: Windows XP Level 1.
Price: $690
Virtual 1 Day(s)
SQL Server 2012 Analysis ServicesCourse Overview During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2012 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution. SQL Server 2012 Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. This course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and successful analytical solution using SQL Server 2012 Analysis Services. Objectives Upon completion of this course, the student will be able to: • Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process. • Create effective SSAS solutions complete with calculations, actions, aggregations, and more. • Design SSAS solutions that are both scalable and secure. • Successfully manage and deploy SSAS solutions in a development/test/production environment. To accomplish that, BISM tabular and multidimensional models will be covered across the whole course. Audience This course is intended for IT Professionals that are responsible for designing, developing, and deploying business intelligence solutions. The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the new capabilities provided by SSAS to build analytical applications. Prerequisites • While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with any version of SQL Server Analysis Services. • A basic understanding of relational design and theory is helpful, as is basic familiarity with Structured Query Language (SQL).
Price: $3,738
Virtual 4 Day(s)
SQL Server 2012 Architecture, Internals and TuningCourse Overview SQL Server 2012 Internals is an advanced 5-day course designed for experienced SQL Server professionals. This course will be presented on SQL Server 2012 and cover features specific to that version, but most of the information is relevant to SQL Server 2008 as well. Topics to be covered include the following: • SQL Server Architecture and Metadata • Physical Storage Structures • Index Design and Tuning • Query Processing and Query Plans • Optimization and Recompilation • Concurrency Control: Locking, Blocking and Row Level Versioning • Query Tips and Techniques • Troubleshooting Tools The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques. Objectives At the end of this course, the student will be able to: • Examine details of SQL Server's internal structures to determine their impact on query performance. • Use the SQL Server 2012 Dynamic Management Objects to determine SQL Server's internal behavior. • Read query plans to determine where a poorly performing query needs tuning. • Determine if concurrency issues are causing problems with performance and troubleshoot those problems. • Use the SQL Server 2012 Tracing Tools to determine how SQL Server is performing, and to use those tools as a basis for improving performance. Audience Experienced SQL Server professionals. Prerequisites Before attending this course, students should have a good understanding and practical experience of SQL Server programming and administration. This is an advanced seminar designed for experienced SQL Server professionals.
Price: $4,595
Virtual 5 Day(s)
SQL Server 2012 Reporting ServicesCourse Overview This SSRS 2012 training is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes. Objectives • Use SSRS tools • Work with solutions and projects • Design basic reports • Enhance reports with formatting, images, and charts • Effectively group and summarize data • Work with parameterized reports • Incorporate charts and custom maps • Work with drillthrough reports • Manage reports • Utilize Report Builder Prerequisites All attendees must have a general familiarity with databases prior to the class. Working knowledge of Microsoft SQL Server or Microsoft Office applications is beneficial.
Price: $1,720
Virtual 3 Day(s)
SQL Server High AvailabilityCourse Overview This course provides an in-depth review of SQL Server 2012 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2012, and how to implement high availability using those technologies. Troubleshooting and operational guidance will also be provided. Objectives Upon completion of this course, the student will be able to: • Design a SQL Server 2012 availability solution to meet their availability goals • Implement that design using the available technologies in SQL Server 2012 • Implement system maintenance while understanding the availability implications • Troubleshoot problems with High Availability in SQL Server 2012 Audience This course is intended for those responsible for designing and implementing high availability solutions for SQL Server 2012. Prerequisites Before attending this course, it is recommended that students have the following skills: • 1 year of SQL Server experience (not necessarily SQL Server 2012) • 1 year of Windows Server 2008 (or later) experience Recommendations: • 1 year of Hyper-V experience • 1 year of Windows Failover Clustering experience
Price: $2,703
Virtual 3 Day(s)