MySQL is a very popular reliable saleable and free open source relational database management system owned by Oracle. There is a commercial licensed version of MySQL that can be purchased which comes with premium support. This is the version most widely used by notable companies.
The course reviews topics such as introduction to DBMS, structured query language, installation of MySQL, Normalization, data definition language commands, data manipulation language commands, sub queries and constraints, aggregate functions, clauses and views, conceptual data modelling, relational data model, relational query languages, relational database design and transaction processing and current technologies. This course is a practical hand on and should be easy to follow.
Course Objectives:
At the end of the course, delegates will be able to:
- Eliminate duplicate records with MySQL distinct
- Combine results of multiple MySQL queries
- Specify multiple values using MySQL in operator
- Design and build a professional level database using MySQL RDBMS
Who Should Attend?
- SQL aspiring developers
- Anyone who wants to learn something new
- Aspiring database administrators
- Anyone who wants to learn about databases
- Aggregate function, clauses and views
Delivery method: This will include combine lectures, discussions, group exercises and illustrations. Participants will also understand the theoretical and practical knowledge of the topic.
Venue: London
Fee:
Duration: 2 weeks
Course Date: November 1st -12th, 2022