All about SQL, tutorials, lists, cheat sheets, code samples

When application data complexity demands object-oriented data we need PostgreSQL. The object-relational database is a natural fit for object-oriented coding. PostgreSQL advanced queries have many advantages, such as table inheritance and foreign keys. For example, we can use relationships among data to find records. You can even add custom functions with other languages like C and Java! In this PostgreSQL tutorial, we are going to illustrate the best of PostgreSQL advanced queries. This will serve as [...]

MSSQL and PostgreSQL are both relational databases. They both are identical but different in various ways. They both are created to store data in an organized way for querying. One of the major differences between both is that PostgreSQL is an open-source database management system and MSSQL is a relational database management system of Microsoft.that is most popular with mid-sized and large enterprises. Both these databases are widely used by many enterprises for creating robust [...]

MySQL and SQL Server are relational database management systems. The major difference between these two databases is that MySQL is open source whereas SQL Server is developed by Microsoft. Both databases support various programming languages. For instance, MySQL supports Java, C++, TCL, Perl, and Haskel. SQL Server supports Java, C++, Visual Basic, Delphi, Ruby, and R. Many database administrators think that the performance of MySQL is better than MsSQL. On the other hand, MSSQL has [...]

SQL (Structured Query Language) is the most widely used programming language for creating and designing relational databases, and for the fulfillment of various operations on the data. Many times developers fail to understand the importance of query optimization. The speed of SQL queries or the performance of the database application depends on the efficient SQL queries. This article will explain how to increase the speed of SQL queries. SQL Query Optimization Executing Stored Procedures in [...]

Are you getting ready for a database administrator position? Is SQL knowledge a prerequisite for the position that you are applying for? If the answer is yes, then you probably need to brush up your database skills once again. This post is all about getting you ready for the interview process. The following are 10 common yet challenging SQL interview questions that you must get ready for. The question set is broken into 3 sections [...]

Relational database management systems and Non-Relational database management systems are fighting with each other in the world of data. MongoDB is one of the most popular non-relational databases that is trying to solve the scalability issue. MS-SQL is a popular relational database management system that uses T-SQL to solve many issues. This article explains the technical difference between MongoDB and MS-SQL. Table vs Collection MongoDB Stored Procedure vs MSSQL Stored Procedure MSSQL DROP Table vs [...]

Today we’re going to explore the differences between MongoDB and MySQL. First, a question: are the two locked in mortal competition? Not at all. In fact, “MongoDB vs SQL” makes the issue sound more adversarial that reality reveals since the two serve very different purposes by design. Another important FAQ is this: Is MongoDB faster than MySQL? Again, this is like comparing basketball and baseball: they’re different games, but you might say they both have [...]

An SQL Injection Attack is presumably the simplest crime to prevent while being one of the smallest defended against modes of attack. The focus of the attack is that an SQL call is connected to the back end of a form entries in the web or application front end, with the purpose of destroying the fundamental SQL Script and then operating the SQL script that was included in the form fields. This SQL injection most [...]

SQL is a server-side scripting language used to query relational databases such as MySQL database. Relational databases as the name referrers are ways in which data is stored in formatted clusters such as databases and their corresponding SQL server tables in ways and means which creates relationships between tables of similar or even different databases. The language is used to manipulate data stored on the server by creating and deleting tables, creating and dropping databases, [...]

The power and functionality of SQL database programming are immense! But this can only be seen in the relational JOIN operations which connect a set of tables with a purpose. JOIN statements enable us to find conditional relationships within tables or datasets. We can then do calculations, sort, and even create new tables based on relationships established among key fields! Moreover, many tutorials simply illustrate the syntax of SQL statements without deeply exploring how they [...]