Learn MySQL in 3 Days – 100% Practical




        If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.


You will get:
  • What is database? SQL and noSQL, Introduction to MySQL, Creating a Database and Table, Primary key and other constraints.DDL commands with practical implementation.
  • DML commands with practical implementation. 
  • Will end the session by providing a cheat sheet for MySQL commands.

Syllabus:
Day 1:
  • What is a database?
  • SQL and NoSQL
  • Introduction to MySQL
  • Creating a Database and Table
  • Primary key and other constraints.
  • Live Demo of these commands
Day 2:
  • DDL commands with practical implementation.
  • CREATE to create a new table or database.
  • ALTER for alteration.
  • Truncate to delete data from the table.
  • DROP to drop a table.
  • RENAME to rename a table.
Day 3:
  • DML commands with practical implementation
  • Create command
  • Update command
  • Select command
  • Delete commands
  • MERGE for merging two rows or two tables.
  • Will create a table with CRUD Operations
  • Will end the session by providing a cheat sheet for MySQL commands.










Previous
Next Post »