MCSA - SQL SERVER 2014

Become a Microsoft Certified Solution Associate (MCSA) with SQL SERVER 2014 from SSDN Technologies, It will take you out to build your career as Microsoft Certified Database Administrator. Whether your focus is SQL Server Database administration, SQL Server Database programming or SQL Server business intelligence and SQL Server reporting services, SSDN Technologies covers all your expectation. Get trained about all the SQL Server 2014 product features, learn the tools for managing a database, how to implement data warehouse, and use Extract Transform Load (ETL). You will also learn how to maintain a Microsoft SQL Server 2014 database by focusing on data storage, database backup, import and export data, making data secure, database maintenance etc.




By completing the training successfully, participants would be proficient with:

  • How to install SQL Server on machines.
  • How to configure SQL Server after installation.
  • How to retrieve the data with the help of several functions, executing triggers, stored procedures etc.
  • Understand the physical structure of databases common configuration.
  • How to create SQL Server Database Backups and Restore SQL Server Backups in SQL Server Databases.
  • How to work with system roles, user-defined roles, database roles and user-defined database roles.

Duration: 40 Hours

  • Introduction to Microsoft SQL Server 2014

    • The Basic Architecture of SQL Server
    • SQL Server Editions and Versions
    • Getting Started with SQL Server Management Studio
  • Introduction to T-SQL Querying

    • Introducing T-SQL
    • Understanding Sets
    • Understanding Predicate Logic
    • Understanding the Logical Order of Operations in SELECT statements
  • Writing SELECT Queries

    • Writing Simple SELECT Statements
    • Eliminating Duplicates with DISTINCT
    • Using Column and Table Aliases
    • Writing Simple CASE Expressions
  • Querying Multiple Tables

    • Understanding Joins
    • Querying with Inner Joins
    • Querying with Outer Joins
    • Querying with Cross Joins and Self Joins
  • Sorting and Filtering Data

    • Sorting Data
    • Filtering Data with a WHERE Clause
    • Filtering with the TOP and OFFSET-FETCH Options
    • Working with Unknown and Missing Values
  • Working with SQL Server 2014 Data Types

    • Introducing SQL Server 2014 Data Types
    • Working with Character Data
    • Working with Date and Time Data
  • Using DML to Modify Data

    • Inserting Data
    • Modifying and Deleting Data
  • Using Built-In Functions

    • Writing Queries with Built-In Functions
    • Using Conversion Functions
    • Using Logical Functions
    • Using Functions to Work with NULL
  • Grouping and Aggregating Data

    • Using Aggregate Functions
    • Using the GROUP BY Clause
    • Filtering Groups with HAVING
  • Using Subqueries

    • Writing Self-Contained Subqueries
    • Writing Correlated Subqueries
    • Using the EXISTS Predicate with Subqueries
  • Using Table Expressions

    • Using Derived Tables
    • Using Common Table Expressions
    • Using Views
    • Using Inline Table-Valued Functions
  • Using Set Operators

    • Writing Queries with the UNION Operator
    • Using EXCEPT and INTERSECT
    • Using APPLY
  • Using Window Ranking, Offset and Aggregate Functions

    • Creating Windows with OVER
    • Exploring Window Functions
  • Pivoting and Grouping Sets

    • Writing Queries with PIVOT and UNPIVOT
    • Working with Grouping Sets
  • Querying data with Stored Procedures

    • Writing Queries with PIVOT and UNPIVOT
    • Passing Parameters to Stored Procedures
    • Creating Simple Stored Procedures
    • Working with Dynamic SQL
  • Programming with T-SQL

    • T-SQL Programming Elements
    • Controlling Program Flow
  • Implementing Error Handling

    • Using TRY / CATCH Blocks
    • Working with Error Information
  • Implementing Transactions

    • Transactions and the Database Engine
    • Controlling Transactions
  • Improving Query Performance

    • Factors in Query Performance
    • Displaying Query Performance Data
  • Querying SQL Server Metadata

    • Querying System Catalog Views and Functions
    • Executing System Stored Procedures
    • Querying Dynamic Management Objects

