s33046.pcdn.co Open in urlscan Pro
108.138.17.21  Public Scan

Form analysis
2 forms found in the DOM

Name: cookieAgreement —

<form name="cookieAgreement"><input type="checkbox" name="agreed" value="Agreed" checked="" style="display: none"><span class="acceptance"></span></form>

GET https://www.sqlshack.com/

<form role="search" method="get" id="searchform" action="https://www.sqlshack.com/">
  <div class="social-icons-search">
    <li class="lang-item lang-item-52 lang-item-es no-translation" style="margin-right: 5px;"><a href="/sql-server-training/">SQL Server training</a></li>
    <li class="lang-item lang-item-52 lang-item-es lang-item-first"><a lang="es-ES" hreflang="es-ES" href="https://www.sqlshack.com/es/">Español</a></li>
    <a href="/about-us" style="text-decoration:none; color:black;">
      <i class="fa fa-question-circle fa-3x" title="About" style="color: darkcyan;"></i>
    </a>
    <div style="display: inline-block; padding-right: 1em; vertical-align: top !important;">
      <p id="change-button">
        <input type="button" id="mysearchsubmit" value="">
      </p>
    </div>
  </div>
</form>

Text Content

This website uses cookies. By continuing to use this site and/or clicking the
"Accept" button you are providing consent


Quest Software and its affiliates do NOT sell the Personal Data you provide to
us either when you register on our websites or when you do business with us. For
more information about our Privacy Policy and our data protection efforts,
please visit GDPR-HQ






SQLSHACK

Skip to content




SQL Server training Español






INTRODUCTION TO THE SQL STANDARD DEVIATION FUNCTION


April 21, 2023 by Gauri Mahajan

In this article, we will learn about one of the important statistical functions,
the SQL Standard Deviation function. Read more »

Functions, T-SQL


HOW TO DO A GROUP BY CLAUSE


April 12, 2023 by Manvendra Singh

Today, I am going to explain how to do a group by clause in your SQL queries.
SQL (Structured Query Language) is a very popular query language that is widely
used to access and manipulate records stored in a database. The GROUP BY clause
is also a SQL statement that is used to group identical values. Let’s first
understand this clause what it does and why we use this clause in SQL queries.

Read more »

T-SQL


POSTGRESQL TUTORIAL FOR BEGINNERS


April 6, 2023 by Daniel Calbimonte


INTRODUCTION TO THE POSTGRESQL TUTORIAL

In this article, we will have a tutorial to learn PostgreSQL. According to
Statista, PostgreSQL is the 4th most popular database in the world (the other
ones are Oracle, SQL Server, and MySQL). That is why we think it is an important
DBMS to learn.

Read more »

PostgreSQL


MYSQL GROUP_CONCAT() FUNCTION OVERVIEW


March 28, 2023 by Rahul Mehta

This article will provide an understanding of how to effectively use group
concatenation in MySQL.

Read more »

MySQL, String Concatenation


UNDERSTANDING SUBSTRING IN ORACLE SQL


March 22, 2023 by Arindam Mondal

The Oracle SQL database provides many useful functions to use with your query or
programming. The SUBSTR function is one of the most used string functions in the
Oracle SQL database. I will also discuss a few important string functions TRIM,
UPPER, and LOWER which can be used along with substring functions. In this
article, we will discuss substring in Oracle SQL.

Read more »

Oracle


POSTGRESQL VS MYSQL: UNDERSTANDING THEIR DIFFERENCES


March 13, 2023 by Manvendra Singh

Today, we will compare the two most popular database products PostgreSQL vs
MySQL, and explain the differences between them in this article. There are many
database systems based on the relations database management system (RDBMS)
concept in the market. Some of them are Oracle, SQL Server, MySQL, PostgreSQL,
etc. It’s really important to understand the differences between them before
selecting any database product for your application. Keeping this in mind, I am
writing this article to explain these two database systems i.e., PostgreSQL vs
MySQL, and compare them from various aspects so that you can understand them
before taking any decision for your requirements.

Read more »

MySQL, PostgreSQL


UNDERSTANDING THE SCALABILITY IN ORACLE DATABASE


March 9, 2023 by Randheer Parmar

When an application grows the associated database grows automatically. It needs
to be scaled to a larger machine or server and overall configuration needs to be
increased to handle the application and database performance requirement.

Read more »

Database development, Oracle


LEARN SQL: INSERT MULTIPLE ROWS COMMANDS


March 6, 2023 by Hadi Fadlallah

This article explains the different approaches used to insert multiple rows into
SQL Server tables.

