SQL Online Quiz

Here you can find some quizzes that I have prepared. You can test your knowledge

This page this page has no other subpages

T-SQL Online Quiz – For beginners

3. 11. 2019
Ing. Jan Zedníček - Data & Finance
SQL Online Quiz, SQL Tutorials

Today, I prepared for you an SQL quiz for experienced beginners and slightly advanced. Successful completion of the quiz should be routine for a person who uses SQL on...

Číst »

Mac M1/Apple Silicon – SQL Server Developer – Installation Guide
I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience […]
Sales Report in Power BI and Direct Query into SQL Database
Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second […]
AND, OR Logical Functions in Excel
Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out […]
Excel | Subtotal – 11 Functions in One
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, […]
Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may have needed […]

Resources: Power BI News and Blogs a BI Blogs and Magazines – SQL Server, Excel, Reporting

Build a Power BI Paginated Report Online
by Matt Allington on 31. 3. 2023 at 1:34
Back in April 2022, I wrote an article called Poor Man’s Paginated Reports. That article covered an easy way to create a paginated report without […]
Snowflake Temporary Tables vs. Transient Tables
by Additional Articles on 31. 3. 2023 at 0:00
When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we […]
Shrink Database Log Files One by One
by Manie Verster on 31. 3. 2023 at 0:00
Learn how you can shrink your transaction log files serially, one by one. The post Shrink Database Log Files One by One appeared first on […]
Using TOP clause in a SELECT statement
by Additional Articles on 29. 3. 2023 at 0:00
There might be a time when you might want to return just a few rows of a result set, instead of the complete set. This might be useful if you want to […]
Piping, Filtering and Using Flyway Output in PowerShell
by Additional Articles on 29. 3. 2023 at 0:00
Flyway's output is often overwhelmed with verbose messages, most of which we can ignore but some of which provide vital warnings about failed […]
Pin workspaces
on 28. 3. 2023 at 19:03
You can pin your workspaces on top of the list. And unpin them anytime as needed. This functionality enables you to easily navigate to the workspaces […]
MySQL group_concat() function overview
by Rahul Mehta on 28. 3. 2023 at 10:21
This article will provide an understanding of how to effectively use group concatenation in MySQL. Introduction MySQL is an open-source relational […]