What Will I Learn?
In this video you will learn how to use The max, min, group by, is null and is not null commands on tables created in the MySQL Database. With these commands, you will learn to perform faster and easier operations in the database.
Requirements
Your computer should be one of the following operating systems.
• Windows 32 - 64
• Linux
• MacOS
• The MySQL program is required to run this application.
MySQL download link: https://dev.mysql.com/downloads/mysql/
Difficulty
• Intermediate
Description
The content of this video includes the detailed use of MySQL, a database management system.
You will see a very fast and comfortable operation in the table created in the MySQL program with the commands I will show in this application.
With this application, you will find the highest and lowest value from the numeric information in the table. With this application, you will see a combination of the information in the table with the same name. With this application, you will find the missing information in the table and find the complete information.
Commands I Use
• Max: Finds the highest value in the column shown.
• Min: Finds the lowest value in the column shown.
• Group by: Makes a single column of information with the same name in the table.
• Is null: Returns the null rows in the column shown in the table.
• Is not null: Returns the rows that are full in the column shown in the table.
Video Tutorial - English Language - 720p
Curriculum
• Creating a database with MySQL, connecting to a database, creating a table (TR)
• The “update” and “delete” functions in the database with MySQL (TR)
• “Alter” and “drop” functions that provide structural changes to the database with MySQL (TR)
• Primary key assignment to tables in the database with MySQL, primary key properties (TR)
• Relationship of three tables with foreign key function in MySQL database (TR)
• Create an application using with As, In , Like, Limit and Sum commands on the MySQL database (ENG)
Posted on Utopian.io - Rewarding Open Source Contributors