BestHub
Sign in
Tagged articles
17 articles
Page 1 of 1
Su San Talks Tech
Su San Talks Tech
Dec 10, 2024 · Databases

Master MySQL: 13 Essential Functions & Commands Every Developer Should Know

This article walks through 13 practical MySQL techniques—including group_concat, char_length, locate, replace, now, various INSERT variations, SELECT FOR UPDATE, on duplicate key update, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST, and mysqldump—providing clear examples, SQL snippets, and screenshots to help developers write more efficient and reliable queries.

QueriesSQLdatabase
0 likes · 14 min read
Master MySQL: 13 Essential Functions & Commands Every Developer Should Know
Top Architect
Top Architect
Jun 16, 2024 · Databases

20 Essential SQL Optimization Techniques for Better Query Performance

This article presents twenty practical SQL optimization techniques—including index usage, selective column queries, avoiding functions in WHERE clauses, replacing subqueries with joins, limiting result sets, using prepared statements, proper data types, and transaction handling—to improve query performance and overall database efficiency.

Database OptimizationQueriesSQL
0 likes · 11 min read
20 Essential SQL Optimization Techniques for Better Query Performance
FunTester
FunTester
Nov 25, 2022 · Databases

100 Common SQL Interview Questions with Answers and Explanations

This article presents 100 typical SQL interview questions covering basic queries, advanced techniques, and database design, illustrated with three sample tables (employee, department, job) and detailed answers, code examples, and analysis for both MySQL and Oracle implementations.

QueriesSQLSQL Advanced
0 likes · 50 min read
100 Common SQL Interview Questions with Answers and Explanations
ITPUB
ITPUB
Nov 9, 2021 · Databases

Essential MySQL Optimization Tips for Faster Queries

This guide presents practical MySQL performance tricks—including choosing minimal field types, using NOT NULL, preferring JOIN over sub‑queries, leveraging UNION, applying proper transaction control, foreign keys, table locking, indexing strategies, and query‑writing best practices—to dramatically speed up data retrieval and reduce resource consumption.

JoinsQueriesTransactions
0 likes · 19 min read
Essential MySQL Optimization Tips for Faster Queries
FunTester
FunTester
Aug 26, 2021 · Databases

Master MySQL Interview Questions: 33 Essential Queries and Answers

This article presents a complete MySQL interview guide, including a script to create and populate tables for students, teachers, courses, scores, and grades, followed by 33 common interview questions with detailed SQL solutions covering selection, aggregation, joins, subqueries, and ordering.

QueriesSQLdata import
0 likes · 19 min read
Master MySQL Interview Questions: 33 Essential Queries and Answers
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2021 · Operations

Why Prometheus’s TSDB Makes Massive Monitoring Feasible

This article explains how Prometheus turns complex monitoring into manageable tasks by introducing its core concepts, daily query examples, the advantages of its TSDB storage engine, and powerful data computation techniques that enable efficient large‑scale time‑series analysis.

PrometheusQueriesStorage Engine
0 likes · 7 min read
Why Prometheus’s TSDB Makes Massive Monitoring Feasible
Liangxu Linux
Liangxu Linux
Sep 20, 2020 · Databases

Master MySQL: Installation, Configuration, and Advanced Query Techniques

This guide provides a comprehensive overview of MySQL, covering its definition, installation steps for Windows and Linux, connection commands, database and user management, permission handling, table creation and alteration, CRUD operations, and essential data types, all illustrated with practical code examples.

CRUDPermissionsQueries
0 likes · 16 min read
Master MySQL: Installation, Configuration, and Advanced Query Techniques
Architecture Talk
Architecture Talk
Sep 30, 2018 · Backend Development

Why Event‑Driven Architecture Beats Command‑Driven Design in Microservices

This article explains how shifting from synchronous command‑driven interactions to asynchronous event‑driven flows reduces coupling, improves scalability, and enables flexible querying in distributed systems, while also discussing hybrid patterns, the single‑writer principle, and practical advantages illustrated with Kafka‑based examples.

Event-Driven ArchitectureEventsKafka
0 likes · 13 min read
Why Event‑Driven Architecture Beats Command‑Driven Design in Microservices
ITPUB
ITPUB
Nov 11, 2016 · Databases

Essential Oracle SQL Queries for Performance Monitoring and Troubleshooting

This guide compiles a comprehensive set of Oracle SQL statements and explanations for detecting fragmented tables, index fragmentation, high clustering factor tables, session and process mapping, DML lock analysis, DDL lock inspection, active SQL tracking, resource usage statistics, and various performance‑related metrics, helping DBAs diagnose and tune database behavior efficiently.

AdministrationOracleQueries
0 likes · 26 min read
Essential Oracle SQL Queries for Performance Monitoring and Troubleshooting
ITPUB
ITPUB
Nov 8, 2016 · Databases

40+ Essential Oracle SQL Queries Every DBA Should Know

This article compiles over forty practical Oracle SQL queries covering date manipulation, server information, data dictionary lookups, database administration, performance monitoring, and utility functions, providing developers with ready-to-use commands to streamline everyday database tasks.

AdministrationOracleQueries
0 likes · 16 min read
40+ Essential Oracle SQL Queries Every DBA Should Know
ITPUB
ITPUB
Apr 8, 2016 · Databases

How to Monitor and Analyze Oracle SQL Statements with Powerful Queries

This guide provides Oracle SQL queries to list currently running statements, retrieve historical SQL, identify high‑CPU or high‑disk‑usage queries, find slow statements, and detect uncommitted transactions, enabling DBAs to quickly diagnose performance issues.

Database AdministrationOraclePerformance Monitoring
0 likes · 4 min read
How to Monitor and Analyze Oracle SQL Statements with Powerful Queries
Qunar Tech Salon
Qunar Tech Salon
Mar 26, 2016 · Databases

MySQL User Management, Database and Table Operations Guide

This guide provides step‑by‑step instructions for connecting to MySQL, creating and managing users and permissions, displaying, creating and deleting databases and tables, performing backups and restores, and executing various query operations such as selecting, updating, and aggregating data.

BackupDatabase operationsQueries
0 likes · 14 min read
MySQL User Management, Database and Table Operations Guide
ITPUB
ITPUB
Mar 11, 2016 · Databases

Essential Oracle SQL Queries for DBAs: Tablespaces, Rollback Segments, and Performance Insights

A comprehensive collection of Oracle SQL statements helps database administrators quickly retrieve tablespace sizes, data file details, rollback segment information, control and log files, usage statistics, object metadata, version data, long‑running queries, partition parameters, locked objects, resource‑intensive sessions, lock and wait statuses, SGA metrics, cached objects, and SQL area details.

Database AdministrationOracleQueries
0 likes · 10 min read
Essential Oracle SQL Queries for DBAs: Tablespaces, Rollback Segments, and Performance Insights