by SQL Commands
- SQL commands are instructions. It is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data.
- SQL can perform various tasks like create a table, add data to tables, drop the table, modify the table, set permission for users.
Data Definition Language (DDL)
- DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.
- All the command of DDL is auto-committed that means it permanently saves all the changes in the database.
Commands that come under DDL:
- Create
- Alter
- Drop
- Truncate
Data Manipulation Language
- DML commands are used to modify the database. It is responsible for all form of changes in the database.
- The command of DML is not auto-committed that means it can’t permanently save all the changes in the database. They can be rollback.
Commands that come under DML:
- Insert
- Update
- Delete
Data Control Language
DCL commands are used to grant and take back authority from any database user.
Commands that come under DCL:
- Grant
- Revoke
Transaction Control Language
- TCL commands can only use with DML commands like INSERT, DELETE and UPDATE only.
- These operations are automatically committed in the database that’s why they cannot be used while creating tables or dropping them.
Commands that come under TCL:
- Commit
- Rollback
- Savepoint
Data Query Language
DQL is used to fetch the data from the database.
It uses only one command:
- Select
Report generation
A report generator is a computer program whose purpose is to take data from a source such as a database, XML stream or a spreadsheet, and use it to produce a document in a format which satisfies a particular human readership.
Report generation functionality is almost always present in database systems, where the source of the data is the database itself. It can also be argued that report generation is part of the purpose of a spreadsheet. Standalone report generators may work with multiple data sources and export reports to different document formats.
An early report writer was part of the Nomad software.
Information systems theory specifies that information delivered to a target human reader must be Timely, Accurate and Relevant. Report generation software targets the final requirement by making sure that the information delivered is presented in the way most readily understood by the target reader.
Features of Report Generator:
- For every phase of report generation, the report generator is user-friendly and effective.
- From numerous sources of data, report generators can easily extract information.
- Report generator operators with real-time work. The reports are automatically generated after arranging templates and report the frequency of annual, quarterly, monthly, and day to day reports and are sent to the email address that is set.
- Report generator supports the reuse of templates to generate reports.
- Printing or exporting of reports is supported by the report generator. The report can be exported or printed in pdf, images, or excel.
- Users can review the reports anywhere and anytime by their phones with the help of the report generator.
Steps to Generate
Step 1
Open your preferred DBMS. Ensure that the application loads the data from the appropriate database.
Step 2
Navigate to the report writer within your DBMS. Select the tables from the database you wish to report. For example, your database might contain all inventory information but your report might want to pull only the tables that contain damaged and returned inventory.
Step 3
Design the appearance of your report in the “what-you-see-is-what-you-get” (WYSIWIG) report designer window. Insert static text, such as headers and titles, like “Damaged Inventory.”
Step 4
Insert dynamic text. Use the query language of your DBMS to indicate where the report generator should insert the values for specific fields, such as “Serial Number” or “Date Returned.”
Step 5
Preview the report using the report writer in your DBMS. Check that the layout displays properly and that the dynamic text is correct. Make any necessary corrections to the template.
Step 6
Export the report using your DBMS report writer. Save the file in your desired format, such as PDF or XML.
