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