# [sql](https://hackernoon.com/tagged/sql) Domain-specific language for stream processing or data management in a relational database management system ### [1. How to Сompress a mysqldump Backup Using Gzip](https://hackernoon.com/how-to-sompress-a-mysqldump-backup-using-gzip-901v3wb6)  What is mysqldump? ### [2. Cloud Services Will Take Over the World, says Noonies Nominee and Python Teacher, Veronika](https://hackernoon.com/cloud-services-will-take-over-the-world-says-noonies-nominee-and-python-teacher-veronika)  2021 Noonies Nominee General Interview with Veronika. Read for more on cloud services, data engineering, and python. ### [3. Create and Execute Stored Procedure in PHPMyAdmin](https://hackernoon.com/create-and-execute-stored-procedure-in-phpmyadmin-i1z32r0)  First of all what is Stored Procedure? ### [4. With JSONB Data in PostgreSQL, You Can Get the Best of Both Worlds](https://hackernoon.com/with-jsonb-data-in-postgresql-you-can-get-the-best-of-both-worlds)  JSONB in PostgreSQL offers the best of relational and NoSQL. Here are two techniques that we use at AppLand to make JSONB data even more effective. ### [5. A Tool to Help Fix SQL Code Using ChatGPT](https://hackernoon.com/a-tool-to-help-fix-sql-code-using-chatgpt)  With ChatGPT's help, you can now make the most out of your SQL queries. ### [6. Python & Data Engineering: Under the Hood of Join Operators ](https://hackernoon.com/python-and-data-engineering-under-the-hood-of-join-operators)  In this post, I discuss the algorithms of a nested loop, hash join, and merge join in Python. ### [7. 14 Open Source SQL Parsers](https://hackernoon.com/14-open-source-sql-parsers)  Parsing SQL queries provides superpowers for monitoring data health. This post describes how to get started on parsing SQL for data observability. ### [8. 6 Best SQL Programming Books Ranked by Reviews](https://hackernoon.com/6-best-sql-programming-books-ranked-by-reviews)  SQL Practice Problems and SQL for Dummies are some of the best SQL programming books on the market based on review score. ### [9. Every Way Natural Language is Better Than SQL](https://hackernoon.com/every-way-natural-language-is-better-than-sql-272t3yts)  Since the dawn of time, humans have communicated through gestures, drawings, smoke, or speech. Along the way, Structured Query Language (SQL) made its way into human life so we could speak to databases. However, it’s time to revert back to our natural language and rethink how we talk to our data. ### [10. 3 Ways to Deal With Hibernate N+1 Problem](https://hackernoon.com/3-ways-to-deal-with-hibernate-n1-problem)  Hibernate N+1 issue occurs when you use FetchType.LAZY for your entity associations. ### [11. The Story of Dwayne Richard Hipp and the Development of SQLite in 1999](https://hackernoon.com/the-story-of-dwayne-richard-hipp-and-the-development-of-sqlite-in-1999-yc4v356q)  The story of SQLite and it's inventor D. Richard Hipp. A proof of how open source software movement is destined to change the world in a positive direction. ### [12. PostgreSQL diff Explained](https://hackernoon.com/postgresql-diff-explained-14kv3ygl)  Normal development flow requires continuous patching the production database with local changes normally made automatically by the orm software, this method is not perect but deceptively simple, all we'll use is standard Unix commands, and is good enough for us. ### [13. How to Install and Configure PHP for Apache and MySQL](https://hackernoon.com/how-to-install-and-configure-php-for-apache-and-mysql-wb1m33z1)  In this article, we explain how to install PHP, Apache, and MySQL and then find out how to configure PHP. ### [14. The Importance Of Staying Humble And Strong Company Culture: Stephen Goldberg, HarperDB CEO](https://hackernoon.com/the-importance-of-staying-humble-and-strong-company-culture-stephen-goldberg-harperdb-ceo)  Harper DB is a startups of the year nominee from Denver, Colorado. Stephen Goldberg, CEO, shares the origin story and what makes their company culture relevant. ### [15. The Fastest Way to Become A Professional Data Analyst](https://hackernoon.com/the-fastest-way-to-become-a-professional-data-analyst)  Sharyph, a tech writer, goes over how to become a professional data analyst. ### [16. How to Write Raw SQL Query Migration in Laravel ](https://hackernoon.com/how-to-write-raw-sql-query-migration-in-laravel)  We have created a laravel package to keep the track of raw SQL migration using package Laravel raw sql query migration ### [17. The Noonification: 6 Best SQL Programming Books Ranked by Reviews (12/17/2022)](https://hackernoon.com/12-17-2022-noonification)  12/17/2022: Top 5 stories on the Hackernoon homepage! ### [18. Introducing FBSQL: Frontend Backend SQL Server](https://hackernoon.com/introducing-fbsql-frontend-backend-sql-server-qu223w23)  Work (secure) with your backend database within HTML ### [19. Understanding the Command Query Responsibility Segregation Pattern](https://hackernoon.com/understanding-the-command-query-responsibility-segregation-pattern)  ### [20. Querty: Bringing the Power of SQL to REST APIs in your Web App](https://hackernoon.com/querty-bringing-the-power-of-sql-to-rest-apis-in-your-web-app)  Make your REST API easier to work with using Querty and SQL queries. ### [21. The Noonification: 16 SQL Techniques Every Beginner Needs to Know (2/11/2023)](https://hackernoon.com/2-11-2023-noonification)  2/11/2023: Top 5 stories on the Hackernoon homepage! ### [22. How to query JSONB, beginner sheet cheat](https://hackernoon.com/how-to-query-jsonb-beginner-sheet-cheat-4da3aa5082a3)  Let’s say we have to query a user table with a metadata JSONB column on a PostgreSQL 9.5+ database. ### [23. Retrieving your SQL LocalDB Instance Name: A How-To Guide](https://hackernoon.com/retrieving-your-sql-localdb-instance-name-a-how-to-guide-pu2c33p8)  This command displays some info about the specified SQL instance: this info includes the version, the owner, and the current state. ### [24. 10 Free Resources to Become a Health Data Scientist](https://hackernoon.com/10-free-resources-to-become-a-health-data-scientist)  Becoming a health data scientist can be challenging but rewarding; it merges statistical analysis with other tools to gain insights from healthcare data. ### [25. JDBC Tutorial Part 3: How to Use Database Connection Pools](https://hackernoon.com/jdbc-tutorial-part-3-how-to-use-database-connection-pools)  Learn what database connection pools are, why you should use them, and how ### [26. Data Lakes Are Crucial To Business Analytics and Big Data Processing](https://hackernoon.com/data-lakes-are-crucial-to-business-analytics-and-big-data-processing-014335sk)  While the term Data is in cognizance of business of all sizes even the most layman person is aware of the buzz and fuss around Data. So from Database to Data Warehouse and now this Data Lake, we have come a long way. ### [27. How to Solve Race Conditions in a Booking System](https://hackernoon.com/how-to-solve-race-conditions-in-a-booking-system)  Race conditions in a database and how you can solve them using techniques such as pessimistic and optimistic concurrency control. ### [28. How to Efficiently Manage Queues in SQL Databases](https://hackernoon.com/how-to-efficiently-manage-queues-in-sql-databases)  A queue using an SQL-database? well, you need to know pros and cons, and a typical implementation. ### [29. Decoding MySQL EXPLAIN Query Results for Better Performance](https://hackernoon.com/decoding-mysql-explain-query-results-for-better-performance)  Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query. ### [30. SubQuery to Provide Indexing and Querying Infrastructure to Developers on Algorand ](https://hackernoon.com/subquery-to-provide-indexing-and-querying-infrastructure-to-developers-on-algorand)  SubQuery is a blockchain developer toolkit that makes it easier to build upcoming Web3 apps. ### [31. Your Guide To Schema-based, Multi-Tenant Systems and PostgreSQL Implementation](https://hackernoon.com/your-guide-to-schema-based-multi-tenant-systems-and-postgresql-implementation-gm433589)  There are several architectures that could be followed to achieve multi-tenancy at the database layer. ### [32. Alternative Overview of the SSMSBoost Add-in for SQL Server Management Studio (SSMS)](https://hackernoon.com/alternative-overview-of-the-ssmsboost-add-in-for-sql-server-management-studio-ssms)  Today we will do a short review and features comparison of dbForge SQL Complete and SSMSBoost. ### [33. How SQL Database Engine Work](https://hackernoon.com/how-sql-database-engine-work-483e32o7)  For now, I am assuming that you all know what is SQL or you have some experience with SQL or you are using SQL for many years. I know many people who know so much about SQL and even have created many projects based on SQL and they do not know what is SQL engine or how actually SQL database engine works. It’s obvious no one’s care about the internal working of SQL engine or something because without knowing How SQL works we can still create and access database using any SQL program. ### [34. How to Make Rough Estimates of SQL Queries](https://hackernoon.com/how-to-make-rough-estimates-of-sql-queries)  To do estimates of SQL queries we need to understand how DB works with queries. Let's find out what exactly the db do with queries. ### [35. FastAPI with Materialize for Real-Time Data Processing: An Essential Guide](https://hackernoon.com/fastapi-with-materialize-for-real-time-data-processing-an-essential-guide)  This is a self-contained demo of FastAPI and Materialize. ### [36. How I Connected MySQL Shell Over SSH](https://hackernoon.com/how-i-connected-mysql-shell-over-ssh)  Until recently, I had only used MySQL Shell to connect to a local instance of MySQL running on my development machine. ### [37. Customizing MariaDB Docker Images](https://hackernoon.com/customizing-mariadb-docker-images)  How to customize MariaDB Docker images: Execute SQL and shell scripts when the containers start and pass configuration files. ### [38. The Roadmap to Learning SQL in 90 Days](https://hackernoon.com/the-roadmap-to-learning-sql-in-90-days)  A Zero to SQL 90 Days Roadmap ### [39. 10 Best Online Courses to Learn Oracle and PL/SQL for Beginners ](https://hackernoon.com/10-best-online-courses-to-learn-oracle-and-plsql-for-beginners)  ### [40. Unexpected Discoveries in TypeORM 0.3.11](https://hackernoon.com/unexpected-discoveries-in-typeorm-0311)  TypeORM is an ORM tool for TypeScript, supports popular databases and make it easy to interact with them. Upgrade to v0.3.11 for new features and improvements. ### [41. 7 Useful SQL Resources for Beginners](https://hackernoon.com/most-useful-sql-resources-f8q3254)  In this post, I have compiled some of the most useful SQL resources that I recommend to everyone who wants to study SQL. Depending on how much time you can invest and the type of course one would prefer, I have segregated the resources into different segments. So, let’s begin: ### [42. SQLAlchemy is a Better Way to Run Queries](https://hackernoon.com/sqlalchemy-is-a-better-way-to-run-queries)  In college, I discovered a new and even better way to run queries, SQLAlchemy. ### [43. How to Efficiently Generate Test Data With SQL](https://hackernoon.com/how-to-efficiently-generate-test-data-with-sql)  There are a large number of utilities for generating test data. Here are some examples of using SQL queries to generate test data. ### [44. Improving your experience with Criteria API using Builder pattern and JPA Static Metamodel - Part II](https://hackernoon.com/improving-your-experience-with-criteria-api-using-builder-pattern-and-jpa-static-metamodel-part-ii)  An extension for the Criteria API using Builder pattern and JPA Static Metamodel Generator to increase readability and reduce read complexity with explicitness ### [45. A Brief Introduction to MongoDB](https://hackernoon.com/a-brief-introduction-to-mongo-db)  MongoDB is a document-oriented NoSQL database for storing large amounts of data. MongoDB uses collections and documents instead of tables and rows ### [46. How to Improve Query Speed to Make the Most out of Your Data](https://hackernoon.com/how-to-improve-query-speed-to-make-the-most-out-of-your-data)  In this article, I will talk about how I improved overall data processing efficiency by optimizing the choice and usage of data warehouses. ### [47. A Web3 Native Database: Tableland](https://hackernoon.com/a-web3-native-database-tableland)  Smart contract developers need a web3 native database to decouple dapps and data. Tableland makes a nice try. ### [48. Why You Should Learn SQL to Boost Your Career](https://hackernoon.com/why-you-should-learn-sql-to-boost-your-career-dx1v33r3)  Out of 13 million new jobs that have been created in the United States in the last 10 years, over 8.5 million have required skills in technology. ### [49. How to import your MS SQL database to Amazon RDS](https://hackernoon.com/how-to-import-your-ms-sql-database-to-amazon-rds-lv5337rm)  I will show you how to create a database in the cloud, connect it to MS SQL, deploy from a database backup. ### [50. The Most Commonly Used SQL Queries by Data Scientists](https://hackernoon.com/the-most-commonly-used-sql-queries-by-data-scientists)  SQL (Structured Query Language) is a programming tool or language that is widely used by data scientists and other professionals ### [51. Configuring SQL Server for High Availability in the Cloud](https://hackernoon.com/configuring-sql-server-for-high-availability-in-the-cloud-rs4b36ns)  Every big Cloud service provider offers you guaranteed SLAs availability about 99.95 %, and this percentage of availability can make you think that cloud is perfect for a SQL Server deployment which requires High Availability. Azure and AWS are the two giants of cloud services, and their geographical distribution of data centers can leverage you to think of cloud for a SQL server development configured with disaster recovery. ### [52. JDBC Tutorial Part 2: How to Run SQL Queries](https://hackernoon.com/jdbc-tutorial-part-2-how-to-run-sql-queries)  Learn how to securely run SQL queries from Java apps using JDBC to prevent SQL injection attacks ### [53. Applying Statistical Analysis to Intraday Forex Trading Using SQL](https://hackernoon.com/applying-statistical-analysis-to-intraday-forex-trading-using-sql)  Statistical Analysis, Intraday Forex Trading, Using SQL ### [54. What is the Future for SQL Developers in a Machine Learning World?](https://hackernoon.com/what-is-the-future-for-sql-developers-in-a-machine-learning-world-9l3k3yi8)  Do you know the machine learning global market is estimated to reach $30.6 billion by 2024? This marvellous growth is the outcome of Omni-presence of artificial intelligence and its trending subset; machine learning. ### [55. How to Persist Data in a Flutter App](https://hackernoon.com/how-to-persist-data-in-a-flutter-app)  In this article, we will explore the different ways to persist data in a Flutter app, and the pros and cons of each method. ### [56. A Primer on Decoupling SQL Engines from Hive Data Warehouse](https://hackernoon.com/a-primer-on-decoupling-sql-engines-from-hive-data-warehouse)  Are you using SQL engines, such as Presto, to query existing Hive data warehouse and experiencing challenges? ### [57. Building a Large-Scale Interactive SQL Query Engine with Open Source Software](https://hackernoon.com/building-a-large-scale-interactive-sql-query-engine-with-open-source-software-ww2z3yf6)  This is a collaboration between Baolong Mao's team at JD.com and my team at Alluxio. The original article was published on Alluxio's blog. This article describes how JD built an interactive OLAP platform combining two open-source technologies: Presto and Alluxio. ### [58. Take your Materialized Views to the Next Level by Joining MySQL and Postgres](https://hackernoon.com/take-your-materialized-views-to-the-next-level-by-joining-mysql-and-postgres)  ### [59. Using dbt with Materialize and Redpanda](https://hackernoon.com/how-to-use-dbt-with-materialize-and-redpanda)  ### [60. Intro to Databases: Using Different Data Models and Representing Databases Visually](https://hackernoon.com/intro-to-databases-using-different-data-models-and-representing-databases-visually-bn7c3x37)  As you get into the Databases and Data Science, the first thing that you have to master is the relations between entities in your database. That is important because the data that you use has to be absolutely efficient for its further implementations. ### [61. Optimizing SQL Queries With JPA Repositories](https://hackernoon.com/optimizing-sql-queries-with-jpa-repositories)  Today I would like to talk about how you can optimize work with JPA repositories and improve performance by avoiding native SQL queries in the code. ### [62. An Overview of Database Indexing for Beginners](https://hackernoon.com/an-overview-of-database-indexing-for-beginners)  Database Indexing is the most common way known and utilized by backend developers to optimize database queries. ### [63. Logging in Observability - Part 2](https://hackernoon.com/logging-in-observability-part-2)  In this article, I want to describe how to work with logs, analyze them in the command line, and we will consider new modern tools to visualize logs. ### [64. "SQL Will Help You Achieve Your Goals" - Jarosław Błąd, Vertabelo CEO ](https://hackernoon.com/sql-will-help-you-achieve-your-goals-jaroslaw-blad-vertabelo-ceo)  We spoke to Jarosław Błąd, CEO at Vertabelo about how he set up his website based around teaching people how to code using SQL and the motivations behind it. ### [65. Getting started with Distributed SQL](https://hackernoon.com/getting-started-with-distributed-sql)  ### [66. Cloud Computing Explained: What is Serverless SQL and Why Should You Care?](https://hackernoon.com/cloud-computing-explained-what-is-serverless-sql-and-why-should-you-care-5y3t33z5)  Serverless SQL is a distributed computing tool that enables us to process distributed data using SQL language without managing the databases servers themselves. ### [67. How to do Database Read/Write Splitting With Your Browser](https://hackernoon.com/how-to-do-database-readwrite-splitting-with-your-browser)  A tutorial that explains how a database proxy like MariaDB MaxScale serves as a transparent read/write splitter that scales SQL queries. ### [68. Use Feature Toggle to Safely Release Updates On Your Server](https://hackernoon.com/use-feature-toggle-to-safely-release-updates-on-your-server)  No matter how much effort is put into the development of fault-tolerant self-sustainable systems, manual interventions are inevitable. ### [69. Generating Unique Values for Test Data in MySQL](https://hackernoon.com/generating-unique-values-for-test-data-in-mysql)  Generating unique values for test data in MySQL ### [70. The Hitchhiker's Guide to Laravel Vapor](https://hackernoon.com/the-hitchhikers-guide-to-laravel-vapor)  An honest review of the migration process to a serverless architecture using Laravel, AWS and Laravel Vapor written by someone with 18 years of experience. ### [71. Learn How To Group Data in SQL Using The GROUP BY Clause [Tutorial]](https://hackernoon.com/grouping-data-in-sql-s7r32zx)  Learn how to group data in SQL using the GROUP BY clause. In this article, I’ll show you this process by using a sample of marketing data. ### [72. Postgres: Idle queries and pg_locks](https://hackernoon.com/postgres-idle-queries-and-pg-locks-216b207c3e39)  Getting postgres unstuck when it seems to “hang” or be super slow on queries ### [73. Exploring PL/SQL Nested Tables in Oracle](https://hackernoon.com/exploring-plsql-nested-tables-in-oracle-gx1v3ufk)  In this tutorial, you will learn how to declare and initialize Oracle PL/SQL collections (Nested Tables). ### [74. Small-scale Logs Processing and Analysis](https://hackernoon.com/small-scale-logs-processing-and-analysis)  Occasionally you need to process some HTTP server logs and extract analytical data from them. ### [75. 5 Ways to Store Market Data: CSV, SQLite, Postgres, Mongo, Arctic](https://hackernoon.com/5-ways-to-store-market-data-csv-sqlite-postgres-mongo-arctic)  What's the most efficient way to store market data? SQL or NoSQL? Let's compare 5 most common options and find out what is best. ### [76. Apache Druid, TiDB, ClickHouse, or Apache Doris? A Comparison of OLAP Tools](https://hackernoon.com/apache-druid-tidb-clickhouse-or-apache-doris-a-comparison-of-olap-tools)  The OLAP experience of an automobile manufacturer. ### [77. Super Duper SQL Tips for Software Engineers](https://hackernoon.com/super-duper-sql-tips-for-software-engineers)  In this post, we will talk about the features of working with SQL. We will talk about how you can possibly improve your database queries and speed up your app ### [78. Learning SQL Can Give You a Major Career Boost](https://hackernoon.com/learning-sql-can-give-you-a-major-career-boost)  Why learning SQL is a major career boost with LogicLoop ### [79. Improving Your Experience With CriteriaAPI Using Builder Pattern and JPA Static Metamodel - Part III](https://hackernoon.com/improving-your-experience-with-criteriaapi-using-builder-pattern-and-jpa-static-metamodel-part-iii)  An extension for the Criteria API using Builder pattern and JPA Static Metamodel Generator to reduce complexity with explicitness and to increase readability ### [80. Fear database changes? Get them under control with CI/CD](https://hackernoon.com/database-changes-can-be-scary-how-r1hy2gfe)  Developers often fear database changes because a mistake by anyone on your team can lead to a major outage and even data loss. The stakes are higher when changes are not backwards compatible, cannot be rolled back, or impact system performance. This can cause a lack of confidence and slow your team velocity. As a result, database changes are a common failure point in agile and DevOps.  ### [81. Why Are We Teaching Pandas Instead of SQL?](https://hackernoon.com/why-are-we-teaching-pandas-instead-of-sql)  How I learned to stop using pandas and love SQL. ### [82. Introducing Bun: A Golang ORM ](https://hackernoon.com/introducing-bun-a-golang-orm)  Bun is a SQL-first Golang ORM for PostgreSQL, MySQL/MariaDB, MSSQL, and SQLite. It supports migrations, fixtures, and performance monitoring. ### [83. Getting Started with MariaDB using Docker, Python and Flask](https://hackernoon.com/getting-started-with-mariadb-using-docker-python-and-flask-pa1i3ya3)  Since being forked from MySQL back in 2009, MariaDB has become one of the most popular databases of choice for developers over the past decade. While many technologists have likely gravitated to it as a solution due to its open source roots and that it's rooted in the relational database world, that really only begins to scratch the surface of what MariaDB has to offer. ### [84. Please Don't Use OFFSET and LIMIT For Your Pagination](https://hackernoon.com/please-dont-use-offset-and-limit-for-your-pagination-8ux3u4y)  Gone are the days when we wouldn’t need to worry about database performance optimization. ### [85. How to Configure VS Code for Java in 2022](https://hackernoon.com/configuring-vs-code-for-java)  VS Code is Java-ready! Learn which extensions to use and how to configure it to start coding Java in a modern IDE. ### [86. A Guide to Importing Smartsheet Data into SQL Server using SSIS](https://hackernoon.com/import-smartsheet-data-into-sql-server-using-ssis-ag1g3wlb)  Easily back up Smartsheet data to SQL Server using the SSIS components for Smartsheet. ### [87. An Essential Plan to Get Your SQL Knowledge Ready for Interviews](https://hackernoon.com/an-essential-plan-to-get-your-sql-knowledge-ready-for-interviews-xc3a3te0)  SQL is the cornerstone of a wide variety of data-intensive roles, and it is not going anywhere soon. Loads have been written about its usefulness already, so this post is focused on getting your skills from C to A+ for your interviews. No knowledge is assumed, and I feel comfortable promising that your level will be more than enough for what will be asked in interviews if you follow this game-plan. ### [88. NoSQL vs SQL: Comparison From the Development Team](https://hackernoon.com/nosql-vs-sql-comparison-from-the-development-team)  Let’s dive into the main types of databases, their main features, and their working principles. And also development differences to be more practical.  ### [89. Jython: The Love Child of Python and Java](https://hackernoon.com/jython-the-love-child-of-python-and-java-bz2h3520)  Jython is an implementation of Python that runs on Java. For the most part, it is compatible with Python 2.7. ### [90. My Personal Guide to SQL Window Functions (Part 2) ](https://hackernoon.com/my-personal-guide-to-sql-window-functions-part-2)  First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can be difficult to grok. ### [91. Hybrid Data Models: How To Have Your JSON Cake and Eat MariaDB Too](https://hackernoon.com/hybrid-data-models-how-to-have-your-json-cake-and-eat-maria-db-too)  By adding support for JSON, MariaDB provides the ultimate schema flexibility without sacrificing transactions or data integrity. ### [92. How to Set Up a Dedicated Database Server for Analytics](https://hackernoon.com/how-to-set-up-a-dedicated-database-server-for-analytics)  Have that old laptop that's just in the back of your closet? Figure out how to give it a new life! ### [93. Understanding SQL's Application in Data Science [A Deep Dive]](https://hackernoon.com/understanding-how-sql-is-used-in-data-science-g31l328a)  To learn about SQL, we need to understand how a DBMS works. DBMS or Database Management System is essentially a software to create and manage databases. ### [94. How to Quickly and Efficiently Create Tests for MySQL](https://hackernoon.com/how-to-quickly-and-efficiently-create-tests-for-mysql)  How to quickly and efficiently create tests for MySQL without installing any additional utilities. ### [95. What the Heck is PRQL?](https://hackernoon.com/what-the-heck-is-prql)  Another clever tool for a powerful SQL pre-processor ### [96. SQLite vs Realm: Which Database to Choose in 2021?](https://hackernoon.com/sqlite-vs-realm-which-database-to-choose-in-2021-8g1v3wf9)  Image a situation wherein you have just launched your app. But the data of your app is not being properly displayed or you are not able to fetch the data that is being entered by the users. What will be the impression of your app in the user’s mind? ### [97. How To Create and Load Test Data in PostgreSQL](https://hackernoon.com/how-to-create-and-load-test-data-in-postgresql-i41e353m)  Learn what tools and approaches are available to create and load test data for webapps without an ORM. ### [98. How Useful is PostgreSQL Full Text Search](https://hackernoon.com/how-useful-is-postgresql-full-text-search-u39242fi)  PostgreSQL is the jack of all trades when it comes to databases. It brings you all the features you've come to love about SQL plus a bunch of features from Non-SQL databases. Some of these Non-SQL features like the JSONB data type are wonderful and you don't even have to dare flirt with another database. Others are good but not as robust and featureful as other databases. ### [99. How to Quickly Get Started With PHP and MariaDB](https://hackernoon.com/how-to-quickly-get-started-with-php-and-mariadb)  A simple tutorial on how to get started with PHP and MariaDB. ### [100. How to Query Multiple Results with Dapper ORM Efficiently ](https://hackernoon.com/how-to-query-multiple-results-with-dapper-orm-efficiently)  Dapper is a powerful and lightweight Object-Relational Mapping (ORM) tool for C#. It is designed to be simple and fast, allowing developers to execute SQL query ### [101. Nontechnical Explanation for Why Relational Databases Don't Work ](https://hackernoon.com/nontechnical-explanation-for-why-relational-databases-dont-work-b7jd321a)  This is What I’m Telling Business People About Why Relational Databases Are So Bad ### [102. An Intro to SQL for Data Scientists](https://hackernoon.com/an-intro-to-sql-for-data-scientists)  The importance of SQL and how to go about learning it ### [103. What’s the Database Plus Concept and What Challenges Can It Solve?](https://hackernoon.com/whats-the-database-plus-concept-and-what-challenges-can-it-solve)  Explaining the Database Plus concept, its impact on system architecture design, and its innovations: from Proxyless Service Mesh to microservice backend support ### [104. Taking a Closer Look into Google's AlloyDB Architecture for PostgreSQL](https://hackernoon.com/taking-a-closer-look-into-googles-alloydb-architecture-for-postgresql)  An exploration of AlloyDB's architecture and design, focussing on its storage engine, with descriptions of how it handles reads and writes ### [105. ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples](https://hackernoon.com/shardingsphere-proxy-front-end-protocol-troubleshooting-guide-and-examples)  Case study: introducing the tools used in database protocol development with a troubleshooting guide for ShardingSphere-Proxy MySQL protocol issues. ### [106. 10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!](https://hackernoon.com/10-minute-guide-to-fixing-damaged-sql-databases-no-recovery-required)  In this article, I covered the use of a freeware application called FDR which can help you recover corrupt or damaged MS SQL databases. ### [107. An Online PHP & SQL Sandbox That I Created now use ChatGPT to fix your code](https://hackernoon.com/phpize-an-online-php-and-sql-sandbox-that-i-created)  PHPize.online is a project I have been working on for the last 2 years. ### [108. Comparing Different Time-Series Databases](https://hackernoon.com/comparing-different-time-series-databases)  A comparison of data models used in open-source SQL and NoSQL time-series databases for IoT. ### [109. Is GraphQL Still a Thing in 2020?](https://hackernoon.com/is-graphql-still-a-thing-in-2020-ob143tra)  GraphQL has become the most loved tool for API development in a very short span of time, and developers across the world cannot seem to get enough of it. Today I met with the founder of Windsor.io, Pranay Prakash, who has worked on the team behind GraphQL during his time at Facebook. I chatted with him to find out more about his experience working closely with Lee Byron, the creator of GraphQL, and some of GraphQL’s benefits. ### [110. Learning Self JOIN Queries With SQLZOO](https://hackernoon.com/learning-self-join-queries-with-sqlzoo-xc163ue7)  This article uses Exercise number 10 on the Self JOIN SQL ZOO tutorial to teach self JOINs in a beginner-friendly way. ### [111. 16 SQL Techniques Every Beginner Needs to Know](https://hackernoon.com/16-sql-techniques-every-beginner-needs-to-know)  This blog post explains the most intricate data warehouse SQL techniques in detail. ### [112. How to use NLP to SQL API?](https://hackernoon.com/how-to-use-nlp-to-sql-api-i31tu30cc)  Data is useless without the ability to easily get and act on it. The success of future enterprises will combine sophisticated information collection with better user experience, and the Natural Language User Interface comprises much of this user experience. ### [113. Stream and Display Data in Realtime with Materialize and Adonis](https://hackernoon.com/stream-and-display-data-in-realtime-with-materialize-and-adonis)  In this tutorial, we are going to build a web application using AdonisJS and integrate it with Materialize to create a real-time dashboard ### [114. How to Create a View in SQL and Its Uses](https://hackernoon.com/how-to-create-a-view-in-sql-and-its-uses)  This brief article on VIews in SQL explains how to create a view and other various operations in a step-by-step explanation. ### [115. How to Connect With External MySQL Servers (Part 1: Select Operations)](https://hackernoon.com/how-to-connect-with-external-mysql-servers-part-1-select-operations-o52c34wl)  This tutorial shows how to perform basic select queries to interact with MySQL Server using mysql2 gem. ### [116. How To Improve Data Quality for More Efficient Business Operations](https://hackernoon.com/how-to-improve-data-quality-for-more-efficient-business-operations)  Need to fix inconsistent data? This article covers how to improve data quality using real-world examples, and why data quality is an issue. ### [117. How to Enable MariaDB Replication: A Guide](https://hackernoon.com/how-to-enable-mariadb-replication-a-guide)  To set up replication for a new fresh MariaDB server, you can just enable the binary log in the primary and configure the connection in the replica. ### [118. Top Tech Skills Employers Demand in 2020](https://hackernoon.com/top-tech-skills-employers-want-in-2020-d94042s0)  Soft skills matter in the tech world, but if you don’t know the right programming language or platform, you probably won’t get the job.  ### [119. 5 Best Courses to Learn MySQL Database for Beginners](https://hackernoon.com/5-best-courses-to-learn-mysql-database-for-beginners)  If you are interested in learning SQL with MySQL database then you have come to the right place. ### [120. How To Add Data Sensitivity Classification Command in SQL Server 2019](https://hackernoon.com/how-to-add-data-sensitivity-classification-command-in-sql-server-2019-g6253ws4)  For a database administrator, the common everyday practice involves running multiple operations targeted at ensuring database security and integrity. Thus, we shouldn’t overlook the importance of sensitive data stored in the database under any circumstances. In light of this, we are excited to demonstrate the new ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019, which allows adding the sensitivity classification metadata to database columns. ### [121. Do Modern Technologies Like Serverless Really Offer Better Benefits?](https://hackernoon.com/do-modern-technologies-like-serverless-really-offer-better-benefits)  Remember mainframes? Serverless is pretty much that: we own the machine and you rent out time on our big iron. We went full circle on progress! ### [122. Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2)](https://hackernoon.com/decoding-mysql-explain-query-results-for-better-performance-part-2)  Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query. ### [123. PGSync Introduction: Real-time Integration Tool For PostgreSQL And Elasticsearch](https://hackernoon.com/pgsync-introduction-real-time-integration-tool-for-postgresql-and-elasticsearch-6r103tll)  PGSync is a change data capture tool for moving data from Postgres to Elasticsearch. It allows you to keep Postgres as your source-of-truth and expose structured denormalized documents in Elasticsearch. ### [124. Accelerating Analytics by 200% with Impala, Alluxio, and HDFS at Tencent](https://hackernoon.com/accelerating-analytics-by-200percent-with-impala-alluxio-and-hdfs-at-tencent-o5h3u1v)  This article describes how engineers in the Data Service Center (DSC) at Tencent PCG (Platform and Content Business Group) leverages Alluxio to optimize the analytics performance and minimize the operating costs in building Tencent Beacon Growing, a real-time data analytics platform.  ### [125. Running Presto Engine in a Hybrid Cloud Architecture](https://hackernoon.com/running-presto-engine-in-a-hybrid-cloud-architecture-3vq3ujy)  Migrating Presto workloads from a fully on-premise environment to cloud infrastructure has numerous benefits, including alleviating resource contention and reducing costs by paying for computation resources on an on-demand basis. In the case of Presto running on data stored in HDFS, the separation of compute in the cloud and storage on-premises is apparent since Presto’s architecture enables the storage and compute components to operate independently. The critical issue in this hybrid environment of Presto in the cloud retrieving HDFS data from an on-premise environment is the network latency between the two clusters. ### [126. 2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use](https://hackernoon.com/2019-database-trends-sql-vs-nosql-top-databases-single-vs-multiple-database-use-ly1cu3z18)  Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL, MongoDB, PostgreSQL, Redis, and many others to see which database management systems are most favored this year. ### [127. How to Query Deeply Nested JSON Data in PSQL](https://hackernoon.com/how-to-query-deeply-nested-json-data-in-psql)  Recently I had to write a script, which should’ve changed some JSON data structure in a PSQL database. Here are some tricks I learned along the way. ### [128. Another Solution To Sam Saffron’s Annoying INSERT Problem](https://hackernoon.com/another-answer-to-sam-saffrons-annoying-insert-problem-x62ir35ee)  I explain how Mighty, following Rob Conery’s Massive, implements a great answer to “that annoying INSERT problem” that Sam Saffron never mentioned. ### [129. How to Manage Multiple Databases in Rails 6](https://hackernoon.com/how-to-manage-multiple-databases-in-rails-6-ye6x3ypv)  With the launch of Rails 6, one of the new features that were announced was of multiple database support. ### [130. Top 5 Ways To Prevent SQL Injections](https://hackernoon.com/top-5-ways-to-prevent-sql-injections-ro2e35ba)  An attacker can quickly push multiple SQL injection sequences in a python script that runs very fast and cramp up more data than you think in a single sitting. ### [131. How to Get Started With JPA/Hibernate](https://hackernoon.com/how-to-get-started-with-jpahibernate)  JPA was born as the acronym for Java Persistence API. ### [132. An In-Depth Guide to Blue-Green Deployments with Materialize](https://hackernoon.com/an-in-depth-guide-to-blue-green-deployments-with-materialize)  Minimizing downtime during any deployment is a key part of any successful deployment strategy. There are many ways to achieve this. ### [133. Sharing My Experience Attending MS Build 2020](https://hackernoon.com/sharing-my-experience-attending-ms-build-2020-519y3whj)  This year was a special edition of MS Build; for obvious reasons, it was 100% virtual. I must say that I had my doubts at first, but I'm forced to admit that Microsoft nailed it. The experience was fantastic. I liked the personal schedule builder and the rebroadcast in 3 different timezones, to only name a few things. Microsoft even took the time to ship the conference's gear to all attendees, DIRECTLY to their doorstep, what a nice touch. ### [134. Architecture Evolution for Interactive Queries](https://hackernoon.com/architecture-evolution-for-interactive-queries)  Presto and Alluxio working together enable a unified, robust, high-performance, low-latency, and cost-effective analytics architecture. ### [135. Spring Boot Performance Workshop with Vlad Mihalcea](https://hackernoon.com/spring-boot-performance-workshop-with-vlad-mihalcea)  Learn how to improve the performance of a Spring application and diagnose problems in production. Lessons from our live workshop covering JPA! ### [136. Which Database Is Right For You? HarperDB vs. MongoDB vs. PostgreSQL](https://hackernoon.com/which-database-is-right-for-you-harperdb-vs-mongodb-vs-postgresql-8m6a35uf)  The purpose of this article is not to determine which database is the best but to help determine which is a fit for your specific project. ### [137. How We Collaborated with Meta (Facebook) to Create Shadow Cache](https://hackernoon.com/how-we-collaborated-with-meta-facebook-to-create-shadow-cache)  Shadow cache is deployed in Meta (Facebook) Presto and is being leveraged to understand the system bottleneck and help with routing design decisions. ### [138. A Guide to Running ASP.NET Core & SQL Server from Docker](https://hackernoon.com/a-guide-to-running-aspnet-core-and-sql-server-from-docker-wu4034xc)  I've recently gotten into using Docker in my development cycle and I'm really enjoying how much of a wonderful tool it is. One thing that always used to be a pain was setting up a development server to run SQL Server. Now with Docker, I can just spin up a Docker container and I instantly have a SQL Server ready to go. ### [139. Migrating Away From Query Builders and ORMs in JavaScript or TypeScript](https://hackernoon.com/migrating-from-query-builders-and-orms-in-javascript-or-typescript-gc113uh0)  I spent the better part of a day moving a project completely off of the ORM we were using (TypeORM). Ever since I started doing web development, I’ve been using some kind of heavy abstraction on top of my database. Whether it’s Mongoose when I used MongoDB, or TypeORM when I decided to move to TypeScript and PostgreSQL. However, it turns out that ORMs and query builders aren’t so great. I used to be that person that thought ORMs and query builders did the job for me, and I used it as an excuse to not learn SQL (which is what everyone tells you NOT to do). Given the tools that exist today, I would wholeheartedly recommend doing it the opposite of how I did if you’re starting off new to these things — write your SQL stuff by hand, or with help from the tools I mention later in the post. It’ll feel really slow at first, but you’ll thank yourself later 😄 ### [140. Solving Noom's Data Analyst Interview Questions](https://hackernoon.com/solving-nooms-data-analyst-interview-questions)  Noom helps you lose weight. We help you get a job at Noom. In today’s article, we’ll show you one of Noom’s hard SQL interview questions. ### [141. Azure Data Factory: An Amazing Data Migration Tool](https://hackernoon.com/azure-data-factory-an-amazing-data-migration-tool-1u1e34hd)  This blog will highlight how users can define pipelines to migrate the unstructured data from different data stores to structured data via Azure Data Factory ### [142. How to Connect Your Bastion Server to a PostgreSQL Server with an SSH Tunnel](https://hackernoon.com/how-to-connect-your-bastion-server-to-a-postgresql-server-with-an-ssh-tunnel-pw3g35lt)  In this article, you'll learn how to connect to an RDS server through a bastion server in Bash using an SSH tunnel. ### [143. How To Connect MariaDB Docker Containers with Java Spring And JDBC](https://hackernoon.com/how-to-connect-mariadb-docker-containers-with-java-spring-and-jdbc-ex243urb)  Since being forked from MySQL back in 2009, MariaDB has become one of the most popular databases of choice for developers over the past decade. While many technologists have likely gravitated to it as a solution due to its open source roots and that it's rooted in the relational database world, that really only begins to scratch the surface of what MariaDB has to offer. ### [144. Do Product Managers Need to Understand SQL and Python?](https://hackernoon.com/do-product-managers-need-to-understand-sql-and-python)  We asked our Product Management community, ‘Do Product Managers Need SQL/ Python?' Read all about what they had to say. ### [145. What is the Significance of Time-Weighted Averages in Data Analysis](https://hackernoon.com/what-is-the-significance-of-time-weighted-averages-in-data-analysis)  Learn how time-weighted averages are calculated, why they’re so powerful for data analysis, and how to use TimescaleDB hyperfunctions to calculate them faster. ### [146. My Personal Guide to SQL Window Functions (Part 1)](https://hackernoon.com/my-personal-guide-to-sql-window-functions-part-1)  First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can be difficult to grok. ### [147. How Hot Does it Get Inside a Car During a Heat Wave?](https://hackernoon.com/how-hot-does-it-get-inside-a-car-during-a-heat-wave-a13u37y4)  Using a Raspberry Pi to measure the temperature inside a Ford Focus during a record-breaking heatwave. ### [148. Establish Your Data Team Early Using These Tools and Techniques ](https://hackernoon.com/establish-your-data-team-early-using-these-tools-and-techniques)  Start building your data strategy team and architecture as soon as you can. A one-person data team can make a massive difference to your success as you grow. ### [149. How to Install and Use Materialize to Run SQL Queries on your nginx Logs](https://hackernoon.com/how-to-install-and-use-materialize-to-run-sql-queries-on-your-nginx-logs)  In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will ### [150. Technical Data Science Interview Questions: SQL and Coding](https://hackernoon.com/technical-data-science-interview-questions-sql-and-coding-jv1k32bf)  A data science interview consists of multiple rounds. One of such rounds involves theoretical questions, which we covered previously in 160+ Data Science Interview Questions. ### [151. How To Manage Sensitive Data Using SQL Data Discovery and Classification](https://hackernoon.com/how-to-manage-sensitive-data-using-sql-data-discovery-and-classification-661g3wpm)  The 17.5 version of SQL Server Management Studio (SSMS) brought with it a new built-in security tool. Since then, the Data Discovery and Classification feature has become a difference-maker in the protection of sensitive information. ### [152. Introducing Apache ShardingSphere 5.2.0!](https://hackernoon.com/introducing-apache-shardingsphere-520)  ShardingSphere 5.2.0 is released bringing new cloud-native possibilities, elastic migration from Oracle, MySQL, and PostgreSQL, and more features & enhancements ### [153. How You Can Take Advantage of Hazelcast to Query Your IMDG Data](https://hackernoon.com/how-you-can-take-advantage-of-hazelcast-to-query-your-imdg-data-6s6734ld)  Though IMDGs are sometimes generically described as a distributed in-memory data store, IMDGs offer more than just storage. Learn why and how you query IMDG. ### [154. Performance Testing of Python ORMs Based on the TPC-C benchmark](https://hackernoon.com/performance-testing-of-python-orms-based-on-the-tpc-c-benchmark-ae3g3yis)  Object-relational mappers (ORMs) are often used in Python programming when one needs to develop an application that works with databases. Examples of Python ORMs are SQLAlchemy, Peewee, Pony-ORM and Django. When choosing an ORM,  performance plays a crucial role. But how are these toolsets compared? ORM performance benchmarks offer a measure of clarity but leave considerable room for improvement. I examine and extend the qualitative ORM benchmark to develop a stronger metric. ### [155. Using Upsolver To Get Insights Into Your Company's Big Data](https://hackernoon.com/using-upsolver-to-get-insights-into-your-companys-big-data)  Upsolver is a no-code data lake engineering platform for agile cloud analytics. Let's see how easy it is to use. ### [156. Top 10 Microsoft SQL Server Tips](https://hackernoon.com/top-10-microsoft-sql-server-tips-dmu327t)  There is a lot of information about different T-SQL features. I want to tell you about equally useful, but less popular tips for working with this language! ### [157. SQL Injections: Beginners Guide](https://hackernoon.com/sql-injections-beginners-guide-8t13z3v17)  The basics of how to test and protect your application ### [158. The SAS (Statistical Analysis System) Response To SQL Challenges in a Data Warehouse Environment](https://hackernoon.com/the-sas-statistical-analysis-system-response-to-sql-challenges-in-a-data-warehouse-environment-80h335j)  As computing hardware became more powerful, so datasets grew. SAS in turn evolved to harness greater computational power and meet the data challenge. ### [159. A Snap Is Worth A Thousand Words (Podcast Transcript)](https://hackernoon.com/a-snap-is-worth-a-thousand-words-podcast-transcript-jl1b35k2)  Is database migration as scary as it sounds? Amy Tom talks to Matt Groves, Senior PM Manager at Couchbase, and Curt Gratz, Co-Owner of CKH Consulting. ### [160. How To Restore Your Database From a SQL Backup](https://hackernoon.com/how-to-restore-your-database-from-a-sql-backup-c14e35sf)  Backing up SQL and databases using the manual restore method, the full database backup, the incremental restore, or the manageauditing command. ### [161. 3 Tools to Make Growing and Scaling your Side Projects Easier](https://hackernoon.com/3-tools-to-make-growing-and-scaling-your-side-projects-easier-cj3l347a)  Growing a side project is hard. Ex-Clourflare dev shares 3 easy to use tools to help you get more signups, analyze user data, and monitor production errors. ### [162. How To Create A User Portal On Airtable With Sync Inc And React](https://hackernoon.com/how-to-create-a-user-portal-on-airtable-with-sync-inc-and-react-nd1c35h9)  In this tutorial, you’ll see how to build a scalable, secure, and flexible client portal on Airtable using Sync Inc, Cotter, and Next.js. ### [163. How To Create Secure Registration Flow with PHP and Password Hashing](https://hackernoon.com/how-to-create-secure-registration-flow-with-php-and-password-hashing-nw1b3t1z)  Building a secure user registration form with PHP seems like a scary task. How do I protect myself from MySQL injection and other methods of hacking. Surprisingly, with only a few steps and precautions, you can greatly reduce the chance of success for attacks. ### [164. What Happened to Hadoop? What Should You Do Now?](https://hackernoon.com/what-happened-to-hadoop-what-should-you-do-now-3i1i3v6r)  by Monte Zweben & Syed Mahmood of Splice Machine ### [165. Top 12 FAQs About PostgreSQL](https://hackernoon.com/top-12-faqs-about-postgresql-je263uwk)  PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for all major platforms including Linux, UNIX, Windows, and OS X. It allows you to add custom functions developed using different programming languages such as C/C++, Java, etc. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server. ### [166. The United Kingdom's New National Data Strategy (Summary and Analysis)](https://hackernoon.com/the-united-kingdoms-new-national-data-strategy-summary-and-analysis-ci2s3efi)  This Article is a Summary for the official National Data Strategy release here ### [167. Types Of Medical Databases And Their Benefits For Humanity](https://hackernoon.com/types-of-medical-databases-and-their-benefits-for-humanity-gk1j34a3)  What are medical databases?Medical Databases serve as an essential part in medical care, which includes the disciplines of research, documentation, patient care and treatment. The medical industry is constantly on the lookout for new medical applications, which would help improve their services. These endeavors are usually done through databases, which store data regarding diseases, diagnosis, treatments, medication, medical devices, medical practices and other pertinent details about medical professionals. With the constant advancements made in technology, these databases have also grown to be more technologically advanced and complex. ### [168. The Rise of Reusable SQL-based Data Modeling Tools and DataOps services](https://hackernoon.com/the-resurgence-of-sql-based-rdbms-if-there-is-one-analytics-trend-we-can-all-agree-on-it-is-that-we-0iy32i5)  The resurgence of SQL-based RDBMS ### [169. Write Code to Build Your Own Playlist and Throw Away Spotify](https://hackernoon.com/write-code-to-build-your-own-playlist-and-throw-away-spotify)  You don't need a whole music cloud service to get music recommendations ### [170. How to Extract Knowledge from Wikipedia, Data Science Style](https://hackernoon.com/how-to-extract-knowledge-from-wikipedia-data-science-style-ee9u34qo)  As Data Scientists, people tend to think what they do is developing and experimenting with sophisticated and complicated algorithms, and produce state of the art results. This is largely true. It is what a data scientist is mostly proud of and the most innovative and rewarding part. But what people usually don’t see is the sweat they go through to gather, process, and massage the data that leads to the great results. That’s why you can see SQL appears on most of the data scientist position requirements. ### [171. Using a Relational Database to Query Unstructured Data](https://hackernoon.com/using-a-relational-database-to-query-unstructured-data)  Using Relational Database to search inside unstructured data ### [172. Querying Complex JSON Objects With SQL](https://hackernoon.com/querying-complex-json-objects-with-sql-6kr34h9)  How many times have you run into a situation where you wish you could do a SQL join without getting duplicate rows back? What if we could get a list "column" returned instead? HarperDB’s ARRAY() function enables just that. In this post we’re going to take a look at a basic example of people with addresses and phone numbers. ### [173. Build your Own Live Chart With Deno, WebSockets, Chart.js and Materialize](https://hackernoon.com/build-your-own-live-chart-with-deno-websockets-chartjs-and-materialize)  We will build a simple dashboard app that displays data from a Deno Web Socket server. ### [174. Intro to Structured Query Language (SQL)](https://hackernoon.com/intro-to-structured-query-language-sql-uy2237bx)  In the post, I used a simple SQL query to explain how certain things work in SQL. I also outlined problems with the query and potential ways to improve the code ### [175. What is an SQL Injection Attack? How To Prevent SQL Injection Vulnerabilities ](https://hackernoon.com/what-is-an-sql-injection-attack-how-to-prevent-sql-injection-vulnerabilities-xo5r35wz)  The best way to prevent SQL injection vulnerabilities is to use a framework that allows you to construct and parameterize queries safely. An ORM works well. ### [176. Improving your experience with Criteria API using Builder pattern and JPA Static Metamodel - Part I](https://hackernoon.com/improving-your-experience-with-criteria-api-using-builder-pattern-and-jpa-static-metamodel-part-i)  An extension for the Criteria API using Builder pattern and JPA Static Metamodel to increase readability and reduce read complexity with explicitness ### [177. JDBC Tutorial Part 1: How to Connect to a Database](https://hackernoon.com/jdbc-tutorial-part-1-how-to-connect-to-a-database)  Learn how to use databases from Java ### [178. NoSQL: A Brief History and the DynamoDB Challenge](https://hackernoon.com/nosql-a-brief-history-and-the-dynamodb-challenge-7c2u34b8)  Dynamo accelerated the NoSQL revolution that’s driving the database industry. ### [179. We need Roslyn for SQL!](https://hackernoon.com/we-need-roslyn-for-sql)  Code review and other quality assurance methods are incredibly useful tools that can be facilitated by Roslyn which is not available for SQL, though it should. ### [180. Postgres and MySQL: Performance Comparisson](https://hackernoon.com/postgres-and-mysql-performance-comparisson-qs3s35g1)  What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency. ### [181. Finessing Postgres into an Insane 200x Faster Query Plan](https://hackernoon.com/finessing-postgres-into-an-insane-200x-faster-query-plan)  This article will show you a real-life optimization story and how PostgreSQL row count estimation can go very wrong when trying to get a faster query plan ### [182. Check Out These 8 Free SQL Courses to Learn About Oracle, MySQL, and SQL Server](https://hackernoon.com/check-out-these-8-free-sql-courses-to-learn-about-oracle-mysql-and-sql-server)  SQL is very important and many programmers realize this, however, I have found that many more programmers just don't spend much time improving their SQL skills. ### [183. An Overview of SQL Antipatterns](https://hackernoon.com/an-overview-of-sql-antipatterns)  I was recently going through my notes of SQL Antipatterns and was shocked to realize how actual this book still is. ### [184. Introduction to Recursive CTE](https://hackernoon.com/introduction-to-recursive-cte-n31f3wok)  This article will introduce the concept of SQL recursive. Recursive CTE is a really cool. We will see that it can often simplify our code, and avoid a cascade of SQL queries! ### [185. Secure Enclaves and ML using MC²](https://hackernoon.com/secure-enclaves-and-ml-using-mc-e0363701)  Announcing the official release of MC², a platform for secure analytics and machine learning. ### [186. The Pros and Cons of NoSQL](https://hackernoon.com/the-pros-and-cons-of-nosql-391l3268)  Learn how NoSQL differs from SQL and how it's built for high performance and availability. And no, it doesn't stand for "No SQL". ### [187. Using SPyQL and Python to Run Command Line Analytics](https://hackernoon.com/using-sypgl-and-python-to-run-command-line-analytics)  SPyQL combines Python and SQL to make querying of CSV and JSON data easy. In this tutorial we analyse the geographical distribution of cell towers. ### [188. What is SQL? And Where is it Used?](https://hackernoon.com/what-is-sql-and-where-is-it-used-0c19355b)  What is SQL? Databases use it, query APIs use it, even energetic big data dashboards use it! Where did it come from and how are developers, DBAs, and app using. ### [189. SQL and Database Management Skills Should Be Introduced Into School Curriculums](https://hackernoon.com/sql-and-database-management-skills-should-be-introduced-into-school-curriculums-nu9k35sy)  This article will discuss the wide-ranging benefits of learning SQL, and how we can transform the current curriculum. ### [190. Getting Started with MariaDB using Docker and Node.js](https://hackernoon.com/getting-started-with-mariadb-and-nodejs-xr323ynt)  It's no secret that MariaDB has become a popular database solution for developers over the past decade. Why? Well, one could argue that it's largely because it's open source and relational. So, for developers, that basically means it's free, and we get the gist of it. But that really only begins to scratch the surface. ### [191. 3 Real SQL Questions Asked During Technical Interviews](https://hackernoon.com/3-real-sql-questions-asked-during-technical-interviews-x22w3ysa)  I love to engage with my readers and learn about what their concerns are when it comes to the technical interview. In this article, I’ll go through a question from a reader and 3real SQL questions that were asked during technical screenings from real companies. ### [192. Integrating Python and SQL: A Guide for Beginners](https://hackernoon.com/integrating-python-and-sql-a-guide-for-beginners-5i283w9l)  SQL is a structured query language that is used to communicate with a database where the database is the organized collection of data that is usually stored electronically on your computer. ### [193. A Quick Start Guide For MariaDB](https://hackernoon.com/a-quick-start-guide-for-mariadb)  Get started with MariaDB with just three steps using the official MariaDB docker container. ### [194. [Tutorial] Top 5 Ways to Query your Relational Database in JavaScript [Part 1]](https://hackernoon.com/tutorial-top-5-ways-to-query-your-relational-database-in-javascript-part-1-v1x3uy0)  If you’re developing web applications, you’re almost certainly going to be constantly interacting with a database. And when it comes time to select the way you’ll interact, the choices can be overwhelming. ### [195. Getting Started with MariaDB using Docker and Node.js](https://hackernoon.com/getting-started-with-mariadb-using-docker-and-nodejs-fo433yp2)  It's no secret that MariaDB has become a popular database solution for developers over the past decade. Why? Well, one could argue that it's largely because it's open source and relational. So, for developers, that basically means it's free, and we get the gist of it. But that really only begins to scratch the surface. ### [196. A Security Vulnerability Let Anyone “Rewrite the Laws” of Gibraltar](https://hackernoon.com/a-security-vulnerability-let-anyone-rewrite-the-laws-of-gibraltar-x35636e7)  “Rewriting the laws” of British Overseas territory Gibraltar with SQL Injection ### [197. A Comprehensive Guide To Database Architectures And Use Cases](https://hackernoon.com/a-comprehensive-guide-to-database-architectures-and-use-cases-8nv33ca)  This article will provide an overview on database architectures, including use cases and pros & cons for each of them. ### [198. Are NoSQL databases relevant for data engineering?](https://hackernoon.com/are-nosql-databases-relevant-for-data-engineering-6f1y35zd)  In this article, we’ll investigate use cases for which data engineers may need to interact with NoSQL database, as well as the pros and cons. ### [199. SQL Databases Vs. NOSQL Databases](https://hackernoon.com/sql-databases-vs-nosql-databases-ja3g3yy9)  The decision to choose a database for project is not that simple. But when it comes to choosing a database, the biggest decisions is picking a relational (SQL) or non-relational (NoSQL) data structure. ### [200. Hunting for Customers With PostgreSQL](https://hackernoon.com/hunting-for-customers-with-postgresql-kt133tp9)  Now more than ever, you have to hold onto every customer you can. Customers don’t love your product one minute, then fall out of love with it the next. Normally there’s a declining trend in usage of your product over time. ### [201. How To Query JSON in Couchbase via Collections and Scopes](https://hackernoon.com/how-to-query-json-in-couchbase-via-collections-and-scopes-3p1l3ze8)  This week I’m attending the 3-day Couchbase Connect event and will be reporting on some of the topics that I find most interesting. ### [202. Build a Live Dashboard with Materialize, Airbyte, MySQL and Redpanda/Kafka](https://hackernoon.com/build-a-live-dashboard-with-materialize-airbyte-mysql-and-redpandakafka)  ### [203. MySQL Errors Messages And Common Problems](https://hackernoon.com/mysql-errors-messages-and-common-problems-lm2631yv)  Errors or mistakes are common in any aspects, especially in development. Using MySQL or any database can't guarantee you an error-free environment. ### [204. Ruby on Rails Hidden Secrets: How To Get The Most Out Of Active Record Associations](https://hackernoon.com/ruby-on-rails-hidden-secrets-how-to-get-the-most-out-of-active-record-associations-6m133w8a)  Hello folks! In this article, we are going to unravel the mystery behind the Rails Active Record class. To be honest, I struggled a lot with Rails models as a beginner. I spent a lot of time reading the docs, read a couple of medium articles, watched some youtube videos but all in vain. I have chosen to draft a nice article that constitutes of baby steps that is suitable for aspiring Rails Engineers. ### [205. SQL's 50 Year Reign: Here's Why SQL Is Still Relevant Today](https://hackernoon.com/sqls-50-year-reign-heres-why-sql-is-still-relevant-today-917z31qb)  Dive into the detailed history of SQL's rise and reign over the past 50 years. They remained relevant by listening and adapting to the market. ### [206. Why We Should Have Different Databases](https://hackernoon.com/why-we-should-have-different-databases-6o1i345i)  Today there are hundreds of SQL and NoSQL databases. Some of them are popular, some are ignored. Some are user-friendly and well documented and some are hard to use. Some are open sourced and some are proprietary. And, perhaps, the most important - some are scalable, optimized, highly available and some are difficult to scale or maintain. ### [207. How to Create World Leading Databases](https://hackernoon.com/creating-world-leading-databases-with-harperdb-svp-jaxon-repp)  Jason Repp is the SVP of HarperDB, a world-leading database and development platform that is leading the charge in terms of performance, flexibility, and ease. ### [208. How To Find Origin And Context of JPA For Issued SQL Statements](https://hackernoon.com/how-to-find-origin-and-context-of-jpa-for-issued-sql-statements-261p31j2)  ORM frameworks like Hibernate and other JPA implementors can significantly simplify development of persistence layer. Introducing entity abstraction level helps to model clean business domain and to hide underlying SQL statements used to achieve persistence of the domain. Such approach is especially useful in large domains, since developer no longer needs to create and maintain all SQL statements used by application. ### [209. [Tutorial] Top 5 Ways to Query Your Relational Database in JavaScript [Part 2]](https://hackernoon.com/tutorial-top-5-ways-to-query-your-relational-database-in-javascript-part-2-sa293u0y)  Welcome back! In the first part of this series, we looked at a very "low-level" way to interact with a relational database by sending it raw SQL strings and retrieving the results. We created a very simple Express application that we can use as an example and deployed it on Heroku with a Postgres database. ### [210. How To Optimize Large S3 API Costs using Alluxio](https://hackernoon.com/how-to-optimize-large-s3-api-costs-using-alluxio-yev3uwg)  This is a guest blog contributed by datasapiens’ Juraj Pohanka, Koen Michiels and Sam Gilbert. This article described how engineers at datasapiens brought down S3 API costs by 200x by implementing Alluxio as a data orchestration layer between S3 and Presto. ### [211. Simple Steps To Connect SQL Azure To SSMS](https://hackernoon.com/simple-steps-to-connect-sql-azure-to-ssms-sk1l349f)  Find out easy and sequential process on how to connect to Azure SQL Server and create a database using SQL Server Management Studio. ### [212. MySQL FAQs](https://hackernoon.com/mysql-faqs-aw123tab)  MySQL is an open-source relational database management system. As the name suggests, it is used to create, update, and store databases. It is based on SQL (Structured Query Language). So, today we will be checking out the 13 most asked questions on MySQL. ### [213. Migration Makes My Skin Crawl: From SQL to NoSQL](https://hackernoon.com/migration-makes-my-skin-crawl-from-sql-to-nosql-ic7835kh)  Is database migration as scary as it sounds? Amy Tom talks to Matt Groves, Senior PM Manager at Couchbase, and Curt Gratz, Co-Owner of CKH Consulting.