DevsCall
TutorialsBlogAboutContact
HomeTutorialsBlogAboutContact
  • Explore Tutorials
  • Python
  • Coding Interview Prep
  • Machine Learning
  • JavaScript
  • TypeScript
  • Python with Copilot
  • Advanced Web Development
  • SQL
  • Ai Essentials
  • Pandas
  • NumPy
  • Email Meeting Assistant
  • Java in AI Era

Learn SQL Basics

  • SQL Introduction
  • SQL Create Database
  • SQL DROP DATABASE
  • SQL BACKUP DATABASE

SQL Tables

  • SQL CREATE TABLE
  • SQL ALTER TABLE
  • SQL DROP TABLE

SQL Constraints

  • SQL Create Constraints
  • SQL NOT NULL
  • SQL UNIQUE Constraint
  • SQL PRIMARY KEY
  • SQL FOREIGN KEY
  • SQL DEFAULT
  • SQL AUTO INCREMENT

SQL Data Handling

  • SQL INSERT INTO
  • SQL UPDATE
  • SQL DELETE

SQL SELECT and WHERE

  • SQL SELECT
  • SQL SELECT DISTINCT
  • SQL WHERE Clause
  • SQL ORDER BY
  • SQL AND Operator
  • SQL OR Operator
  • SQL NOT Operator
  • SQL TOP

Aggregate Functions

  • SQL Aggregate Functions
  • SQL GROUP BY
  • SQL MIN() and MAX()
  • SQL COUNT()
  • SQL SUM Function
  • SQL AVG()
  • SQL HAVING

Nested Queries

  • SQL Joins
  • SQL EXISTS Operator
  • SQL Correlated Subqueries

Conclusion

  • Wrap Up