Introduction to SQL 💗

 Introduction to SQL💗



A. ENGAGE

A. DATA DEFINITION LANGUAGE

 - A data definition or data description language in the context of SQL is a syntax for creating and changing database objects such as tables, indices, and users.

B. INTERACTIVE DATA MANIPULATION LANGUAGE

- Interactive Data Manipulation Language or DML  is a set of computer languages that are expressly used to change the database, such as CRUD operations to create, read, update, and remove data. INSERT, SELECT, UPDATE, and DELETE commands are used.

C. EMBEDDED DATA MANIPULATION LANGUAGE
- Embedded SQL is a means of merging a programming language's computing capability with SQL's database manipulation capabilities. Embedded SQL statements are SQL statements that are written inline with the host language's program source code.

B. EXPLORE & EXPLAIN 

1. What are the basic sql expression?
 - SQL expression can be classified into following categories.

  1.  SQL Boolean Expression - fetches data based on the condition that is mentioned as part of the  SQL query.
  2.  SQL Date Expression - SQL Date Expression results in datetime value.
  3.  SQL Numeric Expression - SQL Numeric Expression is used for performing mathematical operation in SQL query .

2. What is the difference between simple equijoin and natural join?
  - An equijoin would find rows with the same 'A' value in both tables. A natural join, on the other hand, matches data based on column names that are shared by two tables.


3. What are the different types of join?



 
 
 


 



4. What are the different components of sql structure?












5. What is the different between write and fetch transaction?
- The write statement is the start while the fetch statements return the value for the column specified in declare cursor as a single-row result set.

C. ELABORATE & EVALUATION

1. The where clause

2. PROC SQL

3. Database Management System

4.Data Definition Language

5.The select clause



Comments

Post a Comment

Popular posts from this blog

DATABASE MANAGEMENT SYSTEM

Image
DATABASE MANAGEMENT SYSTEM  A. What is a Database? - It is an organized collection of structure information, or data, typically stored electronically in computer system. B. What type of Software is Microsoft excel? - Microsoft Excel is a spreadsheet program included in Microsoft Office suite of application. C. What type of Software is Microsoft access? - Microsoft Access is a database management system DBMS that combines the relational Microsoft  Jet Database Engine with a graphical user interface and software development tools. D. think of at least two differences between access and excel. - Excel is made up of sheets with cells that can be used to perform calculations, create charts, and so on. Access, on the other hand, includes tables, queries, forms, and report modules. Overall, Excel is a spreadsheet, whereas Access is a database management system. B. Explore & Explain 1. What is Information Management? - It is the collection and management of informat...
Read more

Functions Of DBMS and Its Advantage and Disadvantage

Image
  Functions Of DBMS and Its Advantage and Disadvantage A. Functions of DBMS    1. Data Dictionary Management    -    DBMS stores definitions of the data elements and their relationships       (metadata)     in a data dictionary. Example of   Data Dictionary Management: 2. Data Storage Management   -  creates and manage the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics. 3. Data transformation and presentation -  transforms entered data in to required data structures. The DBMS relieves you of the chore of making a distinction between the logical data format and the physical data format. 4. Security Management -  creates a security system that enforces user security and data privacy. Security rules determine which users can access the database, which data items each user can access, and w...
Read more