How do I turn JSON keys and elements into table rows and columns with Oracle SQL?
Learn how to unlock the full potential of your JSON data using the JSON_TABLE function in Oracle SQL.
Software Engineering
Ideas, insights, and strategies for today’s software engineers.
How can I determine if an element or value exists in JSON data with Oracle SQL?
Learn how the JSON EXISTS function can help you verify the existence of an element or value with Oracle SQL.
How can a MySQL query return data from multiple tables?
Learn how the JOIN technique can help you present information from two or more tables.
What is the difference between explicit and implicit JOINs in MySQL?
Learn the difference between explicit and implicit JOINs and understand which you should use in your MySQL project.
What is the difference between an inner join and outer join in MySQL?
Learn how to join tables with non-matching data using inner or outer join in MySQL
Why use Scala?
If you're familiar with Java or the JVM but want more power from your APIs and want to see what functional programming can do with your data, Scala is a good bet.
How can I access documentation in Linux?
Learn how to access, decipher, and implement commands with the correct syntax using the man pages in Linux.
What are the standard file locations in Linux systems?
Learn the directory structure and where common files are located in Linux.
How do I manage jobs in Linux?
Learn to effectively manage your program processes in Linux.
How can I make the Linux spell command more useful?
Learn how to deal with the shortcomings of the Linux spell command; such as unsorted output, duplicates, and false positives.
How can I find duplicate files in Linux?
Learn how to identify duplicate copies of files in your Linux system allowing you to be more organized and save disk space.
How can I find out where all my disk space has gone on a Linux file system?
Learn how to use the Linux du command to discover what directories are consuming the most space in your file system.
How to use pull requests to improve your code reviews
Spend more time building and less time fixing with GitHub Pull Requests for proper code review.
Should you port your project from Python 2 to Python 3?
Get practical knowledge on why and how to port your project to Python 3.
What is YAML used for in Spring?
Learn how to use the YAML format to configure a Spring project.
What annotation should I use for service registry in Spring Cloud?
Understand the variety of annotations available to you when using service registry with Spring Cloud.
How should I inject dependencies in Spring?
Learn Spring’s three dependency injection methods and understand when to use them.
How do actors in Akka work?
Learn the theory behind actors, how actor parent-child relationships behave, and fault tolerance in Akka.
How do I create actors in Akka?
Learn how to create an actor, send and receive messages, and configure a login with HOCON in Akka.
How do I use actorSelection to communicate with other actors?
Learn how to use actorOf to create actors and how to pass a URL to actorSelection to obtain the actor reference and send a message with Akka.
How can I create a Transact-SQL query graphically?
Learn how to visualize tables and data using SQL Server Management Studio’s graphical query tool.
How do I locate data in my SQL Server tables using SQL Server Management Studio diagrams?
Locate data quickly and easily with the SQL Server Management Studio diagram tool.
How should I format Transact-SQL queries?
Learn the formatting possibilities for Transact-SQL queries and develop your own code structure.
How do I use the repository pattern in C#?
Learn how to correctly implement the repository pattern in C#.