Özgür Özkök
SQL stands for Structured Query Language. It is a language used to manage data in relational database management systems (RDBMS).
RDBMSs are database management systems that store data in tables. Each table consists of rows and columns. The rows represent individual data records, and the columns represent the different pieces of data about each record.
SQL is a declarative language, meaning you tell the database what you want to do, not how.
The EXPLAIN command in MySQL is used to obtain information about how a SELECT, INSERT, UPDATE, or DELETE statement will be executed. It provides information about the query execution plan and the estimated number of rows that will be examined for each table in the query. The data from EXPLAIN […]
Here’s a list of some of MySQL’s time functions with SQL samples: NOW() – returns the current date and time in the format ‘YYYY-MM-DD HH:MM:SS’ Example: SELECT NOW(); CURDATE() – returns the current date in the format ‘YYYY-MM-DD’ Example: SELECT CURDATE(); CURTIME() – returns the current time in the format […]
Date functions in MySQL are a set of functions that allow you to manipulate and extract date and time values from expressions, columns, or literals. Date functions help perform various operations on dates, such as finding the difference between two dates, adding or subtracting intervals from a date, formatting a […]
I use Amazon as a cloud service in my new Java/Kotlin projects. I couldn’t easily find a complete list of AWS modules. I was able to create this shortlist as a result of the reviews. Compute EC2 Virtual Private Servers Lightsail Amazon’s hosting provider (VPS, DNS, storage) Lambda Functions […]
I am sharing a sample and full DevOps Stack by Simon Reymann Our whole DevOps stack consists of the following tools: The main reason we have chosen Kubernetes over Docker Swarm is related to the following artifacts: for the original post and comments please visit https://stackshare.io/zimoony/decisions/104069607668616391 and my StackShare profile is https://stackshare.io/ozgurozkok
Debezium is an open-source distributed platform that turns your existing databases into event streams so that applications can see and respond almost instantly to each committed row-level change in the databases. Debezium is built on top of Kafka and provides Kafka Connect compatible connectors that monitor specific database management systems. Debezium records the history […]
pgloader loads data into PostgreSQL. The official site is https://pgloader.io/ pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today! Introduction pgLoader has two modes of operation. It […]
This video details the SQL and NoSQL Basics, Comparison, Pros and Cons of When to use what, etc. SQL (Structured Query Language) and NoSQL (Not only SQL) are two broad categories of database management systems that differ in how they store, process and retrieve data. SQL databases are based on […]
“Debezium (noun | de·be·zi·um | /dɪ:ˈbɪ:ziːəm/) – secret ingredient for change data capture” Updating caches and full-text indexes, synchronizing data between microservices, maintaining different read models in a CRQS-style architecture, and feeding operational data to your analytics tools — just a few use cases which benefit so much from streaming […]
CREATE TABLE COMPANY( ID INTEGER PRIMARY KEY AUTOINCREMENT, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL );