An Exploration of SQL
Well organized and easy to understand, this blog explores SQL, enhancing your ability to access and manipulate databases.
Latest from the Blog
Improving SQL Performance
Introducing EXPLAIN and EXPLAIN ANALYZE We ought to find and apply the most cost effective application method In order to calculate the cost of a Query, postgres-SQL evaluates the: Through the explain keyword EXPLAIN can be used in front of a query beginning with: SELECT, INSERT, DELETE, REPLACE, or UPDATE Explain Syntax Type EXPLAIN, and then the query you want to…
SQL Storage Types
Cloud Data Storage for your data, apps, and workloads Azure Storage Azure Data Lake Store Azure Cosmos DB Azure SQL Databases AzureSQL PosgreSQL and MySQL Azure SQL Data Warehouse Relational Y Y Y Non – Relational Y Y Y Advanced Querying Y Y Y Y Y For OLAP Y Y For OTLP Y Y Y…
Stored Procedures and Functions
Procedures are used to encapsulate oft-used queries, such as conditional statements and loops Syntax Creating Stored Procedures Replacing Stored Procedures One must drop and replace with the CREATE PROC syntax above, or using an alter procedure and re-scripting, as below Executing Stored Procedures Syntax Deleting Stored Procedures Syntax Paramatized Stored Procedures Allows one to pass…
Get new content delivered directly to your inbox.