Microsoft SQL Server 2016/2012 eLearning Bundle Course

Learn at Your Own Pace

This self-paced online course lets you learn independently at your own pace through Certstaffix Training's easy-to-use platform.

How It Works

• A Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
• Lecture utilizing video and recorded screenshots
• 6-month subscription length
• Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

Exploring SQL Server 2016, Part 1 of 5: First Look

Course Duration - 1 hr 51 min

Begin your exploration of SQL Server 2016 with an overview of what’s new and what’s been updated. Following an installation example, discover the changes in R services and configuring tempdb, then take a close-up look at the various ways SQL Server Management Studio has been updated. Gain an understanding of the enhancements that have been made to ETL packages, integration services, and reporting services for something like mobile reporting and analytical databases for cubes and tabular models, then take a peek at enhancements in TSQL, temp tables, CHECKDB, and the online altering of tables and store procedures and functions.

Exploring SQL Server 2016, Part 2 of 5: Performance Enhancements

Course Duration - 5 hrs 35 min

Enhancements in performance are an important reason to upgrade to SQL Server 2016. Learn about changes in manageability features and execution, as well as query plans with live query statistics before taking a look at Powershell and integration with automation, and discovering 3 new groups of commandlets. Continue your exploration with a focus on in-memory table improvements, columns store index changes, and the new temporal tables, then learn about some additional improvements including enhancements of optimizer, cloud first development, and testing in the cloud.

Exploring SQL Server 2016, Part 3 of 5: Security and Availability

Course Duration - 1 hr 31 min

Continue your exploration of SQL Server 2016 with a review of row level security, including a look at Always Encrypted and dynamic data masking, high availability, and clusters, and discover a wealth of enhancements in the areas of security and encryption.

Exploring SQL Server 2016, Part 4 of 5: Business Intelligence

Course Duration - 2 hrs 38 min

Dive deeper into your SQL Server 2016 exploration, starting with a review of new improvements to integration services including how to use catalogue and project parameters, as well as improvements related to deploying packages. Explore the new data sources for cubes, changes in bidirectional filtering, new functions that improve direct query translation to DAX, and improvements to analysis and reporting services.

Exploring SQL Server 2016, Part 5 of 5: Advanced Integration

Course Duration - 1 hr 1 min

Take a look at the R language, which has been more deeply integrated into SQL Server 2016 via the SQL Server database engine, and how to run stand-alone R services for development. Examine new client tools to interact with R services and learn how to integrate R services with T-SQL to enable DBAs to write their own R scripts. In addition, discover Master Data Services, or MDS, the SQL Server solution for master data management.

SQL Server 2016 Core, Part 1 of 3: Getting Started

Course Duration - 2 hrs 28 min

In this course, you'll get an overview of what SQL Server is all about, and tour some of its more prominent features. We'll start by looking at the product itself, and its various editions, and talk about how Microsoft is constantly shifting features around the various editions. Then we'll explore some of the tools you get in the product, as well as the extensive documentation and sample applications available to help you learn SQL Server's many features. One of the main tools you're likely to use with SQL Server is Management Studio, a nearly all-encompassing set of tools that let you administer and develop code in just about every nook and cranny of the product. Then you'll see how you can work with data tables, views, and queries, where you really can start getting things done with SQL Server. You'll see how to create and edit tables and views, generate scripts, and view data from one or more tables. We'll wrap up with a short discussion about the Business Intelligence features, or BI, in SQL Server.

SQL Server 2016 Core, Part 2 of 3: Install and Configure

Course Duration - 2 hrs 18 min

Modern versions of SQL Server are very easy products to install—the setup program walks you through all of the necessary steps to installing the features you need. There are a number of decisions you’ll have to make along the way, which can seem a bit overwhelming, particularly if you’re new to SQL Server. The good news is that Microsoft carefully considered most of the default settings so that they’ll work in many scenarios. And for most installation options, you can change the setting later, even after using the server in production for a while. But in order to ensure that you are able to perform a successful installation with a resulting server that will serve your needs, you should do some careful planning and preparation long before you start up the SQL Server installation program. In this course, you'll learn about the basic hardware and software requirements for a successful installation, and learn about some of the decisions you'll need to make about security and instances of SQL Server. Then we'll explore some of the issues involved in upgrading an existing instance of and older version of SQL Server. You'll see a tool from Microsoft that makes the process way easier, because it identifies issues that you might face during the update process. Then we'll run through an entire installation of SQL Server, as I explore the process and some of the options and decisions you'll face along the way. Then we'll wrap up by looking at how you can configure SQL Server after installation, so that it perfectly suits your needs with the features it needs.

