Skip to content
Let Me FailLet Me Fail
  • Articles
  • Books
  • Projects
  • Tech & Tools
  • About
sql
100 Days of SQL

Day 92 – 100 – What is SQL and what is it used for? SQL

05
Apr
sql
100 Days of SQL

Day 91 – Cursors In this example, a cursor named order_cursor is used to retrieve

05
Apr
sql
100 Days of SQL

Day 90 – User-Defined Functions In this example, a user-defined function named fnGetProductPrice is created

05
Apr
sql
100 Days of SQL

Day 89 – Views In this example, a view named vwProductSales is created to retrieve

05
Apr
sql
100 Days of SQL

Day 88 – Triggers In this example, a trigger named trUpdateProductInventory is created to update

05
Apr
sql
100 Days of SQL

Day 87 – Stored Procedures In this example, a stored procedure named spGetSalesByRegion is created

05
Apr
sql
100 Days of SQL

Day 86 – Indexes These are database objects that are used to improve the performance

05
Apr
sql
100 Days of SQL

Day 85 – Transactions These are a series of SQL statements that are executed as

05
Apr
sql
100 Days of SQL

Day 84 – Cursors These are database objects that allow you to traverse through the

05
Apr
sql
100 Days of SQL

Day 83 – User-Defined Functions These are custom functions that can be created to perform

05
Apr
sql
100 Days of SQL

Day 82 – Views These are virtual tables that are created based on the result

05
Apr
sql
100 Days of SQL

Day 81 – Triggers These are database objects that are automatically executed in response to

05
Apr
sql
100 Days of SQL

Day 80 – Stored Procedures Stored Procedures: These are pre-compiled SQL statements that are stored

05
Apr
sql
100 Days of SQL

Day 79 – SQL FOREIGN KEY Constraint In SQL, a FOREIGN KEY constraint is a way to

05
Apr
sql
100 Days of SQL

Day 78 – MySQL CONCAT() Function In MySQL, the CONCAT() function is used to concatenate two or

04
Apr
sql
100 Days of SQL

Day 77- SQL SET In SQL, the SET keyword is used to update the values of

04
Apr
sql
100 Days of SQL

Day 75 – SQL RIGHT JOIN Keyword In SQL, a RIGHT JOIN is a type

04
Apr
sql
100 Days of SQL

Day 76 – SQL SELECT TOP, LIMIT and ROWNUM Keywords In SQL, the keywords TOP, LIMIT,

04
Apr
sql
100 Days of SQL

Day 74 – SQL CREATE PROCEDURE Keyword In SQL, the CREATE PROCEDURE statement is used to

04
Apr
sql
100 Days of SQL

Day 73 – SQL FOREIGN KEY Keyword In SQL, a FOREIGN KEY is a constraint that

04
Apr
sql
100 Days of SQL

Day 72 – SQL EXISTS Keyword SQL EXISTS keyword is used to check for the existence

04
Apr
sql
100 Days of SQL

Day 71 – SQL EXEC Keyword SQL EXEC keyword is used to execute a stored procedure

04
Apr
sql
100 Days of SQL

Day 70 – SQL DROP TABLE and TRUNCATE TABLE Keywords SQL DROP TABLE and TRUNCATE TABLE

04
Apr
sql
100 Days of SQL

Day 69 – SQL SELECT DISTINCT Keyword SQL SELECT DISTINCT keyword is used to retrieve unique

04
Apr
sql
100 Days of SQL

Day 68 – SQL DESC Keyword SQL DESC keyword is short for “DESCRIBE”, and it

04
Apr
sql
100 Days of SQL

Day 67 – SQL DELETE Keyword SQL DELETE keyword is used to delete one or more

04
Apr
sql
100 Days of SQL

Day 66 – SQL CREATE VIEW Keyword SQL CREATE VIEW keyword is used to create a

04
Apr
sql
100 Days of SQL

Day 65 – SQL CREATE UNIQUE INDEX Keyword SQL CREATE UNIQUE INDEX keyword is used to

04
Apr
sql
100 Days of SQL

Day 64 – SQL CREATE PROCEDURE SQL CREATE PROCEDURE keyword is used to create a stored

04
Apr
sql
100 Days of SQL

Day 62 – SQL CREATE Keyword SQL CREATE keyword is used to create new database objects,

04
Apr
sql
100 Days of SQL

