Total Page Preview: 000000000336
Define database in SQL in English and Hindi
Database in SQL in English
In SQL, a database is a collection of related data that is organized and stored in a structured way, so that it can be easily accessed, managed, and updated. It is a software system that allows users to store and retrieve data as well as perform various operations on that data, such as querying, updating, and deleting.
Here's an example of a database in SQL:
Let's say we have a company that sells products online. We need to store information about our products, customers, orders, and transactions in a database. To do this, we can create a SQL database called "online_store" with multiple tables for each type of data we need to store.
In this example, we've created a SQL database called "online_store" and defined multiple tables to store different types of data. The "products" table contains information about the products we sell, such as their name, description, price, and inventory. The "customers" table contains information about our customers, such as their name, email, phone number, and address. The "orders" table contains information about each order placed by a customer, including the order ID, the customer ID, the order date, and the total amount. Finally, the "transactions" table contains information about each transaction, including the transaction ID, the order ID, the transaction date, and the amount.
By creating a database with multiple tables, we can easily organize and manage our data in a structured way. We can also perform various SQL operations on our data, such as querying for specific information, updating records, and deleting records as needed.
Database in SQL in Hindi
Database ek organized collection hoti hai jismein data store kiya jata hai, jis se baad mein us data ko access kiya jaa sakta hai. SQL (Structured Query Language) ek programming language hai jiska use relational database management system (RDBMS) mein data storage, retrieval aur management ke liye kiya jata hai. SQL ka use data manipulation, data definition, aur data control ke liye kiya jata hai.
Ek example ke roop mein, agar hum ek simple database banayenge jismein "students" ke naam se ek table hogi jismein students ke naam, roll number aur marks store kiye jaa sakte hain. Iske liye, hum pehle ek table create karenge:
Is command se, "students" naam ki ek table ban jayegi jismein columns honge id, name, roll_number aur marks.
Iske baad, hum is table mein data insert kar sakte hain:
Is command se, students table mein 4 records insert ho jayenge.
Ab, hum is table se data retrieve kar sakte hain:
Is command se, students table se saare records retrieve ho jayenge.
Hum is table se specific data bhi retrieve kar sakte hain, jaise ki:
Is command se, students table se woh records retrieve ho jayenge jinme marks 85 se zyada hai, aur sirf name aur marks columns show honge.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com