- Home
- HTML
-
CSS
- Introduction of CSS
- CSS Syntax
- CSS Selectors
- How To Add CSS
- CSS Comments
- CSS Colors
- CSS Backgrounds
- CSS Borders
- CSS Margins
- CSS Text
- CSS Lists
- CSS Tables
- CSS Box Model
- CSS Dimension
- CSS Padding
- CSS Border
- CSS Margin
- CSS Outline
- CSS Cursors
- CSS Overflow
- CSS Units
- CSS Visual Formatting
- CSS Display
- CSS Visibility
- CSS Position
- CSS Layers
- CSS Float
- CSS Alignment
- CSS Pseudo-classes
- CSS Pseudo-elements
- CSS Media Types
- CSS Sprites
- CSS Opacity
- CSS Attribute Selectors
- CSS Validation
- CSS3 Border
- CSS3 Gradients
- CSS3 Text Overflow
-
JavaScript
- JS Introduction
- JS Getting Started
- JS Syntax
- JS Variables
- JS Generating Output
- JS Data Types
- JS Operators
- JS Events
- JS Strings
- JS Numbers
- JS If Else
- JS Switch Case
- JS Arrays
- JS Sorting Arrays
- JS Loops
- JS Functions
- JS Objects
- JS DOM Nodes
- JS DOM Selectors
- JS DOM Styling
- JS DOM Get Set Attributes
- JS DOM Manipulation
- JS DOM Navigation
- JS Window
- JS Screen
- JS Location
- JS History
- JS Navigator
- JS Dialog Boxes
- JS Timers
- JS Date and Time
- JS Math Operations
- JS Type Conversions
- JS Event Listeners
- JS Event Propagation
- JS Borrowing Methods
- JS Hoisting Behavior
- JS Closures
- JS Strict Mode
- JS JSON Parsing
- JS Error Handling
- JS Regular Expressions
- JS Form Validation
- JS Cookies
- JS AJAX Requests
- JS ES6 Features
-
jQuery
- jQuery Introduction
- jQuery Syntax
- jQuery Selectors
- jQuery Events
- jQuery Show/Hide
- jQuery Fade
- jQuery Slide
- jQuery Animation
- jQuery Stop
- jQuery Chaining
- jQuery Callback
- jQuery Get/Set
- jQuery Insert
- jQuery Remove
- jQuery CSS Classes
- jQuery Style Properties
- jQuery Dimensions
- jQuery Traversing
- jQuery Ancestors
- jQuery Descendants
- jQuery Siblings
- jQuery Filtering
- jQuery Ajax
- jQuery Load
- jQuery Get/Post
- jQuery No-Conflict
-
PHP
- PHP Introduction
- PHP Install
- PHP Syntax
- PHP Comments
- PHP Variables
- PHP Echo / Print
- PHP Data Types
- PHP Strings
- PHP Constants
- PHP Operators
- PHP If...Else...Elseif
- PHP Switch
- PHP Loops
- PHP Functions
- PHP Arrays
- PHP Superglobals
- PHP Date and Time
- PHP Include
- PHP File Handling
- PHP File Upload
- PHP Cookies
- PHP Sessions
- PHP Filters
- PHP Callback Functions
- PHP JSON
- PHP Exceptions
- PHP What is OOP
- PHP Classes/Objects
- PHP Constructor
- PHP Destructor
- PHP Access Modifiers
- PHP Inheritance
- PHP Abstract Classes
- PHP Interfaces
- PHP Traits
- PHP Static Methods
- PHP Namespaces
-
SQL
- Introduction to SQL
- SQL Create Command
- SQL ALTER Command
- SQL Truncate Drop Rename
- INSERT SQL command
- UPDATE SQL command
- DELETE SQL command
- SQL COMMIT command
- SQL ROLLBACK command
- SQL GRANT and REVOKE Command
- SQL WHERE clause
- SQL LIKE clause
- SQL ORDER BY Clause
- SQL Group By Clause
- SQL HAVING Clause
- SQL DISTINCT keyword
- SQL AND OR operator
- SQL Constraints
- SQL Functions
- SQL JOIN
-
Python
- Getting started with Python
- Introduction to IDLE
- Python 2.x vs. Python 3.x
- Syntax Rules and First Program
- Numbers and Math Functions
- Python Operators
- Python Variables
- Python Modules and Functions
- Python Input and Output
- Data Types in Python
- String in Python
- String Functions in python
- Lists in Python
- Utilizing List Elements by Iterating
- Deleting List Elements & other Functions
- Dictionaries in Python
- Functions for Dictionary
- Tuples in Python
- Relational and Logical Operators
- Conditional Statements in Python
- Looping in Python
- Define Functions in Python
- Python-Introduction to OOP
- Object Oriented Programming in Python
- Classes in Python
- The concept of Constructor
- Destructors - Destroying the Object in Python
- Inheritance in Python
- Access Modifers in Python
- Types of Inheritance
- Method Overriding in Python
- Polymorphism
- static Keyword
- Operator Overloading Python
- Introduction to Error Handling
- Exception Handling: try and except
- Exeption Handling: finally
- Exception Handling: raise
- File Handling
- Reading and Writing File
- Introduction to Multithreading
- Threading Module in Python
- Thread Object
- Lock Object
- RLock Object
- Event Object
- Timer Object
- Condition Object
- Barrier Object
- __name__ Variable in Python
- Iterable and Iterator
- yield Keyword
- Python Generators
- Python Closures
- Python Decorators
- @property Decorator in Python
- Assert Statement
- Garbage Collection
- Shallow and Deep Copy
- Introduction to Logging
- Configure Log LEVEL, Format etc
- Python Logging in a file
- Python Logging Variable Data
- Python Logging Classes and Functions
- Python MySQL Introduction
- Create Database - Python MySQL
- Create Table - Python MySQL
- Insert Data in Table
- Select Data from Table
- Update data in Table
- Delete data from Table
- Drop Table from Database
- WHERE clause - Python MySQL
- Order By clause - Python MySQL
- Limit clause - Python MySQL
- Table Joins - Python MySQL
-
MongoDB
- MongoDB Introduction
- Overview of MongoDB
- MongoDB vs SQL Databases
- Advantages of MongoDB
- When to go for MongoDB
- Data Modelling in MongoDB
- Is MongoDB really Schemaless?
- Installing MongoDB on Windows and Linux
- Datatypes in MongoDB
- Create and Drop Database in MongoDB
- MongoDB: Creating a Collection
- CRUD Operations in MongoDB
- Data Relationships in MongoDB
- Indexing in MongoDB
- Sorting in MongoDB
- Aggregation in MongoDB
- Data Backup and Restoration in MongoDB
- Sharding in MongoDB
- Java Integration with MongoDB
-
Elixir
- Elixir Overview
- Elixir Environment
- Elixir Basic Syntax
- Elixir Data Types
- Elixir Variables
- Elixir Operators
- Elixir Pattern Matching
- Elixir Decision Making
- Elixir Strings
- Elixir Char Lists
- Elixir Lists and Tuples
- Elixir Keyword Lists
- Elixir Maps
- Elixir Modules
- Elixir Aliases
- Elixir Functions
- Elixir Recursion
- Elixir Loops
- Elixir Enumerables
- Elixir Streams
- Elixir Structs
- Elixir Protocols
- Elixir File I/O
- Elixir Processes
- Elixir Sigils
- Elixir Comprehensions
- Elixir Typespecs
- Elixir Behaviours
- Elixir Errors Handling
- Elixir Macros
- Elixir Libraries
-
TypeScript
- TypeScript Overview
- Install TypeScript
- First TypeScript Program
- Type Annotation
- TypeScript Variable
- TypeScript Data Type Number
- TypeScript Data Type String
- TypeScript Data Type Boolean
- TypeScript Arrays
- TypeScript Tuples
- TypeScript Enum
- TypeScript Union
- TypeScript Any Data Type
- TypeScript Void Data Type
- TypeScript Never Data Type
MongoDB vs SQL Databases
Welcome to a tutorial where we will compare MongoDB and SQL Databases.
Well, already that SQL databases have ruled the world of data technologies and have been the primary source of data storage for over four decades. Generally, SQL databases are mainly for accessing relational databases. Oracle and Microsoft SQL Server ruled the segment, however, as the Web development market paced up, there came a shift towards the usage of open source databases such as MySQL, Postgres, and many more. However, RDBMS was still the first choice.
Of recent, data started growing exponentially and scalability became a major issue, at that time NoSQL rolled in to save the day. An interesting part of NoSQL databases is that they existed since 1960, but in recent times they have gained more popularity, especially for the scaling feature it provides.
The major difference between MongoDB and SQL Databases is the way they handle data, SQL databases stored data in form of a traditional 2-dimensional row-column structure whereas MongoDB's rich data document model is followed, which allows storage of any type of data.
The table shows the major differences between MongoDB and other SQL databases.
| SQL Database | NoSQL Database (MongoDB) |
| It is a relational database | It is a non-relational database |
| It supports SQL query language | It supports JSON query language |
| It is Table based | It is a Collection based and key-value pair |
| It is Row based | It is Document based |
| It is Column based | It is Field based |
| It supports foreign key | Doesn't support foreign key |
| It supports triggers | It Doesn't Support triggers |
| It contains a predefined schema | It contains a dynamic schema |
| It is not an option for hierarchical data storage | It is the Best fit for hierarchical data storage |
| It is Vertically scalable - increasing RAM | It is Horizontally scalable - add more servers |
| It Emphasizes ACID properties (Atomicity, Consistency, Isolation, and Durability) | This Emphasizes on CAP theorem (Consistency, Availability, and Partition tolerance) |
In addition, MongoDB Documents align with the structure of objects in modern programming languages, because they are a form of JSON. Thus making it easy for developers to map the data used in the application to its associated document in the database. But in SQL Database, creating a table with columns mapped to the attributes of an object in a programming language, therefore, appears to be quite tedious.