Day 63 – SQL CREATE INDEX Keyword SQL CREATE INDEX keyword is used to create a

04
Apr
sql
100 Days of SQL

Day 61 – SQL CONSTRAINT Keyword SQL CONSTRAINT keyword is used to define rules and restrictions

04
Apr
sql
100 Days of SQL

Day 60 – SQL CHECK Keyword SQL CHECK keyword is used to define a condition that

04
Apr
sql
100 Days of SQL

Day 59 – SQL CASE Keyword SQL CASE keyword is used to add conditional logic to

04
Apr
sql
100 Days of SQL

Day 58 – SQL BETWEEN Keyword SQL BETWEEN keyword is used in a WHERE clause to

04
Apr
sql
100 Days of SQL

Day 57 – SQL BACKUP DATABASE Keyword SQL BACKUP DATABASE keyword is used to create a

04
Apr
sql
100 Days of SQL

Day 56 – SQL ASC Keyword SQL ASC keyword is used in the ORDER BY clause

04
Apr
sql
100 Days of SQL

Day 55 – SQL AS Keyword SQL AS keyword is used to give an alias or

04
Apr
sql
100 Days of SQL

Day 54 – SQL ANY Keyword SQL ANY keyword is used in conjunction with a comparison

04
Apr
sql
100 Days of SQL

Day 53 – SQL AND Keyword SQL AND keyword is a logical operator used to combine

04
Apr
sql
100 Days of SQL

Day 52 – SQL ALTER TABLE Keyword SQL ALTER TABLE keyword is used to modify the

04
Apr
sql
100 Days of SQL

Day 51 – SQL ALTER COLUMN Keyword SQL ALTER COLUMN keyword is used to modify the

04
Apr
sql
100 Days of SQL

Day 50 – SQL ALTER Keyword SQL ALTER keyword is used to modify the structure of

02
Apr
sql
100 Days of SQL

Day 49 – SQL ADD Keyword The SQL ADD keyword is used to add a new

02
Apr
sql
100 Days of SQL

Day 48 – SQL Keywords SQL keywords are reserved words that have a specific meaning

02
Apr
sql
100 Days of SQL

Day 47 – SQL Data Types for MySQL, SQL Server, and MS Access SQL data types

02
Apr
sql
100 Days of SQL

Day 46 – SQL Hosting SQL hosting refers to the practice of hosting a SQL

02
Apr
sql
100 Days of SQL

Day 44 – SQL CREATE VIEW Statement In SQL, a view is a virtual table

02
Apr
sql
100 Days of SQL

Day 45 – SQL Injection SQL injection is a type of security vulnerability that occurs

02
Apr
sql
100 Days of SQL

Day 43 – SQL Dates In SQL, dates are a common data type used to

02
Apr
sql
100 Days of SQL

Day 42 – AUTO INCREMENT Field In SQL, an AUTO INCREMENT field is a column

02
Apr
sql
100 Days of SQL

Day 41 – SQL CREATE INDEX Statement In SQL, an index is a database object

02
Apr
sql
100 Days of SQL

Day 40 – SQL DEFAULT Constraint In SQL, a DEFAULT constraint is used to set

02
Apr
sql
100 Days of SQL

Day 39 – SQL CHECK Constraint In SQL, a CHECK constraint is used to ensure

02
Apr
sql
100 Days of SQL

Day 38 – SQL FOREIGN KEY Constraint In SQL, a FOREIGN KEY constraint is used

02
Apr
sql
100 Days of SQL

Day 37 – SQL PRIMARY KEY Constraint In SQL, the PRIMARY KEY constraint is used to specify

02
Apr
sql
100 Days of SQL

Day 36 – SQL UNIQUE constraint SQL UNIQUE constraint is used to ensure that each

01
Apr
sql
100 Days of SQL

Day 35 – SQL NOT NULL Constraint SQL NOT NULL constraint is used to ensure that a

01
Apr
sql
100 Days of SQL

Day 34 – SQL Constraints In SQL, constraints are used to specify rules and restrictions on

01
Apr
sql
100 Days of SQL

Day 32 – SQL DROP TABLE SQL DROP TABLE statement is used to delete an

01
Apr
sql
100 Days of SQL

Day 33 – SQL ALTER TABLE SQL ALTER TABLE statement is used to modify the structure