Duration: 40 Hours

  • Introduction to SQL Server 2014 Database Administration

    • Database Administration Overview
    • Introduction to the SQL Server Platform
    • Database Management Tools and Techniques
  • Installing and Configuring SQL Server 2014

    • Planning SQL Server Installation
    • Installing SQL Server 2014
    • Post-Installation Configuration
  • Working with Databases and Storage

    • Introduction to Data Storage with SQL Server
    • Managing Storage for System Databases
    • Managing Storage for User Databases
    • Moving Database Files
    • Configuring the Buffer Pool Extension
  • Planning and Implementing a Backup Strategy

    • Understanding the Restore Process
    • Restoring Databases
    • Advanced Restore Scenarios
    • Working with Point-in-Time Recovery
  • Importing and Exporting Data

    • Introduction to Transferring Data
    • Importing and Exporting Table Data
    • Copying or Moving a Database
  • Monitoring SQL Server 2014

    • Introduction to Monitoring SQL Server
    • Dynamic Management Views and Functions
    • Performance Monitor
  • Tracing SQL Server Activity

    • Tracing SQL Server Workload Activity
    • Using Traces
  • Managing SQL Server Security

    • Introduction to SQL Server Security
    • Managing Server-Level Security
    • Managing Database-Level Principals
    • Managing Database Permissions
  • Auditing Data Access and Encrypting Data

    • Auditing Data Access in SQL Server
    • Implementing SQL Server Audit
    • Encrypting Databases
  • Performing Ongoing Database Maintenance

    • Ensuring Database Integrity
    • Maintaining Indexes
    • Automating Routine Database Maintenance
  • Automating SQL Server 2014 Management

    • Automating SQL Server Management
    • Implementing SQL Server Agent Jobs
    • Managing SQL Server Agent Jobs
    • Managing Job Step Security Contexts
    • Managing Jobs on Multiple Servers
  • Monitoring SQL Server 2014 by Using Alerts and Notifications

    • Monitoring SQL Server Errors
    • Configuring Database Mail
    • Configuring Operators, Alerts, and Notifications

Duration: 40 Hours

  • Introduction to Data Warehousing

    • Overview of Data Warehousing
    • Considerations for a Data Warehouse Solution
  • Data Warehouse Hardware Considerations

    • Considerations for Building a Data Warehouse
    • Data Warehouse Reference Architectures and Appliances
  • Designing and Implementing a Data Warehouse

    • Logical Design for a Data Warehouse
    • Physical Design for a Data Warehouse
  • Creating an ETL Solution with SSIS

    • Introduction to ETL with SSIS
    • Exploring Source Data
    • Implementing Data Flow
  • Implementing Control Flow in an SSIS Package

    • Introduction to Control Flow
    • Creating Dynamic Packages
    • Using Containers
    • Managing Consistency
  • Debugging and Troubleshooting SSIS Packages

    • Debugging an SSIS Package
    • Logging SSIS Package Events
    • Handling Errors in an SSIS Package
  • Implementing an Incremental ETL Process

    • Introduction to Incremental ETL
    • Extracting Modified Data
    • Loading Modified Data
  • Enforcing Data Quality

    • Introduction to Data Quality
    • Using Data Quality Services to Cleanse Data
    • Using Data Quality Services to Match Data
  • Using Master Data Services

    • Introduction to Master Data Services Concept
    • Implementing a Master Data Services Model
    • Managing Master Data
    • Creating a Master Data Hub
  • Extending SQL Server Integration Services

    • Using Custom Components in SSIS
    • Using Scripts in SSIS
  • Deploying and Configuring SSIS Packages

    • Overview of SSIS Deployment
    • Deploying SSIS Projects
    • Planning SSIS Package Execution
  • Consuming Data in a Data Warehouse

    • Introduction to Business Intelligence
    • Introduction to Reporting
    • Introduction to Data Analysis
Batch Date Course Duration
20 Nov 2017 2 Months
Citrix Authorize Learning Center Microsoft Partner Network Summer Training Training Center Amcat Partner Network
Testimonials
Enquiry Button
x

Fill this form to Enquiry us


       2 + 6   =
L G Y