MySQL offered by Seven Mentor Pvt Ltd
5.0 /5MySQL at Seven Mentor Pvt Ltd Overview
Duration | 90 hours |
Mode of learning | Online |
Credential | Certificate |
MySQL at Seven Mentor Pvt Ltd Highlights
- Earn a certification after completion
- Job Placement
MySQL at Seven Mentor Pvt Ltd Course details
- SQL stands for Structured query language which is used to interact with the database. In every business, the core and essential part is management of data. On data various CRUD operation is performed such as Create, Read, Update and Delete
MySQL at Seven Mentor Pvt Ltd Curriculum
Introduction
What is SQL?
Why do we need SQL?
What is DataBase Management System? Types of DBMS
Execution Of SQL query
Difference Between SQL and MYSQL
Introduction to MySQL
Installation of MySQL server
Download sample database
Load sample database to work.
Basic SQL Keywords
Basic SELECT Statement
Limit/Offset
OrderBy
Distinct
Where
Comparison Operators
Null
JOINS
What are Joins?
Inner Join
Outer Join
Left Join
Right Join
Self Join
SubQueries/NestedQueries/Inner Queries
Triggers +Views
Stored Procedures +Functions
DML/DDL and Normalisation
DML:Insert
DML:Update, Delete DDL:Create Table
DDL:Alter:Add, Drop, Modify
DDL:Drop Table, Truncate, Delete
DCL:Data Control Language: GRANT,REVOKE
Normalisations
MySQL at Seven Mentor Pvt Ltd Entry Requirements
- Freshers
- BE/ Bsc Candidate
- Any Engineers
- Any Graduate
- Any Post-Graduate
- Working Professionals
Other courses offered by Seven Mentor Pvt Ltd
- – / –
- – / –
- – / –
- – / –
Student Forum
Anything you would want to ask experts?
MySQL at Seven Mentor Pvt Ltd Contact Information
21/A and 31/B,Shreenath Plaza,1st floor,Dnyaneshwar Paduka Chowk,1184/4 F.C Road,
Pune ( Maharashtra)