Request Demo

Database Administration Training

Home > Database Administration Training
  • Introduction
  • The Business Intelligence Solution
  • Overview Of Business Intelligence
  • BI And Power Pivot Demo
  • ETL Intro
  • Designing Data Warehouses
  • Design For Speed
  • BI Semantic Model
  • Basic Database Objects Demo
  • Stored Procedures And Triggers Demo
  • Database Clusters Demo
  • SQL Server Management
  • Table Triggers
  • DB Config Options
  • DB Backup
  • DB Files And Restore
  • Using SQL Server Data Tools Demo
  • Building An IS Integration Services Package Demo
  • Loading Data From Remote Sources Demo
  • Report Building Intro Setup Demo
  • Using Report Builder Demo
  • Processing Data From Web Service Demo
  • Reporting From Multiple Tables Demo
  • Report Function And Matrix Demo
  • Interactive Reports Demo
  • Sorting Report Data Demo
  • Drill Through Reports
  • Data Visualization
  • Creating Store Procedure From Scratch
  • Memory Optimize Table
  • Building Our First Integration Project
  • Data Transformation
  • Introduction To Big Data
  • Transformation Using Store Procedure
  • Transformation Using SSIS
  • Building Fact Table Using Store Procedure
  • Building Fact Table Using SSIS
  • Backup Enhancements
  • Index Enhancements
  • Online DB Enhancements
  • BackUp To The Cloud
  • Partition Data
  • BI Review
  • SharePoint Overview
  • SharePoint Demo
  • Exam Prep
  • Before You Take The Exam
  • Conclusion
  • Total Course Video Hours: 19 Hrs 17 Min
  • Total Videos: 47
  • Introduction To Business Intelligence and Data Modeling Part1
  • Introduction To Business Intelligence and Data Modeling Part2
  • The Microsoft Business Intelligence Platform Part 1
  • The Microsoft Business Intelligence Platform Part 2
  • The Microsoft Business Intelligence Platform Part 3
  • The Microsoft Business Intelligence Platform Part 4
  • Implementing Reports the SQL Server Reporting Services Part 1
  • Implementing Reports the SQL Server Reporting Services Part 2
  • Implementing Reports the SQL Server Reporting Services Part 3
  • Implementing Reports the SQL Server Reporting Services Part 4
  • Implementing Reports the SQL Server Reporting Services Part 5
  • Implementing Reports the SQL Server Reporting Services Part 6
  • Implementing Reports the SQL Server Reporting Services Part 7
  • Implementing Reports the SQL Server Reporting Services Part 8
  • Supporting Self Service Reporting Part 1
  • Supporting Self Service Reporting Part 2
  • Managing Report Execution And Delivery
  • Managing Report Execution
  • Subscriptions And Data Alerts
  • Creating Multidimensional Databases
  • Creating Data Sources And Data Source Views
  • Creating And Browsing a Cube
  • Working with Cubes And Dimensions
  • Sorting And Grouping Attributes
  • Working With Measures and Measure Groups
  • Introduction To MDX
  • Adding Calculations To A Cube
  • Customizing Cube Functionality Part 1
  • Customizing Cube Functionality Part 2
  • Customizing Cube Functionality Part 3
  • Implementing A Tabular Data Model Part 1
  • Implementing A Tabular Data Model Part 2
  • Introduction to DAX
  • Demonstration Making A Tabular Model Part 1
  • Demonstration Making A Tabular Model Part 2
  • Using DAX
  • Implementing An Analysis Services Tabular Data Model Part 1
  • Implementing An Analysis Services Tabular Data Model Part 2
  • Deploying A Tabular Data Model
  • SQL Analysis Services Part 1
  • SQL Analysis Services Part 2
  • Creating Data Visualizations With Power View
  • Performing Predictive Analysis With Data Mining
  • Using The Data Mining Wizard
  • Supporting Self Service Reporting
  • Predictive Analytics Part 1
  • Predictive Analytics Part 2
  • Total Course Video Hours: 12 Hrs 46 Min
  • Total Videos: 47
  • Introduction
  • Designing A Database Server Infrastructure-Part1
  • Designing A Database Server Infrastructure-Part2
  • Designing A Database Server Infrastructure-Part3
  • Designing A Database Server Infrastructure-Part4
  • Considerations For Database Server Consolidation
  • Managing Server Resources
  • Designing A Logical Database Scheme-Part1
  • Designing A Logical Database Scheme-Part2
  • Designing A Logical Database Scheme-Part3
  • Designing A Logical Database Scheme-Part4
  • Designing A Logical Database Scheme-Part5
  • Designing A Physical Database Implementation-Part1
  • Designing A Physical Database Implementation-Part2
  • Designing A Physical Database Implementation-Part3
  • Incorporating Data Files Into The Database-Part1
  • Incorporating Data Files Into The Database-Part2
  • Incorporating Data Files Into The Database-Part3
  • Incorporating Data Files Into The Database Demo
  • Searching Data Files
  • Searching Data Files Demo
  • Tuning Database Performance-Part1
  • Tuning Database Performance-Part2
  • Tuning Database Performance-Part3
  • Working With Query Plans-Part1
  • Working With Query Plans-Part2
  • Working With Query Plans-Part3
  • Working With Query Plans-Part4
  • Designing Database Security-Part1
  • Designing Database Security-Part2
  • Contained Databases
  • Protecting Data With Encryption
  • Policy Based Management
  • Policy Based Management Demo
  • Monitoring Server Health
  • Monitoring Server Health Demo
  • Designing Database Backup Solution-Part1
  • Designing Database Backup Solution-Part2
  • Designing Database Backup Solution-Part3
  • Designing Database Backup Solution-Part4
  • Disaster Recovery Plan-Part1
  • Disaster Recovery Plan-Part2
  • Automating Multi Server Maintenance
  • Managing Multiple Servers
  • Managing SQL Server WIth Windows Powershell
  • Windows Powershell Lab
  • Replicating Data-Part1
  • Replicating Data-Part2
  • Replicating Data-Part3
  • Planning High Availability-Part1
  • Planning High Availability-Part2
  • Review Of SQL Statements-Part1
  • Review Of SQL Statements-Part2
  • Review Of SQL Statements-Part3
  • Eleven Rules Of Database Design
  • Conclusion
  • Total Course Video Hours: 10 Hrs 45 Min
  • Total Videos: 56
  • Introduction
  • Introduction To Data Warehouse-Part1
  • Introduction To Data Warehouse-Part2
  • Introduction To Data Warehouse-Part3
  • Introduction To Data Warehouse-Part4
  • Introduction To Data Warehouse-Part5
  • Introduction To Data Warehouse-Part6
  • Creating Dimensions And Changing Granularity Of Dimensions-Part1
  • Creating Dimensions And Changing Granularity Of Dimensions-Part2
  • Creating Dimensions And Changing Granularity Of Dimensions-Part3
  • Creating Dimensions And Changing Granularity Of Dimensions-Part4
  • Creating Dimensions And Changing Granularity Of Dimensions-Part5
  • Creating Dimensions And Changing Granularity Of Dimensions-Part6
  • Creating Fact Tables And Column Store Indexes-Part1
  • Creating Fact Tables And Column Store Indexes-Part2
  • Creating Fact Tables And Column Store Indexes-Part3
  • Creating Fact Tables And Column Store Indexes-Part4
  • Creating Fact Tables And Column Store Indexes-Part5
  • Implementing Data Warehouse-Part1
  • Implementing Data Warehouse-Part2
  • Implementing Data Warehouse-Part3
  • Implementing Data Warehouse-Part4
  • Working With Integration Services-Part1
  • Working With Integration Services-Part2
  • Working With Integration Services-Part3
  • Working With Integration Services-Part4
  • Working With Integration Services-Part5
  • Working With Integration Services-Part6
  • Managing Control Flow-Part1
  • Managing Control Flow-Part2
  • Managing Control Flow-Part3
  • Managing Control Flow-Part4
  • Managing Control Flow-Part5
  • Working With Dynamic Variables-Part1
  • Working With Dynamic Variables-Part2
  • Working With Dynamic Variables-Part3
  • Working With Dynamic Variables-Part4
  • Working With Dynamic Variables-Part5
  • Working With Dynamic Variables-Part6
  • Working With Dynamic Variables-Part7
  • Working With Dynamic Variables-Part8
  • Managing DataFlow-Part1
  • Managing DataFlow-Part2
  • Managing DataFlow-Part3
  • Managing DataFlow-Part4
  • Managing SSIS Package Execution-Part1
  • Managing SSIS Package Execution-Part2
  • Managing SSIS Package Execution-Part3
  • Managing SSIS Package Execution-Part4
  • Managing SSIS Package Execution-Part5
  • Managing SSIS Package Execution-Part6
  • Implementing DataFlow-Part1
  • Implementing DataFlow-Part2
  • Implementing DataFlow-Part3
  • Implementing DataFlow-Part4
  • Implementing DataFlow-Part5
  • Implementing DataFlow-Part6
  • Implementing DataFlow-Part7
  • Implementing DataFlow-Part8
  • Debugging And Troubleshooting-Part1
  • Debugging And Troubleshooting-Part2
  • Debugging And Troubleshooting-Part3
  • Debugging And Troubleshooting-Part4
  • Deploying Packages-Part1
  • Deploying Packages-Part2
  • Deploying Packages-Part3
  • Securing Packages And Databases-Part1
  • Securing Packages And Databases-Part2
  • Working With MDS And Windows Azure
  • Total Course Video Hours: 6 Hrs 55 Min
  • Total Videos: 69
  • Overview
  • DataStorage-Part 1
  • DataStorage-Part 2
  • Install-Part 1
  • Install-Part 2
  • Configuring-Part 1
  • Configuring-Part 2
  • Changing Memory-Part 1
  • Changing Memory-Part 2
  • Email-Part 1
  • Email-Part 2
  • User Databases-Part 1
  • User Databases-Part 2
  • User Databases-Part 3
  • User Databases-Part 4
  • User Databases-Part 5
  • Setting Security-Part 1
  • Setting Security-Part 2
  • Server Roles-Part 1
  • Server Roles-Part 2
  • Setting Permissions-Part 1
  • Setting Permissions-Part 2
  • Querying Data From Multiple Tables-Part 1
  • Querying Data From Multiple Tables-Part 2
  • Querying Data From Multiple Tables-Part 3
  • Querying Data From Multiple Tables-Part 4
  • Querying Data From Multiple Tables-Part 5
  • Encrypting And Compressing-Part 1
  • Encrypting And Compressing-Part 2
  • Encrypting And Compressing-Part 3
  • Functions-Part 1
  • Functions-Part 2
  • Functions-Part 3
  • Functions-Part 4
  • Functions-Part 5
  • Functions-Part 6
  • Managing Backups-Part 1
  • Managing Backups-Part 2
  • Managing Backups-Part 3
  • Managing Backups-Part 4
  • Managing Backups-Part 5
  • Managing Backups-Part 6
  • Managing Backups-Part 7
  • Stored Procedures-Part 1
  • Stored Procedures-Part 2
  • Stored Procedures-Part 3
  • Stored Procedures-Part 4
  • Managing SQL Performance-Part 1
  • Managing SQL Performance-Part 2
  • Managing SQL Performance-Part 3
  • Managing SQL Performance-Part 4
  • Managing SQL Performance-Part 5
  • Managing SQL Performance-Part 6
  • Managing SQL Performance-Part 7
  • Set Operators-Part 1
  • Set Operators-Part 2
  • Set Operators-Part 3
  • Set Operators-Part 4
  • Set Operators-Part 5
  • Managing Database Infrastructures-Part 1
  • Managing Database Infrastructures-Part 2
  • Managing Database Infrastructures-Part 3
  • Total Course Video Hours: 8 Hrs 24 Min
  • Total Videos: 62
  • Course Introduction
  • Creating Queries-Part 1
  • Creating Queries-Part 2
  • Creating Queries-Part 3
  • Creating Queries-Part 4
  • Creating Queries-Part 5
  • Constraints-Part 1
  • Constraints-Part 2
  • Constraints-Part 3
  • Constraints-Part 4
  • Constraints-Part 5
  • Select Statement-Part 1
  • Select Statement-Part 2
  • Select Statement-Part 3
  • Select Statement-Part 4
  • Data Types-Part 1
  • Data Types-Part 2
  • Data Types-Part 3
  • Data Types-Part 4
  • Data Types-Part 5
  • Data Types-Part 6
  • Data Types-Part 7
  • Data Types-Part 8
  • Data Types-Part 9
  • Data Types-Part 10
  • Sorting Results-Part 1
  • Sorting Results-Part 2
  • Sorting Results-Part 3
  • Sorting Results-Part 4
  • Sorting Results-Part 5
  • Sorting Results-Part 6
  • Tables Part 1
  • Tables Part 2
  • Tables Part 3
  • Tables Part 4
  • Tables Part 5
  • Tables Part 6
  • Inserting Data-Part 1
  • Inserting Data-Part 2
  • Inserting Data-Part 3
  • Inserting Data-Part 4
  • Inserting Data-Part 5
  • Inserting Data-Part 6
  • Functions
  • Parse
  • Logical Functions
  • Group By
  • Programming-Part 1
  • Programming-Part 2
  • Programming-Part 3
  • Programming-Part 4
  • Programming-Part 5
  • Programming-Part 6
  • Storage Procedures-Part 1
  • Storage Procedures-Part 2
  • Dynamic SQL-Part 1
  • Dynamic SQL-Part 2
  • Sub-Queries And Table Expressions-Part 1
  • Sub-Queries And Table Expressions-Part 2
  • Sub-Queries And Table Expressions-Part 3
  • Sub-Queries And Table Expressions-Part 4
  • Set Operators-Part 1
  • Set Operators-Part 2
  • Window Functions-Part 1
  • Window Functions-Part 2
  • User Defined Functions-Part 1
  • User Defined Functions-Part 2
  • Advanced Analytical Functions
  • Pivot
  • Grouping Sets
  • Error Handling-Part 1
  • Error Handling-Part 2
  • Manage Transactions-Part 1
  • Manage Transactions-Part 2
  • Manage Transactions-Part 3
  • System Databases-Part 1
  • System Databases-Part 2
  • System Databases-Part 3
  • System Databases-Part 4
  • Query Planning-Part 1
  • Query Planning-Part 2
  • Index-Part 1
  • Index-Part 2
  • Index-Part 3
  • Total Course Video Hours: 12 Hrs 22 Min
  • Total Videos: 84
  • Course Intro
  • Social Media
  • Moblie Access
  • Business Intelligence – Part 1
  • Business Intelligence – Part 2
  • Sharepoint Licensing Overview
  • Organize Info
  • Share Your Insights
  • Minimal Download Strategy
  • Enhances Social and Collaboration Features
  • Enhanced Search
  • Workflow
  • Enterprise Content Management
  • Web Content Management
  • What We Will Cover – Part 1
  • What We Will Cover – Part 2
  • What We Will Cover – Part 3
  • What We Will Cover – Part 4
  • What We Will Cover – Part 5
  • What We Will Cover – Part 6
  • What We Will Cover – Part 7
  • What We Will Cover – Part 8
  • What We Will Cover – Part 9
  • Software Requirements
  • Service and Accounts
  • Physical Architecture
  • Physical Architecture – Traditional Topologies
  • Physical Architecture – Streamlined Topologies
  • Physical Architecture – Search Architectures
  • Physical Architecture – Enterprise Search Architecture
  • Physical Architecture – Multi – Farm
  • Logical Architecture
  • Logical Architecture – Host Names Based Sites
  • Logical Architecture – Path – Based
  • Logical Architecture – Extranet
  • Logical Architecture – Mobile
  • Logical Architecture – Single Farm Deployment
  • Databasis
  • Summary
  • Web Applications and Site Collections Intro
  • Logical Structure and Web Applications
  • Demo
  • Site Collections
  • Demo – Part 1
  • Demo – Part 2
  • Application Pools and Summary
  • Intro
  • Service Applications
  • Demo of Configuring Excel Services
  • Sharepoint Management Shell Demo
  • Summary
  • Intro
  • Site Permissions
  • Terms
  • Demo
  • Authentication Modes
  • O Auth
  • Summary
  • Intro
  • Intro to Search
  • Search Logical Architecture
  • Crawling the Content
  • Conent Processing
  • Analytics Processing Component
  • Summary
  • Intro
  • User Profile Service
  • User Profile Demo
  • Profile Synchronization Goals
  • Profile Synchronization Demo
  • Sync Performance Changes
  • Sync Performance Changes Demo
  • Profile Import Options
  • Intro
  • What To Look For
  • Total Course Video Hours: 7 Hrs 22 Min
  • Total Videos: 75
2021 Integrated IT Training Corp. All rights reserved. All company names or logos are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
Create a Menu