FB
81 Best Books for Programmers

81 Best Books for Programmers

If you’re a programmer or software developer, you’ve probably done a lot of reading. And if you’re interested in becoming a better programmer, there are many books you can read to improve your skills.

This page contains a list of the best books for programmers. I’ve looked at different lists on Google, Reddit, Twitter, and other places.

(more…)

MySQL Drop All Tables: How-To With Examples

MySQL Drop All Tables: How-To With Examples

There may come a time when you need to drop all tables in a MySQL database.

In this article, you’ll learn how to do that easily, both using an SQL command an inside an IDE such as MySQL Workbench.

Let’s see how we can do that.

read more…

How to Reset IDENTITY Column Values in SQL Server

How to Reset IDENTITY Column Values in SQL Server

Do you want to reset an identity column in your table in SQL Server so the numbers are in order?

And you want to do it without recreating the table?

In this article, I’ll show you how you can do this, and a few things to be aware of.

Let’s take a look.

read more…

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.

read more…

MySQL Create User and Grant Permissions: How To

MySQL Create User and Grant Permissions: How To

If you work with MySQL, there will be a point when you’ll need to create a new user.

This could be for another part of the system or another developer on your team. Or perhaps you want to use a user other than the default “root” account on MySQL.

read more…

MySQL Date Data Types and Date Functions

MySQL Date Data Types and Date Functions

Working with dates is something you’ll do a lot in MySQL.

It helps to understand the different date data types and many of the functions that can be used with them.

In this guide, we’ll look at the MySQL date data types, the date functions, and see some examples of them.

read more…

Ben Brumm
Ben Brumm
DatabaseStar

Database Star Academy:
Login

Oracle SQL Expert

Oracle SQL Associate

Popular Posts

Database Normalisation
Introduction to Oracle SQL
SQL Joins
Database Developer