SQL Tutorial

• SQL | Datatypes
• SQL | DDL, DML, TCL and DCL
• SQL | TRANSACTIONS
• SQL | VIEWS
• SQL | Comments
• SQL | Constraints
• SQL | Creating Roles
• SQL | Indexes
• SQL | SEQUENCES
• SQL | Query Processing
• CTE in SQL
• SQL Trigger | Student Database
• Book Management Database
• Introduction to NoSQL

SQL Clauses / Operators

• SQL | WITH clause
• SQL | With Ties Clause
• SQL | Arithmetic Operators
• SQL | Wildcard operators
• SQL | Intersect & Except clause
• SQL | USING Clause
• SQL | MERGE Statement
• MERGE Statement in SQL Explained
• SQL | DDL, DML, DCL and TCL Commands
• SQL | CREATE DOMAIN
• SQL | DESCRIBE Statement
• SQL | Case Statement
• SQL | UNIQUE Constraint
• SQL | Create Table Extension
• SQL | ALTER (RENAME)
• SQL | ALTER (ADD, DROP, MODIFY)
• SQL | LIMIT Clause
• SQL | INSERT IGNORE Statement
• SQL | LIKE
• SQL | SOME
• SQL | OFFSET-FETCH Clause
• SQL | Except Clause
• Combining aggregate and non-aggregate values in SQL using Joins and Over clause
• SQL | ALL and ANY
• SQL | EXISTS
• SQL | GROUP BY
• SQL | Union Clause
• SQL | Aliases
• SQL | ORDER BY
• SQL | SELECT TOP Clause
• SQL | UPDATE Statement
• SQL | DELETE Statement
• SQL | INSERT INTO Statement
• SQL | AND and OR operators
• SQL | WHERE Clause
• SQL | Distinct Clause
• SQL | SELECT Query
• SQL | DROP, TRUNCATE
• SQL | CREATE
• SQL | Join (Cartesian Join & Self Join)
• SQL | Alternative Quote Operator
• SQL | Concatenation Operator
• SQL | MINUS Operator
• SQL | DIVISION
• SQL | NOT Operator
• SQL | BETWEEN & IN Operator
• SQL | Join (Inner, Left, Right and Full Joins)
• SQL | CHECK Constraint

SQL-Injection

• SQL Injection
• How to use SQLMAP to test a website for SQL Injection vulnerability
• Mitigation of SQL Injection Attack using Prepared Statements (Parameterized Queries)
• Basic SQL Injection and Mitigation with Example

SQL Functions

• SQL | Mathematical functions (SQRT, PI, SQUARE, ROUND, CEILING & FLOOR)
• SQL | Conversion Function
• SQL general functions | NVL, NVL2, DECODE, COALESCE, NULLIF, LNNVL and NANVL
• SQL | Conditional Expressions
• SQL | Character Functions with Examples
• SQL | LISTAGG
• SQL | Aggregate functions
• SQL | Functions (Aggregate and Scalar Functions)
• SQL | Date functions
• SQL | NULL
• SQL | Numeric Functions
• SQL | String functions
• SQL | Advanced Functions

SQL Queries

• SQL | Joining three or more tables
• SQL | How to Get the names of the table
• SQL | Sub queries in From Clause
• SQL | Correlated Subqueries
• SQL | Top-N Queries
• SQL | SUB Queries
• SQL | How to print duplicate rows in a table?
• SQL | How to find Nth highest salary from a table
• DBMS | Nested Queries in SQL
• SQL query to find second highest salary?

PL/SQL

• PL/SQL Introduction
• Cursors in PL/SQL
• Sum Of Two Numbers in PL/SQL
• Reverse a number in PL/SQL
• Factorial of a number in PL/SQL
• Print Patterns in PL/SQL
• Decision Making in PL/SQL
• Oracle SQL | Pseudocolumn
• SQL | Procedures in PL/SQL
• Print different star patterns in SQL
• GCD of two numbers in PL/SQL
• Centered triangular number in PL/SQL
• Floyd’s triangle in PL/SQL
• Convert distance from km to meters and centimeters in PL/SQL
• Convert the given numbers into words in Pl/SQL
• Sum of digits of a number in PL/ SQL
• Sum of digits equal to a given number in PL/SQL
• Sum and average of three numbers in PL/SQL
• Check whether a string is palindrome or not in PL/SQL
• Count odd and even digits in a number in PL/SQL
• No. of vowels and consonants in a given string in PL/SQL
• Area and Perimeter of a circle in PL/SQL
• Finding sum of first n natural numbers in PL/SQL
• Area and Perimeter of Rectangle in PL/SQL
• Sum of the first and last digit of a number in PL/SQL
• Count no. of characters and words in a string in PL/SQL
• Greatest number among three given numbers in PL/SQL
• Concatenation of strings in PL/SQL
• PL/SQL | User Input