01
Apr
sql
100 Days of SQL

Day 30 – SQL BACKUP DATABASE SQL BACKUP DATABASE statement is used to create a

01
Apr
sql
100 Days of SQL

Day 31 – SQL CREATE TABLE SQL CREATE TABLE statement is used to create a new

01
Apr
sql
100 Days of SQL

Day 29 – SQL DROP DATABASE The SQL DROP DATABASE statement is used to delete an

01
Apr
sql
100 Days of SQL

Day 28 – SQL CREATE DATABASE SQL CREATE DATABASE statement is used to create a new

01
Apr
sql
100 Days of SQL

Day 27 – SQL Stored Procedures SQL stored procedures are a type of program stored in

01
Apr
sql
100 Days of SQL

Day 26 – SQL CASE Expression SQL CASE expression is a conditional expression used to

01
Apr
sql
100 Days of SQL

Day 25 – SQL SELECT INTO Statement The SQL SELECT INTO statement is used to create a

01
Apr
sql
100 Days of SQL

Day 24 – SQL EXISTS Operator The SQL EXISTS operator is a logical operator that

01
Apr
sql
100 Days of SQL

Day 23 – SQL HAVING Clause The SQL HAVING clause is used in conjunction with

01
Apr
sql
100 Days of SQL

Day 22 – SQL GROUP BY Statement The SQL GROUP BY statement is used to group rows

01
Apr
sql
100 Days of SQL

Day 21 – SQL FULL OUTER JOIN Keyword The SQL FULL OUTER JOIN keyword is

01
Apr
sql
100 Days of SQL

Day 20 – SQL RIGHT JOIN Keyword In SQL, the RIGHT JOIN keyword is used

31
Mar
sql
100 Days of SQL

Day 19 – SQL LEFT JOIN Keyword In SQL, the LEFT JOIN keyword is used

31
Mar
sql
100 Days of SQL

Day 18 – SQL INNER JOIN Keyword In SQL, the INNER JOIN keyword is used

31
Mar
sql
100 Days of SQL

Day 17 – SQL Joins In SQL, a JOIN operation is used to combine rows from

31
Mar
sql
100 Days of SQL

Day 16 – SQL Aliases In SQL, an alias is a temporary name given to

31
Mar
sql
100 Days of SQL

Day 15 – SQL BETWEEN Operator In SQL, the BETWEEN operator is used to specify

31
Mar
sql
100 Days of SQL

Day 14 – SQL IN Operator In SQL, the IN operator is used to specify

31
Mar
sql
100 Days of SQL

Day 13 – SQL LIKE Operator In SQL, the LIKE operator is used to search for patterns

31
Mar
sql
100 Days of SQL

Day 12 – SQL COUNT(), AVG() and SUM() Functions In SQL, the COUNT(), AVG(), and SUM() functions

31
Mar
sql
100 Days of SQL

Day 11 – SQL MIN() and MAX() Functions In SQL, the MIN() and MAX() functions

31
Mar
sql
100 Days of SQL

Day 10 – SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause SQL provides different ways to limit

31
Mar
sql
100 Days of SQL

Day 08 – SQL UPDATE Statement The SQL UPDATE statement is used to modify existing records in

31
Mar
sql
100 Days of SQL

Day 09 – DELETE statement The SQL DELETE statement is used to delete one or

31
Mar
sql
100 Days of SQL

Day 07 – SQL NULL Values In SQL, NULL is a special marker used to indicate

31
Mar
sql
100 Days of SQL

Day 06 – SQL INSERT INTO statement SQL INSERT INTO statement is used to insert

31
Mar
sql
100 Days of SQL

Day 05 – SQL ORDER BY The SQL ORDER BY clause is used to sort

31
Mar
sql
100 Days of SQL

Day 04 – logical operators – AND, OR, and NOT SQL provides three logical operators

31
Mar
sql
100 Days of SQL

Day 03 – SQL WHERE Clause WHERE clause is used to filter data based on

31
Mar
sql
100 Days of SQL

Day 02 – SELECT DISTINCT Statement The SQL SELECT DISTINCT statement is used to retrieve

31
Mar
sql
100 Days of SQL

This 100 Days of SQL challenge is a structured approach to learn and improve your

31
Mar

©2023letmefail

  • Articles
  • Books
  • Projects
  • Tech & Tools
  • About