Microsoft Sql Server Training Series – 16 Courses
Learn essential SQL Server skills to troubleshoot and optimize queries, ensuring accurate reports and dashboards with this comprehensive training series.
Fixing a bad join is not glamorous work, but it is the kind of work that saves a report, a dashboard, or an entire payroll run. If you have ever written a query where the what is wal in sql server question comes up because you are trying to understand how SQL Server protects data during write operations, you already know the difference between “I think this query should work” and “I know exactly why it works.” That difference is what this Microsoft SQL Server Training Series is built to teach. I built this course to help you move from guessing at results to understanding how SQL Server actually behaves, especially when joins, filters, indexing, security, and reporting all start interacting in real systems.
This is an on-demand training bundle, so you can start immediately and work through the material on your own schedule. The scope is broad on purpose: administration, query writing, database design, data warehousing, reporting, business intelligence, and Power BI. That matters because SQL Server jobs are rarely siloed in the real world. A database analyst may need to tune a query in the morning, troubleshoot permissions after lunch, and verify a report definition before the end of the day. This training gives you the working knowledge to handle those moments without hand-waving.
What This Microsoft SQL Server Training Series Actually Teaches
This series is not a casual overview. It is a practical path through the skills you need to work with Microsoft® SQL Server in real environments. You will learn how to query data correctly, administer databases safely, design schemas that hold up under pressure, and build reporting and business intelligence solutions that business users can trust. The training spans the concepts most organizations still rely on, including SQL Server 2012 through SQL Server 2019-era features and workflows, which is important because many shops run mixed versions rather than a perfectly clean upgrade path.
What makes this different from a shallow introduction is the way the topics connect. Query writing is not isolated from administration. If you do not understand indexing, data types, transaction behavior, and execution logic, your queries will eventually disappoint you. Database administration is not just backups and restores; it is also security, maintenance, recovery strategy, and performance awareness. BI is not just dragging fields into a report; it is understanding where the data came from, whether it is clean, and whether the business can trust the result.
This course is built around that reality. You will move through the major functional areas of SQL Server in a way that mirrors job responsibilities, not textbook chapters. That is the whole point of good sql server training: it should make you more useful on Monday morning, not just more informed on paper.
- Querying and filtering data with T-SQL
- Working with joins, subqueries, aggregates, and conditional logic
- Understanding SQL Server data types and schema decisions
- Administering databases, users, permissions, and recovery tasks
- Designing and supporting data warehouse structures
- Building reporting and business intelligence solutions
- Using modern analysis workflows that connect SQL Server to Power BI
If you have been searching for sql admin training that covers more than the basics, this is the kind of curriculum that helps you make the jump from “I can follow instructions” to “I know what this system is doing and why.”
Why You Need to Understand what is wal in sql server
The phrase what is wal in sql server gets searched for a reason: people want to understand how SQL Server keeps data safe when it is writing changes to disk. WAL stands for write-ahead logging, and it is one of those concepts that quietly shapes almost everything about durability, recovery, and transaction behavior. If you are responsible for databases, you cannot treat that as trivia. You need to know why a committed transaction is protected, how recovery works after a crash, and why SQL Server logs changes before it finalizes them in the data files.
I always tell students that WAL is one of the best examples of how a database engine thinks differently than a human does. A human thinks, “I changed the row, so the job is done.” SQL Server thinks, “I must record the intent and sequence of the change so I can recover correctly if the system stops halfway through.” That distinction matters in backup design, disaster recovery, high-availability planning, and troubleshooting slow or blocked operations.
In this course, you will learn enough about transaction behavior, logging, and recovery concepts to stop treating them like mystery words. That matters whether you work as a database administrator, database developer, support analyst, or data engineer. When a restore takes longer than expected, when a transaction log grows too fast, or when a maintenance plan creates unexpected pressure on the system, you need the mental model behind WAL, not just a definition.
When you understand WAL, you stop seeing the transaction log as a black box and start seeing it as the backbone of recovery and reliability.
That is also why topics like backups, recovery models, and transaction handling belong in a serious Microsoft SQL Server training path. They are not side topics. They are the reason the platform can survive real production use.
Core Query Skills: Joins, Filtering, and the Logic Behind the Output
Most SQL mistakes are not dramatic. They are subtle. A LEFT JOIN returns more rows than expected. A WHERE clause removes the very records you needed to preserve. A GROUP BY changes the shape of the result set in a way that looks “close enough” until finance notices the totals are off by 2%. This is where practical SQL Server training pays off immediately, because good query writing is less about memorizing syntax and more about understanding how the database engine evaluates your request.
In this course, you will work through the logic of querying with T-SQL, including joins, filtering, sorting, aggregation, and conditional expressions. You will see how to think about the order of operations, how to isolate a problem query, and how to spot when a result is technically valid but analytically wrong. That is an important distinction. A query can run without error and still produce misleading business data.
You will also get exposure to sql server data types, which sounds basic until you have a string comparison issue, an implicit conversion problem, or a date filter that silently excludes the wrong records. Data types affect storage, performance, validation, and output. If you do not respect them, the rest of the query work becomes fragile.
- INNER, LEFT, RIGHT, and FULL join behavior
- Filtering with WHERE, HAVING, and nested conditions
- Grouping and summarizing data accurately
- Working with NULL values and avoiding logic traps
- Using CASE expressions for business rules
- Writing queries that are readable and maintainable
If you are taking this as part of sql server training for a new role, this is the part that will save you the most time. You will spend less effort guessing and more effort proving what the query should do before you run it.
Database Administration Skills That Actually Matter on the Job
Good administration is not about making a server look tidy. It is about keeping databases available, recoverable, secure, and performant under actual workload pressure. That is why the administrative side of this series goes beyond checkbox tasks. You will learn the working concepts behind SQL Server management so you can respond intelligently when something breaks, slows down, or needs to be changed in a controlled way.
In real environments, the database administrator is often the person people call when they do not fully understand the problem. A report is slow, and suddenly everyone wants an answer. A login fails. A database fills the disk. A backup job runs but nobody knows whether it is valid. This course prepares you for those moments by teaching you the administration mindset: identify the symptom, narrow the cause, and verify the fix.
That includes understanding server configuration, security basics, backup and restore planning, monitoring, and maintenance. It also includes knowing how SQL Server version latest considerations affect your environment. Even when you are not on the newest version, you need to understand what changes across releases, what stays stable, and what compatibility issues might appear when applications or reports connect to the database.
- Database creation and configuration
- User and role management
- Backup and restore strategy
- Security and permission control
- Performance awareness and troubleshooting
- Routine maintenance and operational hygiene
This is the practical side of sql admin training. It is not glamorous, but it is what keeps systems working, and that makes it valuable.
How the Course Builds Your Development and Data Design Skills
SQL Server development is where structure meets logic. If the database design is sloppy, every downstream task becomes harder: reports are slower, queries become confusing, and application code has to compensate for poor modeling. This course addresses development from the perspective of someone who needs to build and support systems that last, not just tables that exist.
You will learn how schemas, relationships, constraints, and keys work together to protect data integrity. That means understanding when to normalize, when to keep things simple, and how design choices influence everything from indexing to maintenance. A lot of beginners focus on getting data into tables. The more important skill is getting it into the right tables in the right shape.
We also look at transaction handling and error management, which is where the sql server try catch pattern becomes important. In production code, failure is not hypothetical. A foreign key violation, a deadlock, a missing object, or a data conversion error can happen at any time. TRY…CATCH gives you a controlled way to handle those errors, log them, and keep the application from behaving unpredictably. That is not a flashy topic, but it is one of the most practical skills in the course.
- Design tables with the correct data types and constraints
- Use keys and relationships to enforce integrity
- Write procedural logic that behaves predictably
- Handle errors and exceptions responsibly
- Support application logic with clean database structure
If you want to move from writing ad hoc queries into database development, this part of the training will help you think like someone who owns the system, not just uses it.
Data Warehousing, Reporting, and Business Intelligence
A transactional database and a reporting system do not serve the same purpose, and confusing them creates endless pain. Operational systems are built to process day-to-day work quickly. Reporting systems are built to summarize, analyze, and present that work in a useful form. This course explains that difference clearly and gives you the foundation to work with both.
You will learn how data warehousing supports historical analysis, trend reporting, and decision-making. That includes understanding fact and dimension style thinking, organizing data for analytics, and recognizing why warehouse design is different from operational design. If you have ever wondered why a report runs fine at 8 a.m. but struggles at 2 p.m., the answer often lives in the structure of the data and the way the report is querying it.
The business intelligence portion also connects SQL Server to Power BI, which is increasingly important for analysts and technical professionals alike. SQL Server often serves as the source layer for dashboards and interactive reports, so you need to understand the journey from raw data to visualization. If the source query is weak, the report becomes weak. If the warehouse is poorly designed, the report gets slower and less trustworthy.
- Warehouse concepts and analytical modeling
- Source-to-report data flow
- Reporting accuracy and data validation
- Power BI integration concepts
- Business intelligence workflow planning
This section matters to data analysts, BI developers, report writers, and anyone who needs to support decisions with accurate data instead of hopeful assumptions.
Who This Course Is For and What Roles It Supports
This Microsoft SQL Server Training Series is for you if you need practical competence rather than surface familiarity. Some students come in already working in support or development and want to strengthen weak areas. Others are preparing for a new role and need a structured path that does not assume they already know everything. Both groups benefit, because the training is built around actual responsibilities, not just exam-style memorization.
It is especially useful for people in roles that sit close to databases and reporting. That includes database administrators, junior DBAs, data analysts, BI developers, support engineers, application developers, and systems professionals who are expected to understand SQL Server well enough to troubleshoot and communicate clearly.
Career-wise, stronger SQL Server skills can support roles that often fall into a healthy salary range depending on experience, industry, and location. In the United States, database-related roles commonly range from roughly $65,000 to well over $120,000 annually, with senior or specialized positions going higher. The point is not the number alone. The point is that employers pay for people who can protect data, improve performance, and keep reporting accurate.
This training can help you stand out when you need to do one of the following:
- Write better SQL and avoid common query mistakes
- Support SQL Server in a business environment
- Move toward DBA or database developer responsibilities
- Work more confidently with BI and reporting teams
- Prepare for deeper technical interviews involving SQL Server concepts
If you have been looking for sql server training that connects day-to-day work with long-term career growth, this series is built for that purpose.
Recommended Background and How to Get the Most from the Training
You do not need to be an expert to start, but you should be ready to think. Basic familiarity with databases, tables, and simple queries will help you move faster, although the course is designed to build those ideas as well. If you already know some T-SQL, the value comes from tightening your logic and filling in the administrative and architectural gaps that often separate beginners from reliable practitioners.
I recommend that you approach the series in order and practice the ideas as you go. The concepts make more sense when you connect them. For example, learn joins and filtering, then notice how those queries interact with indexes and execution behavior. Learn data types, then watch how they affect conversion and storage. Learn error handling, then think about why production systems need it so badly. That kind of deliberate practice is what turns content into skill.
To get the most from the course, keep a notebook of patterns, not just definitions. Write down the queries that confused you, the mistakes you made, and the reasons the corrected version worked. That habit will help you far more than passive viewing. SQL Server is a system where precision matters, and precision comes from repeated, thoughtful use.
By the time you finish, you should be able to explain core SQL Server behavior, write cleaner T-SQL, support database operations more confidently, and understand where the data is going when it leaves the database and enters a report or dashboard. That is the kind of practical competence this training is meant to build.
Microsoft® and SQL Server are trademarks of Microsoft Corporation. This content is for educational purposes.
Microsoft SQL Server 2019 – Introduction to Data Analysis Course Content
Module 1 – Query Tools
- 1.1 Course Introduction
- 1.2 Intro to Management Studio
- 1.3 Intro to command-line query tools
Module 2 – Introduction to T-SQL Querying
- 2.1 Introducing T-SQL
- 2.2 Understanding Sets
- 2.3 Understanding the Logical Order of Operations in SELECT statements
Module 3 – Basic SELECT Queries
- 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
Module 4 – Querying Multiple Tables
- 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
Module 5 – Sorting and Filtering Data
- 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
Module 6 – Introduction to Business Intelligence and Data Modeling
- 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
Module 7 – Prepare Data
- 7.1 Introduction to Power BI
- 7.2 Get data from various data sources
- 7.3 Preview source data
Module 8 – Clean, Transform, and Load 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
Module 9 – Design a Data Model
- 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
Module 10 – Create Model Calculations using DAX
- 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
Module 11 – Create Reports
- 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
Module 12 – Create Dashboards
- 12.1 Dashboard Basics
- 12.2 Real Time Dashboards
- 12.3 Enhanced Dashboards
Module 13 – Create Paginated Reports
- 13.1 Introduction to Power BI Report Builder
- 13.2 Report Layouts
- 13.3 Report Data
- 13.4 Report Tables
Module 14 – Perform Advanced Analytics
- 14.1 Introduction to Advanced Analytics
- 14.2 Scatter Chart
- 14.3 Forecast
- 14.4 Decomposition Tree
- 14.5 Key Influencers
Module 15 – Create and Manage Workspaces
- 15.1 Introduction to Workspaces
- 15.2 Working with Workspaces and the Portal
Module 16 – Create Power App Visuals
- 16.1 Introduction to Power Apps Visual
- 16.2 Creating the App
- 16.3 Basic Power Apps Concepts
- 16.4 Refreshing the Report
Module 17 – Analysis Services and Power BI
- 17.1 Introduction to Analysis Services
- 17.2 Connecting with Multidimensional Models
- 17.3 Premium Workspaces and Analysis Services
- 17.4 Course Wrap Up
Microsoft SQL Server 2019 – Querying SQL Server Course Content
Module 1 – Query Tools
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Intro to Management Studio
- 1.4 Intro to command-line query tools
Module 2 – Introduction to T-SQL Querying
- 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
Module 3 – Basic SELECT Queries
- 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
Module 4 – Querying Multiple Tables
- 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
Module 5 – Sorting and Filtering Data
- 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
Module 6 – Working with SQL Server Data Types
- 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
Module 7 – Using DML to Modify Data
- 7.1 Module 7 Introduction
- 7.2 Inserting Records with DML
- 7.3 Updating Records Using DML
- 7.4 Deleting Records Using DML
Module 8 – Using Built-In Functions
- 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
Module 9 – Grouping and Aggregating Data
- 9.1 Module 9 Introduction
- 9.2 Using Aggregate Functions
- 9.3 Using the GROUP BY Clause
- 9.4 Filtering Groups with HAVING
Module 10 – Using Subqueries
- 10.1 Module 10 Introduction
- 10.2 Writing Self-Contained Subqueries
- 10.3 Writing Correlated Subqueries
- 10.4 Using the EXISTS Predicate with Subqueries
Module 11 – Using Table Expressions
- 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
Module 12 – Using Set Operators
- 12.1 Module 12 Introduction
- 12.2 Writing Queries with the UNION operator
- 12.3 Using EXCEPT and INTERSECT
- 12.4 Using APPLY
Module 13 – Using Window Ranking, Offset, and Aggregate Functions
- 13.1 Module 13 Introduction
- 13.2 Creating Windows with OVER
- 13.3 Exploring Window Functions
Module 14 – Pivoting and Grouping Sets
- 14.1 Module 14 Introduction
- 14.2 Writing Queries with PIVOT and UNPIVOT
- 14.3 Working with Grouping Sets
Module 15 – Implementing Error Handling
- 15.1 Module Introduction
- 15.2 Implementing T-SQL error handling
- 15.3 Implementing structured exception handling
Module 16 – Managing Transactions
- 16.1 Module 16 Introduction
- 16.2 Transactions and the Database Engine
- 16.3 Controlling Transactions
- 16.4 Course Wrap Up
SQL Server 2019 Database Design Course Content
Module 1 – Designing and Building Tables
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Database Design
- 1.4 Creating Tables
- 1.5 Data Types
- 1.6 Schemas
- 1.7 Altering Tables
Module 2 – Enforcing Data Integrity
- 2.1 Module 2 Introduction
- 2.2 Introduction to Data Integrity
- 2.3 Data Domain Integrity
- 2.4 Implementing Data Domain Integrity
- 2.5 Implementing Entity and Referential Integrity
Module 3 – Indexing
- 3.1 Module 3 Introduction
- 3.2 Core Indexing Concepts
- 3.3 Heaps, Clustered, and Nonclustered Indexes
- 3.4 Data Types and Indexes
- 3.5 Single Column and Composite Indexes
Module 4 – Stored Procedures, Functions, and Triggers
- 4.1 Module 4 Introduction
- 4.2 Introduction to Database Programming
- 4.3 Creating Stored Procedures
- 4.4 Creating User-Defined Functions
- 4.5 Creating Triggers
Module 5 – Blob and Filestream Data
- 5.1 Module 5 Introduction
- 5.2 Introduction to Binary Data
- 5.3 Considerations for BLOB data
- 5.4 FILESTREAM Example
- 5.5 File Table Example
Module 6 – Full-Text Search
- 6.1 Module 6 Introduction
- 6.2 Introduction to Full-Text Search
- 6.3 Full-Text Catalogs
- 6.4 Full-Text Indexes
- 6.5 Full-Text Queries
Module 7 – Azure vs On-Prem
- 7.1 Module 7 Introduction
- 7.2 SQL Server on Azure VM
- 7.3 Azure Managed SQL Instance
- 7.4 Azure SQL Database
- 7.5 Course Wrap Up
Microsoft SQL Server 2019 Analysis Services (SSAS) Course Content
Module 1 – Introduction to Business Intelligence and Data Modeling
- 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
Module 2 – Multidimensional Databases
- 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
Module 3 – Cubes and Dimensions
- 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
Module 4 – Measures and Measure Groups
- 4.1 Module 4 Introduction
- 4.2 Measures
- 4.3 Measure Groups and Relationships
- 4.4 Measure Group Storage
Module 5 – Introduction to MDX
- 5.1 Module 5 Introduction
- 5.2 MDX Fundamentals
- 5.3 Adding Calculations to a Cube
- 5.4 Querying a cube using MDX
Module 6 – Customizing Cube Functionality
- 6.1 Module 6 Introduction
- 6.2 Key Performance Indicators
- 6.3 Actions
- 6.4 Perspectives
- 6.5 Translations
Module 7 – Tabular Data Models
- 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
Module 8 – Data Analysis Expressions (DAX)
- 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
Module 9 – Data Mining
- 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
Introduction to Microsoft Power BI Course Content
Module 1 – Prepare Data
- 1.1 Course Introduction
- 1.2 Module 1 Introduction
- 1.3 Introduction to Power BI
- 1.4 Get data from various data sources
- 1.5 Preview source data
Module 2 – Clean, Transform, and Load Data
- 2.1 Module 2 Introduction
- 2.2 DimEmployee Example
- 2.3 DimEmployeeSalesTerritory Example
- 2.4 DimReseller Example
- 2.5 FactResellersSales Example
- 2.6 ResellerSalesTargets Example
- 2.7 Color Formats Example
Module 3 – Design a Data Model
- 3.1 Module 3 Introduction
- 3.2 Introduction to Data Modeling
- 3.3 Model Relationships
- 3.4 Table Configuration
- 3.5 Model interface
- 3.6 Quick Measures
- 3.7 Many-to-many relationships
- 3.8 Row-level security
Module 4 – Create Model Calculations using DAX
- 4.1 Module 4 Introduction
- 4.2 DAX context
- 4.3 Calculated Tables
- 4.4 Calculated Columns
- 4.5 Managing Date Tables
- 4.6 Measures
- 4.7 Filter Manipulation
- 4.8 Time Intelligence
Module 5 – Create Reports
- 5.1 Module 5 Introduction
- 5.2 Basic Report Creation
- 5.3 Example Page 1
- 5.4 Example Page 2
- 5.5 Example Page 3
- 5.6 Report Publishing
- 5.7 Enhancing Reports
- 5.8 Drill-Through Pages
- 5.9 Conditional Formatting
- 5.10 Buttons and Bookmarks
Module 6 – Create Dashboards
- 6.1 Module 6 Introduction
- 6.2 Dashboard Basics
- 6.3 Real Time Dashboards
- 6.4 Enhanced Dashboards
Module 7 – Create Paginated Reports
- 7.1 Module 7 Introduction
- 7.2 Introduction to Power BI Report Builder
- 7.3 Report Layouts
- 7.4 Report Data
- 7.5 Report Tables
Module 8 – Perform Advanced Analytics
- 8.1 Module 8 Introduction
- 8.2 Introduction to Advanced Analytics
- 8.3 Scatter Chart
- 8.4 Forecast
- 8.5 Decomposition Tree
- 8.6 Key Influencers
Module 9 – Create and Manage Workspaces
- 9.1 Introduction to Workspaces
- 9.2 Working with Workspaces and the Portal
Module 10 – Create Power App Visuals
- 10.1 Module 10 Introduction
- 10.2 Introduction to Power Apps Visual
- 10.3 Creating the App
- 10.4 Basic Power Apps Concepts
- 10.5 Refreshing the Report
Module 11 – Analysis Services and Power BI
- 11.1 Module 11 Introduction
- 11.2 Introduction to Analysis Services
- 11.3 Connecting with Multidimensional Models
- 11.4 Premium Workspaces and Analysis Services
- 11.5 Course Wrap Up
Microsoft SQL Server – Big Data Course Content
Module 1: What are Big Data Clusters?
- 1.1 Introduction
- 1.2 Linux, PolyBase, and Active Directory
- 1.3 Scenarios
Module 2: Big Data Cluster Architecture
- 2.1 Introduction
- 2.2 Docker
- 2.3 Kubernetes
- 2.4 Hadoop and Spark
- 2.5 Components
- 2.6 Endpoints
Module 3: Deployment of Big Data Clusters
- 3.1 Introduction
- 3.2 Install Prerequisites
- 3.3 Deploy Kubernetes
- 3.4 Deploy BDC
- 3.5 Monitor and Verify Deployment
Module 4: Loading and Querying Data in Big Data Clusters
- 4.1 Introduction
- 4.2 HDFS with Curl
- 4.3 Loading Data with T-SQL
- 4.4 Virtualizing Data
- 4.5 Restoring a Database
Module 5: Working with Spark in Big Data Clusters
- 5.1 Introduction
- 5.2 What is Spark
- 5.3 Submitting Spark Jobs
- 5.4 Running Spark Jobs via Notebooks
- 5.5 Transforming CSV
- 5.6 Spark-SQL
- 5.7 Spark to SQL ETL
Module 6: Machine Learning on Big Data Clusters
- 6.1 Introduction
- 6.2 Machine Learning Services
- 6.3 Using MLeap
- 6.4 Using Python
- 6.5 Using R
Module 7: Create and Consume Big Data Cluster Apps
- 7.1 Introduction
- 7.2 Deploying, Running, Consuming, and Monitoring an App
- 7.3 Python Example – Deploy with azdata and Monitoring
- 7.4 R Example – Deploy with VS Code and Consume with Postman
- 7.5 MLeap Example – Create a yaml file
- 7.6 SSIS Example – Implement scheduled execution of a DB backup
Module 8: Maintenance of Big Data Clusters
- 8.1 Introduction
- 8.2 Monitoring
- 8.3 Managing and Automation
- 8.4 Course Wrap Up
Microsoft SQL Server 2019 Administration Course Content
Module 1: Installation
- SQL Admin Intro
- Installation
Module 2: Data Storage
- Introduction to Data Storage with SQL Server
- Managing Storage for System Databases
- Managing Storage for User Databases
- Moving Database Files
Module 3: Data Recover
- 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
Module 4: Monitoring
- 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
Module 5: Security
- 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
Module 6: Maintenance
- Introduction to Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Automating SQL Server Management
- Monitoring SQL Server Errors
- Configuring Database Mai
Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases Course Content
Module 1: Deploy a Microsoft Azure SQL Database
- Introduction
- Introducing the Azure SQL Database Part 1
- Introducing the Azure SQL Database Part 2
- Setting Up Azure Lab
- Chose a Service Tier Part 1
- Chose a Service Tier Part 2
- Create Servers and Databases Part 1
- Creating a Azure SQL Server and Database Lab
- Create Servers and Databases Part 2
- Create Servers and Databases Part 3
- Connecting SSMS to Azure SQL Lab Part 1
- Connecting SSMS to Azure SQL Lab Part 2
- Create a Sysadmin Account
- Creating Azure SQL Logins and Users Lab
- Congure Elastic Pools
- Creating and Conguring an Elastic Pool Lab
Module 2: Plan for SQL Server Installation
- Plan for an IaaS or On-Premises Deployment Part 1
- Plan for an IaaS or On-Premises Deployment Part 2
- Select the Appropriate Size for a Virtual Machine
- Plan Storage Pools Based on Performance Requirements Part 1
- Plan Storage Pools Based on Performance Requirements Part 2
- Evaluate Best Practices for Installation
- Design a Storage Layout for a SQL Server Virtual Machine
Module 3: Deploy SQL Server Instances
- Deploy a SQL Server Instance in IaaS and On-Premises
- Restoring AdventureWorks 2016 Database Lab
- Provision an Azure Virtual Machine to Host a SQL Server Instance
- Provisioning an Azure Virtual Machine to Host a SQL Server Lab
- Manually Install SQL Server on an Azure Virtual Machine
- Installing SQL 2016 Lab Part 1
- Installing SQL 2016 Lab Part 2
- Automate the Deployment of SQL Server Databases
- Exploring Azure SQL Database Automation Lab
- Deploy SQL Server by Using Templates
- Managing JSON Templates Lab
Module 4: Deploy SQL Server Databases to Azure Virtual Machines
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3
- Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4
- Generate Benchmark Data for Performance Needs
- Generating Benchmark Data Lab Part 1
- Generating Benchmark Data Lab Part 2
- Perform Performance Tuning on Azure IaaS
- Perform Performance Tuning on Azure IaaS Lab Part 1
- Perform Performance Tuning on Azure IaaS Lab Part 2
- Support Availability Sets in Azure Part 1
- Support Availability Sets in Azure Part 2
- Manage High Availability Lab Part 1
- Manage High Availability Lab Part 2
- Manage High Availability Lab Part 3
- Manage High Availability Lab Part 4
- Manage High Availability Lab Part 5
Module 5: Configure Secure Access to Microsoft Azure SQL Databases
- Configure Firewall Rules
- Creating Firewall Rules Lab
- Configure Always Encrypted for Azure SQL Database
- Implementing Always Encrypted Lab
- Configure Cell-Level Encryption
- Cell-Level Encryption Lab
- Configure Dynamic Data Masking
- Dynamic Data Masking Lab
- Configure Transparent Data Encryption (TDE)
- Transparent Data Encryption (TDE) Lab
Module 6: Configure SQL Server performance settings
- Configure SQL Performance Settings
- Configuring SQL Performance Settings Lab
- Configure Max Server Memory
- Configuring SQL Memory Lab
- Configure Database Performance Settings
- Configure Database Performance Settings Lab
- Configure Operators and Alerts
- Configure alerts in Azure and On-Premise SQL Server Lab
Module 7: Manage SQL Server instances
- Create Databases
- Creating Databases Lab
- Manage Files and File Groups
- Managing Files and File Groups Lab
- Manage System Database Files
- Manage System Database Files Lab
- Configure tempdb
- Configure tempdb Lab
Module 8: Manage SQL Storage
- Manage SMB File Shares
- Manage SMB File Shares Lab
- Manage Stretch Databases
- Configure Azure Storage
- Change Service Tiers
- Change Service Tiers Lab Part 1
- Review Wait Statistics
- Manage Storage Pools
- Recover from Failed Storage
- Managing Storage Lab Part 1
- Managing Storage Lab Part 2
Module 9: Perform Database Maintenance
- Monitoring Tools
- Using Monitoring Tools Lab Part 1
- Using Monitoring Tools Lab Part 2
- Azure Performance Tuning
- Automate Maintenance Tasks
- Update Statistics and Indexes
- Update Statistics and Indexes Lab Part 1
- Update Statistics and Indexes Lab Part 2
- Verify Database Integrity
- Verify Database Integrity Lab
- Recover from Database Corruption
- Recover from Database Corruption Lab
- Conclusion
Microsoft 70-764 SQL 2016 – Administering a SQL Database Infrastructure Course Content
Module 1: Configure Encryption
- Introduction
- Exam Objectives and Lab Setup
- Restoring AdventureWorks 2016 Database Lab Part 1
- Restoring AdventureWorks 2016 Database Lab Part 2
- Restoring AdventureWorks 2016 Database Lab Part 3
- Configure Encryption
- Cell-Level Encryption Part 1
- Cell-Level Encryption Part 2
- Cell-Level Encryption Lab Part 1
- Cell-Level Encryption Lab Part 2
- Transparent Data Encryption
- Transparent Data Encryption Lab
- Always Encrypted
- Always Encrypted Lab
- Backup Encryption
- Backup Encryption Lab
- Connection Encryption
- Encryption Troubleshooting
Module 2: Configure Data Access and Permissions
- Create and Maintain Users
- Create and Maintain Users Lab Part 1
- Create and Maintain Users Lab Part 2
- Configure and Maintain Custom Roles
- Configure and Maintain Custom Roles Lab
- Manage Database Object Permissions Part 1
- Manage Database Object Permissions Part 2
- Manage Database Object Permissions Lab Part 1
- Manage Database Object Permissions Lab Part 2
- Configure User Options for Azure SQL Database
- Configure Row-Level Security
- Configure Dynamic Data Masking
- Configure Dynamic Data Masking Lab
Module 3: Configure Auditing
- Manage a SQL Server Audit
- Manage a SQL Server Audit Lab
- Query the SQL Server Audit Log
- Manage an Azure SQL Server Audit
Module 4: Develop a Backup Strategy
- Backup Types Part 1
- Backup Types Part 2
- Manage, Backup, and Restore Databases Lab Part 1
- Manage, Backup, and Restore Databases Lab Part 2
- Backup Very Large Databases Part 1
- Backup Very Large Databases Part 2
- Backup Very Large Databases Part 3
- Backup Very Large Databases Part 4
- 4.9 Managing Very Large Databases Lab Part 1
- 4.10 Managing Very Large Databases Lab Part 2
- 4.11 Managing Very Large Databases Lab Part 3
- Configure Alerting for Failed Backups
- Configure Alerting for Failed Backups Lab Part 1
- Configure Alerting for Failed Backups Lab Part 2
- Back up Databases to Azure
- Manage Transaction Log Backups
- Configure Database Recovery Models
- Set Database Recovery Model Lab
- Configure Backup Automation
- Configure Backup Automation Lab
Module 5: Restore Databases
- Perform Piecemeal Restores
- Restore Databases Lab Part 1
- Restore Databases Lab Part 2
- Restore Databases Lab Part 3
- Perform Page Recovery
- Perform Point-in-Time Recovery
- Perform Point-in-Time Recovery Lab
- Restore File Groups
- Develop a Plan to Automate and Test Restores
Module 6: Manage Database Integrity
- Implement Database Consistency Checks
- Implement Database Consistency Checks Lab
- Identify Database Corruption
- Recover From Database Corruption
Module 7: Monitor Database Activity
- Monitor Current Sessions
- Monitor Current Sessions Lab
- Identify Sessions that Cause Blocking Activity
- Identify Sessions that Consume tempdb Resources
- Configure the Data Collector
Module 8: Monitor Queries
- Manage the Query Store
- Manage the Query Store Lab
- Configure Extended Events and Trace Events
- Identify Problematic Execution Plans
Module 9: Manage Indexes
- Identify and Repair Index Fragmentation
- Identify and Create Missing Indexes
- Identify and Drop Underutilized Indexes
- Manage Existing Columnstore Indexes Part 1
- Manage Existing Columnstore Indexes Part 2
- Partitioned Tables
Module 10: Monitor SQL Server Instances
- Create and Manage Operators
- Create and Manage SQL Agent Alerts
- Configure Policy-Based Management
- Configure Policy-Based Management Lab
- Identify Available Space on Data Volumes
- Identify the Cause of- Manage Performance Degradation
- Identify the Cause of- Manage Performance Degradation Lab Part 1
- Identify the Cause of- Manage Performance Degradation Lab Part 2
Module 11: Implement Log Shipping
- Configure and Monitor Log Shipping
- Configure and Monitor Log Shipping Lab Part 1
- Configure and Monitor Log Shipping Lab Part 2
Module 12: Implement Failover Cluster Instances
- Windows Server Failover Cluster
- Manage Shared Disks
- Configure Cluster Shared Volumes
- Configuring WSFC Lab
Module 13: Implement Always On Availability Groups
- Database Mirroring
- Create an Availability Group
- Manage Failover
- Configure Read-Only Routing
- Create Distributed Availability Groups
- Configuring Always On Availability Group Lab Part 1
- Configuring Always On Availability Group Lab Part 2
- Conclusion
Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 Course Content
Module 1: Intro To Business Intelligence
- 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
Module 2: Database Essentials
- 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
Module 3: Business Intelligence Development
- Using SQL Server Data Tools Demo
- Building An IS Integration Services Package Demo
- Loading Data From Remote Sources Demo
Module 4: Business Intelligence Results
- 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
Module 5: Advanced Reporting And Development
- Drill Through Reports
- Data Visualization
- Creating Store Procedure From Scratch
- Memory Optimize Table
Module 6: SQL Server Integration Services (SSIS)
- 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
Module 7: SQL Server 2014 New Features
- Backup Enhancements
- Index Enhancements
- Online DB Enhancements
- BackUp To The Cloud
- Partition Data
Module 8: Course Review And Exam Prep
- BI Review
- SharePoint Overview
- SharePoint Demo
- Exam Prep
- Before You Take The Exam
- Conclusion
Microsoft 70-466: Implementing Data Models and Reports with SQL Server 2012 Course Content
Module 1: Introduction To Business Intelligence And Data Modeling
- 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
Module 2: Implementing Reports The SQL Server Reporting Services
- 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
Module 3: Supporting Self Service Reporting
- Supporting Self Service Reporting Part 1
- Supporting Self Service Reporting Part 2
Module 4: Managing Report Execution And Delivery
- Managing Report Execution And Delivery
- Managing Report Execution
- Subscriptions And Data Alerts
Module 5: Creating Multidimensional Databases
- Creating Multidimensional Databases
- Creating Data Sources And Data Source Views
- Creating And Browsing a Cube
Module 6: Working With Cubes And Dimensions
- Working with Cubes And Dimensions
- Sorting And Grouping Attributes
Module 7: Working With Measures And Measure Groups
- Working With Measures and Measure Groups
Module 8: Introduction To MDX
- Introduction To MDX
- Adding Calculations To A Cube
Module 9: Customizing Cube Functionality
- Customizing Cube Functionality Part 1
- Customizing Cube Functionality Part 2
- Customizing Cube Functionality Part 3
Module 10: Implementing A Tabular Data Model
- Implementing A Tabular Data Model Part 1
- Implementing A Tabular Data Model Part 2
Module 11: Introduction To DAX
- Introduction to DAX
- Demonstration Making A Tabular Model Part 1
- Demonstration Making A Tabular Model Part 2
- Using DAX
Module 12: Implementing An Analysis Services Tabular Data Model
- Implementing An Analysis Services Tabular Data Model Part 1
- Implementing An Analysis Services Tabular Data Model Part 2
- Deploying A Tabular Data Model
Module 13: SQL Analysis Services
- SQL Analysis Services Part 1
- SQL Analysis Services Part 2
Module 14: Creating Data Visualizations With Power View
- Creating Data Visualizations With Power View
Module 15: Supporting Self Service Reporting
- Supporting Self Service Reporting
Module 16: Performing Predictive Analysis With Data Mining
- Performing Predictive Analysis With Data Mining
- Using The Data Mining Wizard
Module 17: Predictive Analytics
- Predictive Analytics Part 1
- Predictive Analytics Part 2
Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012 Course Content
Module 1: Designing A Database Server Infrastructure
- 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
Module 2: Designing A Logical Database Scheme
- 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
Module 3: Designing A Physical Database Implementation
- Designing A Physical Database Implementation-Part1
- Designing A Physical Database Implementation-Part2
- Designing A Physical Database Implementation-Part3
Module 4: Incorporating Data Files Into the Database
- 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
Module 5: Tuning Database Performance
- 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
Module 6: Designing Database Security
- Designing Database Security-Part1
- Designing Database Security-Part2
- Contained Databases
- Protecting Data With Encryption
Module 7: Policy Based Management
- Policy Based Management
- Policy Based Management Demo
Module 8: Monitoring Server Health
- Monitoring Server Health
- Monitoring Server Health Demo
Module 9: Designing Database Backup Solution
- 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
Module 10: Automating Multi Server Maintenance
- Automating Multi Server Maintenance
- Managing Multiple Servers
Module 11: Managing SQL Server With Windows Powershell
- Managing SQL Server WIth Windows Powershell
- Windows Powershell Lab
Module 12: Replicating Data
- Replicating Data-Part1
- Replicating Data-Part2
- Replicating Data-Part3
Module 13: Planning High Availability
- Planning High Availability-Part1
- Planning High Availability-Part2
Module 14: Review of SQL Statements
- Review Of SQL Statements-Part1
- Review Of SQL Statements-Part2
- Review Of SQL Statements-Part3
Module 15: Eleven Rules of Database Design
- Eleven Rules Of Database Design
- Conclusion
Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases Course Content
Module 1: SQL 2012 And The 464 Test
- Introduction
- Intro To SQL Server 2012-Part1
- Intro To SQL Server 2012-Part2
- Management Studio Demo-Part1
- Management Studio Demo-Part2
- Management Studio Demo-Part3
- Other SQL Server Tools
Module 2: Working With Data Types
- Working With Data Types-Part1
- Working With Data Types-Part2
- Working With Data Types-Part3
- Other Data Types
Module 3: Tables
- Tables
- Creating Tables
Module 4: Data Constraints
- Data Constraints-Part1
- Data Constraints-Part2
Module 5: Planning In Indexing
- Planning In Indexing-Part1
- Planning In Indexing-Part2
- Planning In Indexing-Part3
- Planning In Indexing-Part4
Module 6: Table Structures
- Table Structures
- Working With Clustered Indexes
- Clustered Indexes
- Designing Effective Clustered Indexes
Module 7: Improving Performance with Non-Clustered Indexes
- Improving Performance With Non-Clustered Indexes-Part1
- Improving Performance With Non-Clustered Indexes-Part2
- Improving Performance With Non-Clustered Indexes-Part3
Module 8: Using Indexes And Execution Plans
- Using Indexes
- Execution Plans-Part1
- Execution Plans Demo
- Execution Plans-Part2
Module 9: Working with Views
- Working With Views-Part1
- Working With Views-Part2
Module 10: Designing and Implementing Stored Procedures
- Designing And Implementing Stored Procedures-Part1
- Designing And Implementing Stored Procedures-Part2
- Designing And Implementing Stored Procedures-Part3
Module 11: Merging Data and Passing Tables
- Merging Data And Passing Tables-Part1
- Merging Data And Passing Tables-Part2
- Merging Data And Passing Tables-Part3
Module 12: Designing and Implementing User Functions
- Designing And Implementing User Functions
Module 13: Creating Highly Concurrent SQL Server Applications
- Creating Highly Concurrent SQL Server Applications-Part1
- Creating Highly Concurrent SQL Server Applications-Part2
- Creating Highly Concurrent SQL Server Applications-Part3
Module 14: Handling Errors in T-SQL
- Handling Error InT-SQL-Part1
- Handling Error InT-SQL-Part2
Module 15: Triggers
- Triggers
Module 16: Implementing Managed Code
- Implementing Managed Code-Part1
- Implementing Managed Code-Part2
- Implementing Managed Code-Part3
- Implementing Managed Code-Part4
Module 17: Storing XML in SQL
- Storing XML In SQL-Part1
- Storing XML In SQL-Part2
Module 18: Querying XML
- Querying XML-Part1
- Querying XML-Part2
Module 19: Working with the Spatial Data
- Working With Spatial Data-Part1
- Working With Spatial Data-Part2
- Working With Spatial Data-Part3
Module 20: Working With Full-Text Indexes and Queries
- Working With Full-Text Indexes And Queries-Part1
- Working With Full-Text Indexes And Queries-Part2
- Working With Full-Text Indexes And Queries-Part3
Microsoft 70-461: Querying SQL Server 2012 Course Content
Lesson 1: Getting Started with SQL Server 2012
- Course Introduction
Lesson 2: Working with T-SQL
- 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
Lesson 3: Writing SELECT Queries
- Select Statement-Part 1
- Select Statement-Part 2
- Select Statement-Part 3
- Select Statement-Part 4
Lesson 4: Working with SQL Data Types
- 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
Lesson 5: Sorting and Filtering Data
- Sorting Results-Part 1
- Sorting Results-Part 2
- Sorting Results-Part 3
- Sorting Results-Part 4
- Sorting Results-Part 5
- Sorting Results-Part 6
Lesson 6: Querying Data from Multiple Tables
- Tables Part 1
- Tables Part 2
- Tables Part 3
- Tables Part 4
- Tables Part 5
- Tables Part 6
Lesson 7: Modifying Data
- Inserting Data-Part 1
- Inserting Data-Part 2
- Inserting Data-Part 3
- Inserting Data-Part 4
- Inserting Data-Part 5
- Inserting Data-Part 6
Lesson 8: Working with SQL Server Built-in Functions
- Functions
- Parse
- Logical Functions
- Group By
Lesson 9: Programming in T-SQL
- Programming-Part 1
- Programming-Part 2
- Programming-Part 3
- Programming-Part 4
- Programming-Part 5
- Programming-Part 6
Lesson 10: Implementing Stored Procedures
- Storage Procedures-Part 1
- Storage Procedures-Part 2
- Dynamic SQL-Part 1
- Dynamic SQL-Part 2
Lesson 11: Working with Subqueries and Table Expressions
- 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
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
- 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
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
- Pivot
- Grouping Sets
Lesson 14: Managing Error Handling and Transactions
- Error Handling-Part 1
- Error Handling-Part 2
- Manage Transactions-Part 1
- Manage Transactions-Part 2
- Manage Transactions-Part 3
Lesson 15: Querying SQL Server System
- System Databases-Part 1
- System Databases-Part 2
- System Databases-Part 3
- System Databases-Part 4
Lesson 16: Optimizing Query Performance
- Query Planning-Part 1
- Query Planning-Part 2
- Index-Part 1
- Index-Part 2
- Index-Part 3
Microsoft 70-462: Administering SQL Server 2012 Databases Course Content
Lesson 1: Identifying the SQL Server Platform
- Overview
- DataStorage-Part 1
- DataStorage-Part 2
Lesson 2: Deploying SQL Server
- Install-Part 1
- Install-Part 2
Lesson 3: Configuring SQL Server
- Configuring-Part 1
- Configuring-Part 2
- Changing Memory-Part 1
- Changing Memory-Part 2
- Email-Part 1
- Email-Part 2
Lesson 4: Managing Databases in SQL Server 2012
- User Databases-Part 1
- User Databases-Part 2
- User Databases-Part 3
- User Databases-Part 4
- User Databases-Part 5
Lesson 5: Managing SQL Server Security
- Setting Security-Part 1
- Setting Security-Part 2
- Server Roles-Part 1
- Server Roles-Part 2
- Setting Permissions-Part 1
- Setting Permissions-Part 2
Lesson 6: Implementing Advanced Security Settings
- 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
Lesson 7: Applying Encryption and Compression
- Encrypting And Compressing-Part 1
- Encrypting And Compressing-Part 2
- Encrypting And Compressing-Part 3
Lesson 8: Working with Indexes and Log Files
- Functions-Part 1
- Functions-Part 2
- Functions-Part 3
- Functions-Part 4
- Functions-Part 5
- Functions-Part 6
Lesson 9: Working with Backup and Restore
- 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
Lesson 10: Implementing High Availability
- Stored Procedures-Part 1
- Stored Procedures-Part 2
- Stored Procedures-Part 3
- Stored Procedures-Part 4
Lesson 11: Optimizing Server Performance
- 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
Lesson 12: Troubleshooting Issues and Recovering Databases
- Set Operators-Part 1
- Set Operators-Part 2
- Set Operators-Part 3
- Set Operators-Part 4
- Set Operators-Part 5
Lesson 13: Performing Advanced Database Management Tasks
- Managing Database Infrastructures-Part 1
- Managing Database Infrastructures-Part 2
- Managing Database Infrastructures-Part 3
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Course Content
Lesson 1: Introduction to Data Warehouse
- 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
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
- 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
Lesson 3: Creating Fact Tables and ColumnStore Indexes
- 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
Lesson 4: Implementing Data Warehouse in SQL Server 2012
- Implementing Data Warehouse-Part1
- Implementing Data Warehouse-Part2
- Implementing Data Warehouse-Part3
- Implementing Data Warehouse-Part4
Lesson 5: Working with Integration Services
- 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
Lesson 6: Managing Control Flow
- Managing Control Flow-Part1
- Managing Control Flow-Part2
- Managing Control Flow-Part3
- Managing Control Flow-Part4
- Managing Control Flow-Part5
Lesson 7: Working with Dynamic Variables
- 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
Lesson 8: Implementing Data Flow
- Implementing DataFlow-Part1
- Implementing DataFlow-Part2
- Implementing DataFlow-Part3
- Implementing DataFlow-Part4
- Implementing DataFlow-Part5
- Implementing DataFlow-Part6
- Implementing DataFlow-Part7
- Implementing DataFlow-Part8
Lesson 9: Managing Data Flow
- Managing DataFlow-Part1
- Managing DataFlow-Part2
- Managing DataFlow-Part3
- Managing DataFlow-Part4
Lesson 10: Managing SSIS Package Execution
- 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
Lesson 11: Debugging and Troubleshooting
- Debugging And Troubleshooting-Part1
- Debugging And Troubleshooting-Part2
- Debugging And Troubleshooting-Part3
- Debugging And Troubleshooting-Part4
Lesson 12: Deploying Packages
- Deploying Packages-Part1
- Deploying Packages-Part2
- Deploying Packages-Part3
Lesson 13: Securing Packages and Databases
- Securing Packages And Databases-Part1
- Securing Packages And Databases-Part2
Lesson 14: Working with MDS and Windows
- Working With MDS And Windows Azure
This course is included in all of our team and individual training plans. Choose the option that works best for you.
Enroll My Team.
Give your entire team access to this course and our full training library. Includes team dashboards, progress tracking, and group management.
Choose a Plan.
Get unlimited access to this course and our entire library with a monthly, quarterly, annual, or lifetime plan.
Frequently Asked Questions.
What are the key benefits of taking the Microsoft SQL Server Training Series?
This training series is designed to enhance your understanding of SQL Server, focusing on practical skills like fixing complex joins and optimizing queries. By completing these courses, you’ll gain the ability to troubleshoot and correct common issues that can impact reporting and data accuracy.
Additionally, the series covers a broad range of topics from basic query writing to advanced optimization techniques. This comprehensive approach ensures that you’ll develop both foundational knowledge and specialized skills, making you more effective in managing SQL Server databases and improving overall data integrity.
Will this training series help me prepare for specific SQL Server certifications?
While the series is primarily focused on practical skills and real-world troubleshooting, it also aligns well with the knowledge required for various Microsoft SQL Server certifications. Courses cover core concepts like joins, indexing, and query optimization, which are often tested in certification exams.
However, to maximize your exam readiness, it’s recommended to supplement this series with official certification guides and practice exams. This approach ensures you are well-prepared for certification-specific questions and the exam environment.
Is prior experience with SQL Server necessary to benefit from this series?
Some basic familiarity with SQL and database concepts is helpful, but this series is designed to accommodate learners at various levels. Beginners can start with foundational courses that cover core SQL syntax and database principles.
For those with more experience, the series offers advanced topics like query tuning and troubleshooting complex joins. Regardless of your starting point, the courses are structured to build your skills progressively, ensuring you gain practical knowledge applicable to real-world scenarios.
What specific topics related to SQL joins does this training cover?
This training series delves into various types of SQL joins, including inner joins, left joins, right joins, and full outer joins. It emphasizes understanding how each join type affects data retrieval and report accuracy.
Students learn to identify common join issues, such as missing data or duplicated rows, and how to fix them. The courses also explore best practices for writing efficient joins and avoiding common pitfalls that can lead to incorrect query results or poor performance.
How does fixing bad joins improve overall data reporting and analysis?
Fixing bad joins ensures that data retrieved from multiple tables accurately reflects the underlying relationships. Incorrect joins can lead to missing data, duplicate records, or misleading totals, which compromise report integrity.
By mastering join troubleshooting, you’ll be able to deliver more reliable reports, dashboards, and data insights. This skill is critical in environments where precise data analysis impacts business decisions, payroll processing, or regulatory compliance.