Technology – The Best Tools to Use MySQL

One of the most useful programs for MySQL developers is phpMyAdmin. With the help of this tool, you can create and administer MySQL databases. However, phpMyAdmin is not the only tool for MySQL developers. MySQL Workbench is another useful tool for database developers, database architects, and DBAs. Its features include data modeling, SQL development, and … More Technology – The Best Tools to Use MySQL

Technology – The Difference Between Float Vs. Double Data Types

It would be incorrect to say that floating-point numbers should never be used as an SQL data type for arithmetic. I will stick to double-precision floating-point data types for SQL Server that are suitable for my requirements. The double-precision floating-point data type is ideal for modeling weather systems or displaying trajectories but not for the … More Technology – The Difference Between Float Vs. Double Data Types

Technology – What Are The SQL Minus and Except Clauses

Structured Query Language (SQL) is the de-facto query language used in most database management systems (DBMS) such as Oracle and Microsoft SQL Server. This domain-specific language is used in programming to query and return the desired data from a database. We use SQL to write queries that declare what data to expect from a dataset … More Technology – What Are The SQL Minus and Except Clauses

SQL Server Length Function Equivalent

The purpose of the Length function in SQL The SQL LENGTH function returns the number of characters in a string. The LENGTH function is available in many Database Management Systems (DBMS). The LENGTH Function Syntax LENGTH(string) LENGTH Function Notes If the input string is empty, the LENGTH returns 0. If the input string is NULL, … More SQL Server Length Function Equivalent

Technology – What is the difference between left join and left outer join in SQL

If you’re confused between a LEFT JOIN and a LEFT outer JOIN in SQL, you’re not alone. There are plenty of examples that explain both. In this article, we’ll explore LEFT JOIN, which combines the records from table1 with any matched records in table2, and OUTER JOIN, which combines records from both tables. RIGHT joins … More Technology – What is the difference between left join and left outer join in SQL