Read more »

T-SQL


MYSQL CLUSTER IN SIMPLE WORDS


February 23, 2023 by Haroon Ashraf

This article provides an overview of MySQL Cluster in a simple understandable
manner suitable for both database beginners and professionals.

Read more »

General database design, MySQL


SQL CHEAT SHEET FOR NEWBIES


February 21, 2023 by Esat Erkec

In this SQL cheat sheet, we’ll look at sample SQL queries that can help you
learn basic T-SQL queries as quickly as possible.

Read more »

SQL commands, T-SQL


HOW TO USE THE CROSSTAB FUNCTION IN POSTGRESQL


February 17, 2023 by Rajendra Gupta

This article will explore the use of the CROSSTAB function in PostgreSQL.

Read more »

PostgreSQL, SQL commands


PSQL STORED PROCEDURES OVERVIEW AND EXAMPLES


February 14, 2023 by Daniel Calbimonte

In this article, we will learn how to create PostgreSQL stored procedures using
PSQL.

Read more »

PostgreSQL, Stored procedures


MIGRATING ORACLE DATABASE TO AZURE SQL DATABASE


February 9, 2023 by Randheer Parmar

Data Modernization has become important nowadays. Organizations are looking into
options to migrate their on-premises database to a cloud and some other
heterogeneous databases. In this article, we will see the strategy and options
to migrate the Oracle database to the Azure SQL database. We will be leveraging
the SSMA tool for migrating the database.

Read more »

Azure, Oracle


A QUICK OVERVIEW OF MYSQL FOREIGN KEY WITH EXAMPLES


February 7, 2023 by Gauri Mahajan

In this article, we will learn how to work with MySQL foreign keys with a few
examples.

Read more »

MySQL


COMMON USE CASES OF SQL SELECT DISTINCT


February 2, 2023 by Haroon Ashraf

This article talks about the commonly used scenarios of SQL Select Distinct in
an easily understandable format equally suitable for beginners and
professionals.

Read more »

Data Warehouse, Development, T-SQL


TOP POWER BI INTERVIEW QUESTIONS AND ANSWERS


January 31, 2023 by Arindam Mondal

Microsoft Power BI is a very popular data visualization tool. In this article,
we will discuss the most frequently asked Power BI Interview Questions and
Answers.

Read more »

PowerBI, SQL interview questions


SQL PRACTICE: COMMON QUESTIONS AND ANSWERS FOR THE FINAL ROUND INTERVIEWS


January 26, 2023 by Esat Erkec

In this article, we are going to make a SQL practice exercise that will help to
prepare for the final round of technical interviews of the SQL jobs.

Read more »

Development, Query analysis, SQL interview questions


INTRODUCTION TO SQL ESCAPE


January 24, 2023 by Rahul Mehta

This article will provide an introduction to SQL escape characters for using
special characters and their characteristics.

Read more »

MySQL, T-SQL


LEARN THE POSTGRESQL COALESCE COMMAND


January 19, 2023 by Rajendra Gupta

This article will make you learn the Postgres Coalesce command with examples.

Read more »

Development, PostgreSQL, SQL commands


LEARN SQL STANDARD DEVIATION FUNCTION


January 17, 2023 by Hadi Fadlallah

This article will show the SQL standard deviation function with several
examples.

Read more »

SQL commands, T-SQL


GETTING STARTED WITH SQL LIMIT CLAUSE


January 13, 2023 by Manvendra Singh

Today, I am going to explain how to use the SQL LIMIT clause to limit output
values. We all know RDBMS systems are one of the popular ways to store, protect,
access, and analyze data in a structured way. We can store enormous sizes of
data and then further can access them with the help of SQL language to get our
desired output to analyze it. SQL stands for Structured Query Language which is
used to perform activities like creating, modifying, and accessing data from the
databases hosted on RDBMS systems like SQL Server or MySQL, etc. This article
will explain one of the SQL query statements LIMIT which we use to limit the
number of records returned in the output result.

Read more »

MySQL, T-SQL


HOW TO CREATE POWER BI REPORTS


January 11, 2023 by Daniel Calbimonte

In this article, we will learn how to create Power BI Reports. This article is
created for newbies to start the Power BI world with a simple example. We will
connect to SQL Server, show how to transform data from SQL Server in Power BI,
and then we will create some reports, and play with the options available in
Power BI.

Read more »

PowerBI


COMMON SQL INTERVIEW QUESTIONS AND ANSWERS


January 6, 2023 by Randheer Parmar

