SQL Shack

SQL Shack is a new SQL server blog with articles about database auditing, server performance, data recovery and more

[SQL Shack @SQLShack]

We’re moving, but not far! 🛫

We're part of @Quest, and we're sharpening our focus on what matters most: trusted data, secure identities, and modern platforms. All to power AI success.

Follow us on LinkedIn, X, Facebook, YouTube or visit 🔗 https://t.co/vUFGOnj2ge.

[SQL Shack @SQLShack]

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:
https://t.co/cX2HnUP5ET

[SQL Shack @SQLShack]

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: https://t.co/Druvl56CBF

[SQL Shack @SQLShack]

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:
https://t.co/dPz54h2A9E

[SQL Shack @SQLShack]

Learn how to install Postgres on Ubuntu 20.04.5 LTS:
https://t.co/JnZIPe5Fnq

[SQL Shack @SQLShack]

#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: https://t.co/oyfUPSD4pS

[SQL Shack @SQLShack]

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: https://t.co/X0mWHQQjqX…

[SQL Shack @SQLShack]

Gauri Mahajan shows how to calculate the standard deviation function manually as well as using the #sql standard deviation function:
https://t.co/oGiYcfmfJx

[SQL Shack @SQLShack]

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: https://t.co/b8ecNwamWC

[SQL Shack @SQLShack]

#PostgreSQL is important to learn as it's the 4th most popular #database in the world.

Daniel Calbimonte is sharing his expertise with newbies: https://t.co/2Lwj6eCwpc

[SQL Shack @SQLShack]

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: https://t.co/pRrsG8szfp

[SQL Shack @SQLShack]

#Oracle #SQL database has several helpful functions, including the commonly used SUBSTR for string manipulation.

Learn more about this function and its syntax, availability, and usage:
https://t.co/gHZh10GMFc

[SQL Shack @SQLShack]

Manvendra Deo Singh compares the two most popular database products #postgresql vs #mysql, and explains the differences between them:
https://t.co/3wav8deTkg

[SQL Shack @SQLShack]

When an application grows the associated database grows automatically, so it needs to be scaled to a larger machine or server.

Randheer Parmar explains scaling in #oracledatabase and the methods to implement scaling:
https://t.co/eSdxevJsFn

[SQL Shack @SQLShack]

Learn about the different approaches used to insert multiple rows in #SQL:
https://t.co/8z64WsKdp7

[SQL Shack @SQLShack]

Here is an overview of #MySQL Cluster suitable for both database beginners and professionals.

Get a taste of how different components work together to form a system in the form of MySQL Cluster and the challenges it may face:
https://t.co/KWHxBXBC9K

[SQL Shack @SQLShack]

Transact-SQL is an extension of the #SQL that is used to manipulate and fetch data from the Microsoft SQL server.

Take a look at sample SQL queries that can help you learn basic T-SQL queries as quickly as possible:
https://t.co/Npxe9RBZmM

[SQL Shack @SQLShack]

The main difference between #SQL server and #PostgreSQL to create stored procedures are the dollar-quoting ($$), the use of semicolons (;) and the way to concatenate strings with variables.

Learn how to create a PSQL stored procedure: https://t.co/9ttWWLQIrQ

[SQL Shack @SQLShack]

How to create a PostgreSQL stored procedure, and how to work with variables?

Find out here:https://t.co/9ttWWLQIrQ

[SQL Shack @SQLShack]

While doing the #database migration you should take care of multiple things to do it successfully.

Learn about the strategy and options to migrate the #Oracle database to the #Azure SQL database:
https://t.co/e7EzlJGc3g