Preview

Unit 1 Research Assignment 1: Exploring Programming Languages

Satisfactory Essays
Open Document
Open Document
612 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Unit 1 Research Assignment 1: Exploring Programming Languages
1. Structured Query Language (SQL) is a standard database computer language used for querying, modifying and managing data in Relational Database Management Systems (RDBMS). 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 for Standardization (ISO) standards.

Until this day, there are lots of users who refuse to refer to it as SQL. To some people, SEQUEL is the right name for this international standardized database language. SQL has additionally been revised in 1989 and then 1992 (SQL-92). Ever since, SQL has undergone many revisions to enhance their standardization.

Sybase and Ashton with their team support created a product which is known with the name of the SQL server 1.0 and within few years SQL server 4.21 also came in existence for the Microsoft NT operating system. Microsoft itself on their individual basis work for the SQL server 6.0 and this was the first Individual product of the SQL series for the Microsoft which works with the Windows NT because at that point of time windows NT was the main operating system.

After few years later, when a copyrights conflict is there between the Microsoft and Sybase then Microsoft has done so many revisions in its project which lead to the development of the SQL server 7.0 which is known with the name of SQL server 2000 and the main part of this scheme and model is that it can work with the 64 bit platform. The development of the Integrated development Environment for the creation of web and windows packages with the SQL server 2005 that includes so many tools and utilities that includes the ETL tool, a Reporting server, data mining server, and several messaging service brokers that will be for the notification services. The next version which was come after the Microsoft SQL Server2005 is the

You May Also Find These Documents Helpful

  • Satisfactory Essays

    PT2520 Unit7Labs Tramil

    • 330 Words
    • 1 Page

    4. What is SQL language? The programming language used to manipulate data and data objects in a relational database.…

    • 330 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Garbage Collector in C#: Runtime has a Garbage Collector Which cleans the objects that are not in use.…

    • 485 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Major commercial database developers have set a trend of offering “Express” versions of their databases. Companies such as Microsoft, Oracle and IBM DB2 are a part of this trend setting. Microsoft has a program called SQL Express which has the following features; SQL Server Configuration Manager, Replication, Advanced Query Optimizer, SMO/RMO, Sqlcmd, and Integration with Visual Studio 2005. SQL Express all has snapshot isolation level features, Native XML support, SQL language support-Multiple Active Result Sets (MARS), and Dedicated Admin Connection-Import/Export Wizard. These features are different than that of Oracles express version. Some of the software limitations include a 1GB maximum memory, the maximum size of each relational database.…

    • 452 Words
    • 2 Pages
    Good Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    I will use SQL 2008 Express Edition. This software closely resembles the software I use at work. I am familiar with the flexibility of this software. I am very comfortable in using SQL 2008. SQL is also one of the industry standard RDMS.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Good Essays

    pt2520 assignment 1

    • 466 Words
    • 2 Pages

    Let’s get the definition out the way, the standard meaning if you will SQL or “sequel” to some is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Now that we got that out the way, let’s get to the first question.…

    • 466 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Unit 6 True

    • 287 Words
    • 1 Page

    SQL is the programming language used to manipulate data and data objects in a relational database management system. TRUE…

    • 287 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data. _________________________…

    • 585 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Unit 1 Research Paper

    • 1606 Words
    • 7 Pages

    * SQL Server version 1.0: SQL Server version 1.0 is a 16 bit server modeled in the year 1989 for supporting OS/2.…

    • 1606 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    unit 6

    • 360 Words
    • 2 Pages

    1) SQL is the programming language used to manipulate data and data objects in a relational database management system.…

    • 360 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mia Mccain Cook

    • 901 Words
    • 4 Pages

    MS Operating Systems (Windows XP, Vista, 7) MS Office and Network Systems Administration Information Systems and Network Security Structured Query Language (SQL Server) Hardware and Software Implementation Access Control (Public Key Infrastructure)…

    • 901 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    Unit 6 Assignment 2 Choosing the right programming language. (P2) There are several factors to consider when choosing the right programming language, these include Organisational policy, suitability in terms of available features and tools, availability of trained staff and development and maintenance costs. Organisational policy Organisations which make and develop loads of computer software’s and programs tend to have a policy of using a certain language, a reason for this might be because that language allows them to make all their software consistent and easier to maintain.…

    • 1542 Words
    • 7 Pages
    Good Essays
  • Good Essays

    Pos 421 Week 4 Assignment

    • 667 Words
    • 3 Pages

    There are many different versions of Windows operating systems and software. Each has a different ability or use as the technology for each was increased and or changed over time as each was used. Some of the major versions of Windows include: Windows Server 2003, Windows Server 2008, Windows 200, Windows XP, Windows Vista, and Windows 7. These versions all have some similarities as well as differences that make them separate from each other. The following paragraphs will lists some of the comparisons and contrasts that make each individually different.…

    • 667 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    MIS Section3&4

    • 255 Words
    • 2 Pages

    7. The specialized language programmers use to add and change data in the database is called:…

    • 255 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    SQL was originally developed in the 1970’s by IBM to manipulate and retrieve data inside IBM system R. The SQL language then became standardized in 1986 by The American National Standards Institute or (ANSI); for short. But later releases were released as International Organization Standardization or (ISO) standards. (Inc., 2013)…

    • 769 Words
    • 3 Pages
    Better Essays
  • Powerful Essays

    Case Study on Windows Xp

    • 1510 Words
    • 7 Pages

    2000 – improved networking and laptop support, support for plug-and play devices, support for more processors (up to 8) and memory,becomes true multi-user through terminal server.…

    • 1510 Words
    • 7 Pages
    Powerful Essays

Related Topics