Description
In this course, you will learn:
- Understanding why databases are used.
- How to write SQL queries to insert, update and delete data into database.
- How to write SQL queries to manipulate data.
- How to write complex SQL queries to obtain useful information from the database
You will first begin the course with the basic introduction about databases and understand what exactly are databases and why they are used. Then you will learn how to install the required tools which will allow you to create your own databases and add data into it.
Moving along, you will learn some SQL operators, and learn how these operators can be used in SQL queries which allows you to form more complex queries. Further you will learn how SQL statements can be used to insert, update and delete data into the database. Once it is done, you will move forward to learn about joins and learn what are different types of joins.