databasestar

[databasestar]

Github Tutorial for SQL Files

Github Tutorial for SQL Files

Do you want to, or need to, learn how to use GitHub for your SQL files? GitHub is a commonly-used service for application development. But it can also be used for your SQL scripts and other files used in development. Continue reading

[databasestar]

How to Set Up a Database on Docker

How to Set Up a Database on Docker

In this guide, you’ll learn: What Docker is (briefly) Why you might want to use it for your database How to set it up How to get a database (Oracle, SQL Server, MySQL, or PostgreSQL) running using Docker – with screenshots and explanations Let’s get into it. (more…)

[databasestar]

Complex SQL Query Example - Daily Order Analysis

Complex SQL Query Example – Daily Order Analysis

If you want to see how to write a complex query on an SQL database, this example will show you. (more…)

[databasestar]

115 Software Development Tools

115 Software Development Tools

If you want to see the best tools for software development in one place, then you’ll love this guide. This list contains 115 tools that are either for developing software or can help you work as a software developer. The tools are grouped into categories to help you navigate the list. Check it out below. (more…)

[databasestar]

SQL Default Value: How To with Examples

SQL Default Value: How To with Examples

The SQL DEFAULT constraint is a constraint that can be added to tables to specify a default value for a column. The default value is used for the column’s value when one is not specified (for example, when you insert a row into the table without specifying a value for the column). (more…)

[databasestar]

How to Fix MySQL Error: Access Denied for User 'root'@'localhost'

How to Fix MySQL Error: Access Denied for User ‘root’@’localhost’

This “access denied” error is one of the most common errors you’ll get when working with MySQL. Learn how to fix it, and see a range of solutions if the suggested fix does not work, in this article. (more…)

[databasestar]

How to Update from Select in SQL

How to Update from Select in SQL

The basic UPDATE statement in SQL allows us to update data in a table. But what if we want to update data in one table based on data in another table? There are a few ways to do that in different versions of SQL. Let’s take a look at the SQL Update from Select techniques in this guide. Continue reading

[databasestar]

JSON in SQL Server: The Ultimate Guide

JSON in SQL Server: The Ultimate Guide

SQL Server has quite a few features for storing and working with JSON data. In this guide, you’ll learn: What JSON is and why you might want to use it Creating a table with a JSON field How to add, read, update, and delete JSON data Tips for performance, validating and working with JSON Let’s get into the guide. Continue reading

[databasestar]

SQL Injection: The Definitive Guide

SQL Injection: The Definitive Guide

SQL injection is a type of vulnerability that software developers aim to avoid. In this guide, you’ll learn: what SQL injection is examples of SQL injection how to prevent SQL injection Let’s get into the guide. Continue reading

[databasestar]

The Complete Guide to Asynchronous Communication for Improving and Replacing Meetings

The Complete Guide to Asynchronous Communication for Improving and Replacing Meetings

[et_pb_section fb_built=”1″ _builder_version=”4.7.7″ _module_preset=”default” custom_margin=”0px||||false|false”][et_pb_row _builder_version=”4.7.7″ _module_preset=”default” custom_margin=”0px||||false|false”][et_pb_column type=”4_4″ _builder_version=”4.7.7″ _module_preset=”default”][et_pb_text admin_label=”Intro” _builder_version=”4.7.7″ _module_preset=”default”] Do you feel like you’re having…

[databasestar]

JSON in MySQL: The Ultimate Guide

JSON in MySQL: The Ultimate Guide

MySQL has quite a few features for storing and working with JSON data.

(more…)

[databasestar]

SQL Best Practices and Style Guide

SQL Best Practices and Style Guide

SQL is a common language to learn when working with software.

But once you learn the basics, you’ve probably got a lot of questions about different ways to do things.

How should I format my code? Which alternative of these features is better?

This guide aims to help answer those questions.

Read on to learn how to style your SQL and some recommendations in this “SQL Style Guide and Best Practices”.

[databasestar]

Hierarchical Data in SQL: The Ultimate Guide

Hierarchical Data in SQL: The Ultimate Guide

[et_pb_section fb_built=”1″ _builder_version=”4.6.5″ _module_preset=”default”][et_pb_row _builder_version=”4.6.5″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.6.5″ _module_preset=”default”][et_pb_text admin_label=”Heading” _builder_version=”4.6.5″ _module_preset=”default”]

Hierarchical Data in SQL: The Ultimate Guide

[/et_pb_text]

[databasestar]

How to Save MySQL Query Output to a File

How to Save MySQL Query Output to a File

Do you need to save your results from a MySQL query to a CSV or text file?

It’s easy to do in MySQL. You can do this using an IDE or the command line, using a built-in MySQL command.

Let’s take a look.

(more…)

[databasestar]

17 Sites for SQL Practice

17 Sites for SQL Practice

Are you looking for places to practice SQL online? This list contains many different websites that have SQL practice functionality.

(more…)

[databasestar]

81 Best Books for Programmers

81 Best Books for Programmers

[et_pb_section fb_built=”1″ _builder_version=”4.6.1″ _module_preset=”default” custom_margin=”0px||||false|false” custom_padding=”0px||||false|false”][et_pb_row _builder_version=”4.6.1″ _module_preset=”default” custom_padding=”0px||||false|false”][et_pb_column type=”4_4″ _builder_version=”4.6.1″ _module_preset=”default”][et_pb_code admin_label=”Bootstrap Code” _builder_version=”4.6.1″…

[databasestar]

SQL Rename Table: How To with Examples

SQL Rename Table: How To with Examples

Once you create a table in SQL, you may want to rename it. This might happen if you are creating a new table to replace it, or have come up with a better name for it.

In this article, you’ll learn the SQL commands to rename a table in Oracle, SQL Server, MySQL, and PostgreSQL, along with examples of each.

Let’s get into the article.

(more…)