Database
2023-05-14
ACID Properties
This article covers the ACID properties in database transactions, explaining their importance and role in ensuring data integrity and reliability.
Database
2023-05-12
Database
This article provides an overview of databases, including their types, management systems, and the use of SQL in relational databases, with a focus on relational and NoSQL databases.
Database
2023-04-08
Column-Oriented Database
This article explains the column-oriented databases, their unique approach to data storage as well as disadvantages.
Database
2023-04-07
B-Tree Index
This article covers the B-Tree index, its advantages, considerations for choosing indexed columns, creating B-Tree indexes, and scenarios where using B-Tree indexes may not be beneficial.
Database
SQL
2023-04-07
Index in Database
This article explains the database indexes, their purposes, how they work, and the different types available.
Database
2023-04-07
Building a MySQL Environment with Docker
This article introduces how to create a MySQL 8.0 environment using Docker, allowing you to quickly set up a MySQL server for development or testing purposes without the need for manual installation and configuration.
Database
MySQL
Docker
2023-04-07
Building a PostgreSQL Environment with Docker
This article introduces how to create a PostgreSQL environment using Docker, allowing you to quickly set up a PostgreSQL server for development or testing purposes without the need for manual installation and configuration.
Database
PostgreSQL
Docker
2023-04-06
Normalization in Database
This article explains the concepts of normalization and denormalization in databases.
Database
2023-03-20
Partitioning in SQL
This article explains the concept of partitioning in SQL, its advantages, and various types of partitioning methods available, including range partitioning, list partitioning, hash partitioning, key partitioning, and subpartitioning.
Database
SQL
2023-03-20
Transaction in PostgreSQL
This article explains transaction control in PostgreSQL, including the usage of commands like BEGIN TRANSACTION, COMMIT, and ROLLBACK, and discusses their limitations. It also provides example demonstrations of using ROLLBACK and COMMIT commands to undo or save changes made to a table in a transaction.
Database
PostgreSQL
2023-03-19
SQL Tuning Techniques
This article introduces fundamental strategies and techniques to optimize SQL queries, including index utilization, avoiding meaningless sorting, reducing repetitive processing, and minimizing the number of SQL executions.
Database
SQL
2023-03-17
SQL Tuning
This article introduces various techniques to optimize SQL queries, including column selection, table aliasing and systematic flow.
Database
SQL
2023-03-14
DDL, DLM, DCL in SQL
This article explains the fundamental concepts of Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) in SQL databases.
Database
SQL
2023-03-14
Cost-Based Optimizer (CBO)
This article explains the Cost-Based Optimizer (CBO) and its role in creating efficient execution plans for SQL queries, considering factors such as statistical information, indexes, and data volume.
Database
SQL
2023-03-14
Full Table, Index Unique, and Index Range Scans
This article provides an overview of SQL scanning methods, including Full Table Scan, Index Unique Scan, and Index Range Scan, and discusses their use cases and factors to consider when selecting between them.
Database
SQL
2023-03-13
CASE Statement in SQL
This article provides an overview of the CASE statement in SQL, including its usage, types (simple and searched), examples, and its application in ORDER BY and UPDATE statements, as well as handling NULL values.
Database
SQL
2023-03-12
CHAR, VARCHAR and TEXT in Database
This article provides an overview of string data types in databases, including CHAR, VARCHAR, and TEXT, explaining their characteristics, space allocation and use cases.
Database
MySQL
2023-03-12
Bind Variable in SQL
This article explains the concept of bind variables in SQL, discussing their role in optimizing performance, preventing SQL injection attacks, and improving scalability.
Database
SQL
2023-03-12
SQLFluff
This article introduces SQLFluff, an open-source tool that automatically detects and corrects formatting issues in SQL queries.
Database
SQL
2023-03-11
Locking in Database
This article explains the locking in databases, covering types of locks, lock levels, transactional impact, and deadlock resolution strategies.
Database
2023-03-11
MySQL Cheat Sheet
This article provides a cheat sheet for the most common operations in MySQL, covering topics such as connecting to MySQL, performing database operations, and managing tables, including creating databases, listing tables, and displaying table structures.
Database
MySQL
2023-03-10
Data Type Mappings Between MySQL and PostgreSQL
This article compares the data types between MySQL and PostgreSQL, describing their similarities and differences in terms of capacity and functionality.
Database
MySQL
PostgreSQL
2023-03-09
PostgreSQL Cheat Sheet
This article provides a PostgreSQL cheat sheet, featuring frequently used commands and queries for quick reference.
Database
PostgreSQL
2023-03-08
Window Functions in SQL
This article explains the window functions in SQL, covering their purpose, structure, and comparing them with the GROUP BY clause.
Database
SQL
2023-03-07
EXISTS in SQL
This article explains the EXISTS operator in SQL, covering the differences between EXISTS and IN, and the usage of correlated and uncorrelated subqueries to optimize performance.
Database
SQL
2023-03-05
NoSQL
This article provides an overview of NoSQL databases, exploring their key characteristics, benefits, and the different types available. The article explains document stores, key-value stores, column-family stores, graph databases, and time-series databases.
Database
NoSQL
2023-03-05
GROUP_CONCAT in MySQL
This article explains the GROUP_CONCAT function in MySQL, which allows concatenation of data from multiple rows into a single field.
Database
MySQL
2023-03-05
Transactions in MySQL
This article provides an overview of transactions in MySQL, covering the concepts of beginning, ending, and terminating transactions.
Database
MySQL
2023-03-04
What is SQL Injection -Understanding the Dangers and How to Prevent It-
This article discusses the concept of SQL injection and the dangers it poses to database-driven applications. SQL injection attacks can lead to loss, manipulation, or destruction of sensitive data, unauthorized access, financial losses, legal liability, and reputational damage.
Database
SQL
2023-03-04
SQL Joins
This article explains the different types of SQL joins - Inner, Left, Right, and Outer joins. SQL joins are used to combine rows from two or more tables based on related columns.
Database
SQL
2023-03-04
Using Nested WITH Clauses in SQL
This article discusses the use of nested WITH clauses in SQL, which allows for the creation of complex queries by nesting one or more Common Table Expressions (CTEs) inside another CTE.
Database
SQL
2023-03-04
Self Join in SQL
This article explores self join in SQL, which is a tool for managing and analyzing complex data structures. It involves joining a table to itself, creating a self-referential relationship between the data.
Database
SQL
2023-03-04
SQL WITH Clause
This article explores the SQL WITH clause, a powerful tool that can simplify complex queries and improve query performance.
Database
SQL
2023-03-02
Subquery in SQL
This article explains the concept of subqueries in SQL and their syntax and usage.
Database
SQL
AlloyDB
Amazon Cognito
Amazon EC2
Amazon ECS
Amazon QuickSight
Amazon RDS
Amazon Redshift
Amazon S3
API
Autonomous Vehicle
AWS
AWS API Gateway
AWS Chalice
AWS Control Tower
AWS IAM
AWS Lambda
AWS VPC
BERT
BigQuery
Causal Inference
ChatGPT
Chrome Extension
CircleCI
Classification
Cloud Functions
Cloud IAM
Cloud Run
Cloud Storage
Clustering
CSS
Data Engineering
Data Modeling
Database
dbt
Decision Tree
Deep Learning
Descriptive Statistics
Differential Equation
Dimensionality Reduction
Discrete Choice Model
Docker
Economics
FastAPI
Firebase
GIS
git
GitHub
GitHub Actions
Google
Google Cloud
Google Search Console
Hugging Face
Hypothesis Testing
Inferential Statistics
Interval Estimation
JavaScript
Jinja
Kedro
Kubernetes
LightGBM
Linux
LLM
Mac
Machine Learning
Macroeconomics
Marketing
Mathematical Model
Meltano
MLflow
MLOps
MySQL
NextJS
NLP
Nodejs
NoSQL
ONNX
OpenAI
Optimization Problem
Optuna
Pandas
Pinecone
PostGIS
PostgreSQL
Probability Distribution
Product
Project
Psychology
Python
PyTorch
QGIS
R
ReactJS
Regression
Rideshare
SEO
Singer
sklearn
Slack
Snowflake
Software Development
SQL
Statistical Model
Statistics
Streamlit
Tabular
Tailwind CSS
TensorFlow
Terraform
Transportation
TypeScript
Urban Planning
Vector Database
Vertex AI
VSCode
XGBoost
