MCSA SQL Server

(0 review)
1, 840.00BHD
MCSA SQL Server

 

 

This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform, and how to create a data warehouse with Microsoft SQL Server 2014.  Database Administrators, Database Developers, and Business Intelligence professionals, individuals who administer and maintain SQL Server databases and database professionals who need to fulfill a Business Intelligence Developer role.

 

As a Microsoft partner, we at ProCloud Training Center, provide you with hands-on experience & practice, through our instructor-led courses in Microsoft Office 365, in order to attain the required technical skills to work on such IT environment. Our trainers are certified, so qualified experts in this field, who have extensive experience in Bahrain and Gulf business environment. We reinforce the training process by tying the learning objectives to the real business needs. We provide full guide and support to the trainees, to validate their achievements, track their progress, and well prepare them to pass the international exams.

Register now using the form at the end of this page, and we will get back to you!


 

MCSA SQL Server Outline 

 


!– Facebook Pixel Code –>



Course Features

  • Lectures 45
  • Quizzes 0
  • Duration 120 hours
  • Skill level All levels
  • Language English
  • Students 0
  • Certificate No
  • Assessments Self
  • Querying Microsoft SQL Server 2012/2014 0/20

    Exam 70-461

    • Lecture1.1
      Introduction to Microsoft SQL Server 2014
      0m
    • Lecture1.2
      Introduction to T-SQL Querying
      0m
    • Lecture1.3
      Writing SELECT Queries
      0m
    • Lecture1.4
      Querying Multiple Tables
      0m
    • Lecture1.5
      Sorting and Filtering Data
      0m
    • Lecture1.6
      Working with SQL Server 2014 Data Types
      0m
    • Lecture1.7
      Using DML to Modify Data
      0m
    • Lecture1.8
      Using Built-In Functions
      0m
    • Lecture1.9
      Grouping and Aggregating Data
      0m
    • Lecture1.10
      Using Subqueries
      0m
    • Lecture1.11
      Using Table Expressions
      0m
    • Lecture1.12
      Using Set Operators
      0m
    • Lecture1.13
      Using Window Ranking, Offset, and Aggregate Functions
      0m
    • Lecture1.14
      Pivoting and Grouping Sets
      0m
    • Lecture1.15
      Querying data with Stored Procedures
      0m
    • Lecture1.16
      Programming with T-SQL
      0m
    • Lecture1.17
      Implementing Error Handling
      0m
    • Lecture1.18
      Implementing Transactions
      0m
    • Lecture1.19
      Improving Query Performance
      0m
    • Lecture1.20
      Querying SQL Server Metadata
      0m
  • Administering Microsoft SQL Server 2012/2014 Databases 0/13

    Exam 70-462

    • Lecture2.1
      Introduction to SQL Server 2014 Database Administration
      0m
    • Lecture2.2
      Installing and Configuring SQL Server 2014
      0m
    • Lecture2.3
      Working with Databases and Storage
      0m
    • Lecture2.4
      Planning and Implementing a Backup Strategy
      0m
    • Lecture2.5
      Restoring SQL Server 2014 Databases
      0m
    • Lecture2.6
      Importing and Exporting Data
      0m
    • Lecture2.7
      Monitoring SQL Server 2014
      0m
    • Lecture2.8
      Tracing SQL Server Activity
      0m
    • Lecture2.9
      Managing SQL Server Security
      0m
    • Lecture2.10
      Auditing Data Access and Encrypting Data
      0m
    • Lecture2.11
      Performing Ongoing Database Maintenance
      0m
    • Lecture2.12
      Automating SQL Server 2014 Management
      0m
    • Lecture2.13
      Monitoring SQL Server 2014 by Using Alerts and Notifications
      0m
  • Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 0/12

    Exam 70-463

    • Lecture3.1
      Introduction to Data Warehousing
      0m
    • Lecture3.2
      Data Warehouse Hardware Considerations
      0m
    • Lecture3.3
      Designing and Implementing a Data Warehouse
      0m
    • Lecture3.4
      Creating an ETL Solution with SSIS
      0m
    • Lecture3.5
      Implementing Control Flow in an SSIS Package
      0m
    • Lecture3.6
      Debugging and Troubleshooting SSIS Packages
      0m
    • Lecture3.7
      Implementing an Incremental ETL Process
      0m
    • Lecture3.8
      Enforcing Data Quality
      0m
    • Lecture3.9
      Using Master Data Services
      0m
    • Lecture3.10
      Extending SQL Server Integration Services
      0m
    • Lecture3.11
      Deploying and Configuring SSIS Packages
      0m
    • Lecture3.12
      Consuming Data in a Data Warehouse
      0m

Reviews

Average Rating

0
0 rating

Detailed Rating

5 stars
0
4 stars
0
3 stars
0
2 stars
0
1 star
0
1, 840.00BHD

Leave A Reply

Your email address will not be published. Required fields are marked *