Introduction to DBMS, What is a Database, What is Management System, Different views of data, Advantages and disadvantages of RDBMS,Introduction to SQL,Sub language of SQL (DDL, DML, DQL/DRL, TCL & DCL).
What is a database table?, How do we create tables?, How do we insert Data?, How to retrieve/select data?, How do we delete data?, How do we update data?
Logical operators, Between operators, In operator, Pattern matching operators.
Detailed coverage of DDL (Data definition language):CREATE, ALTER, DROP, TRUNCATE, RENAME.
MySql Functions, Aggregate functions,Scalar functions (String functions, date related, numeric related, conversion function, null related functions.),Group by, order by, having clause.
Integrity constraints (column and table level). Different types of constraints.
Inner Join, Left Join, Right join and full join.
Triggers, Procedures, Functions, Views and ACID properties.
Normalization (1NF, 2NF, 3NF & BCNF).
No. There are no prerequisites for this course.
Most learners are able to complete the course in about 3 weeks.
Upon completion of the MySQL course you will be a skilled professional ready to face interviews and land a deserving job.
We have limited number of participants in a live session to maintain the Quality Standards, hence, participation in a live class without enrollment is not possible. However, we can create a demo login for one demo session.
You can pay by Credit Card, Debit Card or Net Banking from all the leading banks. We use a Payment Gateway.
We expect around 50 students to be part of the course