Learn What is Database? How to Create and Show Databases using SQL
Learn What is Database? How to Create and Show Databases using SQL. The structured query language is all about databases. Therefore, we must first understand what a database is? The database is a structured set of information or data organized in such a way that a computer program can quickly access, manage and update it. In other words, Database is a collection of one or more tables and the tables contain data "rows" or "records".
The SQL statement to display an existing databases is, "SHOW DATABASES;"
The SQL statement to create a new database is, "CREATE DATABASE school;"
Where "school" is the new database name.
To use a database the SQL statement is again very simple, "USE school;"
Where "school" is an existing database name.
Check out the whole playlist of SQL Tutorials or Individual video from the following links,
SQL Tutorial for Beginners. Introduction to SQL Basics
• SQL Tutorial for Beginners. Introduction t...
1.Learn What is SQL? Introduction to SQL
• Learn What is SQL? Introduction to SQL
2.Learn How to Install MySQL Database Server on Windows Operating System
• Learn How to Install MySQL Database Server...
3.Learn What is Database? How to Create and Show Databases using SQL
• Learn What is Database? How to Create and ...
4.Learn How to Select and Use Existing Database using SQL
• Learn How to Select and Use Existing Datab...
5.Learn How to Delete or Remove Database using SQL
• Learn How to Delete or Remove Database usi...
6.Learn What is Database Table? How to Create a Database Table using SQL?
• Learn What is Database Table? How to Creat...
7.Learn How to Modify or Update Database Table using SQL
• Learn How to Modify or Update Database Tab...
8.Learn How to Delete or Remove Database Table using SQL
• Learn How to Delete or Remove Database Tab...
9.Learn How to Add Data Rows in a Table using SQL
• Learn How to Add Data Rows in a Table usin...
10.Learn How to Use INSERT INTO SELECT Statement in SQL
• Learn How to Use INSERT INTO SELECT Statem...
11.Learn How to Update Data Rows using Update Statement in SQL
• Learn How to Update Data Rows using Update...
12.Learn How to Delete Data Rows using Delete Statement in SQL
• Learn How to Delete Data Rows using Delete...
Subscribe to my channel: / @pntutorialsbypradnyankurnikam