What is self join in SQL

An SQL join clause - corresponding to a join operation in relational algebra - combines columns from one or more tables in a relational database . We know about inner join , left join , natural join etc in SQL . But most of them don’t know what is self join and how does it work ? Now we are going to know what is self join and how does it work . We can use a self join when a table references data in itself. To clearly understand see the following table . See , This is our Employee table and we have to find out who works under the manager . Here Sonam is the manager and Rahul a... Read more

Difference between SQL and programming languages

Basic Concept of SQL SQL is a non-procedural language that is designed specifically for data access operations on normalized relational database structures. The primary difference between SQL and other conventional programming languages is that SQL statements specify what data operations should be performed rather than how to perform them.SQL is a simple and powerful language used to create, access and manipulate data and structure in the database.SQL is the only language through which you create. Concept of Programming Languages  To solve problems in a procedural programming lan... Read more

Normalization in Database with example

What is Normalization ? Normalization : In relational database management design, Normalization is a technique in which the process of organizing data to minimize redundancy. Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. In other words Normalization is a database design technique which organizes tables in a manner that reduces redundancy and dependency of data. It divides larger tables to smaller tables and links them using relationships. Why Database Normalization is important ? Normalization basically affo... Read more

LET'S SOCIALITE - passive income

Recent Tweets