SQL Best Practices
Use explicit column names: Instead of using the asterisk (*) to select all columns, explicitly specify the columns you need.
Continue reading
Tag: SQL
Stored Procedure in SQL
What is a stored procedure? A stored procedure is a collection of SQL statements that are pre-compiled and stored in
Continue reading
SQL Join
As the name suggests, combining two or more things together is known as Join. In terms of SQL, when we
Continue reading
MySQL Triggers
MySQL Triggers are a set of SQL statements. It is a stored procedure that is invoked automatically in response to
Continue reading
Introduction to Triggers and Views in SQL
Triggers: Triggers are event-condition-action (ECA) rules. When an event occurs, test the condition if the condition is satisfied, execute the
Continue reading
How to Use Two Databases In a Single Project?
We will be discussing the usage of two databases (MySQL and MongoDB) in one project (Laravel). For multiple databases first
Continue reading
The Aggregate Functions in SQL
What is the aggregate function in MySQL? Aggregate functions are a bunch of methods that work on a set of
Continue reading
SQL Best Practices
Several SQL(structured query language) best practices are: Choose relationships wisely The SQL (structured query language) language is the language of
Continue reading
Introduction to Database Concepts
DBMS and SQL A Database Management System (DBMS), is a software program that enables the users to access database, manipulate
Continue reading