(042) 35831312

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

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 months (8 weeks with 2 classes and 1 lab in a week)

Nov
22

Free Saminar At 07:30 PM
Lahore

  Classes start from Nov 27, 2018
  • Tuesday :
    07:30 PM To 09:00 PM
  • Thursday :
    07:30 PM To 09:00 PM
  • Thursday (Lab) :
    09:00 PM To 10:30 PM

Oct
20

Free Saminar At 06:00 PM
Rawalpindi

  Classes start from Oct 21, 2018
  • 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
  • 349 Ferozepur Road, M-Block Gulberg
  • Phone : +(042) 111 685 822
  •  Cell : +(92 300) 410 2039
  • 349 Ferozepur Road, M-Block Gulberg
  • Phone : +(042) 111 685 822
  •  Cell : +(92 300) 410 2039

Alternate Text

EVS Professional Training Institute is training division of eVentureSolutions (Pvt.) Ltd. It was established in 2005 to produce highly skilled human resource in latest tools and technologies for IT industry of Pakistan. To achieve this objective EVS has developed professional training centers in Lahore and Rawalpindi/Islamabad and Future plans of EVS include establishing similar training centers in...

Read More