SQL
Our SQL articles below clearly and simply how to use specific aspects of SQL that we also cover in our SQL training courses.
AllAdobe IllustratorAdobe InDesignAdobe PhotoshopAutoCADGuides & TipsManagementMicrosoft AccessMicrosoft ExcelMicrosoft OutlookMicrosoft Power AutomateMicrosoft Power BIMicrosoft PowerPointMicrosoft ProjectMicrosoft SharePointMicrosoft WordNewsResilienceSQLTime Management
SQL Rank Functions
Among the myriad functions SQL offers, specific functions such as RANK and DENSE_RANK stand out for their utility in data analysis and reporting tasks. These functions empower users to make sense of data by enabling them to order and rank…
Top 3 SQL Learning Apps
With SQL’s undeniable significance in the current programming landscape, now is an opportune time to delve into this powerful language. In this article, we’ll explore the top 3 SQL learning apps, examining their features, pricing, suitability, and accessibility. If after…
SQL Aggregate Functions
SQL aggregate functions are functions that perform calculations on multiple rows and return an aggregated single value. For instance, the SUM() aggregate function in SQL server adds all the values in a table column and returns the overall sum. But…
SQL Interview Questions
This article explains the type of interview questions that can be asked for SQL-related job positions such as database developer, database administrator, full stack developer, or even for general programming positions. Depending upon the experience level required, the SQL interview…
Semantic Analysis – SQL Machine Learning
In this article, you will see how to perform semantic analysis of textual data using the MS SQL Server machine learning services. By default the SQL Server does not contain any semantic analysis model. It makes use of pre-trained machine…
[Detailed Guide] SQL Update Statement
This article explains how to use the SQL UPDATE statement for updating table rows in SQL SERVER. It looks at what the SQL UPDATE statement is, how you can use it, and some rules and best practices for using it.…
Mastering The SQL IF Statement
In this article, you will see how to use the SQL IF statement for the conditional execution of your SQL script. You will see what SQL IF statements are, how to use them in simple and complex situations, and what…
Using Union Queries & Select Statements In SQL and Access
Normally when bringing two sets of data together in a relational database the intention is for data in the two sources to be matched in some way. For example: Customers to Invoices, Suppliers to Parts, Staff to Absence. Occasionally, but…
Introduction To SQL Joins
Databases are commonly referred to as relational because they contain tables of data, some of which relates to data in other tables. For a SQL Server query to extract useful data from these related tables, you will need to understand…
Backup Types & Strategies For SQL Databases
Backup and Restore are critical concepts to understand when working with databases in SQL and SQL Server. Whether you are new to SQL and/or SQL Server or an experienced database analyst, you never know when a disaster might occur. It…
Temporary Tables In MS SQL
There are four types of tables in MS SQL: Permanent: Normal tables you create and save #Local Temporary: Short term tables, only used in that procedure for that user ##Global Temporary: Short term tables available to all…