Posts

Showing posts from September, 2017

Webinar: Version Control for the Oracle Database

Image
Version control of tables and PL/SQL code in the Oracle Database has always been challenging. Database programmers lack the tools that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid schemas and writing code in the database. In this presentation you will learn how Gitora 3  can help you use Git, the prominent open source version control software, to manage every database object including tables and PL/SQL source code. Sign up now. Every attendee will receive a discount offer to purchase Gitora 3 developer licenses. :-) About the Webinar: In this presentation you’ll learn how to: Manage any database object including tables and packages in Git. Implement agile development best practices for database development Execute commonly used version control commands in the Oracle Database and how executing these commands can change ...

Version Control for Oracle Database

Image
Today, we’re happy to announce the general availability of Gitora 3 . Gitora 2 enabled developers to manage database objects that support the CREATE OR REPLACE command, namely PACKAGES, PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS, SYNONYMS and TYPES in a Git repository. (In Gitora terminology, we call these  “Soft Objects” ). Gitora 3 goes a step further and enables developers to  manage every database object in an Oracle Database with Git  even if the object does not support the CREATE OR REPLACE command. (In Gitora terminology, we call these  “Hard Objects” .) Specifically, Gitora 3 allows developers and DBA's  to manage TABLES, INDEXES, SEQUENCES, CONSTRAINTS, TABLESPACES, MATERIALIZED VIEWS and every other schema or non-schema objects with Git. Learn more about how Gitora 3 helps developers, DBA's, DevOps people and managers to improve their database development workflow at this link.

How Does Oracle's Core RDBMS work?

Image
Attend the free webinar by the Oracle ACE Director Martin Widlake and learn how Oracle works under the hood. About the Webinar: Despite the complexity and capability of the Oracle database, at it's heart there are a relatively small number of key activities and processes. If you understand them, you will get a lot more out of the database and advanced topics make a lot more sense. In this presentation I explain the key things the database does and how they work together. If you know what a SELECT statement is, you will understand this talk. And by the end of it, you will know some things that even many experienced developers and DBAs don't know. In this webinar, you will learn: The two ways Oracle reads data from disc and how it writes it back. That REDO is actually the most important part of the database.  What happens when you COMMIT. Why Oracle data blocks are key to the buffer cache. What a "Consistent Get" really is. Why indexes are so powerful...