Explain Codes LogoExplain Codes Logo

Best Articles — Page 133

A beginner's guide to SQL database design

sql
database-design
data-integrity
sql-queries

Jquery counting elements by class - what is the best way to implement this?

javascript
javascript-features
jquery-usage
best-practices

Using SQL count in a case statement

sql
conditional-aggregates
sql-functions
best-practices

How to check if a folder exists?

java
file-system
directory-structure
symbolic-links

How to use a calculated column to calculate another column in the same view

sql
prompt-engineering
best-practices
performance

Select multiple columns from a table, but group by one

sql
join
groupby
subqueries

How to get on scroll events?

javascript
event-listeners
scroll-events
angular

How to Remove the Close Button on the jQuery UI Dialog?

javascript
prompt-engineering
jquery-ui-dialog
close-button

Java Pass Method as Parameter

java
method-references
java-8
design-patterns

How to flatten a hierarchical index in columns

python
dataframe
pandas
best-practices

How to use table variable in a dynamic sql statement?

sql
temp-tables
dynamic-sql
performance

Installing a local module using npm?

javascript
npm-link
local-modules
package-management

Explanation of self-joins

sql
self-join
data-normalization
performance-optimization

Checking if an element exists with Python Selenium

python
selenium
webdriver
explicit-wait

How to restore PostgreSQL dump file into Postgres databases?

sql
database-management
backup-and-restore
postgresql

What's the difference between <b> and <strong>, <i> and <em>?

html
semantic-web
accessibility
seo

Fill remaining vertical space - only CSS

html
responsive-design
css
flexbox

How to print VARCHAR(MAX) using Print Statement?

sql
dynamic-slicing
varchar-max
print-statement

Describe table structure

sql
information-schema
sql-queries
database-structure

Check if a key exists in a bucket in S3 using boto3

python
boto3
s3
aws-sdk