Introduction To
SQL(Structured Query Language)
SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.
There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.
With this course, you will be guided through SQL basic to advanced level with detialed examples and codes where neccessary
Course Structure
Basics
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
Functions
- SQL Server 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 Date Functions (Set-1)
- SQL Date Functions (Set-2)
- SQL LISTAGG
- Database Management System Aggregate functions in SQL
- SQL Functions (Aggregate and Scalar Functions)
- SQL Date functions
- SQL NULL functions
- SQL Numeric Functions
- SQL String functions
- SQL Advanced Functions
Queries
- Joining three or more tables in SQL
- How to Get the names of the table in SQL
- SQL Sub queries in From Clause
- SQL Correlated Subqueries
- SQL Top-N Queries
- SQL SUB Queries
- How to print duplicate rows in a table?
- 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 (if-then , if-then-else, Nested if-then, if-then-elsif-then-else )
- Pseudocolumn in Oracle SQL
- 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
- IFNULL in MySQL
- 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 )
Misc
- SQL using Python Set 1
- SQL using Python and SQLite Set 2
- SQL using Python Set 3 (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