TapAcademy

SQL INTRODUCTION

SQL Introduction -Notes

SQL Introduction -Quiz

ATTRIBUTES

Attributes -Notes

Attributes - Quiz

ER DIAGRAMS -P1

ER DIAGRAM -Notes P1

ER DIAGRAMS -P2

ER DIAGRAM -Notes P2

ER DIAGRAMS - Quiz

SQL STATEMENTS

SQL STATEMENTS -Notes

SQL STATEMENTS - Quiz

DATA TYPES, CONSTRAINTS

DATA TYPES - Notes

DATA TYPES - Quiz

CREATE,DROP,ALTER,ADD,MODIFY

DML,DDL COMMANDS -Notes

DML,DDL COMMANDS - Quiz

INSERTING VALUES

INSERTING VALUES -Notes

INSERTING VALUES - Quiz

TYPES OF KEYS,FOREIGN KEY

TYPES OF KEYS,FOREIGN KEY - Quiz

Types of keys, Foreign Key

SELECT,UPDATE,DELETE COMMAND

SELECT,UPDATE,DELETE COMMAND - Quiz

SELECT,UPDATE,DELETE COMMAND

WHERE CLAUSE AND OPERATORS INTRO

WHERE CLAUSE AND OPERATORS INTRO - Quiz

WHERE CLAUSE AND OPERATORS INTRO

ARITHMETIC OPERATORS

ARITHMETIC OPERATORS

KEYWORD OPERATORS

KEYWORD OPERATORS

LIKE KEYWORD

LIKE KEYWORD

LIKE WITH ESCAPE KEYWORD

LIKE WITH ESCAPE KEYWORD

CONCATENATION OPERATORS

CONCATENATION OPERATORS

QUERIES

Queries On Operators

OPERATORS - Quiz

ORDER BY CLAUSE

Order By Clause

INTRODUCTION TO FUNCTIONS, STRING FUNCTIONS

STRING FUNCTIONS

String Built In functions

TRIM(),REPLACE()

trim(), replace()

INSTR()

INSTR()

LOCATE(),REVERSE(),REPEAT()

LOCATE(),REVERSE(),REPEAT()

LEFT(),RIGHT(),LPAD(),RPAD(),SOUNDEX(),HACKERRANK QUERIES

LEFT(),RIGHT(),LPAD(),RPAD(),SOUNDEX(),HACKERRANK QUERIES

Numeric Functions - ROUND(),TRUNCATE()

NUMERIC FUNTIONS

DATE TIME FUNCTIONS1

DATE TIME FUNCTIONS2

CONTROL FLOW FUNCTIONS

CONVERSION FUNCTIONS

AGGREGATE FUNCTIONS

GROUP BY CLAUSE

HAVING CLAUSE

HACKER RANK QUERIES

SUB QUERIES INTRODUCTION

SUBQUERIES WITH EXISTS,ALL,ANY

SUBQUERIES WITH INSERT,UPDATE,DELETE COMMANDS

Joins