Logo "Master Anything, Unlock Your Potential."
Modules

Programming Languages

Python Java DSA Javascript SQL C++

Technology Domains

AI / ML Data Science Cybersecurity DevOps Cloud Computing - AWS Digital Marketing Blockchain Data Engineering
Interview

Programming Languages

Java Python SQL C++ javascript

Technology Domains

AI / ML Data Science Cybersecurity DevOps
  • Python
  • Java
  • DSA
  • JavaScript
  • AI / ML
  • Data Science
  • Cybersecurity
  • DevOps
  • SQL
  • C++
  • Blockchain
  • Cloud Computing - AWS
  • Data Engineering
  • Digital Marketing

Chapters

  • Getting Started with SQL
  • Introduction to Databases and SQL
  • SQL SELECT
  • SQL AND, OR, and NOT Operators
  • SQL SELECT DISTINCT
  • SQL SELECT AS Alias
  • SQL SELECT LIMIT, TOP, and FETCH FIRST
  • SQL IN and NOT IN Operators
  • SQL BETWEEN Operator
  • SQL IS NULL and IS NOT NULL Operators
  • SQL MAX() and MIN() Functions
  • SQL COUNT() Function
  • SQL SUM() and AVG() Functions
  • SQL ORDER BY Clause
  • SQL GROUP BY Clause
  • SQL LIKE and NOT LIKE Operators
  • SQL Wildcards
  • SQL UNION
  • SQL Subqueries
  • SQL Views
  • SQL CTEs (Common Table Expressions)
  • SQL ANY and ALL Operators
  • SQL CASE
  • SQL HAVING Clause
  • SQL EXISTS Operator
  • SQL JOINS
  • SQL INNER JOIN
  • SQL LEFT JOIN
  • SQL RIGHT JOIN
  • SQL FULL OUTER JOIN
  • SQL CROSS JOIN
  • SQL Self JOIN
  • SQL CREATE DATABASE
  • SQL DROP DATABASE
  • SQL ALTER TABLE
  • SQL BACKUP DATABASE
  • SQL INSERT INTO
  • SQL UPDATE
  • SQL SELECT INTO
  • SQL INSERT INTO SELECT
  • SQL DELETE vs. TRUNCATE
  • SQL Constraints
  • SQL NOT NULL Constraint
  • SQL UNIQUE Constraint
  • SQL PRIMARY KEY
  • SQL FOREIGN KEY
  • SQL CHECK Constraint
  • SQL DEFAULT
  • SQL CREATE INDEX
  • SQL Composite Key
  • SQL Data Types
  • SQL Operators
  • SQL Date and Time
  • SQL Date and Time Functions
  • SQL JOIN with Three Tables
  • SQL SUBSTRING()
  • SQL Commands
  • SQL REPLACE()
  • SQL REGEXP
  • SQL Stored Procedures
  • Preventing SQL Injection Attacks
< Previous
Next >



< Previous
Next >


Modules
  • Python
  • Java
  • DSA
  • Javascript
  • SQL
  • C++
Interview Questions
  • Java
  • Python
  • SQL
  • C++
  • javascript

Copyright © 2024 Tutorialdom.   Privacy Policy