1 / 1

Programming Tutorial

Know about SQL commands and their use with examples

Codeatglance
Télécharger la présentation

Programming Tutorial

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Programming Tutorial SQL stands for Structured Query Language designed to execute operations like storing, retrieving and manipulating data such as updating records, deleting records, creating and modifying tables, views etc in the relational database. SQL is only a query language, and not a database. For executing SQL queries, databases need to be installed, such as Oracle, MongoDB, DB2, MySQL, SQL, SQL Server, PostGre, etc. SOME ADVANTAGES OF SQL SQL consists mainly of English statements that make it easy to learn and write SQL queries. Create, Drop databases and tables. Create views, stored procedures, and functions in a database. Set permissions on tables, procedures, and views. Access data in relational database management systems. Users can describe, define and manipulate the data. SQL queries are effective in handling large amounts of data. Databases for SQL use established standards accepted by ANSI and ISO whereas Non-SQL databases do not consider any such standards. SQL COMMANDS: Now SQL interacts with the relational databases using commands that are classified into different groups and are listed as below 1. DATA DEFINITION LANGUAGE (DDL): The DDL statements are used to handle the design and storage of database objects by performing alter / modify database or table structure and schema operations. Below are mentioned DDL commands A.) CREATE: B.) ALTER: More about SQL command

More Related