daac-courses

Mysql

Mysql

MySQL® is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux™, Apache™, MySQL®, PHP/Perl/Python®. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class encourages the student to explore database fundamentals, as well as MySQL features. Students learn the basics of MySQL use and the programming of stored routines and triggers. Students also participate in database design discussions, perform administrative functions, learn about optimization and performance tuning, and explore various APIs. This course covers MySQL 5.6.

Course Feature

MySQL

  • Duration 1 Months
  • Class Timings 1.5 hour a day, 5 days a week
  • Eligibility

Module - I

Database

  • MySQL Introduction
  • MySQL Installation
  • MySQL Administration
  • MySQL PHP Syntax
  • MySQL Connection
  • MySQL Create Database
  • MySQL Drop Database
  • MySQL Select Database
  • MySQL Datatype
  • MySQL Create Table
  • MySQL Drop Table
  • MySQL Insert Query
  • MySQL Select Query
  • MySQL Where Clause
  • MySQL Update Query
  • MySQL Delete Query
  • MySQL Like Clause
  • MySQL Sorting Results
  • MySQL Using Join
  • MySQL Null Values
  • MySQL Regexps
  • MySQL Transactions
  • MySQL Alter Command
  • MySQL Indexes
  • MySQL Temporary Tables
  • MySQL Clone Table
  • MySQL Database Info
  • MySQL Using Sequences
  • MySQL Handling Duplicates
  • MySQL SQL Injection
  • MySQL Database Exports
  • MySQL Database Import
Minor Exam and Project

Powered by Froala Editor

Skills Certificate
From the DAAC

Get In Touch
Related Courses

Highlights of Related Courses in Jaipur

Discover Our App

Access your courses anywhere, anytime & prepare with practice tests