- Location: Tinkune,Subidhanagar, Kathmandu, Shriganesh Marg, Kathmandu 44600, Nepal
- Duration: 1 Month
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
Course Location
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- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Advanced Esp32 - Level 3 Study 365NPR 3,235Duration: 4 Hours
- Data Visualization in Microsoft Excel Lead AcademyNPR 3,406
NPR 53,457Duration: Upto 4 Hours
