UGC NET Database Management System Notes (Part-II)

There are many popular RDBMS available to work with. This tutorial gives a brief overview of some of the most popular RDBMS’s. This would help you to compare their basic features.

MySQL

MySQL is an open source SQL database, which is developed by a Swedish company – MySQL AB. MySQL is pronounced as “my ess-que-ell,” in contrast with SQL, pronounced “sequel.”

MySQL is supporting many different platforms including Microsoft Windows, the major Linux distributions, UNIX, and Mac OS X.

MySQL has free and paid versions, depending on its usage (non-commercial/commercial) and features. MySQL comes with a very fast, multi-threaded, multi-user and robust SQL database server.

History

  • Development of MySQL by Michael Widenius & David Axmark beginning in 1994.
  • First internal release on 23rd May 1995.
  • Windows Version was released on the 8th January 1998 for Windows 95 and NT.
  • Version 3.23: beta from June 2000, production release January 2001.
  • Version 4.0: beta from August 2002, production release March 2003 (unions).
  • Version 4.01: beta from August 2003, Jyoti adopts MySQL for database tracking.
  • Version 4.1: beta from June 2004, production release October 2004.
  • Version 5.0: beta from March 2005, production release October 2005.
  • Sun Microsystems acquired MySQL AB on the 26th February 2008.
  • Version 5.1: production release 27th November 2008.

Features

  • High Performance.
  • High Availability.
  • Scalability and Flexibility Run anything.
  • Robust Transactional Support.
  • Web and Data Warehouse Strengths.
  • Strong Data Protection.
  • Comprehensive Application Development.
  • Management Ease.
  • Open Source Freedom and 24 x 7 Support.
  • Lowest Total Cost of Ownership.

MS SQL Server

MS SQL Server is a Relational Database Management System developed by Microsoft Inc. Its primary query languages are −

  • T-SQL
  • ANSI SQL

History

  • 1987 – Sybase releases SQL Server for UNIX.
  • 1988 – Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2.
  • 1989 – Microsoft, Sybase, and Aston-Tate release SQL Server 1.0 for OS/2.
  • 1990 – SQL Server 1.1 is released with support for Windows 3.0 clients.
  • Aston – Tate drops out of SQL Server development.
  • 2000 – Microsoft releases SQL Server 2000.
  • 2001 – Microsoft releases XML for SQL Server Web Release 1 (download).
  • 2002 – Microsoft releases SQLXML 2.0 (renamed from XML for SQL Server).
  • 2002 – Microsoft releases SQLXML 3.0.
  • 2005 – Microsoft releases SQL Server 2005 on November 7th, 2005.

Features

  • High Performance
  • High Availability
  • Database mirroring
  • Database snapshots
  • CLR integration
  • Service Broker
  • DDL triggers
  • Ranking functions
  • Row version-based isolation levels
  • XML integration
  • TRY…CATCH
  • Database Mail

ORACLE

It is a very large multi-user based database management system. Oracle is a relational database management system developed by ‘Oracle Corporation’.

Oracle works to efficiently manage its resources, a database of information among the multiple clients requesting and sending data in the network.

It is an excellent database server choice for client/server computing. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most UNIX flavors.

History

Oracle began in 1977 and celebrating its 32 wonderful years in the industry (from 1977 to 2009).

  • 1977 – Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories to undertake development work.
  • 1979 – Version 2.0 of Oracle was released and it became first commercial relational database and first SQL database. The company changed its name to Relational Software Inc. (RSI).
  • 1981 – RSI started developing tools for Oracle.
  • 1982 – RSI was renamed to Oracle Corporation.
  • 1983 – Oracle released version 3.0, rewritten in C language and ran on multiple platforms.
  • 1984 – Oracle version 4.0 was released. It contained features like concurrency control – multi-version read consistency, etc.
  • 1985 – Oracle version 4.0 was released. It contained features like concurrency control – multi-version read consistency, etc.
  • 2007 – Oracle released Oracle11g. The new version focused on better partitioning, easy migration, etc.

Features

  • Concurrency
  • Read Consistency
  • Locking Mechanisms
  • Quiesce Database
  • Portability
  • Self-managing database
  • SQL*Plus
  • ASM
  • Scheduler
  • Resource Manager
  • Data Warehousing
  • Materialized views
  • Bitmap indexes
  • Table compression
  • Parallel Execution
  • Analytic SQL
  • Data mining
  • Partitioning

