SQL - Zero to Hero Series Intro

There are 4126 courses on Udemy, with the title - Zero to Hero :-)

Don't go by the funny naming, these courses often proved to be the best value addition to the time spent.

Hey everyone, I am Pradyum and this series will be all you need to review SQL anytime in the future.

SQL is a fundamental skill if you want to do anything related to Data and AI.

A typical SQL environment looks like this -

Database schema and SQL queries play a key role in making data-driven decisions for each org vertical (sales, marketing etc)

There are three major types of SQL statements that can be written -

1. DDL (Data Definition Language), Defines the database. CREATE, ALTER, DROP
2. DML (Data Manipulation Language), Loads the database. INSERT, DELETE, UPDATE, SELECT (Includes group by, order by etc)
3. DCL (Data Control Language), Controls the database. GRANT, ADD, REVOKE

DDL is used for physical design and maintenance

DML is used for implementation of the database

DCL is used for implementation & maintenance of the database

That's all for the introduction! Thanks for reading.

Additional -