‘© Export the report to another file format, (2) Click Close Print Preview. ‘To Print a report: (Q) To print a report without previewing it, Right-click the and click Print. The report is sent to your default printer. @) If you select the report in the Navigation Pane and select Print from «an select additional printing options such as number of pages and printer. ESE rropuction To sat SOL stands for “Structured Query Language” and can be pronounced ay “SEQUEL”. It is a special-purpose language used to define, access, and ‘manipul: = DBMS. SQL provides a set of statements for storing and retrieving data to and Res’ i database. The original version called SEQUEL (Structured English Query Laxg designed by IBM in mid-1970s. SQL was frst introduced as a commercial daabet st 1979 by Oracle Corporation. an eport in the Navigay the File Copies and spe Today, almost all modem Relational Database Management Systems like, Mi Server, Microsoft Access, Oracle, DB2, Sybase, MySQL and Informix use SQL ay standang database language. Most of these have provided their own implementation thus enhancing feature and making it a powerful too. For example, Microsoft SQLServer specifi version egg SQL is called T-SQL, Oracle version of SQL. is called PL/SQL, and MS Access version of SQl'g called JET SQL etc. icrosoft Sq. SQL is different from other programming languages like C++, Visual Basic etc tis anum Procedural, English-like language that processes data in groups of records rather than ew. record at atime. Unlike programs in other languages, where you specify the sequence ofstesis be performed, a SQL program/SQL statement only expresses the desired result. The responsibility for determining how the data will be processed in order to generate the destel result is left to the database management system. This non-procedural nature of SQL makesit easier to access data in application programs. ' What can SQL do? © SQL can retrieve data from a database. * SQL can execute queries against a database * SQL can insert records in a database oA : © SQL can update records in a database. a * SQL can delete records from a database. | oe * SQL can create new databases. con * SQL can create new tables in a database. \ & Fitecreate stored procedures in a database. create Views in a database, an set permissions on tables, Procedures, and views, ids are instructions used to communicate wit P ith th fea ny work with data. SQL commands can be used not only psc the datat Rio perform various other functions like, for example, you can create th ve = ‘or modify data, drop the table, set permissions for users, E She Rien Fe i ne io lg opengl (1) Data Query Languag * SQL command used for retrieving or selecting data from the database. DOL command used in SQL is SELECT. eee (@) Data Definition Language (DDL): These SQL commands are used for creating " or modifying, and dropping the structure of database objects. DDL commands used in’ 2 in SQL are CREATE, ALTER, DROP, RENAME, and TRUNCATE. ] al G) Data Manipulation Language (DML): These SQL commands are used for inserting, was modifying, and deleting data. DML commands used in SQL are INSERT, UPDATE, and a DELETE, (4) Transaction Control Language (TCL): These SQL commands are used for managing QL- changes affecting the data. TCL commands used in SQL are COMMIT, ROLLBACK, zl and SAVEPOINT its (6) Data Control Language (DCL): These SQL commands are used for providing security i to the database objects. DCL commands used in SQL are GRANT and REVOKE. is mn QUESTIONS ne S | (1 MARK QUESTIONS) ] d # Fillin the Blanks _ soi 2 ' 1. DBMS stands for_ ~~ (North Odishe University, 2022, Rajendra University Odlsha, 2022) (FM. University Odisha, 2022, Sambalpur University Odisha, 2022) :) College, Odisha, 2022) (Gerhampur University Odisha, 2022, Bhadrak (Autonomous) pe ong sofware that helps you to manage data. (RD. University Odisha, 2022). <{3-TEMS is an intertace between the ___— and aplication programa, database schema, 4. One of he responsibities of a_ iso create “ ‘see lets you find and retrieve information from one or more tables based on a set of search ‘ek 2A Conditions you define. ‘ 6. Files are referred to as in database terminology.