CS Learning PortalCS Learning PortalCS Learning Portal
  • Tutorials
  • Practice
  • Problems
  • Interview
  • Articles
  • Store
Sign in

◈ Dashboard⚙ Settings
  • Tutorials
  • Practice
  • Problems
  • Interview
  • Articles
  • Store
/…/SQL
Home/Tutorials/SQL

Tutorial · 35 chapters

SQL

Learn SQL hands-on with MySQL: queries, joins, subqueries, window functions, transactions and the most asked SQL interview questions.

Start learning

Mission log

01Introduction to SQL02Setting Up MySQL03SQL Data Types04CREATE DATABASE & CREATE TABLE05INSERT INTO06SELECT Statement07WHERE Clause08SQL Operators (AND, OR, IN, BETWEEN, LIKE)09NULL Values10ORDER BY & LIMIT11DISTINCT12UPDATE & DELETE13ALTER, DROP & TRUNCATE14SQL Constraints15Aggregate Functions16GROUP BY & HAVING17SQL Joins18INNER JOIN19LEFT, RIGHT & FULL OUTER JOIN20SELF JOIN & CROSS JOIN21UNION & Set Operations22Subqueries23Correlated Subqueries & EXISTS24CASE Expression25String Functions26Date & Time Functions27Views28Indexes29Common Table Expressions (WITH)30Window Functions31Ranking Functions (ROW_NUMBER, RANK, DENSE_RANK)32Transactions in SQL33Stored Procedures & Functions34Triggers35Top SQL Interview Queries
SQL
CS Learning PortalCS Learning Portal

All-in-one platform to learn CS, code online, prepare for interviews and use developer tools.

Learn

  • Tutorials
  • Articles
  • Store

Practice

  • Code Editor
  • Challenges
  • Interview Prep

Legal

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • Refund Policy
  • Delivery Policy

© 2026 CS Learning Portal · All systems nominal

PrivacyTermsContact