Curated Video
Microsoft SQL Server Development for Everyone - Deleting Data from the Table Using an SQL Script
This video explains how to delete data from the table using an SQL script. This clip is from the chapter "Manipulating Tables and Data" of the series "Microsoft SQL Server Development for Everyone".This section explains how to manipulate...
Curated Video
Microsoft SQL Server Development for Everyone - Connecting to a Database Instance and Creating a Database
This video explains how to connect to a database instance and create a database. This clip is from the chapter "Manipulating Tables and Data" of the series "Microsoft SQL Server Development for Everyone".This section explains how to...
Packt
Microsoft SQL Server Development for Everyone - Download and Install SQL Server Express 2017
This video demonstrates how to download and install SQL Server Express 2017 • Step 1: Install Microsoft® SQL Server® 2017 Express • Microsoft® SQL Server® 2017 Express is a powerful and reliable free data management system that delivers...
Curated Video
Learning Microsoft Power BI - Creating a DAX Measures Table
In this video, we will learn about the benefits and creation of a DAX Measures table. • Understand the benefits of organizing measures in a separate table • Create a new DAX measures table • Move existing measures from the data table...
Curated Video
Learning Microsoft Power BI - Report View Walkthrough
In this video, we will learn about the design, form, and function of the report view. • Learn about the characteristics of Power BI, compared to other tools • Learn about the various sections of the report layout • Learn about the...
Curated Video
Learning Microsoft Power BI - Translating Report Requirements into DAX Measures
In this video, we will learn how to translate project requirements into calculations needed for a data model. • Learn how to break down project requirements into the needed DAX measures • Understand the types of basic DAX measures that...
Curated Video
Learning Microsoft Power BI - Table Types and Relational Data Modeling
In this video, we will learn some crucial concepts about data modeling and table types in data models. • Understand why we did not import a single table • Understand the advantages of using multiple tables in our data models • Identify...
Curated Video
Microsoft SQL Server Development for Everyone - Running Queries on Related Tables (Inner Join)
This video explains how to run queries on related tables using the inner join clause. This clip is from the chapter "Relationships and Foreign Keys" of the series "Microsoft SQL Server Development for Everyone".This section presents an...
Curated Video
Microsoft SQL Server Development for Everyone - Dropping or Removing a Database
This video explains how to drop or remove a database. This clip is from the chapter "Manipulating Tables and Data" of the series "Microsoft SQL Server Development for Everyone".This section explains how to manipulate tables and data.
Curated Video
Learning Microsoft Power BI - Setting Up Scheduled Refreshes
In this video, we will learn how to set up scheduled refreshes using a data gateway. • Understand the benefits of having scheduled refreshes • Install a data gateway on your computer • Set up a scheduled refresh on the Power BI Service...
Curated Video
Learning Microsoft Power BI - Formatting and Report Design
In this video, we will learn best practices and techniques for designing effective reports. • Learn the three important techniques for designing and formatting a report • Change the color theme and add a report background • Add objects...
Curated Video
Learning Microsoft Power BI - Referencing DAX Measures
In this video, we will learn about the DAX quick measures tool in Power BI. • Understand the benefits of creating a new measure with the quick measures tool • Understand the risks involved with the same • Create a new DAX calculation...
Curated Video
Learning Microsoft Power BI - Creating Basic DAX Measures
In this video, we will learn how to write basic DAX measures. • Understand how DAX calculates based on column or table references • Create your first set of DAX measures • Learn how DAX measures can reference each other This clip is from...
Curated Video
Learning Microsoft Power BI - DAX Concepts and Fundamentals
In this video, we will learn important fundamentals of DAX, including what it is and what it’s used for. • Understand that DAX exists in multiple tools, not just Power BI • Learn how DAX formulas work compared to Excel formulas •...
Curated Video
Learning Microsoft Power BI - Adding New Columns with Power Query
We are going to learn three common ways of adding and modifying columns. • Get introduced to Add Columns, Merge Columns, and Modify Columns • Open your query editor • Apply the steps This clip is from the chapter "Common Data...
Curated Video
Microsoft SQL Server Development for Everyone - Database Scripting, Backup, and Restoring
This video sheds light on database scripting, backup, and restoring. This clip is from the chapter "Advanced SQL Server Objects and Concepts" of the series "Microsoft SQL Server Development for Everyone".null
Curated Video
Learning Microsoft Power BI - Intelligent Data Filtering with Power Query
In this video, we will learn how to apply data filtering. • Understand why we should filter data • Apply data transformations to the FACTSales table • Filter the data using Power Query This clip is from the chapter "Common Data...
Curated Video
Learning Microsoft Power BI - Reviewing Project Requirements and Determining Data Sources
In this video, we are going to review project requirements and determine data sources. • Learn how to take a given set of requirements • Understand what finalizing the requirements by multiple refinement and review iterations means •...
Curated Video
Microsoft SQL Server Development for Everyone - Creating and Managing Views
This video explains how to create and manage views. This clip is from the chapter "Advanced SQL Server Objects and Concepts" of the series "Microsoft SQL Server Development for Everyone".null
Curated Video
Microsoft SQL Server Development for Everyone - SQL SUM Aggregate Function
This video explains the SQL SUM aggregate function. This clip is from the chapter "GROUP BY and Aggregate Functions" of the series "Microsoft SQL Server Development for Everyone".This section presents an introduction to the GROUP BY and...
Curated Video
Microsoft SQL Server Development for Everyone - Selecting Data from the Table Using an SQL Script
This video explains how to select data from the table using an SQL script. This clip is from the chapter "Manipulating Tables and Data" of the series "Microsoft SQL Server Development for Everyone".This section explains how to manipulate...
Curated Video
Learning Microsoft Power BI - Creating Visualizations-Card Visualizations and Title Section
In this video, we will explore the top title section of the report and see what types of information should be displayed there. • Add a title and image to the report • Understand what types of information should be displayed on card...
Curated Video
Learning Microsoft Power BI - Connecting to (Almost) Any Data Source with Power Query
In this video, we will learn how to connect to any data source with the help of Power Query. • Look at the various types of data connections we can make with the help of Power Query • Understand how to connect to data present on premises...
Curated Video
Job-Ready SQL in an Afternoon - NTiles
In this video, we will cover NTiles. This clip is from the chapter "Window Functions" of the series "Job-Ready SQL in an Afternoon".In this section, we will cover Window functions.