MS ACCESS

This is one of the most popular Microsoft products. Microsoft Access is an entry-level database management software. MS Access database is not only inexpensive but also a powerful database for small-scale projects.

MS Access uses the Jet database engine, which utilizes a specific SQL language dialect (sometimes referred to as Jet SQL).

MS Access comes with the professional edition of MS Office package. MS Access has easyto-use intuitive graphical interface.

  • 1992 – Access version 1.0 was released.
  • 1993 – Access 1.1 released to improve compatibility with inclusion the Access Basic programming language.
  • The most significant transition was from Access 97 to Access 2000.
  • 2007 – Access 2007, a new database format was introduced ACCDB which supports complex data types such as multi valued and attachment fields.

Features

  • Users can create tables, queries, forms and reports and connect them together with macros.
  • Option of importing and exporting the data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc.
  • There is also the Jet Database format (MDB or ACCDB in Access 2007), which can contain the application and data in one file. This makes it very convenient to distribute the entire application to another user, who can run it in disconnected environments.
  • Microsoft Access offers parameterized queries. These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO.
  • The desktop editions of Microsoft SQL Server can be used with Access as an alternative to the Jet Database Engine.
  • Microsoft Access is a file server-based database. Unlike the client-server relational database management systems (RDBMS), Microsoft Access does not implement database triggers, stored procedures or transaction logging.

SQL

SQL SELECT Statement

SELECT column1, column2....columnN
FROM   table_name;

SQL DISTINCT Clause

SELECT DISTINCT column1, column2....columnN
FROM   table_name;

SQL WHERE Clause

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION;

SQL AND/OR Clause

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION-1 {AND|OR} CONDITION-2;

SQL IN Clause

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name IN (val-1, val-2,...val-N);

SQL BETWEEN Clause

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name BETWEEN val-1 AND val-2;

SQL LIKE Clause

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name LIKE { PATTERN };

SQL ORDER BY Clause

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION
ORDER BY column_name {ASC|DESC};

SQL GROUP BY Clause

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name;

SQL COUNT Clause

SELECT COUNT(column_name)
FROM   table_name
WHERE  CONDITION;

SQL HAVING Clause

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name
HAVING (arithematic function condition);

SQL CREATE TABLE Statement

CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);

SQL DROP TABLE Statement

DROP TABLE table_name;

SQL CREATE INDEX Statement

CREATE UNIQUE INDEX index_name
ON table_name ( column1, column2,...columnN);

SQL DROP INDEX Statement

ALTER TABLE table_name
DROP INDEX index_name;

SQL DESC Statement

DESC table_name;

SQL TRUNCATE TABLE Statement

TRUNCATE TABLE table_name;

SQL ALTER TABLE Statement

ALTER TABLE table_name {ADD|DROP|MODIFY} column_name {data_ype};

SQL ALTER TABLE Statement (Rename)

ALTER TABLE table_name RENAME TO new_table_name;

SQL INSERT INTO Statement

INSERT INTO table_name( column1, column2....columnN)
VALUES ( value1, value2....valueN);

SQL UPDATE Statement

UPDATE table_name
SET column1 = value1, column2 = value2....columnN=valueN
[ WHERE  CONDITION ];

SQL DELETE Statement

DELETE FROM table_name
WHERE  {CONDITION};

SQL CREATE DATABASE Statement

CREATE DATABASE database_name;

SQL DROP DATABASE Statement

DROP DATABASE database_name;

SQL USE Statement

USE database_name;

SQL COMMIT Statement

COMMIT;

SQL ROLLBACK Statement

ROLLBACK;

Source: Tutorials Point

For more details on preparation strategy: Click Here.

For detailed information about standard study material: Click Here

Share this...
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter

