If you want to see how to write a complex query on an SQL database, this example will show you.
In this post, you’ll learn how to set up a sample database so you can practice your SQL queries. This database works on Oracle, SQL Server, MySQL, and PostgreSQL.
As a software developer you’ll use a range of tools to do your job. Here’s a list of software development tools you may consider using.
Using Docker for an SQL Server database is one way to run the database. Learn how to set up an SQL Server Docker instance in this guide.
Docker can be used to run an Oracle database, which is a good way to run Oracle on a Mac or as an alternative on Windows. Learn how to set it up in this guide.
The SQL DEFAULT constraint is something that can be added to tables to specify a default value for a column.
The Access denied for user ‘root’@’localhost’ error is common in MySQL. Learn what it means and how to resolve it in this article.
Have you heard of the SQL Cross Apply feature but have no idea what it does? Or are you familiar with how both Cross Apply and Outer Apply work but don’t know how they can work in the real world? Learn all about them in this guide.
Learn how to show a list of all databases on your server, on several different vendors, in this guide.
To delete or drop a database you can use the DROP DATABASE command. Learn more about it here.