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

The goal of this app is to help all those students and IT professionals who are new to the field of computer science and IT and are trying to understand new subjects. Here you have been provided tutorials of all the subjects related to computer science and IT tutorials streams in Hindi. In this all the tutorials are given in Hindi. In Hindi you can understand easily and quickly.

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

I hope you will like this App. If you want to share your thoughts or give any suggestion then you can mail.

Free Educational Apps for nation

By

Surendra Kumar

Suren ICT Tech Lab

Sikar (Raj) India