Send Us Inquiry

MYSQL Training in Nepal

Database training center in Kathmandu Nepal

Duration: 1 Month Career Option: DBA

Why MYSQL Training

  • It is open source and widely used relational database system
  • Relatively cost-efficient and easy to use
  • Developed for fast data processing and retrieving
  • Various Support Forums available for guidance and mutual learning
  • MySql being compatible with almost every operating system
  • Currently adopted by thousands of companies
  • Plenty of work offers for individuals with MySql expertise in foreseeable future
  • Good career opportunity as Database Administrator, Data Analyst and so on

Pre-requisites:

Students attending this MYSQL training course should have basic knowledge of Query language

Courses Outline :- MYSQL Training in Nepal
  • 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 on Linux and Unix 
  • Using Mysqladmin 
  • Setting the Root User Password 
  • Using the Mysql Client 
  • Users and Privileges 
  • Normalization
  • Understanding Keys
  • Understanding Relationships
  • First Normal Form
  • Second Normal Form 
  • Third Normal Form 
  • 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
  • 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 
  • Stored Routines
  • Using OUT Parameters
  • Triggers
  • Views 
  • The MySQL Administrator
  • Backing Up Databases
  • Importing Data
  • MySQL Logging
  • Database Maintenance
  • Improving Performance

Send Enquiry

Choose Course
  • MYSQL

Tags