SQL Server Database Specialist

SQL Server Database Specialist

Category:
IT PROGRAMS/
$15,000.00
A room with glass doors

$15,000.00

SQL Server Database Specialist

Program Length Total Contact Hours Program Cost
Clock Hours 450 Theory Hours 150 Tuition $ 12,500
Credit Hours Lab Hours 300 Registration Fees $ 100
Externship Hours Books & Supplies $ 1000
Material Cost $ 500
Exam Cost $ 900
Total Hours 450 Total Program Cost $ 15,000

 

Course Number Course Title Clock Hours Lab Hours
COMP-70-761 Querying Data with Transact-SQL 70-761 30
COMP-70-762 Developing SQL Databases 70-762 30
COMP-70-764 Administering a SQL Database Infrastructure 70-764 30
COMP-70-765 Provisioning SQL Databases 70-765 30
COMP-70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 30
 Total of Theory Hours  150
COMP-70-761 Querying Data with Transact-SQL 70-761 60
COMP-70-762 Developing SQL Databases 70-762 60
COMP-70-764 Administering a SQL Database Infrastructure 70-764 60
COMP-70-765 Provisioning SQL Databases 70-765 60
COMP-70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 70-467 60
Total Lab Hours 300
  Total Hours Theory and Labs 450  

 

Program Objective

In the training, the student will acquire skills in Database Development, Database Administration and Business Intelligence. These courses will prepare the students to be able to design, Install, Program, Manage and troubleshoot Microsoft SQL Server 2016 Databases

Program Description

Querying Data with Transact-SQL 70-761

Developing SQL Databases 70-762

Administering a SQL Database Infrastructure 70-764

Provisioning SQL Databases 70-765

Designing Business Intelligence Solutions with Microsoft SQL Server 70-467

1- Querying Data with Transact-SQL 70-761

    • 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 DML to Modify Data
    • Using Built-In Functions
    • Grouping and Aggregating Data
    • Using Subqueries
    • Using Table Expressions
    • Using Set Operators
    • Using Windows Ranking, Offset, and Aggregate Functions
    • Pivoting and Grouping Sets
    • Executing Stored Procedures
    • Programming with T-SQL
    • Implementing Error Handling
    • Implementing Transactions

 2- Developing SQL Databases 70-762

    • Introduction to Database Development
    • Designing and Implementing Tables
    • Advanced Table Designs
    • Ensuring Data Integrity through Constraints
    • Introduction to Indexes
    • Designing Optimized Index Strategies
    • Column store Indexes
    • Designing and Implementing Views
    • Designing and Implementing Stored Procedures
    • Designing and Implementing User-Defined Functions
    • Responding to Data Manipulation via Triggers
    • Using In-Memory Tables
    • Implementing Managed Code in SQL Server
    • Storing and Querying XML Data in SQL Server
    • Storing and Querying Spatial Data in SQL Server
    • Storing and Querying BLOBs and Text Documents in SQL Server
    • SQL Server Concurrency
    • Performance and Monitoring

3- Administering a SQL Database Infrastructure 70-764

    • SQL Server Security
    • Assigning Server and Database Roles
    • Authorizing Users to Access Resources
    • Protecting Data with Encryption and Auditing
    • Recovery Models and Backup Strategies
    • Backing Up SQL Server Databases
    • Restoring SQL Server 2016 Databases
    • Automating SQL Server Management
    • Configuring Security for SQL Server Agent
    • Monitoring SQL Server with Alerts and Notifications
    • Introduction to Managing SQL Server by using PowerShell
    • Tracing Access to SQL Server with Extended events
    • Monitoring SQL Server
    • Troubleshooting SQL Server
    • Importing and Exporting Data

4- Provisioning SQL Databases 70-765

    • SQL Server 2016 Components
    • Installing SQL Server 2016
    • Upgrading SQL Server to SQL Server 2016
    • Working with Databases
    • Performing Database Maintenance
    • Database Storage Options
    • Planning to Deploy SQL Server on Microsoft Azure
    • Migrating Databases to Azure SQL Database
    • Deploying SQL Server on a Microsoft Azure Virtual Machine
    • Managing databases in the Cloud

5- Designing Business Intelligence Solutions with Microsoft SQL Server 70-467

    • Plan business intelligence infrastructure
      1. Plan for performance
      2. Plan for scalability
      3. Plan and manage upgrades
      4. Maintain server health
    • Design BI Infrastructure
      1. Design a security strategy
      2. Design a SQL partitioning strategy
      3. Design a high availability and disaster recovery strategy
      4. Design a logging and auditing strategy
    • Design a reporting Solution
      1. Design a Reporting Services dataset
      2. Manage Excel Services/reporting for SharePoint
      3. Design a data acquisition strategy
      4. Plan and manage reporting services configuration
      5. Design BI reporting solution architecture
    • Design BI data models
      1. Design the data warehouse
      2. Design a schema
      3. Design cube architecture
      4. Design fact tables
      5. Design BI semantic models
      6. Design and create MDX calculations
    • Design an ETL solution
      1. Design SSIS package execution
      2. Plan to deploy SSIS solutions
      3. Design package configurations for SSIS packages