My SQL in Hindi हिंदी में सीखे

About My SQL in Hindi हिंदी में सीखे

इस App का लक्ष्य उन सभी students और IT professionals की help करना है जो computer science और IT के field में नए है और नए नए subjects को समझने का प्रयास कर रहे है। यँहा पर आपको computer science और IT tutorials streams से related सभी subjects की tutorials Hindi में provide की गयी है। इस में सभी tutorials हिंदी में दी गयी है। हिंदी में आप आसानी से और जल्दी समझ सकते है।

Contents:

MySQL
Introduction to MySQL
Features of MySQL
Architecture of MySQL

DBMS (Database Management System)
What is DBMS (Database Management System)
What is R-DBMS (Relational Database Management System)

Installing MySQL
MySQL supported platforms
Installing MySQL in Windows

SQL (Structured Query Language)
Introduction to SQL (Structured Query Language)
Features of SQL
Keywords of SQL
Different types of SQL statements

MySQL Data Types
Introduction to MySQL Data Types
Rules for using MySQL Data Types
Different MySQL Data Types

MySQL Databases
Introduction to MySQL databases
Creating Databases
Altering Databases
Dropping Databases

MySQL tables
Introduction to MySQL tables
Properties of a MySQL table
Creating MySQL tables
Altering MySQL tables
Truncate a MySQL table
Removing MySQL tables
Using indexes
Assigning keys

Select, from, where & order by
Fetching data with MySQL SELECT statement
Use of MySQL FROM clause
Use of MySQL DISTINCT clause
Use of MySQL WHERE clause
Use of MySQL ORDER BY clause

Insert, delete & update
Inserting data in MySQL tables
Deleting rows from MySQL tables
Updating data in MySQL tables
Replacing data in MySQL tables
Truncating data from MySQL tables

SQL expressions & functions
Introduction to SQL expressions
Numeric expressions
String expressions
Temporal expressions
Use of MySQL like clause
Functions in MySQL expressions

MySQL Joins
Introduction to MySQL joins
Types of MySQL joins
MySQL Inner join
Left join
Right join

Sub Queries
Introduction to MySQL subqueries
Advantages of MySQL subqueries
Types of MySQL subqueries
Defining MySQL subqueries

MySQL Views
Introduction to MySQL views
View processing algorithms
Creating MySQL views
Altering MySQL views
Dropping MySQL views

Prepared Statements
Introduction to MySQL prepared statements
Creating a MySQL prepared statement
Executing a MySQL prepared statement
De-allocating a MySQL prepared statement
MySQL Transactions
Introduction to MySQL transactions
ACID properties
Transaction execution process
Transaction control statements

Stored Routines
Introduction to MySQL stored routines
Uses of MySQL stored routines
Advantages of MySQL stored routines
Types of MySQL stored routines
MySQL Stored procedures
Stored procedures with parameters
MySQL Stored functions

MySQL Triggers
Introduction to MySQL triggers
Creating MySQL triggers
Deleting MySQL triggers

MySQL Metadata
Introduction to MySQL metadata
MySQL INFORMATION SCHEMA
MySQL SHOW statement
MySQL Describe statement

मुझे आशा है की ये App आपको पसंद आएगी। यदि आप अपने विचार share करना चाहते है या फिर कोई suggestion देना चाहते है तो mail कर सकते है।



Free Educational Apps for nation
By
Surendra Kumar
Suren ICT Tech Lab
Sikar (Raj) India