Course 1:Querying Microsoft SQL Server 2012

• Introduction to Microsoft SQL Server 2012
• Getting Started with SQL Azure--AC
• Introduction to T-SQL Querying
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering data
• Working with SQL Server 2012 Data types
• Using Built-In functions
• Grouping and Aggregating
• Using Subqueries
• Using Table Expressions
• Using Set Operators
• Using Window Ranking, Offset and Aggregate Functions
• Pivoting and Grouping Sets
• Querying SQL Server Metadata
• Executing Stored Procedures
• Programming with T-SQL
• Implementing Error Handling
• Implementing Transactions
• Improving Query Performance Course

2: Administering Microsoft SQL Server 2012 Databases

• Introduction to SQL Server 2012 and its Toolset
• Preparing Systems for SQL Server 2012
• Installing and Configuring SQL Server 2012
• Working with Databases
• Understanding SQL Server 2012 Recovery Models
• Backup of SQL Server 2012 Databases
• Restoring SQL Server 2012 Databases-
• Importing and Exporting Data
• Authenticating and Authorizing Users
• Assigning Server and Database Roles
• Authorizing Users to Access Resources
• Auditing SQL Server Environments
• Automating SQL Server 2012 Management
• Configuring Security for SQL Server Agent
• Monitoring SQL Server 2012 with Alerts and Notifications
• Performing Ongoing Database Maintenance
• Access to SQL Server 2012
• Monitoring SQL Server 2012
• Managing Multiple Servers 
• Troubleshooting Common SQL Server 2012 Administrative Issues 

Overview SQL 2016 Data Warehouse (SSIS) Training

Overview SQL Server 2016 Reporting Services (SSRS) Training

Overview Performance, Tuning, and Optimizing SQL Databases 2016 Training