SQL Server 2016 Core, Part 3 of 3: Interface and Querying

Course Duration - 2 hrs 29 min

SQL Server Management Studio (SSMS) is an integrated development environment for writing ransact-SQL and other types of SQL Server code and commands. It is the principal tool that you can use to administer SQL Server and write code, and is hosted in the Visual Studio shell. Management Studio, which integrates capabilities that previously were available in a umber of separate tools, provides a huge number of tools that touch nearly every nook and cranny of all of the features of SQL Server, most certainly including the core database engine.In this course, you'll learn how to connect to an instance of SQL Server with Management Studio, and explore the rich user interface and development environment, so that you can customize it to look how you like and support the way you like to work. One size doesn't fit all, but with all the configuration options you can really personalize Management Studio! One of the core features of Management Studio is Object Explorer, a treeview that exposes pretty much every database and server object in SQL Server. You'll learn how to navigate the hierarchy to find what you need, and how to access the many tools, editors, and designers packed into Management Studio. When you write code using Management Studio, you're likely to do it using the Query Editor. This is a rich environment that understands both SQL Server and Transact-SQL code, with many features to help you write clean, maintainable code that performs efficiently. We'll explore the Query Editor and use it to perform many common tasks with SQL Server.

Microsoft 70-461: Querying SQL Server 2012

Course Duration - 12 hrs 22 min

Develop the technical skills for successful querying of Microsoft SQL Server 2012 in this detailed course, designed to get you up-to-speed quickly and ready for the certification exam. Well begin with an overview of SQL Server 2012, its components and the various versions. Well delve into the built-in SQL tools, including SQL tools such as SQL Server Management Studio (SSMS) and SQL Profiler. Importantly, you'll learn how to write Transact-SQL (T-SQL) queries for SQL. You'll also master the fundamentals of working with SQL data types, sorting and filtering data, querying and modifying data, writing select queries, implementing stored procedures, and more. By completing this in-depth course, you'll be equipped to successfully complete the Querying Microsoft SQL Server 2012 (70-461) exam. You'll gain a solid understanding of how to utilize the SQL database and query with confidence.

Microsoft 70-462: Administering SQL Server 2012 Databases

Course Duration - 8 hrs 24 min

The tips and tricks covered in this course will enable you to improve your organization's SQL Server 2012 database performance and prepare you to pass the certification exam. To begin, Well delve into the various components of SQL 2012, giving you the tools you need to administer the database and optimize critical organizational information. Well cover the database engine itself, along with features and functions including integration services and reporting, analytical, and master data services. These help you to maintain data integrity across an enterprise. Additional topics covered include SQL Server Management Studio, along with and SQL Server Profiler and Database Engine Tuning Advisor that help to improve overall performance. Geared to database professionals, the knowledge you'll gain from this course will prepare you for the 70-462 Administering SQL Server 2012 Databases exam.

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

Course Duration - 7 hrs 3 min

With this course you'll acquire the know-how to effectively store large amounts of data and make better business decisions through implementation and management of a data warehouse with SQL Server 2012. Well start with an overview of data warehousing and concepts. You'll learn how to use the tools within SQL Server 2012 to create fact tables and indexes, execute SSIS (SQL Server Integrating Services) packages, and manage data flow. With data warehousing, you'll have the ability to perform business intelligence analysis and create reports, in order to better understand your company’s strengths and weaknesses. The curriculum highlights key performance needs such as implementing ETL with SQL Server Integration Services, validating data, and using SQL Server Master Data Services (MDS). This course will get you up to speed on data warehousing tools and services, and prepare you for the Implementing a Data Warehouse with Microsoft SQL Server 2012 (70-463) exam.

SSRS 2014, Part 01 of 10: Introduction and Report Builder

Course Duration - 2 hrs 18 min

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer. Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014, Part 02 of 10: Creating Reports

Course Duration - 1 hr 6 min

In this course you'll get a high-level view of the parts and pieces of Reporting Services so that you know what you're workin with. I'll start by looking at the two modes you can install and operate a report server in. Then I'll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I'll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I'll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer.

SSRS 2014, Part 03 of 10: Tablix Report Type

Course Duration - 1 hr 48 min

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer.Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014, Part 04 of 10: Expressions and Functions

Course Duration - 1 hrs 18 min

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer.Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014, Part 05 of 10: Layout, Parameters, and Visualizing

