Database Star

SQL Limit: The Complete Guide to SQL Row Limiting and Top-N Queries

Do you need to get the top rows in an SQL query?

Do you need to perform pagination, or find the top 5 or 10 results from a query?

You can do that in SQL using a “row limiting” feature.

Learn how to use this SQL limit feature in this article.

59 Best Resources for Learning SQL

Are you looking for the best way to learn SQL?

Are you unsure where to begin?

The good news is that there are a lot of SQL tutorials online. There are many ways to learn SQL that are suitable for different people. Some people like reading articles or books, others like watching videos. Some have exercises, some have a practice SQL sandbox, some don’t.

This list contains over 50 different places to learn SQL. Take a look at the list and find one that looks good to you!

(more…)

SQL Subqueries: The Complete Guide

Subqueries are powerful features of SQL.

If you want to move beyond the basics of SQL, then subqueries are something you need to know about.

This article will show you everything you need to know about subqueries in SQL.

4 Books for Programmers I’ve Read

There are many good books for programmers outside of those that teach how a certain technology or programming language. I’ve listed some I’ve read in this article.

77 Data Modeling Tools Compared

(more…)

37 Time Management Tips for Software Developers

As a software developer, you probably find yourself with more work than you can handle, or maybe it feels like there is not enough time in the day to get everything done.

This is a common feeling. To break through this needs successful and effective time management. I’ve listed a lot of different time management tips that software developers can use to get the most out of their day.

26 Tips on Effective Communication in the Workplace

Communication skills are an important part of your career as an IT professional. Learning how to have effective communication in the workplace in this article.

How to Install Oracle on a Mac

Installing an Oracle database on a Mac computer is a bit different to installing it on a Windows or Linux computer.

If you’re running a MacBook (like I am), or any type of Mac, this article will be useful for you. You’ll see the step-by-step instructions to install Oracle on a Mac.

ODC Appreciation Day 2018: Oracle Live SQL

ODC Appreciation Day is a roundup of blog posts by Oracle database blog owners on their favourite features of SQL Developer and other Oracle technologies.

For this year, my appreciation is for Oracle Live SQL.