SQL Programming - Revision history

Lsokolowski1: /* Recap of Basics, Basic Cheat Sheet (Oracle) */

2025-11-20T09:47:41Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 09:47, 20 November 2025
Line 3,981:		Line 3,981:
	'II' DEEP DIVE INTO SURROUNDINGS (KYDB)		'II' DEEP DIVE INTO SURROUNDINGS (KYDB)
	'III' KISS, DISP, DILTS, NF, FACS, DITW, FTS, AYTQ		'III' KISS, DISP, DILTS, NF, FACS, DITW, FTS, AYTQ
	'IV' AFTER EACH SMALLER PART OF "DISP" GO BACK TO point 'I'		'IV' AFTER EACH SMALLER PART OF "DISP" GO BACK TO point 'I' AND REPEAT STEPS 'I-IV'
	'V' WITH "FTS" TEST AND DEBUG OUR CODE		'V' WITH "FTS" TEST AND DEBUG OUR CODE
	'VI' ?? - ALL THE REST DEPENDS ON THE SPECIFIC BUSINESS PERSP		'VI' ?? - ALL THE REST DEPENDS ON THE SPECIFIC BUSINESS PERSP

2025-11-20T08:10:20Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 08:10, 20 November 2025
Line 3,975:		Line 3,975:
	8. FTS - Follow The Sherlock		8. FTS - Follow The Sherlock
	9. AYTQ - Ask Yourself The Questions		9. AYTQ - Ask Yourself The Questions
	**10. ATT - Ask The Train		**10. ATT - Ask The Train (AFTER THE COURSE - SHE'S ALL YOURS!)

	SOLVING SQL PROBLEM - STEPS/ALGO		SOLVING SQL PROBLEM - STEPS/ALGO
	I ASK AND DOUBLE CHECK WHY HOW WHAT		'I' ASK AND DOUBLE CHECK "WHY HOW WHAT"
	II DEEP DIVE INTO SURROUNDINGS (~~kydb~~)		'II' DEEP DIVE INTO SURROUNDINGS (KYDB)
	III KISS, DISP, DILTS, NF, FACS, DITW, FTS, AYTQ		'III' KISS, DISP, DILTS, NF, FACS, DITW, FTS, AYTQ
	IV AFTER EACH SMALLER PART OF DISP GO BACK TO point 'I'		'IV' AFTER EACH SMALLER PART OF "DISP" GO BACK TO point 'I'
	V WITH FTS TEST AND DEBUG OUR CODE		'V' WITH "FTS" TEST AND DEBUG OUR CODE
	VI ?? - THE REST DEPENDS ON THE SPECIFIC BUSINESS PERSP		'VI' ?? - ALL THE REST DEPENDS ON THE SPECIFIC BUSINESS PERSP
	*/		*/
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns

2025-11-20T08:03:49Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 08:03, 20 November 2025
Line 3,983:		Line 3,983:
	IV AFTER EACH SMALLER PART OF DISP GO BACK TO point 'I'		IV AFTER EACH SMALLER PART OF DISP GO BACK TO point 'I'
	V WITH FTS TEST AND DEBUG OUR CODE		V WITH FTS TEST AND DEBUG OUR CODE
	VI ??		VI ?? - THE REST DEPENDS ON THE SPECIFIC BUSINESS PERSP
	*/		*/
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns

2025-11-20T08:03:22Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 08:03, 20 November 2025
Line 3,983:		Line 3,983:
	IV AFTER EACH SMALLER PART OF DISP GO BACK TO point 'I'		IV AFTER EACH SMALLER PART OF DISP GO BACK TO point 'I'
	V WITH FTS TEST AND DEBUG OUR CODE		V WITH FTS TEST AND DEBUG OUR CODE
			VI ??
	*/		*/
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns

2025-11-20T08:03:00Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 08:03, 20 November 2025
Line 3,963:		Line 3,963:
	=== Recap of Basics, Basic Cheat Sheet (Oracle) ===		=== Recap of Basics, Basic Cheat Sheet (Oracle) ===
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	/* BEST PRACTICES:		/*
			BEST PRACTICES:
	0. KYB - Know Your Business		0. KYB - Know Your Business
	1. KYDB - Know Your Data base		1. KYDB - Know Your Data base
Line 3,974:		Line 3,975:
	8. FTS - Follow The Sherlock		8. FTS - Follow The Sherlock
	9. AYTQ - Ask Yourself The Questions		9. AYTQ - Ask Yourself The Questions
	*10. ATT - Ask The Train /		**10. ATT - Ask The Train

			SOLVING SQL PROBLEM - STEPS/ALGO
			I ASK AND DOUBLE CHECK WHY HOW WHAT
			II DEEP DIVE INTO SURROUNDINGS (kydb)
			III KISS, DISP, DILTS, NF, FACS, DITW, FTS, AYTQ
			IV AFTER EACH SMALLER PART OF DISP GO BACK TO point 'I'
			V WITH FTS TEST AND DEBUG OUR CODE
			*/
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns
	DISTINCT -- unique rows only		DISTINCT -- unique rows only

2025-11-19T09:48:50Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 09:48, 19 November 2025
Line 3,971:		Line 3,971:
	5. NF - No Friends		5. NF - No Friends
	6. FACS - Find Always Couple Solutions		6. FACS - Find Always Couple Solutions
	7. DITW - Don't reInvent The Wheel;		7. DITW - Don't reInvent The Wheel
	*8. ATT - Ask The Train /		8. FTS - Follow The Sherlock
			9. AYTQ - Ask Yourself The Questions
			*10. ATT - Ask The Train /
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns
	DISTINCT -- unique rows only		DISTINCT -- unique rows only

2025-11-17T09:41:57Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 09:41, 17 November 2025
Line 3,971:		Line 3,971:
	5. NF - No Friends		5. NF - No Friends
	6. FACS - Find Always Couple Solutions		6. FACS - Find Always Couple Solutions
	*7. ATT - Ask The Train /		7. DITW - Don't reInvent The Wheel;
			*8. ATT - Ask The Train /
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns
	DISTINCT -- unique rows only		DISTINCT -- unique rows only

2025-11-07T13:20:04Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 13:20, 7 November 2025
Line 3,963:		Line 3,963:
	=== Recap of Basics, Basic Cheat Sheet (Oracle) ===		=== Recap of Basics, Basic Cheat Sheet (Oracle) ===
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			/* BEST PRACTICES:
			0. KYB - Know Your Business
			1. KYDB - Know Your Data base
			2. KISS - Keep It Simple Stupid
			3. DISP - Divide Into Smaller Problems
			4. DILTS - Do It Like The Server
			5. NF - No Friends
			6. FACS - Find Always Couple Solutions
			*7. ATT - Ask The Train /
	SELECT -- selection query, filtering columns		SELECT -- selection query, filtering columns
	DISTINCT -- unique rows only		DISTINCT -- unique rows only

2025-11-04T08:26:33Z

Recap of Basics, Basic Cheat Sheet (Oracle)

← Older revision		Revision as of 08:26, 4 November 2025
Line 4,006:		Line 4,006:
	, "Nice alias" DESC -- descending, by alias instead of column name		, "Nice alias" DESC -- descending, by alias instead of column name
	, 3 -- position number of the element in the SELECT clause		, 3 -- position number of the element in the SELECT clause
			, col_not_in_select
			, mod(col7, 3) -- expr not in SELECT; hiding like THE PRO (Arthur The Great) (-;

	UNION -- set operator, works on sets of selects; other set opts - UNION ALL, INTERSECT, MINUS		UNION -- set operator, works on sets of selects; other set opts - UNION ALL, INTERSECT, MINUS

2025-02-20T11:18:21Z

DB setup - price_table

← Older revision		Revision as of 11:18, 20 February 2025
Line 4,022:		Line 4,022:
	=== DB setup - price_table ===		=== DB setup - price_table ===
	Collapsed by default		Collapsed by default
	~~<br />~~
	<syntaxhighlight lang="sql" class="mw-collapsible mw-collapsed">		<syntaxhighlight lang="sql" class="mw-collapsible mw-collapsed">
	-- DDL for Table PRICE_TABLE		-- DDL for Table PRICE_TABLE