SQL for Beginners: Start Your Journey (मराठीतून)

Download MySQL workbench, install on Windows 64-bit, launch, set a local instance password, create a database, and run simple SQL statements with semicolons for practice.

Design a bookstore database by creating tables with data types and constraints, including primary keys, auto increment, not null, unique, and foreign keys linking authors, books, and customers.

Learn to insert data into SQL tables (orders, authors, books, customers) using insert into and values, with primary key autoincrement, foreign keys, not null constraints, and date formats.

Learn to use select statements to retrieve data from authors, books, customers, and orders. Practice selecting specific fields such as first name, last name, title, and total amount.

Learn how to update data using the update query syntax, including set and where clauses. Explore updating orders and customer ids and modifying dates with examples.

Learn to delete data in sql using delete from orders with a where clause to remove specific rows, and use truncate table and drop table to manage data and structure.

Learn how to filter data with SQL using select queries, where conditions, and like patterns. Explore ordering results with order by, range filters with greater/less than, and limit top results.

Learn to sort data with order by in SQL, compare ascending and descending orders, and apply filters and limits, then merge results using temporary tables and union all.

Learn to join multiple tables using inner, left, and right joins with on conditions, illustrated by linking customers and orders via the customer_id foreign key.

Explore how to use join types (inner, left, right) and aggregate functions (sum, avg, min, max, count) with group by to analyze orders and customer data.

Explore subqueries in SQL, including exists, correlated subqueries, and in-clauses, using orders and customers tables to compute totals, averages, and filtered results.

Create and apply single-column, composite, unique, and full-text indexes in SQL to optimize queries on the customers table, such as filtering by last name or email.

Master transaction management in SQL by creating accounts, inserting data, and performing updates within a start transaction; commit and rollback on errors to ensure balance integrity.

Learn how to create and use views in SQL, including defining a view from orders and customers, applying joins to show transaction details and total amounts, and securely querying data.