If you are working on SQL programming or learning SQL or how to write queries
and looking to test your knowledge or prepare for any SQL interview, the below
article can help you.

Read more »

SQL interview questions


OVERVIEW OF THE SQL MEDIAN FUNCTION


January 4, 2023 by Gauri Mahajan

In this article, we will learn how to implement the median functionality and
wrap it into a SQL median function

Read more »

Azure, Functions


SQL SUBTRACT DATES WITH EXAMPLES


January 2, 2023 by Arindam Mondal

SQL Server provides various dates and time functions for different needs. In
this article, we will focus on SQL subtract date functions with various
examples.

Read more »

T-SQL
Page 1 of 10412345...102030...»Last »



FOLLOW US!








POPULAR

 * SQL Convert Date functions and formats
 * SQL Variables: Basics and usage
 * Different ways to SQL delete duplicate rows from a SQL Table
 * SQL PARTITION BY Clause overview
 * How to UPDATE from a SELECT statement in SQL Server
 * SQL WHILE loop with simple examples
 * SELECT INTO TEMP TABLE statement in SQL Server
 * How to backup and restore MySQL databases using the mysqldump command
 * SQL Server functions for converting a String to a Date
 * Overview of SQL RANK functions
 * The Table Variable in SQL Server
 * Understanding the SQL MERGE statement
 * Understanding the SQL Decimal data type
 * SQL multiple joins for beginners with examples
 * SQL Server table hints – WITH (NOLOCK) best practices
 * DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key
 * INSERT INTO SELECT statement overview and examples
 * CASE statement in SQL
 * SQL Lag function overview and examples
 * SQL percentage calculation examples in SQL Server




TRENDING

 * SQL Server Transaction Log Backup, Truncate and Shrink Operations
 * Six different methods to copy tables between databases in SQL Server
 * How to implement error handling in SQL Server
 * Working with the SQL Server command line (sqlcmd)
 * Methods to avoid the SQL divide by zero error
 * Query optimization techniques in SQL Server: tips and tricks
 * How to create and configure a linked server in SQL Server Management Studio
 * SQL replace: How to replace ASCII special characters in SQL Server
 * How to identify slow running queries in SQL Server
 * SQL varchar data type deep dive
 * How to implement array-like functionality in SQL Server
 * All about locking in SQL Server
 * SQL Server stored procedures for beginners
 * Database table partitioning in SQL Server
 * How to drop temp tables in SQL Server
 * How to determine free space and file size for SQL Server databases
 * Using PowerShell to split a string into an array
 * KILL SPID command in SQL Server
 * How to install SQL Server Express edition
 * SQL Union overview, usage and examples




SOLUTIONS

 * Read a SQL Server transaction log
 * SQL Server database auditing techniques
 * How to recover SQL Server data from accidental UPDATE and DELETE operations
 * How to quickly search for SQL database data and objects
 * Synchronize SQL Server databases in different remote sources
 * Recover SQL data from a dropped table without backups
 * How to restore specific table(s) from a SQL Server database backup
 * Recover deleted SQL data from transaction logs
 * How to recover SQL Server data from accidental updates without backups
 * Automatically compare and synchronize SQL Server data
 * Open LDF file and view LDF file content
 * Quickly convert SQL code to language-specific client code
 * How to recover a single table from a SQL Server database backup
 * Recover data lost due to a TRUNCATE operation without backups
 * How to recover SQL Server data from accidental DELETE, TRUNCATE and DROP
   operations
 * Reverting your SQL Server database back to a specific point in time
 * How to create SSIS package documentation
 * Migrate a SQL Server database to a newer version of SQL Server
 * How to restore a SQL Server database backup to an older version of SQL Server