68 thoughts on “UGC NET Database Management System Notes (Part-II)”

  1. I was suggested this web site through my cousin. I’m now not sure whether
    or not this put up is written by way of him as nobody else know such targeted about my trouble.
    You’re amazing! Thank you! Napoli Trikot Kinder

  2. Best CBD Vape Juice: Our Guide to the Top CBD E-Liquid Brands,Ave40vapeshopwholesale2019 We used third-party lab analysis and blind product testing to evaluate dozens of CBD vape juice products.Best Vape Juices in 2019: E-Juice Flavors and E-Liquid Brands,Browsing for best vape brands?Best Vape Brands, Wholesale & Suppliers -Ave40.
    [url=https://www.ave40.com/wholesale-service.html]vape wholesale china[/url]
    vape wholesale china

  3. Best Vape Pens, Premium Dab Pens and Vaporizer Pen,Find the best selling vape pens, vaporizers and e-liquid here.Ave40vapeshopwholesale2019 Vape pens are great way to consume cannabis on the go. Some work with concentrates, and some with dry herb. Find your next adventure companion here.
    nikola

  4. SMOK is world’s most popular vape brand.Ave40vapeshopwholesale2019 SMOK try their best to produce the best e-cig products to you and provide optimal vaping flavor and taste.Buy SMOK Vape Coils, Tanks, Mods and E Cigarette Kit Online | Electronic Cigarettes Wholesale,Vape Wholesale and Distribution – Ave40.
    rincoe neso x kit

  5. Best Cheap Wedding Dresses, red prom Dress Trends from Spring 2019 Bridal,Find the best selection of cheap wedding dresses at vdressy.com,We offer the best products for the cheap prom dresses cheap bridesmaid dresses mother of the bride dresses and wedding guest dresses.#weddingdresses,#cheapweddingdresses,#cheapbridesmaiddresses
    Cheap Formal dresses

  6. Cheap Evening Dresses & Formal Gowns Online | Browse fashion styles of evening dresses and gowns,1000s of styles with custom size & 52+ colors, long or short evening dresses now up to 75% off!Shop for cheap Evening Dresses? We have great 2019 Evening Dresses on sale.Buy cheap Evening Dresses online at vdressy.com today!#eveningdressesuk,#eveningdresses2019,#eveningdresseslace,#eveningdressesireland,#cheapeveningdresses,#cheaplongeveningdresses,#cheaplongeveningdressesuk,#cheapplussizeeveningdressesunder200,#cheapplussizeeveningdresses,#cheapwhiteeveningdresses
    cheap white evening dresses

  7. I’d must verify with you here. Which isn’t one thing I usually do! I get pleasure from reading a submit that may make folks think. Also, thanks for allowing me to comment!

  8. Hey I know this is off topic but I was wondering if you
    knew of any widgets I could add to my blog that automatically tweet
    my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have
    some experience with something like this. Please let me know if you run into anything.

    I truly enjoy reading your blog and I look forward to your new updates.

  9. My partner and I stumbled over here by a different web page
    and thought I may as well check things out.
    I like what I see so now i am following you.
    Look forward to looking at your web page repeatedly.

  10. Ave40 are passionate about vaping! We build innovative vape devices including mods, tanks, vaping kits & tools.Ave40vapeshopwholesale2019 Browse our wide inventory of SMOK box mods, replacement vape coils, and vape tanks. Check out our huge selection of vapor cigarettes and find the best e-cig for your needs.
    Cartomizer

  11. Ave40 is your premium e-liquid and cbd brand selling quality products and the best liquids in the vape and cbd industry.Ave40vapeshopwholesale2019 Vape Club | eLiquids | Kits | Mods | Tanks | Pods,The world’s most popular vapor brand. From gettings start kits to ultimate and flavor taste tanks to cloud beast ones, customize your vaping life with SMOK.
    vladdin

  12. Ave40 | Online Vape Shop | Electronic Cigarettes, E-Juice & More.Ave40vapeshopwholesale2019 Best e-cigarette store for Ireland and England. Try some Best e-liquid and e-cigarette flavors from the best e-cig shop.8000000 Smokers’ choice! Brand electronic cigarettes for vapers, buy best brand e-cigarettes like vapor cigarettes, smokeless cigarettes, vaping starter kit etc.
    SMOK Mico Pod Kit https://www.ave40.com/smok-mico-pod-kit.html
    SMOK Mico Pod Kit

  13. Hello just wanted to give you a quick heads up. The words
    in your content seem to be running off the screen in Ie.

    I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I thought I’d post to let
    you know. The style and design look great though! Hope you
    get the issue solved soon. Cheers

Leave a Reply

Your email address will not be published. Required fields are marked *