Introduction to SQL
| Institution | MASENO UNIVERSITY |
| Course | COMMON UNIT |
| Year | 2nd Year |
| Semester | Unknown |
| Posted By | Mwalimu Evans Okoyo. |
| File Type | doc |
| Pages | |
| File Size | 181.5 KB |
| Views | 1782 |
| Downloads | 0 |
| Price: |
Buy Now
|
Description
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.
Below is the document preview.
Introduction to SQL Notes
Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.
93 Pages
877 Views
0 Downloads
971.46 KB
Introduction to SQL
Introduction to SQL (Structured Query Language) provides a foundation for managing and manipulating relational databases. SQL is a standardized language used to create, retrieve, update, and delete data within databases. It consists of various commands categorized into Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language (DCL), and Transaction Control Language (TCL). SQL enables users to define database structures, query data efficiently, and enforce security through permissions and access controls. Widely used in applications ranging from small-scale software to enterprise-level systems, SQL is essential for database administrators, developers, and data analysts.
6 Pages
157 Views
0 Downloads
620.17 KB