7/1/2023 0 Comments Mysql training free![]() ![]() Types of set operations in sql – Union – Union all – Intersect – Except – Pre-conditions to use a set operator – Difference bw union and union all? What is mean by subquery? – Types of subqueries – Independent subquery – Co related subquery – What is meant by joins in sql? – Types of joins – Inner join – Outer join – Left join – Right join – Full join – Cross join – MySQL Training Concepts Order by, group by, top, distinct, having clause and alias – What is meant by schema? – How to create and drop a schema in MYSQL ? What is meant by system functions? – Different types of system functions available – Aggregate functions – Mathematical functions – String functions – Date time functions – Other functions ![]() Types of SQL constraints – Primary key – Foreign key – Unique key – Not null – Default constraint – Check constraint – What is meant by identity? – how to manually insert a value in identity column? – How to reseed identity column values? – How to get the last generated identity values? What is phpmyadmin – What is Xampp – Types of SQL commands – DDL: – DML – DCL – TCL – Integer datatypes – String datatypes – Date time data types – UDD-User Defined Data types – Arithmetic operator – Logical operator – Comparison operator – Variable definition – Types of variables – Local variables – Global variables What is mean by DBMS and its usage? – Introduction to the relational databases – Difference between relational and non-relational databases – Different types of DBMS available in the market – Different version of MYSQL server – Why we are using SQL in DBMS? – What is SQL and introduction to the SQL scripts? 100% Practical – Live HandsOn – MySQL Training and Certification ![]()
0 Comments
Leave a Reply. |