CATEGORIES AND TIPS

 * ►Auditing and compliance (50)
    * Auditing (40)
      
    * Data classification (1)
      
    * Data masking (9)
      

   
 * Azure (308)
   
 * Azure Data Studio (46)
   
 * Backup and restore (108)
   
 * ►Business Intelligence (486)
    * Analysis Services (SSAS) (47)
      
    * Biml (10)
      
    * Data Mining (14)
      
    * Data Quality Services (4)
      
    * Data Tools (SSDT) (13)
      
    * Data Warehouse (17)
      
    * Excel (20)
      
    * General (39)
      
    * Integration Services (SSIS) (125)
      
    * Master Data Services (6)
      
    * OLAP cube (15)
      
    * PowerBI (97)
      
    * Reporting Services (SSRS) (67)
      

   
 * Data science (21)
   
 * ►Database design (235)
    * Clustering (16)
      
    * Common Table Expressions (CTE) (11)
      
    * Concurrency (1)
      
    * Constraints (8)
      
    * Data types (11)
      
    * FILESTREAM (22)
      
    * General database design (106)
      
    * Partitioning (13)
      
    * Relationships and dependencies (12)
      
    * Temporal tables (12)
      
    * Views (16)
      

   
 * ►Database development (431)
    * Comparison (4)
      
    * Continuous delivery (CD) (5)
      
    * Continuous integration (CI) (11)
      
    * Development (151)
      
    * Functions (109)
      
    * Hyper-V (1)
      
    * Search (10)
      
    * Source Control (15)
      
    * SQL unit testing (23)
      
    * Stored procedures (35)
      
    * String Concatenation (3)
      
    * Synonyms (1)
      
    * Team Explorer (2)
      
    * Testing (35)
      
    * Visual Studio (14)
      

   
 * DBAtools (35)
   
 * DevOps (23)
   
 * DevSecOps (2)
   
 * Documentation (22)
   
 * ETL (76)
   
 * ►Features (213)
    * Adaptive query processing (11)
      
    * Bulk insert (16)
      
    * Database mail (10)
      
    * DBCC (7)
      
    * Experimentation Assistant (DEA) (3)
      
    * High Availability (36)
      
    * Query store (10)
      
    * Replication (40)
      
    * Transaction log (59)
      
    * Transparent Data Encryption (TDE) (21)
      

   
 * Importing, exporting (52)
   
 * Installation, setup and configuration (122)
   
 * Jobs (42)
   
 * ►Languages and coding (715)
    * Cursors (9)
      
    * DDL (9)
      
    * DML (6)
      
    * JSON (17)
      
    * PowerShell (77)
      
    * Python (38)
      
    * R (16)
      
    * SQL commands (206)
      
    * SQLCMD (7)
      
    * String functions (21)
      
    * T-SQL (293)
      
    * XML (15)
      

   
 * Lists (12)
   
 * Machine learning (37)
   
 * Maintenance (99)
   
 * Migration (50)
   
 * Miscellaneous (1)
   
 * ►Performance tuning (871)
    * Alerting (8)
      
    * Always On Availability Groups (82)
      
    * Buffer Pool Extension (BPE) (9)
      
    * Columnstore index (9)
      
    * Deadlocks (16)
      
    * Execution plans (125)
      
    * In-Memory OLTP (22)
      
    * Indexes (79)
      
    * Latches (5)
      
    * Locking (10)
      
    * Monitoring (100)
      
    * Performance (196)
      
    * Performance counters (28)
      
    * Performance Testing (9)
      
    * Query analysis (123)
      
    * Reports (20)
      
    * SSAS monitoring (3)
      
    * SSIS monitoring (10)
      
    * SSRS monitoring (4)
      
    * Wait types (11)
      

   
 * ►Professional development (71)
    * Professional development (27)
      
    * Project management (9)
      
    * SQL interview questions (35)
      

   
 * Recovery (33)
   
 * Security (85)
   
 * Server management (24)
   
 * SQL Azure (272)
   
 * SQL Server Management Studio (SSMS) (91)
   
 * SQL Server on Linux (22)
   
 * ►SQL Server versions (177)
    * SQL Server 2012 (6)
      
    * SQL Server 2016 (63)
      
    * SQL Server 2017 (49)
      
    * SQL Server 2019 (57)
      
    * SQL Server 2022 (2)
      

   
 * ►Technologies (360)
    * AWS (46)
      
    * AWS RDS (56)
      
    * Azure Cosmos DB (33)
      
    * Containers (12)
      
    * Docker (9)
      
    * Graph database (13)
      
    * Kerberos (2)
      
    * Kubernetes (3)
      
    * Linux (44)
      
    * LocalDB (2)
      
    * MySQL (57)
      
    * Oracle (13)
      
    * PolyBase (10)
      
    * PostgreSQL (43)
      
    * SharePoint (4)
      
    * Ubuntu (13)
      

   
 * Uncategorized (4)
   
 * Utilities (21)
   
 * 

Helpers and best practices
 * BI performance counters
 * SQL code smells rules
 * SQL Server wait types




© 2023 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use  
|   Privacy



AddThis Sharing Sidebar
Share to FacebookFacebookShare to TwitterTwitterShare to LinkedInLinkedInShare
to RedditRedditShare to EmailEmail
Hide
Show
Close

AddThis

AddThis Sharing
FacebookTwitterLinkedInRedditEmail