Filter by Topic
Filter by Vendor
70-761: Querying Data with Transact-SQL eLearning
Course Description: In this instructor-led, online training course, students will …
What you'll learn
Describe key capabilities and components of SQL Server
Describe T-SQL, sets, and predicate logs
Write a single table SELECT statement
Write a multi-table SELECT statement
Write SELECT statements with filtering and sorting
Describe how SQL Server uses data types
Write DML statements
Write queries that use built-in functions
Write queries that aggregate data
Write subqueries
Create and implement views and table-valued functions
Use set operations to combine query results
Write queries that use window ranking, offset, and aggregate functions
Transform data by implementing pivot, unpivot, rollup and cube
Create and implement stored procedures
Add programming constructs such as variables, conditions, and loops to T-SQL code
70-764: Administering a SQL Server 2016 Database Infrastructure eLearning
Course Description: In this instructor-led, online training course, students will …
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
70-462: Administering Microsoft SQL Server 2012 eLearning
Course Description: The 70-462: Administering Microsoft SQL Server 2012 online …
What you'll learn
Plan, install, and troubleshoot SQL Server 2012 and SQL Server databases
Working knowledge of SQL Databases, the concept of the transaction log, SQL Server 2012 database recovery, backup and restoration
SQL Server 2012 security models, logins and users
Fixed server roles, user-defined server roles, fixed database roles and permissions and the assignment of permissions, user-defined database roles
Partial database containment option provided by SQL Server 2012
SQL Profiler
Virtualization of SQL Server 2012 and Data-Tier Applications, Central Management Servers and Multi-Server queries
Auditing SQL Server 2012 environments
Monitoring and maintaining SQL Server 2012 databases
Managing and working with multiple servers including virtualizing SQL Server 2012and deploying and upgrading data-tier applications
70-668: Administrating Microsoft SharePoint 2010 eLearning
Course Description: The 70-668: Administrating Microsoft SharePoint 2010 online training …
What you'll learn
Describe the core methods for identifying business requirements and how these affect planning for a SharePoint 2010 and SharePoint Online deployment.
Describe how to plan the service application architecture in SharePoint 2010 and SharePoint Online.
Describe the principles of designing to maximize performance and capacity in aSharePoint 2010 deployment.
Describe how to successfully plan the physical components of a SharePoint 2010deployment.
Describe the security architecture of SharePoint 2010 and SharePoint Online and the importance of creating a design that is based on the principle of least privilege.
Explain how to select authentication methods in a SharePoint 2010 and SharePoint Online design.
Describe how to match the managed metadata architecture in SharePoint 2010 and SharePoint Online to business requirements.
Describe how to plan a social computing implementation of SharePoint 2010 and SharePoint Online that meets business requirements.
Describe the architecture and topologies that are available to service a range of search requirements across business models.
Describe the core functionality of Enterprise Content Management (ECM) in SharePoint 2010 and how it influences solution design.
Describe core BI principles that will affect planning for SharePoint 2010.
Describe how to plan for data governance in SharePoint 2010 and SharePoint Online.
Describe the considerations for developing a maintenance and monitoring plan for SharePoint 2010 that also incorporates the technologies that support SharePoint 2010.
Describe how to develop a business continuity plan for SharePoint 2010 and SharePoint Online.
Understand appropriate command-Line, PowerShell and applicable management shell commands
70-667: Configuring Microsoft SharePoint 2010 eLearning
Course Description: The 70-667: Configuring Microsoft SharePoint 2010 online training …
What you'll learn
Installing and Configuring a Microsoft SharePoint 2010 Environment
Managing a SharePoint Environment
Deploying and Managing Applications
Maintaining a SharePoint Environment
Understand appropriate command-Line, PowerShell and applicable management shell commands
70-332: Advanced Solutions of SharePoint Server 2013 eLearning
Course Description: The 70-332: Advanced Solutions of SharePoint Server 2013 …
What you'll learn
Describe the core features of SharePoint Server 2013
Plan and design a SharePoint Server 2013 environment to meet requirements for high availability and disaster recovery
Plan and implement a service application architecture for a SharePoint Server 2013 deployment
Configure and manage Business Connectivity Services features in a SharePoint Server 2013 deployment
Plan and configure social computing features
Plan and configure productivity and collaboration platforms and features
Plan and configure Business Intelligence solutions
Optimize the search experience for an enterprise environment
Plan and configure enterprise content management in a SharePoint Server 2013 deployment
Plan and configure a web content management infrastructure to meet business requirements
Manage solutions in a SharePoint Server 2013 deployment
Configure and manage apps in a SharePoint Server 2013 environment
Develop and implement a governance plan for SharePoint Server 2013
Perform an upgrade or migration to SharePoint Server 2013
Understand appropriate command-Line, PowerShell and applicable management shell commands
70-331: Core Solutions of SharePoint Server 2013 eLearning
Course Description: The 70-331: Core Solutions of SharePoint Server 2013 …
What you'll learn
Describe the key features of SharePoint 2013
Design an information architecture
Design logical and physical architectures
Install and configure SharePoint Server 2013
Create web applications and site collections
Plan and configure service applications
Manage users and permissions
Configure authentication for SharePoint 2013
Secure a SharePoint 2013 deployment
Manage taxonomy
Configure user profiles
Configure enterprise search
Monitor and maintain a SharePoint 2013 environment
Understand appropriate command-Line, PowerShell and applicable management shell commands
Microsoft SharePoint 2013 Expert Administration eLearning
Course Description: The Microsoft SharePoint 2013 Expert Administration online training …
What you'll learn
Install or upgrade SharePoint 2013 to create your farm
Use Central Administration to configure your SharePoint 2013 farm
Create Web applications and site collections to host your content
Create service applications that provide additional functionality in the SharePoint farm
Scaling your SharePoint 2013 farm for better performance and availability
Create and manage workflows to provide automated business processes
Protecting your data using the available disaster recovery tools in SharePoint 2013
Understand appropriate command-Line, PowerShell and applicable management shell commands
