SQL Tutorial
SQL Tutorial
SQL the Language
databases such as Oracle, Microsoft SQL Server, DB2, Sybase, MySQL and Microsoft Access. Any
modern relational database that you may be using, it is bound to support SQL as it’s standard
data qyery and manupulating language. It may differ slightly depending on the kind of Database
it needs to access (i.e. Oracle and SQL Server release their own SQL) but they all follow the
industry accepted standards cimpiled by ANSI and ISO.
SQL statements or through Oracle’s PL/SQL (Programming Language extention of SQL) or embedded
in C, C++, Java. Whatever programming language you use, as soon as you need to manipulate
or process relational data you will need some form of SQL to rectrive and manipulate the data.
The aim of this tutorial is to give a hands-on knowledge of this powerfull but still so simple
language to the beginers as well as to the experienced programmers who likes to revise their
understanding periodically. The totorial includes lots of example which are used by developers
and managers alike for their day to day functions in developing and supporting commercial
databases.
A few words on Oracle
installed for commercial purpose databases for medium to large businesses. I am not saying that
it can not be used for small business but I think there are much cheaper alternative in the
market for that purpose. But when it comes to scale and performance and ease of maintenance
as well as trained man-power I think Oracle is in the fore front among the league.
as a single database management system. Oracle is a relational database management system
(RDBMS) because it stores data in relational model which make it faster to query and maniputale.
Oracle stores data in an object called Table. There are different types of objects in oracle
such as
Table
Index
Contraint
Procedure
Function
Package
Trigger
Sequence
All these objects are logically stored in Oracle logical structures such as Tables, Segments, Extents
and Blobks.
Physically all these logical data are stored in o/s files called Oracle Data files. These files are
stored in o/s level in some directory which varies in different implementations.
Basic Requirement
machine or in a remote machine where you are able to connect.
Students and Majors. Then you will need to Insert data into these two tables using the data files
and SQL*Loader scripts.
Recent Comments