Skip to Content
Home └SQL
SQL

SQL

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

Private Course
Please sign in to contact responsible
Responsible gavireddy hruthik
Last Update 28/04/2025
Completion Time 17 hours 21 minutes
Members 3
Advanced
  • SQL-FULL COURSE
    80Lessons · 17 hrs 21 mins
    • SQL - Part 1 - Database Concepts (Database, DBMS, Data Models, RDBMS and SQL)
    • SQL - Part 2 - Practice SQL without installing any Software
    • SQL - Part 3 - Select Command
    • SQL - Part 4 - distinct keyword
    • SQL - Part 5 - SQL is not case sensitive
    • SQL - Part 6 - Semicolon
    • SQL - Part 7 - Where Clause
      New
    • SQL - Part 8 - Using Relational Operators in Where Clause Condition
      New
    • SQL - Part 9 - Using Logical Operators (AND, OR, NOT)
      New
    • SQL - Part 10 - Between Operator
      New
    • SQL - Part 11 - Order By Clause (ASC, DESC)
      New
    • SQL - Part 12 - Using Between Operator with Text
      New
    • SQL - Part 13 - In Operator
      New
    • SQL - Part 14 - Like Operator and Wildcard Characters
      New
    • SQL - Part 15 - Aliases for Table Column Names AS Keyword
      New
    • SQL - Part 16 - Limit Keyword
      New
    • SQL - Part 17 - Breaking the Lengthy SQL Statement into multiple lines
      New
    • SQL - Part 18 - MySQL Built in Functions
      New
    • SQL - Part 19 - upper() MySQL String Function
      New
    • SQL - Part 20 - lower() MySQL String Function
      New
    • SQL - Part 21 - length() MySQL String Function
      New
    • SQL - Part 22 - instr() MySQL String Function
      New
    • SQL - Part 23 - substr() MySQL String Function
      New
    • SQL - Part 24 - concat() MySQL String Function
      New
    • SQL - Part 25 - trim() MySQL String Function
      New
    • SQL - Part 26 - abs() MySQL Numeric Function
      New
    • SQL - Part 27 - mod() MySQL Numeric Function
      New
    • SQL - Part 28 - greatest() and least() MySQL Numeric Functions
      New
    • SQL - Part 29 - truncate() MySQL Numeric Function
      New
    • SQL - Part 30 - power() and sqrt() MySQL Numeric Functions
      New
    • SQL - Part 31 - current_date(), curdate(), current_time(), curtime(), now() & sysdate()
      New
    • SQL - Part 32 - year(),month(),day(),monthname(),dayname() MySQL Date Time Functions
      New
    • SQL - Part 33 - avg(), max(), min(), count() and sum() MySQL Aggregate Functions
      New
    • SQL - Part 34 - Arithmetic Operators
      New
    • SQL - Part 35 - Installing MySQL Server and Workbench Client for Practising SQL
      New
    • SQL - Part 36 - Creating, Deleting, viewing and using Databases
      New
    • SQL - Part 37 - Creating, Viewing, Describing and Deleting Tables
      New
    • SQL - Part 38 - Insert Into Statements (For inserting data into Tables)
      New
    • SQL - Part 39 - Data Types
      New
    • SQL - Part 40 - Null Value, Is Null Operator and Is Not Null Operator
      New
    • SQL - Part 41 - Delete Statement (For Deleting the Records from Table)
      New
    • SQL - Part 42 - Update Statement and Set Keyword (For Updating the Table Records)
      New
    • SQL - Part 43 - Rename statement and To Keyword (For Renaming Table Name)
      New
    • SQL - Part 44 - Alter Statement, Add, Modify Column, Rename Column, and Drop Column
      New
    • SQL - Part 45 - Set Autocommit
      New
    • SQL - Part 46 - Commit Statement
      New
    • SQL - Part 47 - Rollback Statement
      New
    • SQL - Part 48 - Truncate Statement
      New
    • SQL - Part 49 - Single Line and Multi Line Comments
      New
    • SQL - Part 50 - Group By Clause
      New
    • SQL - Part 51 - Having Clause
      New
    • SQL - Part 52 - Sequence of using where, group by, having and order by clauses
      New
    • SQL - Part 53 - Set Operators
      New
    • SQL - Part 54 - Union Operator
      New
    • SQL - Part 55 - Union All Operator
      New
    • SQL - Part 56 - Intersect Operator
      New
    • SQL - Part 57 - Minus Operator
      New
    • SQL - Part 58 - Tables and Aliases
      New
    • SQL - Part 59 - Joins (Inner Join, Left Join, Right Join, Full Join and Self Join)
      New
    • SQL - Part 60 - Sub Query (Single Row Sub Query explained by solving different problems)
      New
    • SQL - Part 61 - In Operator
      New
    • SQL - Part 62 - Using In Operator with Multi Row Sub Query
      New
    • SQL - Part 63 - Using Any Operator in Multi Row Sub Query
      New
    • SQL - Part 64 - Using All Operator in Multi Row Sub Query
      New
    • SQL - Part 65 - Exists Operator
      New
    • SQL - Part 66 - Using Sub Queries for retrieving the records from multiple tables
      New
    • SQL - Part 67 - Using Multiple Sub Queries in a single SQL statement
      New
    • SQL - Part 68 - Integrity Constraints
      New
    • SQL - Part 69 - Not Null Integrity Constraint
      New
    • SQL - Part 70 - Unique Integrity Constraint
      New
    • SQL - Part 71- Primary Key Integrity Constraint
      New
    • SQL - Part 72 - Foreign Key Integrity Constraint
      New
    • SQL - Part 73 - Check Integrity Constraint
      New
    • SQL - Part 74 - Default Integrity Constraint
      New
    • SQL - Part 75 - auto_increment
      New
    • SQL - Part 76 - Insert Into
      New
    • SQL - Part 77 - AS Keyword
      New
    • SQL - Part 78 - IfNull() function
      New
    • SQL - Part 79 - Case, When, Then and End Keywords
      New
    • SQL - Part 80 - Delimiter
      New