Create Transact-SQL SELECT queries
Query multiple tables by using joins
Implement functions and aggregate data
Modify data
Query data by using subqueries and APPLY
Query data by using table expressions
Group and pivot data by using queries
Query temporal data and non-relational data
Create database programmability objects by using Transact-SQL
Implement error handling and transactions
Implement data types and NULLs
Design and implement a relational database schema
Design and implement indexes
Design and implement views
Implement columnstore indexes
Ensure data integrity with constraints
Create stored procedures
Create triggers and user-defined functions
Implement transactions
Manage isolation levels
Optimize concurrency and locking behavior
Implement memory-optimized tables and native stored procedures
Optimize statistics and indexes
Analyze and troubleshoot query plans
Manage performance for database instances
Monitor and trace SQL Server baseline performance metrics
Register today for MCSA Training
Configure encryption
Configure data access and permissions
Configure auditing
Develop a backup strategy
Restore databases
Manage database integrity
Monitor database activity
Monitor queries
Manage indexes
Manage statistics
Monitor SQL Server instances
Implement log shipping
Implement AlwaysOn Availability Groups
Implement failover cluster instances
Deploy a Microsoft Azure SQL Database
Plan for SQL Server installation
Deploy SQL Server instances
Deploy SQL Server databases to Azure virtual machines
Configure secure access to Microsoft Azure SQL Databases
Configure SQL Server performance settings
Manage SQL Server instances
Manage SQL Storage
Perform database maintenance
Register today for MCSA Training
Design and implement dimension tables
Design and implement fact tables
Design and implement indexes for a data warehouse workload
Design storage for a data warehouse
Design and implement partitioned tables and views
Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package
Design and implement an ETL data flow by using an SSIS package
Implement an ETL solution that supports incremental data extraction
Implement an ETL solution that supports incremental data loading
Debug SSIS packages
Deploy and configure SSIS packages and projects
Create a knowledge base
Maintain data quality by using DQS
Implement a Master Data Services (MDS) model
Manage data by using MDS
Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
Design and implement dimensions in a cube
Implement measures and measure groups in a cube
Design and publish a tabular data model
Configure, manage, and secure a tabular model
Develop a tabular model to access data in near real time
Create basic MDX queries
Implement custom MDX solutions
Create formulas by using the DAX language
Plan and deploy SSAS
Monitor and optimize performance
Configure and manage processing
Create Key Performance Indicators (KPIs) and translations
Register today for MCSA Training
Design a hybrid SQL Server solution
Implement SQL Server on Azure Virtual Machines (VMs)
Design a database solution on Azure SQL database and SQL Server in Azure
Implement Azure SQL Database
Design and implement MySQL and PostgreSQL database solutions in Azure
Design and implement SQL Server Database security
Design and implement Azure SQL Database security
Design and implement high availability solutions
Design and implement scalable solutions
Design and implement Azure SQL Database data recovery
Monitor and troubleshoot SQL Server VMs on Azure
Monitor and troubleshoot SQL Database
Automate and manage database implementations on Azure
Register today for MCSA Training
Connect to data sources
Perform transformations
Cleanse data
Create and optimize data models
Create calculated columns, tables, and measures
Create performance KPIs
Create hierarchies
Create and format interactive visualizations
Manage custom reporting solutions
Configure a dashboard
Publish dashboards
Configure security for dashboards
Register today for MCSA Training
#101, 1st Floor, UMA Residency, Opposite Sindhu Travels, Backside to Abhiruchi Tiffins.Beside Metro Station SR Nagar, Hyd - 38