SQL Window Functions: All You Need to Know About Using Them
Discover how to use window functions to carry out a statistical analysis with just one SQL query.
5 Dangerous Web Application Vulnerabilities and How to Find Them
If you're creating a web application, you need to make sure it's secure from cyberattacks. So what flaws should you know about?
What Is an SQL Injection? Is It Dangerous?
SQL injections are a form of cyberattack that have been around since the 1990s. So what are they and how do they work?
What Is the Difference Between Clustered and Non-Clustered Indexes in Microsoft SQL Server?
Picking the right type of index for your needs means your database will run more efficiently.
What Are SQL Stored Procedures and How Do You Create Them?
Stored procedures: like functions for your SQL.
How to Find and Delete Duplicates in SQL
Even if you're careful, duplicate data can end up in your database. Make sure you know how to clean it up quickly and easily.
The Top 10 Certifications for Database Developers
Looking to boost your database development skills? Here are some of the best certifications to take your career to the next level.
Make Your MySQL Server More Secure With These 7 Steps
How can you make sure your MSQL database is safe from hackers? Take a belt-and-braces approach with this handy checklist.
How to Import and Export CSV Data in PostgreSQL
Back up your Postgres data, transfer it elsewhere, and import it when necessary, all with the power of CSV.
How to Use Any SQL Database in Go
With a simple database abstraction package, using SQL from Go is easier than you might think.
How to Connect a Node Application to a MySQL Database
The mysql2 package makes connecting to a database from Node straightforward. Learn all about it.
How to Set Up a Microsoft SQL Server Database in Docker on Linux
Learn how to configure and connect to a Microsoft SQL Server Database on a Linux machine using Docker containers.
How to Install Azure Data Studio on Linux to Manage Your SQL Servers
Azure Data Studio helps you manage your cloud-based and local database servers. Here's how to install it on Linux.
How to Install and Configure MySQL on Ubuntu
Want to set up your own relational database management system on Ubuntu? Consider installing MySQL database on the server.
A Guide to MySQL for Beginners
Learn all the most important commands to start working with a MySQL database.
What Is PostgreSQL and How Can It Improve Your Programming Projects?
Oracle, MySql, and SQL Server might be the big players, but PostgreSQL has enough powerful features to make it a good candidate for your next project.
13 Basic SQL Commands and Queries Programmers Should Know
Every big or dynamic website uses a database in some way, and when combined with Structured Query Language (SQL), the possibilities for manipulating data really are endless.
5 Easy Ways to Get Real-World SQL Experience Before Your First Job
SQL is a sought-after skill. Here are a few ways to start a career in SQL and take advantage of the growth opportunities.
Everything You Need to Know About SQL Sub-Queries
Curious to learn more about how you can use SQL sub-queries? You're in the right place.
PostgreSQL vs. MySQL: Understanding the Database Tools
MySQL and PostgreSQL are two of the most popular open-source database management systems, but which one comes out on top?