SQL Server delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features help protect your data at rest and in motion.
Organizations gain deeper insights into their data with capabilities that go beyond business intelligence to perform advanced analytics directly within their database and present rich visualizations for business insights on any device.
You can also gain the benefits of hyper-scale cloud that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure in a secured way so your data is always at hand for queries, no matter the size. In addition, SQL Server delivers a complete database platform for hybrid cloud, enabling you to easily build, deploy and manage solutions that span on-premises and cloud.
This two-day course provides students with the knowledge and skills to analyze data with Power BI.
Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality; Familiarity with Microsoft Office applications – particularly Excel.This course is aimed at database professionals who fulfill a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.
Prerequisites: This course requires that you meet the following prerequisites:» Basic knowledge of the Microsoft Windows operating system and its core functionality.The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:
After completing this course, students will be able to:
The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking.
Prerequisites: » Basic knowledge of the Microsoft Windows operating system and its core functionality;The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.
After completing this course, students will be able to:
This course provides an in-depth review of SQL Server 2014 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2014, and how to implement high availability using those technologies.
Prerequisites: NoneUpon completion of this course, the student will be able to:
This three-day MTA Training course helps you prepare for Microsoft Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database.
Prerequisites: NoneThe Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.
After completing this course, students will be able to:
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.
Prerequisites: Before attending this course, students must have: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
After completing this course, students will be able to:
This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
Prerequisites: NoneThe first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data.
Students will reveal the underlying architecture of the Oracle database environment. This course is also intended to be of help to information technology (IT) managers and executives who require an understanding of the technology.
Prerequisites: NoneThe primary target audiences for this course are: Senior application designers and database developers; PL/SQL developers; Database administrators; Web server administrators; System administrators; Implementation specialists; Data center support engineers.
About Enterprise Architectures
144 - 4 Avenue SW
Calgary, AB
learning@thetrainingcompany.ca
888-922-1132