Learn SQL articles

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Full-Text Indexing is a feature in SQL Server that allows SQL Server-based applications to execute full-text queries against character-based data in SQL Server databases. Full-text queries enable you to search for words, phrases or various forms of a specific word within […]

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Master Data Services, or MDS, is Microsoft’s solution to problems arising from managing and maintaining master data. Master data can be loosely defined as data that is essential for the operations of a business. It does not change often but forms

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Structured Query Language (SQL) is a must-know language for any data analyst or database developer. One of the powerful features of SQL Server is PolyBase, a technology designed to process queries that access both semi-structured and relational data stored in Hadoop

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Whether you’re a DBA, a SQL developer or a data analyst, knowing how to analyze and optimize SQL Server query execution plans is one of the best skills to have in your toolkit. Understanding how the SQL Server optimizes your queries

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update, and modify data. But not all SQL queries are created equal. Once you get beyond the basics of

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> SQL Server Query Store is a performance monitoring tool introduced in SQL Server 2016. It acts as flight recorder or ‘black box’, capturing the history of executed SQL queries. The Query Store feature provides DBAs with insight on query plan choice,

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Welcome to this interesting journey into the world of SQL, specifically exploring stored procedures. Stored procedures are a great way to encapsulate SQL code for reuse. It allows you to create a script in a certain SQL language, store it at

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> Understanding the IS operator and how to work with NULL values is an integral part of SQL programming. SQL treats “NULL” as a special value that represents missing or unknown data. This is somewhat different from the way most programming languages

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> SQL is a notable language used in programming, data manipulation, and for managing large amounts of data stored in relational database management systems. One of its most powerful features is the ability to join data from multiple tables into one comprehensive

For an instructor lead, in-depth look at learning SQL click below. Learn SQL >> A Stored Procedure in SQL is a collection of SQL statements that have been created and stored in the database as a result of which they can be reused and shared by multiple programs. SQL Server’s set of stored procedures go