Course details

MYSQL- Course Outline

Installing MySQL

  • General Installation Steps
  • Installing MySQL on Windows
  • Configuring MySQL on Windows
  • Installing MySQL on Macintosh
  • Installing MySQL on Linux
  • Basic Configuration Options
  • Upgrading MySQL

Running MySQL

  • Running MySQL on Linux and Unix
  • Using Mysqladmin
  • Setting the Root User Password
  • Using the Mysql Client
  • Users and Privileges

Database Design

  • Normalization
  • Understanding Keys
  • Understanding Relationships
  • First Normal Form
  • Second Normal Form
  • Third Normal Form

Creating a MySQL Database

  • MySQL Data Types
  • Extra Column Characteristics
  • Introduction to Indexes
  • Finalizing a Table's Design
  • Choosing a Storage Engine
  • Character Sets and Collations
  • Creating Databases
  • Creating Tables
  • Modifying Tables

Basic SQL

  • Using Values in Queries
  • Inserting Data
  • Selecting Data
  • Using Conditionals
  • Using LIKE and NOT LIKE
  • Performing Joins
  • Sorting Query Results
  • Limiting Query Results
  • Updating Data
  • Deleting Data

MySQL 5 Features

  • Stored Routines
  • Using OUT Parameters
  • Triggers
  • Views

MySQL Administration

  • The MySQL Administrator
  • Backing Up Databases
  • Importing Data
  • MySQL Logging
  • Database Maintenance
  • Improving Performance
Updated on 23 August, 2016

About Broadway Infosys Nepal

Broadway Infosys Nepal is one of the best inclusive computer training institutes in Kathmandu, Nepal. Established in 2008, our professional IT Training and Development center has been employing experts in this field to impart professional education to trainees. We offer well-structured complete professional training in various Programming Languages, Graphics & Multimedia, Web Designing as well as Development Training that is based upon the current recruitment needs in the IT market.

Further, we also provide training on thorough understanding of:

  • Project Requirement Identification and Analysis,
  • Software Development Life Cycle,
  • Functional Design,
  • Testing and Implementation
  • Quality Assurance

Since establishment, we have successfully established and maintained network with more than fifty IT and other companies which has made us able to offer and provide our students with internship and job opportunities.

See all Broadway Infosys Nepal courses
Are you from Broadway Infosys Nepal ? Claim your course!
Courses you can instantly connect with... Do an online course on MySQL starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or