Javarevisited·2yThe 2024 Database Admin RoadMap
This guide outlines the roadmap to becoming a Database Administrator in 2024, covering essential skills like SQL, database systems, advanced SQL topics, database administration, and cloud databases. Recommended learning resources include courses for SQL, Linux, Oracle, and PostgreSQL. The role is highly in-demand and offers robust career prospects.
SQL Shack·2yDifference between SQL SELECT UNIQUE and SELECT DISTINCT
Learn about the difference between SQL SELECT UNIQUE and SELECT DISTINCT, the use of UNIQUE constraint, and the syntax for executing these statements in Oracle. Both statements are used to fetch unique values from a column that may have duplicate values.
DEV·2yComparing SQL engines by CPU instructions for DML
This post compares the CPU usage of different SQL engines, such as PostgreSQL, Oracle, SQL Server, MySQL, TiDB, YugabyteDB, and CockroachDB, for simple DML operations. The results show that despite their different implementations, PostgreSQL, Oracle, and SQL Server perform well in terms of CPU usage. TiDB, YugabyteDB, and CockroachDB exhibit higher CPU utilization due to their distributed and scalable architectures. Overall, the performance varies depending on the database engine and workload.
JRebel·2yJava Basics: What Is WebLogic?
WebLogic is a scalable enterprise Java application server, acquired by Oracle from BEA Systems in 2008. It's used for deploying Java-based web applications and offers robust, highly available, and secure environments for critical applications. The post compares WebLogic with other popular servers like Tomcat and JBoss/WildFly, highlighting WebLogic's comprehensive enterprise features and commercial support, making it suitable for production environments with heavy loads.
InfoWorld·2yWhat’s new in MySQL 9.0
Oracle has released MySQL 8.0.38, MySQL 8.4, and MySQL 9.0, marking the latter as a significant innovation release. MySQL 9.0 introduces features such as a new Vector data type, JavaScript Stored Programs, and updated libraries and compilers. Deprecated features include the removal of SHA-1. Future updates are expected every three months, with the next major LTS releases anticipated in October.
Inside Java·2yBuild a Cloud Compute Instance with Java Concepts – Inside.java
The post explores how to use Java with Pulumi to provision Oracle Cloud Infrastructure (OCI) instances. It provides a step-by-step guide on setting up the project, configuring Maven dependencies, and storing environment parameters in configuration files. Key tasks include setting up Pulumi stacks, configuring Java projects to interact with Pulumi, and writing code to build infrastructure as code. The post also suggests creating keys for secure access and offers tips on managing certificates and secrets for long-term projects.
Inside Java·2ySimplify Your Deployment Workflow: Introducing Oracle Java Releases Public APIs
Oracle has launched Java Releases Public APIs, designed to simplify access to Java release information. These RESTful APIs, available via Oracle Cloud Infrastructure, support seamless CI/CD integration, automated compliance checks, and timely release notifications, enhancing efficiency for IT administrators, DevOps professionals, and developers.
