- SQL
- Introduction
- RDBMS Concepts
- Databases
- Syntax
- Data Types
- Operators
- Expressions
- DDL, DML and DCL
- Create Database
- Drop Database
- Select Database
- Oracle
- Create Table
- Drop Table
- Insert Query
- Select Query
- Where Clause
- AND & OR Clauses
- Update Query
- Delete Query
- Like Clause
- Top Clause
- Order By
- Group By
- Distinct Keyword
- Sorting Results
- Truncate
- Alter
- IN
- NULLs
- Constraints
- NOT NULL Constraint
- DEFAULT Constraint
- UNIQUE Constraint
- PRIMARY Constraint
- FOREIGN Constraint
- CHECK Constraint
- INDEX Constraint
- Joins
- Union
- Except
- Intersect
- Auto Increment
- Sub Query
- Duplicate Table
- Temporary Tables
- Wildcard Operators
- Transaction
- Having
- View
- Index
- Aliases
- NoSQL
- MongoDB
- Overview
- Installation
- Create & Drop DB
- Create & Drop Collections
- Insert Documents
- Query Documents
- AND OR Conditions
- Update Document
- Delete Document
- Projection
- Sort, Skip, and Limit
- Indexing
- Aggregation
- Backup and Restore
- SQLite
- Overview
- Recipes
- Interview Questions
An Online Guide containing useful links of articles, posts, blogs and websites which guides me in better testing (^_^)
Database
Subscribe to:
Posts (Atom)