SQL Shack is a new SQL server blog with articles about database auditing, server performance, data recovery and more
Joined February 2014
- Tweets3.1K
- Following1.6K
- Followers4.4K
- Likes3.7K
Developers widely use the data type “String” in MySQL for storing data as well as in different formatting operations.
Learn more about “Substring” function to extract a substring from a string:
sqlshack.com/mysql-substring…
Data Types are an important part of a database. Choosing the right data type for a table is one of the most important tasks because it determines the kind of data we want to store in a table.
Here are #PostgreSQL Data Types with various examples: sqlshack.com/an-introduction…
Unit testing is a testing technique that allows us to the test functionality of the smallest and programmable part of the software.
Learn the basics of #SQL unit testing and how to write a SQL unit test through the tSQLt framework:
sqlshack.com/sql-unit-testin…
Learn how to install Postgres on Ubuntu 20.04.5 LTS:
sqlshack.com/how-to-install-…
#database monitoring consists of a set of techniques and operations that aims to maintain the health and performance of a database management system.
Learn the different methods for monitoring #mongodb #NoSQL databases: sqlshack.com/different-metho…
Understanding your organization's business needs and leveraging #MachineLearning through the import, manipulation, and export process is critical to achieving goals and objectives.
Learn more: sqlshack.com/sql-machine-lea……
Gauri Mahajan shows how to calculate the standard deviation function manually as well as using the #sql standard deviation function:
sqlshack.com/introduction-to…
The GROUP BY statement is used to group identical values from the specified column to get the desired output.
Manvendra Deo Singh explains how to do a group by clause in your #SQL queries: sqlshack.com/how-to-do-a-gro…
#PostgreSQL is important to learn as it's the 4th most popular #database in the world.
Daniel Calbimonte is sharing his expertise with newbies: sqlshack.com/postgresql-tuto…
One of the common requirements for all #dataoperations is the ability to perform aggregation, which #mysql provides.
Start with understanding the concept and dive into the process: sqlshack.com/mysql-group_con…
