Steven Feuerstein is an author focusing on the Oracle database PL/SQL language, having written ten books on PL/SQL, and one book on mySQL, all published by O'Reilly Media. [1] His signature book, Oracle PL/SQL Programming, [2] which many[ quantify ] consider the "bible" for PL/SQL developers, was first published in September 1993. It has grown from 916 pages in 1993 to over 1000 pages in its 6th edition, published 20 years later.
Feuerstein has developed software since 1980. He spent five years with Oracle Corporation (1987–1992) and served as PL/SQL evangelist for Quest Software from January 2001 to 2013. In March 2014, he re-joined Oracle Corporation as an Architect and leads a team of Oracle Developer Advocates. [3] [ need quotation to verify ] Between 1999 and 2008, he focused his attention on improving the testing of PL/SQL programs, first by starting the open-source framework utPLSQL for unit testing PL/SQL, later on through the creation of Quest Code Tester for Oracle, which automates PL/SQL code testing. [4] Steven was one of the original Oracle ACE Directors and publishes regularly in Oracle Magazine and in the ODTUG magazine.
In April 2010, Feuerstein launched the PL/SQL Challenge, [5] a daily quiz on Oracle PL/SQL that quickly attracted over 1,000 daily players, making it one of the most active PL/SQL-related websites on the Internet.[ citation needed ] In 2011, Feuerstein added the PL/SQL Channel, [6] which offers video-based training on the Oracle PL/SQL language.
In March 2014, Feuerstein re-joined Oracle Corporation as an evangelist. He then formed the Developer Advocates team to help Oracle Database users take full advantage of this database to build their applications. The PL/SQL Challenge was transformed into the Oracle Dev Gym, which offers quizzes, workouts and classes on SQL, PL/SQL, and other Oracle technologies.
Eric Steven Raymond, often referred to as ESR, is an American software developer, open-source software advocate, and author of the 1997 essay and 1999 book The Cathedral and the Bazaar. He wrote a guidebook for the Roguelike game NetHack. In the 1990s, he edited and updated the Jargon File, currently in print as The New Hacker's Dictionary.
MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.
Randal L. Schwartz, also known as merlyn, is an American author, system administrator and programming consultant.
Object–relational mapping in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages. This creates, in effect, a "virtual object database" that can be used from within the programming language. There are both free and commercial packages available that perform object–relational mapping, although some programmers opt to construct their own ORM tools.
Programming Perl, best known as the Camel Book among programmers, is a book about writing programs using the Perl programming language, revised as several editions (1991-2012) to reflect major language changes since Perl version 4. Editions have been co-written by the creator of Perl, Larry Wall, along with Randal L. Schwartz, then Tom Christiansen and then Jon Orwant. Published by O'Reilly Media, the book is considered the canonical reference work for Perl programmers. With over 1,000 pages, the various editions contain complete descriptions of each Perl language version and its interpreter. Examples range from trivial code snippets to the highly complex expressions for which Perl is widely known. The camel book editions are also noted for being written in an approachable and humorous style.
Keith Bostic is an American software engineer and one of the key people in the history of Berkeley Software Distribution UNIX and open-source software.
Oracle Application Express is a web-based software development environment that runs on an Oracle database. It is fully supported and comes standard with all Oracle Database editions and Oracle Autonomous Database Service. Starting with Oracle 11g, APEX is installed by default as part of the core database install. Oracle APEX is also now available as a managed cloud service, Oracle APEX Application Development service.
JDeveloper is a freeware IDE supplied by Oracle Corporation. It offers features for development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP. JDeveloper covers the full development lifecycle from design through coding, debugging, optimization and profiling to deploying.
TOra is a free software database development and administration GUI, available under the GNU General Public License. It features a PL/SQL debugger, an SQL worksheet with syntax highlighting, a database browser and a comprehensive set of database administration tools.
LAMP is an acronym denoting one of the most common solution stacks for many of the web's most popular applications. However, LAMP now refers to a generic software stack model and its components are largely interchangeable.
Shelley Powers is an American author, web developer and technology architect. She works with and writes about open source, LAMP technologies and web service development, CSS/XHTML design, web graphics and the use of these technologies in the semantic web.
Toad is a database management toolset from Quest Software for managing relational and non-relational databases using SQL aimed at database developers, database administrators, and data analysts. The Toad toolset runs against Oracle, SQL Server, IBM DB2, SAP and MySQL. A Toad product for data preparation supports many data platforms.
Elliotte Rusty Harold is an American computer scientist, lecturer and author of several books on Java and XML and the creator of XOM, an open source Java class library for processing XML data.
SQL/PSM is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures. Initially published in 1996 as an extension of SQL-92, SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2016. The SQL:1999 part 4 covered less than the original PSM-96 because the SQL statements for defining, managing, and invoking routines were actually incorporated into part 2 SQL/Foundation, leaving only the procedural language itself as SQL/PSM. The SQL/PSM facilities are still optional as far as the SQL standard is concerned; most of them are grouped in Features P001-P008.
In the field of database computing, Oracle Net Services consists of sets of software which enable client applications to establish and maintain network sessions with Oracle Database servers. Since Oracle databases operate in and across a variety of software and hardware environments, Oracle Corporation supplies high-level transparent networking facilities with the intention of providing networking functionality regardless of differences in nodes and protocols.
Google App Engine is a cloud computing platform as a service for developing and hosting web applications in Google-managed data centers. Applications are sandboxed and run across multiple servers. App Engine offers automatic scaling for web applications—as the number of requests increases for an application, App Engine automatically allocates more resources for the web application to handle the additional demand.
A synonym is an alias or alternate name for a table, view, sequence, or other schema object. They are used mainly to make it easy for users to access database objects owned by other users. They hide the underlying object's identity and make it harder for a malicious program or user to target the underlying object. Because a synonym is just an alternate name for an object, it requires no storage other than its definition. When an application uses a synonym, the DBMS forwards the request to the synonym's underlying base object. By coding your programs to use synonyms instead of database object names, you insulate yourself from any changes in the name, ownership, or object locations. If you frequently refer to a database object that has a long name, you might appreciate being able to refer to it with a shorter name without having to rename it and alter the code referring to it.
PL/SQL is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database, Times Ten in-memory database, and IBM DB 2. Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
Object-PL/SQL is a methodology of using the Oracle Corporation's procedural extension language for SQL and the Oracle relational database. The additional features from version 7 and other improvements, lead to one of the large-scale environment implementations of the object-oriented database paradigm.
PL/SQL Developer, an Integrated Development Environment for developing software in the Oracle database environment, focuses on the development of PL/SQL stored-program units. Allround Automations, based in Enschede in the Netherlands, markets the software.
