Language : Telugu Edition

Category : IT Courses

Price : Rs. 249

See Demos
In Stock

Delivered in 3-4 business days.

A database is an organized collection of data. The data can be textual, like order or inventory data, or it can be pictures, programs or anything else that can be stored on a computer in binary form. SQL language was created to query(add, edit, delete, create etc) the database. Some databases have minimal feature sets and only store data, while others include programming languages, facilities and utilities to support enterprise-level applications like ERP and data warehousing.Its relational database was the first to support the SQL language, which has since become the industry standard.

MySQL was a free-software database engine originally developed and first released in 1995. MySQL is named after My, the daughter Michael Widenius, of one of the product’s originators. It was originally produced under the GNU General Public License, in which source code is made freely available.

MySQL is very popular for Web-hosting applications because of its plethora of Web-optimized features like HTML data types, and because it's available for free. It is part of the Linux, Apache, MySQL, PHP (LAMP) architecture, a combination of platforms that is frequently used to deliver and support advanced Web applications. MySQL runs the back-end databases of some famous websites, including Wikipedia, Google and Facebook- a testament to its stability and robustness despite its decentralized, free-for-all philosophy.

MySQL was originally owned by Sun Microsystems; when the company was purchased by Oracle Corp. in 2010, MySQL was part of the package. Although MySQL is technically considered a competitor of Oracle DB, Oracle DB is mainly used by large enterprises, while MySQL is used by smaller, more Web-oriented databases. In addition, MySQL differs from Oracle's product because it's in the public domain.

You don't need to do know any programming to attend this course. However you need to know the basics of Windows Operating System and you should be able to use Windows in your system comfortably.

If you are not familiar with the Windows environment, we recommend you to complete the course "Introduction To Windows".
  • Introduction to Database
  • Database Architecture 1 Tier, 2 Tier & 3 Tier
  • MySql Introduction
  • Installation of MySql
  • Setting Work Environment
  • Login to MySql Users
  • Creating New Users
  • Principles of Entering commands
  • Naming Rules
  • User Defined Variables & Comments
  • DataTypes
  • SQL Introduction
  • Creating & Managing Databases
  • Creating Tables
  • Insert Data into Tables
  • Retrieve Data from Tables using Select Statement
  • Create Table & Insert Statements using Select Statement
  • SELECT INTO & LOAD Statements to Export & Import Data
  • Operators
  • Introduction to Data Integrity Constraints
  • Data Integrity Constraints & NOT NULL, UNIQUE & PRIMARY KEY
  • Data Integrity Constraints & DEFAULT, AUTOINCREMENT & CHECK
  • Data Integrity Constraints & FOREIGN KEY or Referential Integrity
  • Indexes
  • MySql Partitioning - RANGE Partitioning
  • MySql Partitioning - LIST, COLUMNS, HASH, KEY & SUB Partitioning
  • Mathematical Functions
  • String Functions
  • Date & Time Functions
  • Control Flow Functions
  • Encryption & Compression Function
  • Information Functions
  • Aggregate or Group Functions
  • Other Functions
  • Joins
  • Union Operator
  • Sub-Queries
  • Common Queries & Sub Queries Examples
  • Transaction & Locking Commands (TCL)
  • Data Control Language Commands (DCL)
  • PhpMyAdmin - How to Start & MySql with GUI
  • How to Manage Databases & Tables using PhpMyAdmin
  • How to Build Query, Export & Import Databases using PhpMyAdmin
  • Introduction to Stored Programs
  • Stored Routines - Procedures
  • Stored Procedures & Control Statements
  • Cursors
  • Stored Routines - Functions
  • Triggers
  • Events
  • Views