Request Demo

SQL Server

Home > SQL Server
  • SQL Admin Intro
  • Installation
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Intro to Data Recovery
  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using SSMS For Backup
  • Understanding the Restore Process
  • How to Restore a Database
  • Using SSMS For Restore
  • T-SQL Backup and Restore
  • Advanced Restore Scenarios
  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Server Reports
  • System Performance Monitor
  • Tracing SQL Server Workload Activity
  • Extended Events
  • Database Tuning Advisor
  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Security
  • Row Level Security (RLS) Using Policies
  • Database Security Tools
  • Contained Database
  • Auditing Data Access in SQL Server
  • Implementing Transparent Data Encryption
  • Introduction to Maintenance
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Automating SQL Server Management
  • Monitoring SQL Server Errors
  • Configuring Database Mai
  • Total Course Video Hours: 6 Hrs 24 Min
  • Total Videos: 41
  • 1.1 Course Introduction
  • 1.2 Module 1 Introduction
  • 1.3 Introduction to Business Intelligence
  • 1.4 The Microsoft Business Intelligence Platform
  • 1.5 Exploring a Data Warehouse
  • 1.6 Exploring a Data Model
  • 2.1 Module 2 Introduction
  • 2.2 Introduction to Multidimensional Analysis
  • 2.3 Overview of Cube Security
  • 2.4 Creating and Configuring a Cube
  • 2.5 Data Sources
  • 2.6 Data Source Views
  • 2.7 Adding a Dimension to a Cube
  • 3.1 Module 3 Introduction
  • 3.2 Dimensions
  • 3.3 Attribute Hierarchies and Relationships
  • 3.4 Sorting and Grouping Attributes
  • 3.5 Slowly Changing Dimensions
  • 4.1 Module 4 Introduction
  • 4.2 Measures
  • 4.3 Measure Groups and Relationships
  • 4.4 Measure Group Storage
  • 5.1 Module 5 Introduction
  • 5.2 MDX Fundamentals
  • 5.3 Adding Calculations to a Cube
  • 5.4 Querying a cube using MDX
  • 6.1 Module 6 Introduction
  • 6.2 Key Performance Indicators
  • 6.3 Actions
  • 6.4 Perspectives
  • 6.5 Translations
  • 7.1 Module 7 Introduction
  • 7.2 Introduction to Tabular Data Models
  • 7.3 Creating a Tabular Data Model
  • 7.4 Configure Relationships and Attributes
  • 7.5 Configuring Data Model for an Enterprise BI Solution
  • 8.1 Module 8 Introduction
  • 8.2 DAX Fundamentals
  • 8.3 Calculated Columns
  • 8.4 Relationships
  • 8.5 Measures
  • 8.6 Time Intelligence
  • 8.7 KPI
  • 8.8 Parent – Child Hierarchies
  • 9.1 Module 9 Introduction
  • 9.2 Overview of Data Mining
  • 9.3 Custom Data Mining Solutions
  • 9.4 Validating a Data Mining Model
  • 9.5 Consuming a Data Mining Model
  • 9.6 Course Wrap Up
  • Total Course Video Hours: 8 Hrs 56 Min
  • Total Videos: 50
  • 1.1 Course Introduction
  • 1.2 Module 1 Introduction
  • 1.3 Intro to Management Studio
  • 1.4 Intro to command-line query tools
  • 2.1 Module 2 Introduction
  • 2.2 Introducing T-SQL
  • 2.3 Understanding Sets
  • 2.4 Understanding the Logical Order of Operations in SELECT statements
  • 3.1 Module 3 Introduction
  • 3.2 Writing Simple SELECT Statements
  • 3.3 Eliminate Duplicates with DISTINCT
  • 3.4 Using Column and Table Aliases
  • 3.5 Write Simple CASE Expressions
  • 4.1 Module 4 Introduction
  • 4.2 Understanding Joins
  • 4.3 Querying with Inner Joins
  • 4.4 Querying with Outer Joins
  • 4.5 Querying with Cross Joins and Self Joins
  • 5.1 Module 5 Introduction
  • 5.2 Sorting Data
  • 5.3 Filtering Data with Predicates
  • 5.4 Filtering with the TOP and OFFSET-FETCH
  • 5.5 Working with Unknown Values
  • 6.1 Module 6 Introduction
  • 6.2 Writing Queries that return Date and Time Data
  • 6.3 Writing Queries that use Date and Time Functions
  • 6.4 Writing Queries that return Character Data
  • 6.5 Writing Queries that use Character Functions
  • 7.1 Module 7 Introduction
  • 7.2 Inserting Records with DML
  • 7.3 Updating Records Using DML
  • 7.4 Deleting Records Using DML
  • 8.1 Module 8 Introduction
  • 8.2 Writing Queries with Built-In Functions
  • 8.3 Using Conversion Functions
  • 8.4 Using Logical Functions
  • 8.5 Using Functions to Work with NULL
  • 9.1 Module 9 Introduction
  • 9.2 Using Aggregate Functions
  • 9.3 Using the GROUP BY Clause
  • 9.4 Filtering Groups with HAVING
  • 10.1 Module 10 Introduction
  • 10.2 Writing Self-Contained Subqueries
  • 10.3 Writing Correlated Subqueries
  • 10.4 Using the EXISTS Predicate with Subqueries
  • 11.1 Module 11 Introduction
  • 11.2 Using Views
  • 11.3 Using Inline Table-Valued Functions
  • 11.4 Using Derived Tables
  • 11.5 Using Common Table Expressions
  • 12.1 Module 12 Introduction
  • 12.2 Writing Queries with the UNION operator
  • 12.3 Using EXCEPT and INTERSECT
  • 12.4 Using APPLY
  • 13.1 Module 13 Introduction
  • 13.2 Creating Windows with OVER
  • 13.3 Exploring Window Functions
  • 14.1 Module 14 Introduction
  • 14.2 Writing Queries with PIVOT and UNPIVOT
  • 14.3 Working with Grouping Sets
  • 15.1 Module Introduction
  • 15.2 Implementing T-SQL error handling
  • 15.3 Implementing structured exception handling
  • 16.1 Module 16 Introduction
  • 16.2 Transactions and the Database Engine
  • 16.3 Controlling Transactions
  • 16.4 Course Wrap Up
  • Total Course Video Hours: 10 Hrs 5 Min
  • Total Videos: 67
  • 1.1 Course Introduction
  • 1.2 Intro to Management Studio
  • 1.3 Intro to command-line query tools
  • 2.1 Introducing T-SQL
  • 2.2 Understanding Sets
  • 2.3 Understanding the Logical Order of Operations in SELECT statements
  • 3.1 Writing Simple SELECT Statements
  • 3.2 Eliminate Duplicates with DISTINCT
  • 3.3 Using Column and Table Aliases
  • 3.4 Write Simple CASE Expressions
  • 4.1 Understanding Joins
  • 4.2 Querying with Inner Joins
  • 4.3 Querying with Outer Joins
  • 4.4 Querying with Cross Joins and Self Joins
  • 5.1 Sorting Data
  • 5.2 Filtering Data with Predicates
  • 5.3 Filtering with the TOP and OFFSET-FETCH
  • 5.4 Working with Unknown Values
  • 6.1 Introduction to Business Intelligence
  • 6.2 The Microsoft Business Intelligence Platform
  • 6.3 Exploring a Data Warehouse
  • 6.4 Exploring a Data Model
  • 7.1 Introduction to Power BI
  • 7.2 Get data from various data sources
  • 7.3 Preview source data
  • 8.1 Data Transformation Intro
  • 8.2 Transformation Example 1
  • 8.3 Transformation Example 2
  • 8.4 Transformation Example 3
  • 8.5 Transformation Example 4
  • 8.6 Transformation Example 5
  • 8.7 Transformation Example 6
  • 9.1 Introduction to Data Modeling
  • 9.2 Model Relationships
  • 9.3 Table Configuration
  • 9.4 Model interface
  • 9.5 Quick Measures
  • 9.6 Many-to-many relationships
  • 9.7 Row-level security
  • 10.1 DAX context
  • 10.2 Calculated Tables
  • 10.3 Calculated Columns
  • 10.4 Managing Date Tables
  • 10.5 Measures
  • 10.6 Filter Manipulation
  • 10.7 Time Intelligence
  • 11.1 Basic Report Creation
  • 11.2 Example Page 1
  • 11.3 Example Page 2
  • 11.4 Example Page 3
  • 11.5 Report Publishing
  • 11.6 Enhancing Reports
  • 11.7 Drill-Through Pages
  • 11.8 Conditional Formatting
  • 11.9 Buttons and Bookmarks
  • 12.1 Dashboard Basics
  • 12.2 Real Time Dashboards
  • 12.3 Enhanced Dashboards
  • 13.1 Introduction to Power BI Report Builder
  • 13.2 Report Layouts
  • 13.3 Report Data
  • 13.4 Report Tables
  • 14.1 Introduction to Advanced Analytics
  • 14.2 Scatter Chart
  • 14.3 Forecast
  • 14.4 Decomposition Tree
  • 14.5 Key Influencers
  • 15.1 Introduction to Workspaces
  • 15.2 Working with Workspaces and the Portal
  • 16.1 Introduction to Power Apps Visual
  • 16.2 Creating the App
  • 16.3 Basic Power Apps Concepts
  • 16.4 Refreshing the Report
  • 17.1 Introduction to Analysis Services
  • 17.2 Connecting with Multidimensional Models
  • 17.3 Premium Workspaces and Analysis Services
  • 17.4 Course Wrap Up
  • Total Course Video Hours: 13 Hrs 58 Min
  • Total Videos: 77
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