In this segment, Professor Ramanathan will demonstrate the MySQL Workbench commands and tools that are used to create the schema and tables.
You should be able to install the MySQL Workbench on your machines. Please follow the installation instructions provided in the installation guides attached below.
Note that 32-bit installation is available for Windows. Irrespective of your system architecture (whether it is 32/64 bit), please install the 32-bit version.
So, after installing SQL on your machine and learning about the basic components and terms associated with SQL, you will next learn more about the entire set of commands that are available in SQL. So, let’s watch the upcoming video and learn about it from our expert.
So, the commands available in SQL can be broadly categorised as follows:
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
DDL, as the name suggests, is used to create a new schema as well as modify an existing schema. The typical commands available in DDL include CREATE, ALTER and DROP. Now, as a data analyst, the majority of your work will focus on insight generation, and you will be working with DML commands, specifically, the SELECT command. In the next segment, Professor Ramanathan will discuss this in detail.
For macOS, users can find installation instructions here.
Now, try attempting the question given below and see if you can recall the types of statements that are used in SQL.
in the next segment, you will see the demonstration of the DDL statements.