SQL Examples

MySQL Tutorials for Business Analyst: How to use Alter, Drop and Rename function in MySQL

Hits: 13 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: How to use Alter, Drop and Rename function in MySQL.   MYSQL – ALTER, DROP, RENAME, MODIFY WHAT IS THE ALTER COMMAND? As the saying goes Change is the only constant With …

MySQL Tutorials for Business Analyst: How to use Auto Increment in MySQL

Hits: 36 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: How to use Auto Increment in MySQL.   MySQL AUTO_INCREMENT with Examples What is auto increment? Auto Increment is a function that operates on numeric data types. It automatically generates sequential numeric values every …

MySQL Tutorials for Business Analyst: MySQL Aggregate Functions Tutorial

Hits: 11 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: MySQL Aggregate Functions Tutorial.   MySQL Aggregate Functions Tutorial : SUM, AVG, MAX, MIN , COUNT, DISTINCT Aggregate Functions are all about Performing  calculations on multiple rows Of a single column …

MySQL Tutorials for Business Analyst: MySQL Regular Expressions

Hits: 19 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: MySQL Regular Expressions.   MySQL Regular Expressions (REGEXP) with Syntax & Examples What are regular expressions? Regular Expressions help search data matching complex criteria.  We looked at wildcards in the previous …

MySQL Tutorials for Business Analyst: MySQL Wildcards Tutorial

Hits: 29 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: MySQL Wildcards Tutorial.   MySQL Wildcards Tutorial: Like, NOT Like, Escape, ( % ), ( _ ) What are wildcards? Wildcards are characters that help search data matching complex criteria. Wildcards …

MySQL Tutorials for Business Analyst: MySQL GROUP BY and HAVING Clause

Hits: 14 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: MySQL GROUP BY and HAVING Clause.   MySQL GROUP BY and HAVING Clause with Examples What is the Group by Clause? The GROUP BY clause is a SQL command that is …

MySQL Tutorials for Business Analyst: ORDER BY in MySQL: DESC and ASC

Hits: 23 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: ORDER BY in MySQL: DESC and ASC.   ORDER BY in MySQL: DESC & ASC Sorting Results Using the SELECT command, results were returned in the same order the records were …

MySQL Tutorials for Business Analyst: MySQL UPDATE Query

Hits: 30 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: MySQL UPDATE Query.   MySQL UPDATE Query with Example What is the UPDATE Query? UPDATE MySQL command is used to modify rows in a table. The update command can be used to …

MySQL Tutorials for Business Analyst: MySQL DELETE Query

Hits: 10 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Tutorials for Business Analyst: MySQL DELETE Query.   MySQL DELETE Query with Example What is the DELETE Query? MySQL DELETE command is used to delete rows that are no longer required from the database tables. It …

MySQL Tutorials for Business Analyst: MySQL INSERT INTO Query: How to add Row in Table

Hits: 11 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL INSERT INTO Query: How to add Row in Table.   MySQL INSERT INTO Query: How to add Row in Table What is INSERT INTO? INSERT INTO is used to store data in the tables. The INSERT command …

MySQL Tutorials for Business Analyst: MySQL WHERE Clause with Examples – AND, OR, IN, NOT IN

Hits: 16 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL WHERE Clause with Examples – AND, OR, IN, NOT IN.   MySQL WHERE Clause with Examples – AND, OR, IN, NOT IN What is the WHERE Clause? We looked at how to query data from …

MySQL Tutorials for Business Analyst: MySQL SELECT Statement with Examples

Hits: 15 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL SELECT Statement with Examples.   MySQL SELECT Statement with Examples What is SELECT query in MySQL? SELECT QUERY is used to fetch the data from the MySQL database. Databases store data for later retrieval. The …

MySQL Tutorials for Business Analyst: MySQL Create Database, Tables, Data Types

Hits: 9 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Create Database, Tables, Data Types.   MySQL Create Database, Tables, Data Types Steps for Create Database Mysql Create Database in two ways 1) By executing a simple SQL query 2) By using forward engineering in …

MySQL Tutorials for Business Analyst: MySQL Workbench Tutorial and MySQL Introduction

Hits: 11 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: MySQL Workbench Tutorial and MySQL Introduction. MySQL Workbench Tutorial & MySQL Introduction What is MySQL? MySQL is an open source relational database. MySQL is cross platform which means it runs on a number of different platforms such as Windows, …

SQL Tutorials for Business Analyst: What is Database and what is SQL?

Hits: 28 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: What is Database and what is SQL?   What is Database? What is SQL? Before we learn about a database, let us understand – What is Data? In simple words, data can be facts related to …