#Learn SQL Basics with QueryPie

Exciting news! QueryPie (ver. 5.2.0) has added SQL Tutorial content users can explore while logged in as Guest, with sample connections and queries.

Here's a quick overview of how it works!

1. Download QueryPie

You can download the Standard version of QueryPie for free on our website. We support Windows/Mac/Linux environments, so please choose to make sure you have the correct download file. You can also check available data sources and system requirement below:


💻 2. Install QueryPie

After downloading the installation file, you can run the application. As soon as QueryPie launches, you will see the message on the bottom left corner: Hello Guest!👋

To begin exploring the tutorial, click ‘[MySQL] Sample Connection’ on the right side of the main screen.

📑 3. See Query Directories

Once you connect to the sample database, you can see the default Queries Directory on the right side. To view the queries, double click on a sample query from the Query Directory.

🙌 4. Run the query and view the results!

Click 'SQL Run' and check out the results.

These are just some of the useful features QueryPie has to offer:

  • Convenient Object Information Panel and Data Filtering
  • Multiple SQL Query Execution
  • Auto-Complete and Copy SQL
  • SQL History

But you can't add a new connection or import/export in guest mode.
So if you're enjoying QueryPie, please make sure to sign up here(click)!

📣 Check out all our Tutorials:

1. Learn SQL SELECT/FROM/WHERE (Click to see tutorial!)
2. Learn SQL ORDER BY (Click to see tutorial!)
3. Learn SQL AND/OR/IN (Click to see tutorial!)
4. Learn Using SQL LIKE (Click to see tutorial!)
5. Learn SQL AS/DISTINCT/IS NULL (Click to see tutorial!)
6. Learn SQL COUNT/SUM (Click to see tutorial!)
7. Learn SQL AVG/MIN/MAX (Click to see tutorial!)
8. Learn SQL GROUP BY/HAVING (Click to see tutorial!)
9. Learn SQL CASE (Click to see tutorial!)
10. Learn SQL INNER JOIN (Click to see tutorial!)
11. Learn SQL LEFT / RIGHT JOIN (Click to see tutorial!)
12. Learn SQL Subquery (Click to see tutorial!)
13. Learn SQL DATE_FORMAT, DATEDIFF (Click to see tutorial!)
14. Learn String Functions in SQL — CONCAT, LENGTH, SUBSTR (Click to see tutorial!)
15. Learn Numeric SQL functions — TRUNCATE, ROUND, MOD (Click to see tutorial!)
16. Learn Advanced CASE queries! (Click to see tutorial!)
17. Learn Advanced JOIN queries! (Click to see tutorial!)