On The HeidiSQL For The Windows Using AVG-FIRST DATA-LAST DATA-COUNT-LIMIT Commands Application

On The HeidiSQL For The Windows Using AVG-FIRST DATA-LAST DATA-COUNT-LIMIT Commands Application

HeidiSQL is an open source database.

HeidiSQL stores and manage your datas.

What Will I Learn?

• In this video, we will learn how to switch between data table query views in HeidiSQL application.
• We will learn how to write and display queries on HeidiSQL
• We will learn what is the AVG commands and how can we use it on the database HeidiSQL.
• Also we will learn what is the LIMIT Commands and how can we use it on HeidiSQL.
• We will learn how can we take our first data on our tables which tables i want.
• We will learn how can we take our last data on our tables which tables i want.
• Also we will learn what is the COUNT commands and how can i use it on the database HeidiSQL.
• Also we will learn using the condition with commands.

Requirements

• We should have to HeidiSQL program. HeidiSQL is an open source application. You can click here and download it.
• Also we should have WampServer for the connect to MySql. WampServer is an open source application and you can click here for the download wampserver.
• Windows 32-64

Difficulty

• Intermediate

Description

HeidiSQL is an open source application. We can use it for the stores our datas. Also we can use it for the manage our datas. You can download it on the Requirements Parts.

We can connect MySql and manage our datas on the HeidiSQL. You can download it on the Requirements Parts.

We can display our tables which one i want.

We can average our areas which one is i want.

We can take our first data on the determine tables.

Also we can display last data on the determine tables.

We can use condition on our commands. We can display which one i want.

We can count our datas which one i want on the HeidiSQL

We can create a new area for the display our results.

Commands I Use

AVG I use for the average datas

LIMIT-FIRSTI use for the take our first data

LIMIT-LAST I use for the take our last data

COUNT I use for the count our datas

Video Tutorial

Curriculum

• Create DataBase,Create Table, Stores data,Delete Table on HeidiSQL
  
• SELECT-ORDER BY-UPDATE-DELETE Commands on HeidiSQL
  
• LIMIT-LIKE-IN-BETWEEN Commands on HeidiSQL
  
• INNER JOIN- LEFT JOIN-RIGHT JOIN Commands on HeidiSQL
  
• UNION-INSERT INTO SELECT-ALTER ADD-ALTER DROP Commands on HeidiSQL
  
• CREATE VIEW-SELECT VIEW-DROP VIEW-INDEX Commands on HeidiSQL
  

GitHub Address Of Application

---

Posted on Utopian.io - Rewarding Open Source Contributors

---