Learn three ways of representing inheritance in a database: table-per-hierarchy, table-per-class, and table-per-concrete-class.
Also find me here:
Baeldung Author
Gbenga Oyatoye
Gbenga Oyatoye, a graduate of Economics with a decade of experience as a technical analyst in a Nigerian construction company, specializes in industrial and construction economics. With 15 years as a passionate freelance writer and researcher, his recent focus has been on Data Science, and Information Systems Technology. Gbenga combines his deep industry knowledge with data-driven insights to produce high-quality, informative content on systems technology for educative and research purpose.
Here's what I've written (so far):
Baeldung on SQL
- All
- SQL Queries (3)
- SQL Tables (2)
- SQL Joins (1)
- SQL Functions (1)
- SQL Basics (1)
- DML (1)
Deleting Rows Using LEFT JOIN in SQL
Learn how to delete rows using LEFT JOIN in SQL.
Difference Between CTE and Subquery
Filed under SQL Queries
Explore and understand, with practical examples, the differences between Common Table Expressions(CTEs) and subqueries.
How to Store Decimal Values in SQL
Filed under SQL Basics
Learn how to store decimal values in SQL.
Trimming Strings in SQL
Filed under SQL Functions
An introduction to trimming strings in MySQL, PostgreSQL, and SQL Server.
Using ALTER to Drop a Column Only if the Column Exists in SQL
Filed under SQL Tables
Learn to use ALTER to drop a column only if it exists.
Creating Temporary Tables in a SELECT Statement Without a Separate CREATE TABLE
Filed under SQL Queries
Learn how to create temporary tables directly within a SELECT statement in SQL.
How to Fetch Maximum Value for Each Group Using SQL
Filed under SQL Queries
Learn how to fetch the maximum value for each group using SQL.