What is SQL?
SQL or structured query language is the native language for interacting with databases and is designed for exactly this purpose. It is a language of databases. A database models real-life entities like professors and universities by storing them in tables. Each table contains data from a single entity type. This reduces redundancy by storing entities only once. For example, there only needs to be one row of data containing a certain company's details. Lastly, a database can be used to model the relationship between entities.
-MySQL is a database system used to the web
-MySQL is a database system that runs on a server
-MySQL uses standard SQL
-MySQL is very fast, reliable, and easy to use, easy to database
-MySQL compiles on a number of platforms
-MySQL is ideal for application small or large
-MySQL if free to us download and use
-MySQL is supported by Oracle Corporation
Querying Databases
While SQL can be used to create and modify databases, this tutorial's focus will be on querying databases. A query is a request for data from a database table (or combination of tables). Querying is an essential skill for a data scientist since the data you need for your analyses will often live in databases.
Example
Select Name from Student
In this query, Select and From are called keywords. In SQL, keywords are not case-sensitive, which means you can write the same query as:
Example
The database is useful for storing information categorically
-Staff
-Student
-BookStore
-Customer
Example
Select *from BookStore
Out
| ID | ITEM | QTY | Price |
|---|---|---|---|
| 1 | A | 3 | $4.00 |
| 2 | B | 4 | $6.00 |
Please Watching My Video is Below