Premium Essay

Pt2520-Unit 1 Research-Exploring Programming Language

In: Computers and Technology

Submitted By jcg42784
Words 802
Pages 4
Unit 1 Research Assignment 1: Exploring Programming Language
Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information from databases. SQL is an ANSI and ISO standard, and is the de facto database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for enormous, complex datbases. (Base, 2013). SQL was developed in the 1970’s by IBM to initially manipulate and retrieve data in IBM system R. The SQL language was standardized in 1986 by the American National Standards Institute (ANSI); however, later releases were released as International Organization Standardization (ISO) standards. (Inc., 2013) Although IBM authored SQL, the first SQL implementation was provided by Oracle Corporation (then called Relational Software Inc.). Early commercial implementations were concentrated on midsized UNIX-based DBMSs, such as Oracle, Ingres, and Informix. IBM followed in 1981 with SQL/DS, the forerunner to DB2, which debuted in 1983. (Unknown, 2010) ANSI published the first SQL standard (SQL-86) in 1986. An international version of the standard issued by ISO appeared in 1987. A significant update to SQL-86 was released in 1989 (SQL-89). Virtually, all relational DBMSs that you encounter today support most of the 1986 standard. (Unknown, 2010) In 1992, the standard was revised again (SQL-92), adding more capabilities to the language. Because SQL-92 was s superset of SQL-89, older database application programs ran under the new standard with minimal modifications. In fact, until October 1996, DBMS vendors could submit their products to NIST (National Institute for Standards and Technology) for verification of SQL standard compliance. The testing and certification process provided significant

Similar Documents

Premium Essay

Pt2520 Unit 1

...Unit 1 Research Assignment | Exploring Programming Languages | Cody Tidwell | PT2520 1.) Edgar Frank “Ted” Codd was a mathematician and also a computer scientist who never stopped believing. Going for his doctorate on a scholarship from IBM, his determination was proven to many. Once he finished his Ph.D., he worked for IBM where his work truly began to take off. He was the one proposed a set of “12 Rules”, which there are actually 13 when you include the 0). In SQL Server 2012 Service Pack 1 Cumulative Update 4, it expands the supported features for SQL Server backup and restores with Windows Azure Storage. In this release, new Powershell cmdlets have been added. MICROSOFT EXPRESS FEATURES Stored Procedures-SQL Server Configuration Manager Views-Replication (as a subscriber only) Triggers-Advanced Query Optimizer Cursors-SMO/RMO Sqlcmd and osql utilities-Integration with Visual Studio 2005 Snapshot Isolation Levels-Service Broker (as a client only) Native XML support, including XQuery and XML Schemas-SQL CLR Transact-SQL language support-Multiple Active Result Sets (MARS) Dedicated Admin Connection-Import/Export Wizard ORACLE EXPRESS FEATURES Interactive reports Declarative BLOB support Enhanced report printing Adding to the theme repository Optional runtime-only installation Improved security Application date format Application builder refinements DB2 EXPRESS FEATURES Bi-temporal data management Always on transactions Enhanced security ...

Words: 316 - Pages: 2

Premium Essay

Nothing

...and/or Corequisite(s): Prerequisites: NT1210 Introduction to Networking or equivalent Course Description: This course examines industry standards and practices involving the physical components of networking technologies (such as wiring standards and practices, various media and interconnection components), networking devices and their specifications and functions. Students will practice designing physical network solutions based on appropriate capacity planning and implementing various installation, testing and troubleshooting techniques for a computer network. Where Does This Course Belong? | | | NT2799 | | | | | | | | NSA Capstone | | | | | | | Project | | | | | NT2580 | | | NT2670 | NT2640 | | PT2520 | | Introduction to | | | | | | | | | | | Email and Web | | | | | Information | | | | IP Networking | | Database Concepts | | | | | Services | | | | | Security | | | | | | | | | | | | | | | | NT1330 | | | NT1230 | NT1430 | | PT1420 | | Client-Server | | | Client-Server | | | Introduction to |...

Words: 10839 - Pages: 44