Basics of SQL:
SQL stands for Structured Query Language. It is a language for storing and retrieving information/data from databases. So we can say, SQL as the Standard Database Language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control.
What is a database? Database is a program that helps to store the collection of data. The data is then organized in multiple tables with several different fields. Say for example, a company’s database may include tables such as employee’s list, login details and project details with fields like name, username, password, project name etc.,
If you are a beginner in learning SQL, then this video will be helpful to give you a clear understanding of SQL within 1 hour.
Beginners can learn more about SQL from below websites.
W3schools can be helpful to learn basic understanding of SQL using its online editor.
Khanacademy helps us to learn an interactive talk-through tutorials of SQL.
MySQL is the most popular choice of database for use in web applications. The data in a MySQL database are stored in tables. A table is a collection of related data, and it consists of columns and rows.
MySQL ships with no GUI tools to administer MySQL databases or manage data contained within the databases. Users may use the included command line tools, or install MySQL Workbench via a separate download. Many third party GUI tools are also available.
MySQL Workbench is a visual database design tool. It integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system.
To use this tool, we have to install this MySQL Workbench initially. But prior, check whether you have installed MySQL server. MySql can be installed using WampServer.
If the WampServer download has completed, run the installation file. Once it is installed, you can manually add Apache, Php or MySql versions.
You may see that there are three sections in Workbench. They are SQL Development, Data Modelling and Server Administration.
SQL Development for create and execute SQL Queries.
Data Modelling for designing database models and diagrams from scratch.
Server Administration for monitoring, securing and configuring your servers.