MySQL

• MySQL | Regular expressions(Regexp)
• MySQL | Grant/Revoke Privileges
• MySQL | DATABASE() and CURRENT_USER() Functions
• MySQL | BIN() Function
• MySQL | IFNULL
• MySQL | LAST_DAY() Function
• MySQL | RENAME USER
• MySQL | DROP USER
• MySQL | CREATE USER Statement
• MySQL | Change User Password
• PHP | MySQL WHERE Clause
• PHP | MySQL ORDER BY Clause
• PHP | MySQL UPDATE Query
• PHP | MySQL Delete Query
• PHP | MySQL LIMIT Clause
• PHP | MySQL Select Query
• PHP | Inserting into MySQL database
• PHP | MySQL ( Creating Table )
• PHP | MySQL ( Creating Database )

SQL Server

• SQL SERVER | Conditional Statements
• SQL Server Identity
• SQL Server | STUFF() Function

Misc

• SQL using Python
• SQL using Python and SQLite
• SQL using Python (Handling large data)
• Check if Table, View, Trigger, etc present in Oracle
• Performing Database Operations in Java | SQL CREATE, INSERT, UPDATE, DELETE and SELECT
• Difference between Simple and Complex View in SQL
• Difference between Static and Dynamic SQL
• Having Vs Where Clause?
• Inner Join Vs Outer Join
• Difference between SQL and NoSQL

Difference between SQL and NoSQL

SQL (Structured Query Language) and NoSQL (Not Only SQL) databases are both prevalent in the world of data storage and retrieval, but they have distinct characteristics, strengths, and weaknesses. Here's a comparison between the two:

1. Data Model:

   • SQL: Relational databases, which means they use tables to store data. Data is structured with a fixed schema.
   • NoSQL: Various data models including document-based, key-value pairs, column-oriented, and graph-based. They can have dynamic schemas.

2. Schema:

   • SQL: Fixed schema. Before storing data, you need to define tables and their relationships.
   • NoSQL: Dynamic schema. Allows you to store data without defining its structure first, which can be beneficial for varied or rapidly changing data.

3. Scalability:

   • SQL: Typically scales vertically, meaning you increase the resources on your server (CPU, RAM, storage).
   • NoSQL: Typically scales horizontally, meaning you add more servers to your database to accommodate growth.

4. Languages and Interfaces:

   • SQL: Uses SQL for defining and manipulating data.
   • NoSQL: Different databases use different languages and interfaces. For example, MongoDB uses BSON/JSON.

5. ACID vs BASE:

   • SQL: Often follows ACID properties (Atomicity, Consistency, Isolation, Durability).
   • NoSQL: More likely to follow BASE properties (Basically Available, Soft state, Eventually consistent). This means they might temporarily allow inconsistent or intermediate states during operations.

6. Joins and Transactions:

   • SQL: Supports joins and multi-record transactions.
   • NoSQL: While some NoSQL databases support joins, they're typically not as prevalent or flexible as in SQL databases. Complex transactions are also more limited in many NoSQL environments.

7. Examples:

   • SQL: MySQL, Oracle, SQL Server, PostgreSQL.
   • NoSQL: MongoDB (document-based), Redis (key-value store), Cassandra (column-oriented), Neo4j (graph-based).

8. Best Use Cases:

   • SQL: Systems where data integrity and ACID compliance are essential, such as financial systems, and scenarios where the data structure is consistent and doesn't change frequently.
   • NoSQL: Systems requiring scalability and flexibility, especially when dealing with large volumes of rapidly changing, varied, or unpredictable data, like big data and real-time applications.

9. Consistency and Reliability:

   • SQL: Typically offer strong consistency and reliability.
   • NoSQL: Offer a range of consistency models from strong to eventual consistency.

10. Complex Queries:

• SQL: Highly optimized for complex queries.
• NoSQL: Not all NoSQL databases handle complex queries efficiently. Some might need separate tools or software to perform complex data analysis.

When choosing between SQL and NoSQL, it's essential to consider the specific needs of your application, such as the type of data you're dealing with, scalability requirements, and the kinds of queries you need to execute.