For Java Platform:

Ref: https://www.jooq.org/

•Hierarchical Queries

•START WITH

•CONNECT BY PRIOR

•CONNECT BY FOLLOWING

•ORDER by level

•Analytics Functions

•Windowing

•PRECEDING, UNBOUNDED_PRECEDING

•ROWS BETWEEN Unbounded Preceding

•CURRENT ROW

•RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL ‘30’ DAY Following

•ROWS BETWENN 1 PRECEDING and 1 FOLLOWING

Other Analytics Functions and Clauses:

•OVER()

•PARTITION OVER

•Over Partition By

•Avg () OVER Partition BY

•RANK()

•DENSE_RANK()

•DENSE_RANK FIRST

•DENSE_RANK LAST

•RANK or DENSE_RANK OVER

•KEEP

•Aggregate by keeping

••KEEP (DENSE_RANK FIRST ORDER BY …)

•KEEP (DENSE_RANK LAST ORDER BY …)

•RANK()

•RANK() OVER

•RANK() OVER PARTITION BY

•DENSE RANK() OVER

•DENSE RANK() OVER PARTITION BY

•PARTITION BY …. ORDER BY

•ROW_NUMBER() OVER (ORDER By …)

•ROWS BETWEEN Unbounded Preceding

•CURRENT ROW

•RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL ‘30’ DAY Following

•ROWS BETWENN 1 PRECEDING and 1 FOLLOWING

oKEEP

–Aggregate by keeping

oDENSE_RANK()

oDENSE_RANK FIRST

oDENSE_RANK LAST

oOver()

oOver Partition By

–Avg () OVER Partition BY

oROW_NUMBER

oRANK()

oDENSE_RANK

oVariations

–RANK() OVER

–RANK() OVER PARTITION BY

–DENSE RANK() OVER

–DENSE RANK() OVER PARTITION BY

–PARTITION BY …. ORDER BY

–(Partition … order by)

REF: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/CREATE-FUNCTION-statement.html

Ref: https://docs.oracle.com/database/121/LNPLS/create_procedure.htm#LNPLS01373

Tools for data integration, ETL (Extract, Transform, Load), and data management.

1. Apache NiFi

2. Pentaho Data Integration (PDI)

3. Apache Spark

4. Microsoft SQL Server Integration Services (SSIS)

5. Informatica PowerCenter

6. Apache Airflow

7. Matillion

8. Fivetran

9. Stitch

10. Apache Camel

11. Luigi

12. SnapLogic

13. DataStage (IBM)

Ref: Internet

From: https://docs.oracle.com/cd/B19306_01/server.102/b14200/expressions004.htm

Syntax:

Example:

Write a SQL block that will categorize Customers’ Credit Limit. If the limit is > 5000, show high, when 100 show low otherwise show medium. Utilize CASE statement.

SELECT cust_last_name,
   CASE credit_limit WHEN 100 THEN 'Low'
   WHEN 5000 THEN 'High'
   ELSE 'Medium' END
   FROM customers;

CUST_LAST_NAME       CASECR
-------------------- ------
...
Bogart               Medium
Nolte                Medium
Loren                Medium

Isolation => I in ACID

Supported two types:

• Read Committed
• Serializable

However, there are other levels of ISOLATION such as:

Read Uncommitted

Repeated READ

—

Note: in Read Committed, dirty data is locked until committed.

In Repeated Read, A row (being modified) is locked until committed.

In Serializable, A block/dataset/table (being modified) is locked until Serialization Terminated.

TCL/Transaction Control Language Commands

COMMIT

SET AUTOCOMMIT OFF/ON

ROLLBACK

SAVEPOINT

ROLLBACK TO SAVEPOINT

Provide Context

Provide Delimeters

Use Detailed Instructions

Refactor Prompts

Let ChatGPT ask questions for clarifications

Split complex Tasks

Use Custom Settings (you can keep the context in the custom settings) :

Use multi-modality (voice, image)

Socratic Prompting

Use Dall-E 3

“DALL·E 3 is built natively on ChatGPT, which lets you use ChatGPT as a brainstorming partner and refiner of your prompts. Just ask ChatGPT what you want to …” DALL-E: Text to image Model. DallE: ask chat gpt to create image (this may use DALLE). DallE has multi-modality.

Use proper data controls (

“Data Controls offer you the ability to turn off chat history and easily choose whether your conversations will be used to train our models. They also give you the option to export your ChatGPT data and permanently delete your account. You can find Data Controls under the Settings menu in ChatGPT. ” Ref: https://help.openai.com/en/articles/8983077-what-are-the-data-controls-settings

) You can configure Data Controls from Settings.

Delimeters:

“Delimiters are a sequence of characters or symbols that help ChatGPT understand where important places or distinct sections are located in your prompt. They play a crucial role in helping the model to understand your prompt’s structure.Oct 8, 2024″ Ref: https://libguides.uvic.ca/promptdesign/delimiters

• Socratic prompting: it involves asking and answering questions. This is how it stimulates critical thinking and generate ideas. Ref: Internet

Personas: Tell VhatGPT who you are and then what you want

From: https://thedigitalprojectmanager.com/

“10 Best Requirements Management Tools Shortlist

Here’s my pick of the 10 best software from the 18 tools reviewed.

1. 1. Jama Software — Best for enterprises
2. 2. ReqSuite® RM — Best for innovative, mid-sized companies
3. 3. ReqView — Best for end-to-end traceability
4. 4. Modern Requirements — Best for DevOps
5. 5. Visure Requirements — Best for enterprise-level customizability
6. 6. codebeamer — Best for out-of-box API integrations
7. 7. ReQtest — Best for agile requirements gathering
8. 8. xebrio — Best for requirements communication
9. 9. Doc Sheets — Best for scalability
10. 10. Perforce Helix RM — Best for test case management“

From ChatGPT:

“Here’s a list of the most advanced tools for managing business requirements in software development jobs. These tools focus on capturing, managing, and collaborating on business requirements efficiently:

1. Jira

• Best for: Agile project management, requirements tracking, and issue tracking.
• Features: Customizable workflows, backlog management, real-time collaboration, and reporting.

2. Confluence

• Best for: Documentation and collaboration, especially when paired with Jira.
• Features: Wiki-style documentation, real-time collaboration, requirement templates, and version control.

3. Microsoft Azure DevOps

• Best for: End-to-end lifecycle management, including requirements, development, and deployment.
• Features: Boards for tracking user stories, advanced reporting, and integrations with other tools.

4. IBM Engineering Requirements Management (DOORS)

• Best for: Large, complex systems and highly regulated industries.
• Features: Traceability, version control, impact analysis, and compliance tracking.

5. Aha!“

Tools for Enterprise software requirement management

From Chatgpt:

1. IBM Engineering Requirements Management DOORS

2. Jama Software

3. Microsoft Azure DevOps

4. Helix RM (formerly TestTrack)

5. Atlassian Jira