~hackernoon | Bookmarks (8)

clear filters

sql ×

Every Developer Should Learn to Give Up Sooner

hackernoon.com

Jeffy's search dilemma highlights the importance of knowing when to give up during developer searches. By...
Jeffy's search dilemma highlights the importance of knowing when to give up during developer searches. By navigating the quagmire of information overload and effectively utilizing documentation and source code, developers can optimize their search process and find solutions efficiently. Remember: sometimes you gotta RTFM and sometimes you gotta bail.

developer-advice documentation-diving effective-research rtfm self-improvement
1
Database Management: Creating and Granting User Access in Oracle

hackernoon.com

Oftentimes, colleagues from different departments need quick access to specific datasets. The traditional method of exporting...
Oftentimes, colleagues from different departments need quick access to specific datasets. The traditional method of exporting Excel files from databases is inefficient and time-consuming. A more effective approach involves creating new user accounts in the database. This allows colleagues to seamlessly connect to the database using tools like Power BI or Power Query.

data-engineering data-security database database-management oracle
1
Using DynamoDB and Rockset to Build a Fast, Delightful Application Experience

hackernoon.com

How to use DynamoDB and Rockset together to build a fast, delightful application experience for users.

app-development data-aggregation data-analytics dynamodb rockset
1
Effective Workarounds for SQL-Style Joins in Elasticsearch

hackernoon.com

Explore various techniques for managing data relationships in Elasticsearch, including denormalization, nested documents, and parent-child relationships....
Explore various techniques for managing data relationships in Elasticsearch, including denormalization, nested documents, and parent-child relationships. Understand the challenges and benefits of each method, along with workarounds for implementing SQL-style joins in the NoSQL environment.

elasticsearch json open-source rockset sql
1
Hibernate 5 and Entities Duplication: Let’s Dive Under the Hood

hackernoon.com

Entity duplication occurs when tables are joined and multiple rows are matched. There are several methods...
Entity duplication occurs when tables are joined and multiple rows are matched. There are several methods to address this issue and they all use a Set to deduplicate entities. However, it may not work in certain scenarios due to the fact that, depending on your SELECT clause, it could return newly instantiated arrays of your selected entities for each row.

database hibernate java jpa spring
1
A Beginner's Guide to Understanding SQL Window Functions - Part 2

hackernoon.com

Let us explore more advanced SQL concepts. It may sound a bit complicated at first glance,...
Let us explore more advanced SQL concepts. It may sound a bit complicated at first glance, but I will provide simple examples suitable for beginners for all the possible cases, so it will be easy to catch my drift.

advanced-sql-concepts analytics cumulative-sum sql tools
1
Python: Setting Data Types When Using 'to_sql'

hackernoon.com

data-analyst data-engineering database pandas python
1
121 Stories To Learn About Databases

hackernoon.com

database databases learn learn-databases software-development
1

~hackernoon | Bookmarks (8)

Tags

Domains

Every Developer Should Learn to Give Up Sooner

Database Management: Creating and Granting User Access in Oracle

Using DynamoDB and Rockset to Build a Fast, Delightful Application Experience

Effective Workarounds for SQL-Style Joins in Elasticsearch

Hibernate 5 and Entities Duplication: Let’s Dive Under the Hood

A Beginner's Guide to Understanding SQL Window Functions - Part 2

Python: Setting Data Types When Using 'to_sql'

121 Stories To Learn About Databases