SQL Queries For Mere Mortal Chapter 4: Creating a Simple Query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortal-chapter-4-creating-a-simple-query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortal-chapter-4-creating-a-simple-query
Compare and Find Row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), HASHBYTES()
In this post, we will be looking at how to detect and identify row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), and HASHBYTE() functions. There are use cases where comparing or detecting row changes in the table is necessary like when a ...
Read: https://mssqlserver.dev/compare-and-find-row-changes-in-sql-server-with-checksum-binarychecksum-hashbytes
In this post, we will be looking at how to detect and identify row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), and HASHBYTE() functions. There are use cases where comparing or detecting row changes in the table is necessary like when a ...
Read: https://mssqlserver.dev/compare-and-find-row-changes-in-sql-server-with-checksum-binarychecksum-hashbytes
CFGFWK-60850: Test Failed! Error
The topic of today’s article is CFGFWK-60850: Test Failed! Error. If you get CFGFWK-60850: Test Failed! Error during weblogic domain creation while installing Oracle middleware products, it means that the Wizard cannot communicate with the database. This may come up with messages such as version incompatibility or user name and password error in different ways, …
Read: CFGFWK-60850: Test Failed! Error.
The topic of today’s article is CFGFWK-60850: Test Failed! Error. If you get CFGFWK-60850: Test Failed! Error during weblogic domain creation while installing Oracle middleware products, it means that the Wizard cannot communicate with the database. This may come up with messages such as version incompatibility or user name and password error in different ways, …
Read: CFGFWK-60850: Test Failed! Error.
9. Consistency and Consensus
This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...
Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz
This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...
Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz
SQL Queries For Mere Mortals: Creating a Simple Query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-creating-a-simple-query
Simple Select Statment:
Don't write SQL Query immediately after reading the problem statement:
Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...
Read: https://samra.hashnode.dev/sql-queries-for-mere-mortals-creating-a-simple-query
Building a data tech-stack
Data stack
A data stack is a set of tools and technologies built to facilitate the movement, storage and access to data in a business and transforming the data into actionable insights.
Components of data stack
Data source-This is where the data or...
Read: https://dorothycheruiyot.hashnode.dev/building-a-data-tech-stack
Data stack
A data stack is a set of tools and technologies built to facilitate the movement, storage and access to data in a business and transforming the data into actionable insights.
Components of data stack
Data source-This is where the data or...
Read: https://dorothycheruiyot.hashnode.dev/building-a-data-tech-stack
Updates, Order, & the Binlog
Imagine you had two separate databases, a read-write master and a read-only slave, and you wanted to keep a table between them synchronized. Writes would occur on the master table and should eventually appear on the slave table. To synchronize the da...
Read: https://nav610.hashnode.dev/updates-order-and-the-binlog
Imagine you had two separate databases, a read-write master and a read-only slave, and you wanted to keep a table between them synchronized. Writes would occur on the master table and should eventually appear on the slave table. To synchronize the da...
Read: https://nav610.hashnode.dev/updates-order-and-the-binlog
Flutter Hive: Blazing fast Key-Value storage
Intro to Hive
Data persistence is one of the most important aspects of any mobile application. A mobile application always keeps some type of state, such as user information, game scores, the user's current position, and so on.
Data persistence inv...
Read: https://dhruvnakum.xyz/flutter-hive-blazing-fast-key-value-storage
Intro to Hive
Data persistence is one of the most important aspects of any mobile application. A mobile application always keeps some type of state, such as user information, game scores, the user's current position, and so on.
Data persistence inv...
Read: https://dhruvnakum.xyz/flutter-hive-blazing-fast-key-value-storage
Query Editor In Azure Portal
In today’s article, we will talk about Query Editor In Azure Portal. Microsoft Azure added a previewer feature for SQL Databases called Query Editor. This feature is browser-based and is a query editor used on the portal. As seen in the picture below, we can access the required field in the SQL database through the …
Read: Query Editor In Azure Portal.
In today’s article, we will talk about Query Editor In Azure Portal. Microsoft Azure added a previewer feature for SQL Databases called Query Editor. This feature is browser-based and is a query editor used on the portal. As seen in the picture below, we can access the required field in the SQL database through the …
Read: Query Editor In Azure Portal.
Executing Files with .Bin and .Sh Extensions on Linux OS
In this article, we will talk about Executing Files with .Bin and .Sh Extensions on Linux OS. This simple subject is one of the first commands to learn for beginners to the Linux operating system. As usual in Windows operating systems, all .exe , .bat etc. extensions can be run with the ease of double-clicking, …
Read: Executing Files with .Bin and .Sh Extensions on Linux OS.
In this article, we will talk about Executing Files with .Bin and .Sh Extensions on Linux OS. This simple subject is one of the first commands to learn for beginners to the Linux operating system. As usual in Windows operating systems, all .exe , .bat etc. extensions can be run with the ease of double-clicking, …
Read: Executing Files with .Bin and .Sh Extensions on Linux OS.
Standby Max Data Delay
In today’s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this …
Read: Standby Max Data Delay.
In today’s article, we will talk about Standby Max Data Delay. While some of the reporting users who make inquiries from Active Data Guard expect the retrieved data to be the same as the Production at that moment, others do not care if LAG has been formed for a few seconds. The time until this …
Read: Standby Max Data Delay.
How To Setup Physical Standby Database
In today’s article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard installation on Primary and Standby databases in Oracle 11g R2 architecture is explained using SQL*Plus and RMAN without using OEM. Operating system : RedHat 5.9 Database Software : Oracle 11g R2 Cluster …
Read: How To Setup Physical Standby Database.
In today’s article, we will look for an answer to the question of How To Setup Physical Standby Database. In this article, DataGuard installation on Primary and Standby databases in Oracle 11g R2 architecture is explained using SQL*Plus and RMAN without using OEM. Operating system : RedHat 5.9 Database Software : Oracle 11g R2 Cluster …
Read: How To Setup Physical Standby Database.
Import Dat File Into PostgreSQL
In today’s article we will cover the topic of Import Dat File Into PostgreSQL. Sometimes we need to import/export some tables in PostgreSQL. In this article, we will import the .dat file on PostgreSQL into the table. While doing this, we will do it through pgadmin, which is the simplest and easiest way. First of …
Read: Import Dat File Into PostgreSQL.
In today’s article we will cover the topic of Import Dat File Into PostgreSQL. Sometimes we need to import/export some tables in PostgreSQL. In this article, we will import the .dat file on PostgreSQL into the table. While doing this, we will do it through pgadmin, which is the simplest and easiest way. First of …
Read: Import Dat File Into PostgreSQL.
Remotely Connect PostgreSQL Running on Azure Linux VM
In today’s article, I will explain the topic of Remotely Connect PostgreSQL Running on Azure Linux VM. In order to do this, we need to edit the pg_hba.conf and postgresql.conf files. These files are located in /etc/postgresql/version_info/main. The version information here varies according to the installed PostgreSQL version information. On our server, the access method …
Read: Remotely Connect PostgreSQL Running on Azure Linux VM.
In today’s article, I will explain the topic of Remotely Connect PostgreSQL Running on Azure Linux VM. In order to do this, we need to edit the pg_hba.conf and postgresql.conf files. These files are located in /etc/postgresql/version_info/main. The version information here varies according to the installed PostgreSQL version information. On our server, the access method …
Read: Remotely Connect PostgreSQL Running on Azure Linux VM.
Basic Linux Command
In today’s article I will give information about Basic Linux Command. Cd : You can enter the specified folder with the cd command and you can go to the home directory of the user you are connected to from the directory you are connected to by simply typing cd. After the cd command, you write …
Read: Basic Linux Command.
In today’s article I will give information about Basic Linux Command. Cd : You can enter the specified folder with the cd command and you can go to the home directory of the user you are connected to from the directory you are connected to by simply typing cd. After the cd command, you write …
Read: Basic Linux Command.
Why CockroachDB Serverless is the real deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
Physical migration of Oracle databases to Amazon RDS Custom using Data Guard
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Day 1/100
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1