Certified SQL Server Specialist - EVS Institute

(042) 35831312

Everyday (9AM to 10PM)
Post Inquiry
We'll get back to you

Certified SQL Server Specialist

Certified SQL Server Specialist

Microsoft SQL Server 2016 provides a robust architecture for enterprise level data management, developer’s productivity and business intelligence. This hands-on course is designed to provide necessary knowledge and hands-on experience for installation and configuration and administration of SQL Server 2016; designing and implementing SQL Server databases, querying and manipulating data from SQL Server and implementing a Data Warehouse with SQL Server 2016.

Brief Contents
  • Introduction to Microsoft SQL Server 2016
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server 2016 Data Types
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Sub-queries
  • 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
  • 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
  • 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
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers
  • Troubleshooting Common SQL Server 2012 Administrative Issues
  • Introduction to Data Warehousing
  • Data Warehouse Hardware
  • Designing and Implementing a Data Warehouse
  • Creating an ETL Solution with SSIS
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud into a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SQL Server Integration Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse
Training Methodology
Audience
Course Project

Participants of the course will complete hands-on labs and project assignments with help of their trainers.

Certificate
  • MCP: Quering Data with Transact-SQL
Duration & Frequency
  • 2 Month (8 weeks; with 3 training sessions of 1.5 hours a week)

Oct
14

Free Seminar At 07:30 PM
Lahore Branch

  Classes start from Oct 16, 2019
  • Monday (Lab) :
    07:30 PM To 09:00 PM
  • Wednesday :
    07:30 PM To 09:00 PM
  • Friday :
    07:30 PM To 09:00 PM

Sep
28

Free Seminar At 06:00 PM
Rawalpindi Branch

  Classes start from Sep 29, 2019
  • Saturday :
    06:30 PM To 08:00 PM
  • Saturday (Lab) :
    08:00 PM To 09:30 PM
  • Sunday :
    08:00 AM To 09:30 AM

Online registeration will soon be available !!

Post Inquiry