English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية
In this tutorial, you will learn how to set up the SQL practice environment.
As you know, SQL is used for communication with databases, so before you start trying SQL, you need to access the database system first.
Learn while using. It is necessary to learn SQL language while using it and to do more experiments. Since SQL language experiments are relatively easy to complete and the results are also intuitive, most people can quickly master SQL language through various experiments.
Note: Web SQL databases allow you to create SQL databases and make SQL calls on the client side. It is based on the popular open-sourceSQLiteEngines. Chrome, Opera, and Safari browsers support Web SQL.
A relational database is a database that is divided into logical units called tables, which are interconnected in the database. Relational databases allow data to be decomposed into logical, smaller, and manageable units, making it easier to maintain and improve performance.
Tables are interconnected through public keys or fields in relational database systems, which is why you can easily connect multiple tables together to use a single query to obtain a combined dataset, even if the required data may exist in multiple tables.
Note: SQL in1986year became the standard of the American National Standards Institute (ANSI), and was1987year became the standard of the International Organization for Standardization (ISO). Nevertheless, most SQL code cannot be fully transferred to different database systems without adjustment.
If the DBMS (database management system) has not been installed on your system, there are several options to choose from. You can install free open-source DBMS.
MySQL is the most popular and widely supported open-source database management system. It is very easy to download and use, and is available for Windows and Linux (or UNIX) operating systems. You can access it from herehttps://dev.mysql.com/downloads/mysql/Free download
You can also install SQL Server Express. It is a free version of Microsoft SQL Server, which can store up to10GB database. You can download it from herehttps://www.microsoft.com/zh-cn/download/details.aspx?id=30438Download the Quick Version.
Additionally, if you plan to develop applications with PHP and MySQL, you can install WampServer or XAMPP. WampServer is a Windows web development environment. It allows you to use Apache2Create web applications with PHP and MySQL databases. It will also provide the MySQL management tool PhpMyAdmin, which allows you to easily manage databases using a web browser. You can download it from herehttp://www.wampserver.com/en/Download.