SQL Fundamentals

Course Process

Part 1Introduction to SQL

Lecture 1Types of Databases

Lecture 2SQL Commands

Lecture 3MYSQL Data Types

Lecture 4SQL Server Data Types

Lecture 5MYSQL Setup

Part 2SQL Statements

Lecture 6SHOW Database MYSQL

Lecture 7CREATE Statement on MYSQL

Lecture 8INSERT Statement MYSQL

Lecture 9UPDATE Statement MYSQL

Lecture 10DELETE STATEMENT MYSQL

Lecture 11SELECT Statement MYSQL

Part 3SQL Clauses

Lecture 12WHERE clause MYSQL

Lecture 13DISTINCT Clause MYSQL

Lecture 14ORDER BY Clause MYSQL

Lecture 15GROUP BY Clause MYSQL

Lecture 16HAVING Clause MYSQL

Part 4SQL Operators

Lecture 17LIKE Operator in MYSQL

Lecture 18BETWEEN Operator in MYSQL

Lecture 19SQL Operators

Lecture 20IN Operator MYSQL

Part 5Aggregate Functions

Lecture 21MIN and MAX Function

Lecture 22COUNT Function

Lecture 23AVERAGE Function

Lecture 24SUM Function

Lecture 25INNER Join

Lecture 26LEFT Join

Lecture 27RIGHT Join

Lecture 28SELF Join

SHOW Database MYSQL

To start working with your database you will have to login to database either using mysql workbench or command line CMD

Once successfully logged in, let us list down the all databases

Syntax:

show databases

Query:

show databases

Output:

As you see above, we have listed all the database names with a simple SQL command.

Tester Usage Tips:

Validate different databases of your applications available on database server
Validate the size and other properties of the specific databases

Previous Part Next Part

/home/b0eee662nkt0/public_html/wp-content/plugins/goodlayers-lms/single-course-content.php