Posts
SQL, or Structured Query Language, is a language used to create relational databases and
manipulate data in them. It is pronounced either by its letters (Ess-Que-Ell) or as a word (Seequel),
depending on whom you talk to.
SQL is an open standard database language, supported by ANSI (American National
Standards Institute). SQL has become the language of choice for designing, querying, and
updating relational databases. Oracle, Sybase, Microsoft SQL Server, MySQL, IBM DB2,
Microsoft Access, and Lotus Approach, and many others all support SQL. Indeed over 100
database management products, running on everything from PCs to mainframes, support SQL.
Most systems also have their own visual Query by Example (QBE) interface. But while QBE
varies widely among database systems, SQL is an ANSI standard and varies only slightly. Also,
some kinds of queries cannot be done in QBE on many database systems.
For both database administrators and programmers, knowledge of SQL is essential and
transportable. SQL is often used in client-server programming, web programming, and many
other environments.
manipulate data in them. It is pronounced either by its letters (Ess-Que-Ell) or as a word (Seequel),
depending on whom you talk to.
SQL is an open standard database language, supported by ANSI (American National
Standards Institute). SQL has become the language of choice for designing, querying, and
updating relational databases. Oracle, Sybase, Microsoft SQL Server, MySQL, IBM DB2,
Microsoft Access, and Lotus Approach, and many others all support SQL. Indeed over 100
database management products, running on everything from PCs to mainframes, support SQL.
Most systems also have their own visual Query by Example (QBE) interface. But while QBE
varies widely among database systems, SQL is an ANSI standard and varies only slightly. Also,
some kinds of queries cannot be done in QBE on many database systems.
For both database administrators and programmers, knowledge of SQL is essential and
transportable. SQL is often used in client-server programming, web programming, and many
other environments.
0 comments:
Post a Comment