Steven Feuerstein is a renowned author focusing on the Oracle database PL/SQL language, having published several books on this language through O'Reilly Media. Feuerstein has worked with Oracle Database technology - and worked twice for Oracle Corporation - since 1987, and has been developing software since 1980. [1]
Feuerstein has developed software since 1980. He spent a total of trwelve years with Oracle Corporation (1987–1992, 2014–-2021) 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. [2]
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. [1]
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, [3] 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, [4] 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.
In February 2021, Feuerstein left Oracle to join Insum Solutions as a senior advisor.
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 My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that 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.
Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.
In computers, case sensitivity defines whether uppercase and lowercase letters are treated as distinct (case-sensitive) or equivalent (case-insensitive). For instance, when users interested in learning about dogs search an e-book, "dog" and "Dog" are of the same significance to them. Thus, they request a case-insensitive search. But when they search an online encyclopedia for information about the United Nations, for example, or something with no ambiguity regarding capitalization and ambiguity between two or more terms cut down by capitalization, they may prefer a case-sensitive search.
Randal L. Schwartz, also known as merlyn, is an American author, system administrator and programming consultant. He has written several books on the Perl programming language, and plays a promotional role within the Perl community. He was a co-host of FLOSS Weekly.
Object–relational mapping in computer science is a programming technique for converting data between a relational database and the heap of an object-oriented programming language. This creates, in effect, a virtual object database that can be used from within the programming language.
Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.
Oracle APEX is an enterprise low-code application development platform from Oracle Corporation. APEX is used for developing and deploying cloud, mobile and desktop applications. The platform is a web-based integrated development environment (IDE) with a range of features including wizards, drag-and-drop layout and property editors to simplify the process of building applications and pages.
TOra (Toolkit for Oracle) 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.
A LAMP is one of the most common software stacks for the web's most popular applications. Its generic software stack model has largely interchangeable components.
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.
SQLJ is a working title for efforts to combine Java and SQL. It was a common effort started around 1997 by engineers from IBM, Oracle, Compaq, Informix, Sybase, Cloudscape and Sun Microsystems.
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as PL/SQL and T-SQL.
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:2023. 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 computer programming, a collection is an abstract data type that is a grouping of items that can be used in a polymorphic way.
Bricolage was a content management system (CMS) written in the Perl programming language.
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.
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 Db2. Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
Snake case is the naming convention in which each space is replaced with an underscore (_) character, and words are written in lowercase. It is a commonly used naming convention in computing, for example for variable and subroutine names, and for filenames. One study has found that readers can recognize snake case values more quickly than camel case. However, "subjects were trained mainly in the underscore style", so the possibility of bias cannot be eliminated.
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.
| International | |
|---|---|
| National | |
| Other | |
