1.1. SQL Administration
- Mac M1/Apple Silicon – SQL Server Developer – Installation Guide
- SQL | Triggers in SQL Server – Definition, Types, Syntax and Examples
- SQL Collation – How to Change Collation of Table Column
- SQL Error: Login Failed for User – What to do?
- SQL Error: Saving Changes is Not Permitted – Solution with Example
- SQL Indexes – Indexing Theory Simply, Balanced Tree, Heaps
- SQL Server Express 2014 Installation Step by Step
- SQLCMD (Server command line) – Run SQL query via cmd
1.2. SSRS – Reporting Services
- SQL Server – Reporting services 2016 News
- SSRS Tutorial Part 1 – Creating SSRS Project and Report in Reporting Services
- SSRS Tutorial Part 2 – Data Source Configuration in SSRS – Reporting services
- SSRS Tutorial Part 3 – How to Configure Dataset in SSRS – Reporting Services
- SSRS Tutorial Part 4 – Creating Report in SSRS – Reporting Services
- SSRS Tutorial Part 5 – Configuring Parameter for Filter in SSRS – Reporting Services
- SSRS Tutorial Part 6 – How To Deploy Report in SSRS – Reporting Services
1.3. SSIS – Integration Services
- SSIS | Control Flow – Tasks, Containers and Data Flow – Integration Services (Beginners)
- SSIS | Data Flow Task for Beginners – ETL Data Pump Component with Example
- SSIS | Integration Services for Beginners – Introduction, BIDS, Project, Package, SSIS Toolbox
- SSIS Google analytics Data Import into SQL Server Database (using KingswaySoft)
- SSIS Toolbox – List of All Components and Tasks
2. SQL Tutorials
2.1. SQL Basics
- Basic SQL Queries – Overview For Beginners With Examples
- SQL Basics – The Most Commonly Used Statements for Beginners
- SQL FULL JOIN – Joining Tables in SQL With Explanation in Excel
- SQL GROUP BY – Aggregating Data in Table
- SQL HAVING vs WHERE – What’s the difference?
- SQL INNER JOIN – Joining Tables in SQL With Explanation in Excel + Examples
- SQL LEFT OUTER JOIN – Joining tables in SQL With Explanation in Excel
- SQL ORDER BY – Sorting Data in SQL Table in Descending or Ascending Order
- SQL RIGHT OUTER JOIN – Joining Tables in SQL With Explanation in Excel + Example
- SQL SELECT – Selection of Columns From the Table – Basic Clause
- SQL WHERE Clause – Adding a condition using SQL
2.2. Handling SQL Tables
- SQL CREATE TABLE- How to Create a Database Table (SQL Server)
- SQL DELETE TABLE Statement, Difference DELETE and TRUNCATE, Deleting Large Amounts Of Data
- SQL INSERT – Inserting Rows into Database Table (3 methods) + Common mistakes
- SQL MERGE Statement – INSERT, UPDATE, DELETE at once
- SQL TRUNCATE TABLE Command – Don’t use DELETE when you don’t have to
- SQL UPDATE Statement – Syntax and Example of Updating Records
2.3. Clauses
- Basic SQL Queries – Overview For Beginners With Examples
- SQL HAVING vs WHERE – What’s the difference?
- SQL ORDER BY – Sorting Data in SQL Table in Descending or Ascending Order
- SQL SELECT – Selection of Columns From the Table – Basic Clause
- SQL SELECT DISTINCT – Removing Duplicates from Table = Unique values
- SQL WHERE Clause – Adding a condition using SQL
2.4. Operators
- SQL BETWEEN Operator – Defining Range in a Condition with Examples
- SQL EXISTS Operator With Exampes – Existence Test
- SQL IN Operator – Multiple Values In Condition
- SQL LIKE Operator with Examples – Using Wildcards
- SQL UNION Operator – Unification of Sets with Example
2.5. Functions
- SQL Aggregate Functions – SUM, COUNT, MAX, MIN, AVG
- SQL COUNT Function – How to Count Rows In a Table with Examples
- SQL ISNULL and COALESCE Functions – What Are The Differences And Usage
- SQL OFFSET Functions – LAG, LEAD, FIRST_VALUE, LAST_VALUE
- SQL Ranking Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
- SQL REPLACE Function – Replace Text String
- SQL String Functions – Overview of Text Functions in T-SQL
- SQL SUBSTRING Function – Get Part of String With Example
2.6. Commands
- SQL | Triggers in SQL Server – Definition, Types, Syntax and Examples
- SQL CTE (Common Table Expressions) With Examples – More Organized Queries and Procedures
- SQL IF THEN ELSE Command – Do Not Mix Up With CASE
- SQL INSERT – Inserting Rows into Database Table (3 methods) + Common mistakes
- SQL Loop – Do you Know How to Use WHILE or Recursive CTE?
- SQL OVER() with PARTITION BY – Clause for Gourmets With Examples
- SQL Query Logical Processing Order
- SQL ROLLUP, CUBE, GROUPING SETS – Totals and Subtotals
- SQL TRY CATCH and Error Handling with Examples
- SQL UNION ALL – Unification of Queries with Example
2.7. Useful scripts
- Basic SQL Queries – Overview For Beginners With Examples
- SQL OFFSET Functions – LAG, LEAD, FIRST_VALUE, LAST_VALUE
- SQLCMD (Server command line) – Run SQL query via cmd
2.8. XML for SQL Server
3. Power BI
3.1. DAX for Power BI
- Aggregation in DAX – How Aggregations Work? + Function Overview
- DAX | SUM and SUMX – How to Perform Aggregation in DAX Language for Power BI
- DAX Difference Between Measure and Column + Example on Report
- DAX language – Introduction into DAX for Power BI and Powerpivot
- DAX RELATED Function for Power BI – Lookup Into Table
- FILTER Functions for Power BI in DAX – Overview
- Function DAX CALCULATE – Aggregation With a Condition in Power BI
- Parameters in DAX – Introduction into DAX Expressions
3.2. Power BI Desktop
- Power BI Custom Visuals – Additional Visualizations to Power BI Desktop
- Power BI Desktop – Powerful Report Tool Introduction
- Sales Report in Power BI and Direct Query into SQL Database
3.3. Power Pivot
- Getting Started with Power Pivot – Data Modeling in Excel
- How to Enable Power Pivot in Excel
- Power Query, Power Pivot and Power BI – What’s the Difference?
3.4. Power Query
- Connecting to SQL Server | Power Query
- Power BI Refresh Does Not Work – Reason?
- Power BI Report (Dashboard) Tutorial Step By Step
- Power Query – Powerful Tool For Self Service BI – Introduction
- Power Query, Power Pivot and Power BI – What’s the Difference?
3.5. Sample reports in Power BI
- How to Get Started With Power BI + BI Tools for Excel
- Microsoft Power BI – 10 Reasons to Use It
- MS BI Developer Skill Set – List of Knowledge and Abilities
- Power BI Report (Dashboard) Tutorial Step By Step
- Sales Report in Power BI and Direct Query into SQL Database
4. Excel
4.1. Excel Functions
- AND, OR Logical Functions in Excel
- Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
- Excel | Mean (Average) Functions Overview – Types, Formulas, Explanation and Examples
- Excel | Subtotal – 11 Functions in One
- Excel | Text Functions – Top Functions Overview + Examples
- Excel | VLOOKUP vs HLOOKUP – What’s the Difference + Example
- WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?
- Weighted Arithmetic Mean in Excel – SUMPRODUCT
4.2. Excel Tutorials
- Excel Fuzzy Lookup Guide – Comparing 2 Lists with Example
- Excel Import to SQL Server Database via SSMS
- Getting Started with Power Pivot – Data Modeling in Excel
- How to Enable Power Pivot in Excel
- How to Execute SQL Procedure in Excel incl. Parameters with Example
- How to Execute SQL Query in Excel (Office 365)? Tutorial with Examples