Blog: DBS (Database Star)

210 blogs updated: 65 min. ago
Oracle SQL PIVOT and UNPIVOT: The Complete Guide
Have you ever needed to convert a set of data from rows into columns? You can do this using the Oracle PIVOT feature (and the reverse using ...
17-09-2018 23:04:42 DBS (Database Star) Oracle
JDBC in Java, Hibernate, and ORMs: The Ultimate Resource
As a Java developer, it's very likely you'll need to connect to a database. There are several ways to do this in Java, from creating a simpl...
11-09-2018 13:25:02 DBS (Database Star) Oracle
24 Database Design Mistakes and How to Avoid Them
Creating a database is easy. Designing an effective database, the right way, using good practices, is hard. In this article, I've listed 24 ...
18-08-2018 01:12:51 DBS (Database Star) Oracle
SQL Views and Materialized Views: The Complete Guide
By the end of this article, you'll know all about views, materialized views, how to create them, their advantages, and much more. Table of C...
26-07-2018 13:06:14 DBS (Database Star) Oracle
SQL DISTINCT: The Complete Guide
The SQL DISTINCT keyword lets you find unique rows. By the end of this article, you'll know how to use it, what it can do, and understand se...
24-07-2018 13:04:13 DBS (Database Star) Oracle
SQL Set Operators: The Complete Guide to UNION, INTERSECT & MINUS
Are you wondering what set operators are? Have you seen keywords like UNION or MINUS and want to know what they do and why they are used? In...
19-07-2018 14:14:46 DBS (Database Star) Oracle
SQL Operators: The Complete Guide
Do you want to know the different ways of comparing data in SQL, using operators? SQL operators include EXISTS, IN, LIKE, BETWEEN, and many ...
17-07-2018 14:02:05 DBS (Database Star) Oracle
SQL Stored Procedures: The Complete Guide
Do you want to know what a stored procedure is, how it can help your SQL, and how to create one? Read this guide to find out all of those, a...
12-07-2018 13:15:52 DBS (Database Star) Oracle
Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)
Natural key, surrogate key, composite key. What do these terms mean? And why should you know what they are? In this article, you'll learn wh...
10-07-2018 13:50:48 DBS (Database Star) Oracle
Oracle Merge: The Complete Guide
Do you need to insert or update data depending on if it already exists? You can do this with the MERGE statement in Oracle SQL. What is the ...
22-05-2018 13:40:58 DBS (Database Star) Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.