+ View More
Description
MySQL is an open source platform used by programmers and analytics resources to query and extract data from a relational data base management system. The platform is free to use and is employed by small and large incorporation's for their applications.
MySQL is a very basic skill set required for any data related activities undertaken in the data science pipeline. The Course very quickly would enable the participants to learn the basic required for the same.
The Course enables the learner to use a SQL on a command line for data base creation , querying and manage data related activities.
Method of Obtaining Certification
Upon successfully completing 80% of this course, the learner will be able to download digital copy of the Certificate and Mark sheet from the Certificates section . The Mark Sheet will keep on updating as the learner progresses towards 100% completion.
Curriculum For This Course
18 Lessons
2:34:06 Hours
Introduction
3 Lessons
00:21:36 Hours
- MySQL Introduction 00:08:13
- Installation 00:09:50
- Connecting to MySQL 00:03:33
Data bases and Data Types
2 Lessons
00:22:38 Hours
- Data base 00:05:23
- Data Types 00:17:15
CRUD Operations
5 Lessons
00:46:20 Hours
- Create Tables 00:11:57
- Insert & Select Query 00:09:40
- Delete Query 00:03:41
- Update Query and Where Clause 00:09:16
- Order By Clause and Like Clause 00:11:46
Joins and Regular Expressions
2 Lessons
00:14:38 Hours
- Joins 00:06:27
- Handling Null Values & Regular Expressions 00:08:11
Transactions and Alter Command
2 Lessons
00:19:42 Hours
- Transactions 00:05:34
- Alter Command 00:14:08
Indexes and Temporary Tables
2 Lessons
00:12:32 Hours
- Indexes 00:04:08
- Temporary Tables 00:08:24
Databases - Clone, Export & Import
2 Lessons
00:16:40 Hours
- Clone Tables 00:05:21
- Export & Import Data Base 00:11:19
+ View More
Other Related Courses
Student Feedback
Reviews
-
Mon, 13-May-2019Rohit GuptaI am a programmer, hence I used SQL at my work, but learning again through complimentary course is fun. -
Wed, 15-May-2019Aditya patilAs this was complimentary course, I am just learning it, i believe it will help in data scrapping and that is a part of Data Science.
-
Tue, 21-May-2019Pradeep GandhiI never did sql so learning it for the first time, content wise it looks informative.
-
Tue, 04-Jun-2019Pooja RajputAs a part of Data Science related learning, SQL helps in Data Scrapping, hence I am learning it.
-
Tue, 04-Jun-2019Surya JoshiSql helps in Data Compilation and Scrapping hence I am learning it for Certification.
-
Tue, 04-Jun-2019Jay DikshitSql explanation is easy to comprehend.
-
Wed, 05-Jun-2019Ruben NairI am happy to have complimentary course added to my account, exploring SQL in the same cost is great.
-
Wed, 05-Jun-2019Ravi SharmaExplanation provided for Sql's course is easy to comprehend.
-
Wed, 05-Jun-2019Shyam MakwanaI learnt SQL in my first year of Eng, the complimentary SQL course has good content and lucid explanation.
-
Wed, 05-Jun-2019Rakesh JadhavI learnt this in college, however, doing it again as a revision.
-
Fri, 05-Jul-2019Darpan JhaThe course is good but they don’t provide support for the complimentary courses.
-
Mon, 08-Jul-2019Mitesh PurohitI was able to scrap some website data using the skills learned from this course.
-
Tue, 09-Jul-2019Gautam KumarI already learned some concepts, so was manageable for me. Good course.
-
Wed, 10-Jul-2019Pranit LaghariThe course covers Installation and connecting to MySQL. I can now perform Cloning, importing, exporting and other database related functions more systematically.
-
Thu, 11-Jul-2019Balendra SinghExcellent Course to learn advanced MySQL.
-
Fri, 12-Jul-2019Naveen AgarwalI was provided this as a part of iDS, hence couldn’t delve in to the course basics, however, seems okay.
-
Sat, 13-Jul-2019Tejas NaikI think it is almost 3 hours of content, I learned but couldn’t practice. The access is for more than a year so intend to revise it later.
-
Mon, 15-Jul-2019Aadi DeshmukhI completed this course and have got the Digital Certificate. The course has equipped me to work on Mysql.
-
Tue, 16-Jul-2019Jatin BanerjeeI am trying SQL as it might help is executing Data Science projects especially Data Scrapping. So far the course is comprehensible.
-
Wed, 17-Jul-2019Harish ReddyWorth of knowledge.
-
Tue, 27-Aug-2019Ishaan ShahI am happy to have this as a complimentary course in my account. Exploring SQL in the same cost is enjoyable. Thanks for this complimentary course.
-
Thu, 29-Aug-2019Parth ModiThe explanation provided in this SQL course is easy to learn and practice.
-
Sat, 31-Aug-2019Prutvi GuptaThe concept is new to me, but I am enjoying it, there seems to be some relevance to Data processing in this.
-
Mon, 02-Sep-2019Knika JainI think it is about 3 hours of content, and I was able to practice some aspects of it. I think continuous Learning is possible through their LMS and that is essential for progressing in my professional life.
-
Wed, 04-Sep-2019Arundhti KrishanI completed this course and have got the digital certificate. The course has equipped me to take up small projects of Mysql.
-
Fri, 06-Sep-2019Aakashdeep ChauhanVery easy and advanced tricks in the course to learn SQL. The course has updated my skills, and it helped me a lot while doing my job.
-
Wed, 11-Sep-2019Aabhi SoniExplained in a technically comprehensible manner.
-
Wed, 11-Sep-2019Shauree RastogiWorth of knowledge.
-
Fri, 13-Sep-2019Anthra SrivasExcellent Course to strengthen your fundamentals and learn futuristic technologies.
-
Mon, 16-Sep-2019Kushit MalikGood course, which covers all the necessary skills required for database developer.
-
Mon, 16-Sep-2019Baloo NaranOverall satisfied with the course.
-
Tue, 17-Sep-2019Abhyank MishraThe course covers Installation to application of Mysql. I can now do cloning, importing, exporting and many more data extraction related functions.
-
Wed, 18-Sep-2019Harmil DasI learnt SQL in my first year of an engineering, this SQL course has great content and lucid structuring.
-
Thu, 19-Sep-2019Shaurya BatraThe access was given as an added course for joining data science. SQL helps in data scrapping, so I am learning it. Excellent course structure.
-
Fri, 20-Sep-2019Chetan ParekhI learned this to enhance my scholastic titles, however, I now realize that it is highly recommend for a data scientist.
-
Fri, 20-Sep-2019Sanjay SachdevSql helps in data compilation and scrapping, hence I intend to complete and achieve the certification.
-
Fri, 20-Sep-2019Navin NaiduSQL is explained in a lucid manner.
-
Fri, 20-Sep-2019Tejas SinghSQL being used in Data Science I wanted to learn it and I am content with this course structure
-
Fri, 20-Sep-2019Shivansh RaoI never learned SQL, so learning I am learning it for the first time, I feel that content wise it looks informative.
-
Fri, 20-Sep-2019Shusmita KulkarniI am a programmer, hence I used SQL in my professional life, but learning once again through this course is fun.
-
Wed, 01-Jan-2020Varun Tk
Write A Public Review