Microsoft Certified Solution Associate (MCSA)

Microsoft Certified Solution Associate (MCSA)

Price:

Course Features

  • Course Duration: 2 Months
  • Category:
  • Students: 0
  • Certificate: Yes
  • Location: NEWARK
  • Language: English
  • Lesson: 0
  • Viewers: 605
  • Prerequisites: No
  • Skill Level:
  • Course Capacity: 50
  • Start Course: 09/01/2017

Descriptions

On passing the certification, the candidate can apply for infrastructure
administrator, server or database. We conduct the following 3 certification courses:
(1)MCSA Window Server 2016 (2) MCSA 10 (3) Security SQL 2016
Course Participants will learn:

● Understand the similarities and differences between Transact-SQL and other computer
languages
● Write SELECT queries
● Query multiple tables
● Sort and filter data
● Describe the use of data types in SQL Server
● Describe core database administration tasks and tools
● Manage SQL Server security
● Configure SQL Server databases and storage
● Plan and implement a backup strategy
● Restore databases from backups
● Use built-in functions
● Group and aggregate data
● Use subqueries
● Use table expressions
● Use set operators
● Audit data access and encrypt data
● Perform ongoing database maintenance