Certificate Course In MySQL

by JYCSM (Jatiya Yuva Computer Saksharta Mission) Claim Listing

Certificate Course In MySQL is offered by JYCSM (Jatiya Yuva Computer Saksharta Mission). Jatiya Yuva Computer Shaksharta Mission is the new lighting of computer education in India.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

JYCSM (Jatiya Yuva Computer Saksharta Mission) Logo

img Duration

3 Months

Course Details

Certificate Course In MySQL is offered by JYCSM (Jatiya Yuva Computer Saksharta Mission). Jatiya Yuva Computer Shaksharta Mission is the new lighting of computer education in India. The great scholars realized to make each Indian's life fulfilled with prosperity and improvement, progress through computer education.

 

Content:

  • 1. Definition of DBMS and RDBMS.
  • 2. Advantages and Disadvantages of Database.
  • 3. Database Languages (DDL, DML, DCL)
  • 4. Definition of MySql.
  • 5. Advantages of MySql.
  • 6. How does MySql Works in the Backend Process.
  • 7. Definition of Primary Key, Foreign Key, Candidate Key, Alternate Key.
  • 8. Data types of MySql (Char, Varchar, BLOB or Text, Int, Tinyint, Double, Number, Date, Datetime,
  • Timestamp, Time, Year, Float etc)
  • 9. Sql Commands :
  • A. Create
  • B. Show Database
  • C. USE
  • D. Rename
  • E. Show Tables
  • F. Insert
  • G. Alter
  • H. Drop
  • I. Describe
  • J. Select
  • K. Update
  • L. Select with where clause
  • M. Select with Wildcard Characters
  • N. Select with Count
  • O. Delete
  • 10. Concept of Relationship with example.
  • 11. Types of Relationship with MySql Commands:
  • A. 1:1 Relationship
  • B. 1:Many Relationship
  • C. Many: Many Relationship
  • 12. Concept of Constraints in MySql with Check Command.
  • 13. Group By and Having Clause, Any and ALL clause,
  • 14. Case Statement
  • 15. Project Work.
  • Howrah Branch

    Block A1, Block A, Kalyani, Howrah

Check out more MySQL courses in India

BRIGHT Computer Education Logo

Oracle Training

Oracle is a multinational company that produces various different software. It is one of the biggest technology giants across the globe. It produces  IT products and services which are revered and recognized throughout the world.

by BRIGHT Computer Education [Claim Listing ]
Fita Training Logo

Oracle DBA Training

The Oracle DBA Training program at FITA enables you to get acquainted with how to set up, configure, and administer the Oracle Database and how to develop a recovery and backup strategy of the Databases like a Pro.

by Fita Training [Claim Listing ]
IDES Trainings Logo

Teradata Training

TERADATA Training is an RDBMS system stands for relational data base system where the architecture database is different to other database system .It has an parallel aware optimizer that allow multiple complex queries to run concurrently.

by IDES Trainings [Claim Listing ]
AWT Education (Abstract Web Technologies) Logo

Oracle

Oracle course is offered by AWT Education (Abstract Web Technologies). Database management courses introduce students to languages, applications and programming used for the design and maintenance of business databases.

by AWT Education (Abstract Web Technologies) [Claim Listing ]
GN Infotech Institute Logo

Oracle 11G

Oracle 11G course is offered by GN Infotech Institute. GN Infotech provides the best training in Khanna with an updated curriculum. GN Infotech labs are equipped with latest software so that students can get 100% practical training.

by GN Infotech Institute [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy