https://r0tbyt3.dev/tags/sql/Recent content in Sql on Jesus OsegueraHugoen-ushttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/advanced-sql/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/advanced-sql/Advanced SQL Advanced SQL - complex SQL techniques including window functions, CTEs, and query optimization. Related Links: Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/aggregate-queries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/aggregate-queries/Aggregate queries Aggregate Queries - SQL queries using functions like COUNT, SUM, and AVG to summarize data. Related Links: Advanced SQL Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/common-table-expressions-ctes/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/common-table-expressions-ctes/Common table expressions (CTEs) Common Table Expressions - temporary named result sets within a SQL statement for cleaner query structure. Related Links: Advanced SQL Aggregate queries Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/dynamic-sql/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/dynamic-sql/Dynamic SQL Dynamic SQL - SQL statements constructed and executed at runtime based on variable input conditions. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/join-queries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/join-queries/Join queries Join Queries - SQL operations combining rows from two or more tables based on related columns. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/pivot-and-unpivot-operations/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/pivot-and-unpivot-operations/Pivot and unpivot operations Pivot and Unpivot Operations - SQL transformations rotating rows to columns or columns to rows. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/recursive-queries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/recursive-queries/Recursive queries Recursive Queries - SQL queries using CTEs to traverse hierarchical or tree-structured data. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/select-insert-delete-update-statements/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/select-insert-delete-update-statements/Select, insert, delete, update statements Select, Insert, Delete, Update Statements - core DML statements for reading and modifying database data. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/SQL SQL - Structured Query Language for defining, querying, and manipulating relational database data. Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functions Related Links: Database Fundamentals Database Performance Database Typeshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/stored-procedures-and-triggers/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/stored-procedures-and-triggers/Stored procedures and triggers Stored Procedures and Triggers - precompiled SQL code stored in the database for reuse and automation. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/subqueries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/subqueries/Subqueries Subqueries - SQL queries nested inside other queries to filter or transform result sets. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/views/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/views/Views Views - virtual tables defined by a SQL query providing a simplified or filtered interface to data. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/window-functions/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/window-functions/Window functions Window Functions - SQL functions performing calculations across rows related to the current row. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views