Course Duration - 2 hrs 47 min

In this course you’ll get a high-level view of the parts and pieces of Reporting Services so that you know what you’re working with. I’ll start by looking at the two modes you can install and operate a report server in. Then I’ll show you some of the extensive configuration options you can use to fine tune reporting features. Reporting Services has a fairly complex architecture, and I’ll walk you through a high-level view of it. There are a lot of parts and you need to have a good feel for how they all work. Then I’ll take a look at the tools available for building reports, and will walk through creating a simple report using Report Designer. Next you’ll get a solid introduction to Report Builder, and learn how to install either the standalone version or the ClickOnce version accessible from Report Manager. I’ll walk you through a tour of the Report Builder user interface. Then I’ll show you how to build a simple report, point out more of Report Builder’s features and learn about preview performance. Finally, you’ll learn about shared datasets as a way to make data access easier for end users.

SSRS 2014, Part 06 of 10: Accessing and Subscribing to Reports

Course Duration - 2 hrs 22 min

In this course, you’ll learn about some of the issues you’re likely to face starting Report Manager and connecting to a report server. Then you’ll learn about some of the cool features from a report user’s perspective to find reports, view them, and access a report’s document map. Next you’ll learn about the My Reports folder. An admin has to enable this feature before users can use it, but then it provides a location for each user to save links to reports they use often as well as their own reports. Then the course explores the various export formats supported by Reporting Services. You’ll learn about soft and hard page-break renderers, as well as the data exchange formats that can export the raw data from a report.

SSRS 2014, Part 07 of 10: Programming Report Access

Course Duration - 2 hrs 19 min

There are five major APIs that you can use to program report server access, and this course will cover two of them. First, we’ll look at accessing reports using a custom URL, which is the same way Report Manager provides access, although you can use a shorthand version of the URLs for easier programming. You’ll learn the structure of the URL, and see various ways to build the URLs and some of the many options available as querystring parameters. Then you’ll learn about the ReportViewer control that is available in both Web and Windows Forms .NET applications. You’ll learn how to use the control with both server and local reports, which are reports you build directly in Visual Studio for that application.

SSRS 2014, Part 08 of 10: Web Service Programming

Course Duration - 2 hrs 45 min

In this course you’ll learn how to use the Report Server Web Service, and see some examples of how useful it is. You’ll learn about the two endpoints that Reporting Services exposes, the management and execution endpoints, and the differences between them. You’ll also see how to build an application using the Web services to display a list of reports and render format options, both retrieved dynamically from the report server, as well as how to execute the selected report using both a custom URL and the execution Web service. As a bonus, you’ll learn how to dynamically determine whether the selected report has required parameters and one way to supply parameters to the report.

SSRS 2014, Part 09 of 10: Managing Reporting Services

Course Duration - 1 hr 3 min

IIn this course you’ll learn about reporting tools, starting with seeing how you can use Management Studio for some tasks. Management Studio is far more limited than Report Manager for report server management, but nonetheless supports some important tasks. You’ll learn the three primary kinds of tasks you’ll need to use Management Studio for, as well as how to access those features. Then you’ll explore the management features of Report Manager. You’re likely to use Management Studio occasionally for the tasks it supports, but use Report Manager every day to do things like manage files and folders, including reports, and change and manage site settings and folder and object settings.

SSRS 2014, Part 10 of 10: Reporting Services Security

Course Duration - 2 hrs 45 min

IIn this course, you’ll learn how to work with the security features of Reporting Services. You’ll start by learning how to authorize users to perform actions at both the server and folder level, as well as how to use Management Studio to manage report server roles. Then you’ll learn how to enable Basic authentication, necessary to allow report access via non-IE browsers and outside the local network. It is generally a very bad practice to transmit credentials or data in the clear over any network, even a local network, so next you’ll see how you can enable and optionally require the use of SSL (really TLS, or Transport Layer Security) anytime a user or application accesses Reporting Services. Then you’ll learn about how report data security hooks into the data security features of the core database engine of SQL Server. You’ll see how to require different kinds of credential for any data source, both in SQL Server Data Tools and in Report Manager. You’ll also learn about the permissions required to access data for a report.

Essential Career Skills Pack

Productivity and Time Management

Course Duration - 30 min

It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.

Basic Digital Skills

Course Duration - 13 min

With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.

4 Ways to Boost Creativity

Course Duration - 30 min

The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.

The 11 Essential Career Soft Skills

Course Duration - 1 hr 10 min

Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?

This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.