Browse Library

SQL Server Training & Certification

SQL Server Training & Certification

4.3 8197 views Duration :5 Days hrs Level : Intemediate
Last Updated: 2022-06-23 05:06:44 English Delivery Format: Live Training
Live Training
$630 per participant

It Includes

  • 5 Days training program
  • Live Virtual Training
  • Learn on any PC/Mobile/Tablet
  • Unlimited Doubt Sessions
  • Online Labs (if applicable)
  • Official Courseware & Kits
  • Get Recording after session
  • Get Certificate of Completion
  • Mock Tests & Exam Preps

What you'll learn?

  • Standardization
  • Perform Data Mining
  • Manage Humongous Amounts Of Data
  • Client-Server Access
  • Quick Access To Data
  • Data Manipulation
  • Combine Data From Multiple Sources
  • Simple Troubleshooting

Course Overview

COURSE OBJECTIVE

SQL server training is meant for candidates who want to gain an edge over freshers. The training consists of necessary lab work and practices to help freshers turn into IT professionals. Learnfly SQL Server Training & Certifications includes time devoted to hands-on lab practice sessions and DBA Internship classes. This is done to ensure that participants get practical exposure so that they can be prepared for the job.

Course Outline

  • Course 10985: Introduction To SQL Databases

    • Module 1: Introduction to databases
    • Module 2: Data Modelling
    • Module 3: Normalization
    • Module 4: Relationships
    • Module 5: Performance
    • Module 6: Database Objects

  • Course 10986: Upgrading Your Skills To SQL 2016

    • Module 1: Introduction to SQL Server 2016
    • Module 2: What’s New in SQL Server Performance
    • Module 3: What’s New in SQL Server Security?
    • Module 4: What’s New in SQL Server Availability and Scalability?
    • Module 5: What’s New in SQL Server Reporting and BI
    • Module 6: What’s New in SQL Server Data Access?
    • Module 7: New and Enhanced Features in SQL Server OLAP
    • Module 8: What’s New for SQL Server in the Cloud?

  • Course 20761: Querying Data with Transact-SQL

    • 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 Set Operators

  • Course 20767: Implementing a SQL Data Warehouse

    • Introduction to Data Warehousing
    • Planning Data Warehouse Infrastructure
    • Designing and Implementing a Data Warehouse
    • Columnstore Indexes
    • Implementing an Azure SQL Data Warehouse
    • Creating an ETL Solution
    • Implementing Control Flow in an SSIS Package
    • Debugging and Troubleshooting SSIS Packages
    • Implementing an Incremental ETL Process
    • Enforcing Data Quality
    • Using Master Data Services
    • Extending SQL Server Integration Services (SSIS)
    • Deploying and Configuring SSIS Packages
    • Consuming Data in a Data Warehouse

  • Course 20768 : Developing SQL Data Models

    • Introduction to Business Intelligence and Data Modeling
    • Creating Multidimensional Databases
    • Working with Cubes and Dimensions
    • Working with Measures and Measure Groups
    • Introduction to MDX
    • Customizing Cube Functionality
    • Implementing a Tabular Data Model by Using Analysis Services
    • Introduction to Data Analysis Expression (DAX)
    • Performing Predictive Analysis with Data Mining

  • Course 10990A: Analyzing Data with SQL Server Reporting Services

    • Introduction to Business Intelligence and Data Modelling
    • Reporting Services Data
    • Implementing reports
    • Creating a Map Report
    • Creating Mobile Reports

  • Course 20762: Developing SQL Databases

    • Introduction to Database Development
    • Designing and Implementing Tables
    • Advanced Table Designs
    • Ensuring Data Integrity through Constraints
    • Introduction to Indexes
    • Designing Optimized Index Strategies
    • Columnstore 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
    • Working with SQL Server Spatial Data
    • Storing and Querying Blobs and Text Documents in SQL Server

  • Course 10989: Analyzing Data with Power BI

    • Introduction to Self-Service BI Solutions
    • Introducing Power BI
    • Power BI Data
    • Shaping and Combining Data
    • Modelling Data
    • Interactive Data Visualizations

  • Course 20764: Administering a SQL Database Infrastructure

    • Authenticating and Authorizing Users
    • Assigning Server and Database Roles
    • Authorizing Users to Access Resources
    • Protecting Data with Encryption and Auditing
    • SQL Server Recovery Models
    • Backup of SQL Server Databases
    • Restoring SQL Server 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
    • Monitoring SQL Server
    • Troubleshooting SQL Server
    • Importing and Exporting Data

  • Course 10987: Performance Tuning and Optimizing SQL Databases

    • SQL Server Architecture, Scheduling, and Waits
    • SQL Server I/O
    • Database Structures
    • SQL Server Memory
    • Concurrency and Transactions
    • Statistics and Index Internals
    • Query Execution and Query Plan Analysis
    • Plan Caching and Recompilation
    • Extended Events
    • Monitoring, Tracing, and Baselining
    • Troubleshooting Common Performance Issues

  • Course 20765: Provisioning SQL Databases

    • SQL Server 2016 Components
    • Installing SQL Server 2016
    • Upgrading SQL Server to SQL Server 2016
    • Deploying SQL Server on Microsoft Azure
    • Working with Databases
    • Database Storage Options
    • Performing Database Maintenance

  • Course 20767: Implementing a SQL Data Warehouse

    • Introduction to Data Warehousing
    • Planning Data Warehouse Infrastructure
    • Designing and Implementing a Data Warehouse
    • Columnstore Indexes
    • Implementing an Azure SQL Data Warehouse
    • Creating an ETL Solution
    • Implementing Control Flow in an SSIS Package
    • Debugging and Troubleshooting SSIS Packages
    • Implementing an Incremental ETL Process
    • Enforcing Data Quality
    • Using Master Data Services
    • Extending SQL Server Integration Services (SSIS)
    • Deploying and Configuring SSIS Packages
    • Consuming Data in a Data Warehouse

  • Course 20768 : Developing SQL Data Models

    • Introduction to Business Intelligence and Data Modeling
    • Creating Multidimensional Databases
    • Working with Cubes and Dimensions
    • Working with Measures and Measure Groups
    • Introduction to MDX
    • Customizing Cube Functionality
    • Implementing a Tabular Data Model by Using Analysis Services
    • Introduction to Data Analysis Expression (DAX)
    • Performing Predictive Analysis with Data Mining

  • Course 20768 : Developing SQL Data Models

    • Introduction to Business Intelligence and Data Modeling
    • Creating Multidimensional Databases
    • Working with Cubes and Dimensions
    • Working with Measures and Measure Groups
    • Introduction to MDX
    • Customizing Cube Functionality
    • Implementing a Tabular Data Model by Using Analysis Services
    • Introduction to Data Analysis Expression (DAX)
    • Performing Predictive Analysis with Data Mining

  • Course 20762: Developing SQL Databases

    • Introduction to Database Development
    • Designing and Implementing Tables
    • Advanced Table Designs
    • Ensuring Data Integrity through Constraints
    • Introduction to Indexes
    • Designing Optimized Index Strategies
    • Columnstore 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
    • Working with SQL Server Spatial Data
    • Storing and Querying Blobs and Text Documents in SQL Server

  • Querying Data with Transact SQL

    • Module 1: Introduction to Microsoft SQL Server 2016
    • Module 2: Introduction to T‐SQL Querying
    • Module 3: Writing SELECT Queries
    • Module 4: Querying Multiple Tables
    • Module 5: Sorting and Filtering Data
    • Module 6: Working with SQL Server 2016 Data Types
    • Module 7: Using DML to Modify Data
    • Module 8: Using Built‐In Functions
    • Module 9: Grouping and Aggregating Data
    • Module 10: Using Subqueries
    • Module 11: Using Set Operators

  • Course 20461: Querying Microsoft SQL Server 2014

    • Introduction to Microsoft SQL Server
    • Introduction to TSQL Querying
    • Writing SELECT Queries
    • Querying Multiple Tables
    • Sorting and Filtering Data
    • Working with SQL Server Data Types
    • Using DML to Modify Data
    • Using BuiltIn Functions
    • Grouping and Aggregating Data
    • Using Subqueries
    • Using Table Expressions
    • Using Set Operators
    • Executing Stored Procedures
    • Programming with TSQL
    • Implementing Error Handling

  • Course 20462: Administering Microsoft SQL Server 2014 Databases

    • Introduction to SQL Server Database Administration
    • Installing and Configuring SQL Server
    • Working with Databases and Storage
    • Planning and Implementing a Backup Strategy
    • Restoring SQL Server Databases
    • Importing and Exporting Data
    • Monitoring SQL Server
    • Tracing SQL Server Activity
    • Managing SQL Server Security
    • Auditing Data Access and Encrypting Data
    • Automating SQL Server Management
    • Monitoring SQL Server with Notifications and Alerts

  • Course 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

    • Introduction to Data Warehousing
    • Planning Data Warehouse Infrastructure
    • 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 a Data Extraction Solution
    • Loading Data into a Data Warehouse
    • Enforcing Data Quality
    • Master Data Services
    • Extending SQL Server Integration Services
    • Deploying and Configuring SSIS Packages
    • Consuming Data in a Data Warehouse

  • Course 20464: Developing Microsoft SQL Server 2014 Databases

    • An Introduction to Database Development
    • Designing and Implementing Tables
    • Ensuring Data Integrity through Constraints
    • Introduction to Indexes
    • Advanced Indexing
    • In Memory Database Capabilities
    • 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
    • Working with Spatial Data in SQL Server
    • Incorporating Data Files into Databases

  • Course 20465: Designing a Data Solution with Microsoft SQL Server

    • Introduction to Enterprise Data Architecture
    • Multi-Server Configuration Management
    • Consolidating Database Workloads with SQL Server 2014
    • Introduction to Cloud Data Solutions
    • Introduction to Windows Azure
    • Windows Azure SQL Database
    • SQL Server in Windows Azure Virtual Machines
    • Introduction to High Availability in SQL Server 2014
    • Clustering with Windows Server and SQL Server 2014
    • AlwaysOn Availability Groups
    • Planning High Availability and Disas ter Recovery
    • Replicating Data

  • Course 20466: Implementing Data Models and Reports with Microsoft SQL Server 2014

    • Introduction to Business Intelligence and Data Modeling
    • Creating Multidimensional Databases
    • Working with Cubes and Dimensions
    • Working with Measures and Measure Groups
    • Introduction to MDX
    • Enhancing a Cube
    • Implementing an Analysis Services Tabular Data Model
    • Introduction to DAX
    • Implementing Reports with SQL Server Reporting Services
    • Enhancing Reports with SQL Server Reporting Services
    • Managing Report Execution and Delivery
    • Delivering BI with SharePoint PerformancePoint Services
    • Performing Predictive Analysis with Data Mining

  • Course 20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2014

    • Planning a BI Solution
    • Planning BI Infrastructure
    • Designing a Data Warehouse
    • Designing an ETL solution
    • Designing Analytical Data Models
    • Planning a BI Delivery Solution
    • Designing a Reporting Services Solution
    • Designing an Excel Based reporting Solution
    • Planning a SharePoint Server BI Solution
    • Monitoring and Optimizing a BI Solution
    • Operating a BI Solution

  • Course 10977: Updating Your SQL Server Skills to Microsoft SQL Server 2014

    • Introduction to SQL Server 2014
    • What’s New in SQL Server Database Development
    • In-Memory Database Capabilities
    • Scripting SQL Server 2014
    • Implementing Security in Microsoft SQL Server 2014
    • High Availability and Data Recovery Enhancements
    • New and Enhanced Features in SQL Server Integration Services
    • Data Quality Services
    • Master Data Services
    • SQL Server 2014 Reporting Services
    • Implementing an Analysis Services Tabular Data Model
    • Self-Service BI with Microsoft Excel
    • Introduction to Cloud Data Solutions
    • Windows Azure SQL Database
    • SQL Server in Windows Azure Virtual Machines
    • Implementing Big Data Solutions

  • Course 20461: Querying Microsoft SQL Server 2014

    • Introduction to Microsoft SQL Server
    • Introduction to TSQL Querying
    • Writing SELECT Queries
    • Querying Multiple Tables
    • Sorting and Filtering Data
    • Working with SQL Server Data Types
    • Using DML to Modify Data
    • Using BuiltIn Functions
    • Grouping and Aggregating Data
    • Using Subqueries
    • Using Table Expressions
    • Using Set Operators
    • Executing Stored Procedures
    • Programming with TSQL
    • Implementing Error Handling

  • Course 20461: Querying Microsoft SQL Server 2014

    • Introduction to Microsoft SQL Server
    • Introduction to TSQL Querying
    • Writing SELECT Queries
    • Querying Multiple Tables
    • Sorting and Filtering Data
    • Working with SQL Server Data Types
    • Using DML to Modify Data
    • Using BuiltIn Functions
    • Grouping and Aggregating Data
    • Using Subqueries
    • Using Table Expressions
    • Using Set Operators
    • Executing Stored Procedures
    • Programming with TSQL
    • Implementing Error Handling

  • Course 20462: Administering Microsoft SQL Server 2014 Databases

    • Introduction to SQL Server Database Administration
    • Installing and Configuring SQL Server
    • Working with Databases and Storage
    • Planning and Implementing a Backup Strategy
    • Restoring SQL Server Databases
    • Importing and Exporting Data
    • Monitoring SQL Server
    • Tracing SQL Server Activity
    • Managing SQL Server Security
    • Auditing Data Access and Encrypting Data
    • Automating SQL Server Management
    • Monitoring SQL Server with Notifications and Alerts

  • Course 55144: SQL Server 2014 Performance Tuning and Optimization

    • Course Overview
    • SQL 2014 Architecture
    • The Database Engine
    • SQL Performance Tools
    • Query Optimizing and Operators
    • Understanding Indexes
    • Understanding Statistics
    • In-Memory Database
    • SQL Profiler and SQL Trace
    • Query Issues and Hints

FAQs

  • What is the difference both 1-on-1 Public and 1-on-1 Private.?

    In both, you choose the schedule. In public, other participants can join, Private other participants want to join.
  • Is this website Secure?

    Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
  • Is my information secure?

    We use the best standards in Internet security. Any data retained is not shared with third parties.
  • Once I made my payment online, can I cancel it?

    You can request a refund if you do not wish to enroll in the course.
  • What types of credit cards are accepted?

    We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
  • Do you offer corporate training?

    Yes, we do offer corporate training
  • Are weekend classes available?

    Yes, we also offer weekend classes.
  • What payment options are available?

    You can pay through debit/credit card or bank wire transfer.
  • Can I request for a demo class before Registering?

    Yes you can request your customer experience manager for the same.
Need Help Finding The Right Training Solution?
Our training advisors are here for you.

More in Tech & IT

$630
Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Create New Password
Enter your email address and we'll send you a link to reset your password.