Analytics is Normal

  • Home
  • R
  • Python
  • SAS
  • SQL
  • About Us
  • Contact

SQL Tutorials

SQL is a popular language when it comes to manipulating data and when one is working with relational databases.

This is a repository where you can find the detailed tutorials for learning SQL with examples:

​

Basic SQL:

​

  • Creating a table in SQL

  • INSERTing data into a SQL table

  • Constraints in SQL

  • Primary Key in SQL

  • SELECT statement in SQL (Selecting some of the columns)

  • Aggregate functions and GROUP BY in SQL

  • GROUP BY and HAVING in SQL

  • Sorting data using ORDER BY

  • Filtering data using WHERE Statement

  • 5 Joins in SQL - Includes detailed explanation for interview questions

  • UNION , UNION ALL, INTERSECT and EXCEPT

  • Sub-queries in SQL - Includes detailed explanation for interview questions

  • CASE WHEN (Proxy of IF-ELSE) in SQL - Detailed explanation for interview questions

  • Selecting top N rows in SQL

  • ALTER TABLE in SQL

  • UPDATE - SET in SQL

  • TRUNCATE, DROP and DELETE

  • COALESCE in SQL

  • String functions in SQL

  • CAST in SQL

  • Adding quotes to a column in output

Don't Miss Out

Sign Up and Get All Notifications

Thanks for submitting!

©2023 by Analytics is Normal