SQL for Beginners

MySQL Tutorials for Business Analyst: How to use Unions in MySQL

Hits: 10 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: How to use Unions in MySQL.   MySQL UNION – Complete Tutorial What is a union? Unions combine the results from multiple SELECT queries into a consolidated result set. The only requirements for this to work …

MySQL Tutorials for Business Analyst: How to use Joins in MySQL

Hits: 13 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: How to use Joins in MySQL.   MySQL JOINS Tutorial: INNER, OUTER, LEFT, RIGHT, CROSS What are JOINS? Joins help retrieving data from two or more database tables. The tables are mutually related using primary and …

MySQL Tutorials for Business Analyst: How to use Sub-Queries in MySQL

Hits: 14 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: How to use Sub-Queries in MySQL.   MySQL SubQuery Tutorial with Examples What are sub queries? A sub query is a select query that is contained inside another query. The inner select query is usually used …

MySQL Tutorials for Business Analyst: How to use Limit keyword in MySQL

Hits: 9 (SQL examples for Beginners) In this end-to-end example, you will learn – SQL Tutorials for Business Analyst: How to use Limit keyword in MySQL.   MySQL LIMIT & OFFSET with Examples What is the LIMIT keyword? The limit keyword is used to limit the number of rows returned in a  query result. It …

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: 35 (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: 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 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: 27 (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: 13 (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: 15 (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: 22 (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: 15 (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: 12 (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 …