Menu
Horje
Hi !
Welcome,
Guest
Close Menu
Home
Algorithm
HTML
CSS
Git
Python
PHP
JavaScript
Java
C
C++
C#
Objective-C
R
Haskell
Ruby
Perl
MATLAB
LaTex
SQL
MySQL
MS SQL Server
PostgreSQL
Oracle Database
MongoDB
Node.js
ReactJS
AngularJS
Angular 2
TypeScript
jQuery
React Native
Android
Swift
Kotlin
Xamarin
.NET Framework
Entity Framework
Ruby on Rails
Spring Framework
iOS
Visual Basic .NET
VBA
Excel VBA
Bash
Linux
Home
Web
HTML
CSS
Algorithm
Git
Angular 2
AngularJS
Java Script
Jquery
ReactJS
Angular 2
App
Android
iOS
Java
Latex
React Native
Xamarin
Programming
PHP
C
C++
C#
Git
Haskell
Kotlin
Matlab
Node.js
Objective-c
Swift
PostgreSQL
Python
R
Ruby
Type Script
Visual Basic .NET
Database
Mysql
Mongodb
MS Sql Server
Oracle Database
SQL
Framework
.NET Framework
Entity Framework
Spring Framework/
Ruby on Rails
More
Bash
Excel VBA
Linux
☰
SQL Full Course
Category
Thumb
Getting started with SQL
Identifier
Data Types
NULL
Example Databases and Tables
SELECT
GROUP BY
ORDER BY
AND & OR Operators
CASE
LIKE operator
IN clause
Filter results using WHERE and HAVING
SKIP TAKE (Pagination)
EXCEPT
EXPLAIN and DESCRIBE
EXISTS CLAUSE
JOIN
UPDATE
CREATE Database
CREATE TABLE
CREATE FUNCTION
TRY/CATCH
UNION / UNION ALL
ALTER TABLE
INSERT
MERGE
cross apply, outer apply
DELETE
TRUNCATE
DROP Table
DROP or DELETE Database
Cascading Delete
GRANT and REVOKE
XML
Primary Keys
Indexes
Row number
SQL Group By vs Distinct
Finding Duplicates on a Column Subset with Detail
String Functions
Functions (Aggregate)
Functions (Scalar/Single Row)
Functions (Analytic)
Window Functions
Common Table Expressions
Views
Materialized Views
Comments
Foreign Keys
Sequence
Subqueries
Execution blocks
Stored Procedures
Triggers
Transactions
Table Design
Synonyms
Information Schema
Order of Execution
Clean Code in SQL
Relational Algebra
SQL Injection
SQL CURSOR
Read Article
https://develop.horje.com/learn/1434/reference