Tagged articles
Queries
17 articles · Page 1 of 1
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.
MySQLQueriesSQL
0 likes · 14 min read

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.
Performance TuningQueriesSQL
0 likes · 11 min read

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.
InterviewQueriesSQL
0 likes · 50 min read


ITPUBNov 9, 2021 · Databases
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.
JoinsMySQLQueries
0 likes · 19 min read

This comprehensive guide covers essential SQL concepts, clause usage, aggregate functions, view creation, sequences, indexes, and a collection of classic interview questions with detailed solutions, helping readers deepen their database knowledge and ace SQL interviews.
InterviewQueriesSQL
0 likes · 30 min read

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.
InterviewMySQLQueries
0 likes · 19 min read

This guide provides a thorough walkthrough of SQL fundamentals, including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, aggregate functions, joins, set operations, Oracle-specific objects, DDL/DML commands, and a collection of classic interview questions with complete query examples and performance tips.
InterviewQueriesSQL
0 likes · 27 min read

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.
PrometheusQueriesTSDB
0 likes · 7 min read

This article presents a comprehensive collection of 50 SQL interview questions, complete with sample queries that demonstrate various operations such as joins, subqueries, aggregations, updates, and deletions on student, course, teacher, and enrollment tables.
CourseInterviewQueries
0 likes · 24 min read

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.
CRUDMySQLQueries
0 likes · 16 min read

This article provides concise answers to common MySQL questions covering default ports, regular expression usage, index limits, query examples for retrieving rows, date functions, savepoints, ENUM types, storage engines, connection functions, ACLs, and other essential database concepts.
MySQLQueriesSQL
0 likes · 9 min read

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.
EventsKafkaQueries
0 likes · 13 min read


ITPUBNov 11, 2016 · Databases
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


ITPUBNov 8, 2016 · Databases
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


ITPUBApr 8, 2016 · Databases
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.
OraclePerformance MonitoringQueries
0 likes · 4 min read

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.
MySQLQueriesRestore
0 likes · 14 min read


ITPUBMar 11, 2016 · Databases
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.
OracleQueriesSQL
0 likes · 10 min read
