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.
10Expert Score
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.
PROS
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.
4 reviews for Learn MySQL in 3 Days – 100% Practical
4.8out of 5
★★★★★
★★★★★
3
★★★★★
1
★★★★★
0
★★★★★
0
★★★★★
0
Write a review
Show allMost HelpfulHighest RatingLowest Rating
★★★★★
Shivraj Shahane (verified owner)–
Will get certificate?
Helpful(2)Unhelpful(0)You have already voted this
madhvi –
Yes
Helpful(2)Unhelpful(0)You have already voted this
★★★★★
Murali krishna –
Nice planning
+ PROS: Students will definitely beneficial in live projects
Shivraj Shahane (verified owner) –
Will get certificate?
madhvi –
Yes
Murali krishna –
Nice planning
Rupesh Pawase (verified owner) –
Most helpful 👍
Arjun Narale (verified owner) –
Nice course