Thinking About Data Systems: Reliable, Scalable, and Maintainable Applications.Context Rather than being compute-intensive, modern applications are data-intensive. Volumes, complexity, and the velocity at which data changes are increasingly the major issues. Data-intensive applications require a database to store data and retri...Jan 15, 2022 · 7 min readideocode.hashnode.dev
SQL Regular Expressions (Regexp)A regular expression is a character sequence that is used to search for and locate specific character sequences that match a pattern. You can, therefore, use it for searching text or validating input. Apart from the use of wildcards, SQL supports pat...Jan 11, 2022 · 2 min readideocode.hashnode.dev
Multiple Rows, Single Column Subqueries - Building Conditions With Operators.In my previous introductory article on subqueries, I explained that if a subquery returns multiple rows, then it cannot be used on either side of the equation condition. Fortunately, there are four additional operators that you can use to create cond...1AJan 10, 2022 · 2 min readideocode.hashnode.dev
An intro to SQL Subqueries.Subqueries remain one of the most powerful features in SQL. They can be used to filter data, generate values, and construct temporary data sets. What is a subquery? A subquery is a query contained within another statement (containing statement). It i...4AJOJan 8, 2022 · 3 min readideocode.hashnode.dev
Cyberterrorism and the role of Silicon ValleyFor the moment, at least, cyberterrorists have not harnessed the technology they would need to destroy Western civilization from a basement lab in some remote corner of the world. Although Director of National Intelligence James Clapper has said a “c...Mar 7, 2021 · 3 min readideocode.hashnode.dev
