Database Programming for Data Analyst using MySQL

This is an program recommended for Data Analyst who would have to work on data extraction, curation and processing of data as a pre processing phase for Data Analytics

free 292 Students Enrolled
Created By Imurgence Learning Last Updated Mon, 23-Nov-2020
+ 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 base 00:05:23
  • Data Types 00:17:15
  • 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 00:06:27
  • Handling Null Values & Regular Expressions 00:08:11
  • Transactions 00:05:34
  • Alter Command 00:14:08
  • Indexes 00:04:08
  • Temporary Tables 00:08:24
  • Clone Tables 00:05:21
  • Export & Import Data Base 00:11:19
+ View More
Other Related Courses
Student Feedback
5
Average Rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 100%
Reviews
  • Mon, 13-May-2019
    Rohit Gupta
    I am a programmer, hence I used SQL at my work, but learning again through complimentary course is fun.
  • Rohit Gupta
    Wed, 15-May-2019
    Aditya patil
    As 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.
  • Aditya  patil
    Tue, 21-May-2019
    Pradeep Gandhi
    I never did sql so learning it for the first time, content wise it looks informative.
  • Pradeep Gandhi
    Tue, 04-Jun-2019
    Pooja Rajput
    As a part of Data Science related learning, SQL helps in Data Scrapping, hence I am learning it.
  • Pooja Rajput
    Tue, 04-Jun-2019
    Surya Joshi
    Sql helps in Data Compilation and Scrapping hence I am learning it for Certification.
  • Surya Joshi
    Tue, 04-Jun-2019
    Jay Dikshit
    Sql explanation is easy to comprehend.
  • Jay Dikshit
    Wed, 05-Jun-2019
    Ruben Nair
    I am happy to have complimentary course added to my account, exploring SQL in the same cost is great.
  • Ruben Nair
    Wed, 05-Jun-2019
    Ravi Sharma
    Explanation provided for Sql's course is easy to comprehend.
  • Ravi Sharma
    Wed, 05-Jun-2019
    Shyam Makwana
    I learnt SQL in my first year of Eng, the complimentary SQL course has good content and lucid explanation.
  • Shyam Makwana
    Wed, 05-Jun-2019
    Rakesh Jadhav
    I learnt this in college, however, doing it again as a revision.
  • Rakesh Jadhav
    Fri, 05-Jul-2019
    Darpan Jha
    The course is good but they don’t provide support for the complimentary courses.
  • Darpan Jha
    Mon, 08-Jul-2019
    Mitesh Purohit
    I was able to scrap some website data using the skills learned from this course.
  • Mitesh Purohit
    Tue, 09-Jul-2019
    Gautam Kumar
    I already learned some concepts, so was manageable for me. Good course.
  • Gautam Kumar
    Wed, 10-Jul-2019
    Pranit Laghari
    The course covers Installation and connecting to MySQL. I can now perform Cloning, importing, exporting and other database related functions more systematically.
  • Pranit Laghari
    Thu, 11-Jul-2019
    Balendra Singh
    Excellent Course to learn advanced MySQL.
  • Balendra Singh
    Fri, 12-Jul-2019
    Naveen Agarwal
    I was provided this as a part of iDS, hence couldn’t delve in to the course basics, however, seems okay.
  • Naveen Agarwal
    Sat, 13-Jul-2019
    Tejas Naik
    I 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.
  • Tejas Naik
    Mon, 15-Jul-2019
    Aadi Deshmukh
    I completed this course and have got the Digital Certificate. The course has equipped me to work on Mysql.
  • Aadi Deshmukh
    Tue, 16-Jul-2019
    Jatin Banerjee
    I am trying SQL as it might help is executing Data Science projects especially Data Scrapping. So far the course is comprehensible.
  • Jatin Banerjee
    Wed, 17-Jul-2019
    Harish Reddy
    Worth of knowledge.
  • Harish Reddy
    Tue, 27-Aug-2019
    Ishaan Shah
    I 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.
  • Ishaan Shah
    Thu, 29-Aug-2019
    Parth Modi
    The explanation provided in this SQL course is easy to learn and practice.
  • Parth Modi
    Sat, 31-Aug-2019
    Prutvi Gupta
    The concept is new to me, but I am enjoying it, there seems to be some relevance to Data processing in this.
  • Prutvi Gupta
    Mon, 02-Sep-2019
    Knika Jain
    I 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.
  • Knika Jain
    Wed, 04-Sep-2019
    Arundhti Krishan
    I completed this course and have got the digital certificate. The course has equipped me to take up small projects of Mysql.
  • Arundhti Krishan
    Fri, 06-Sep-2019
    Aakashdeep Chauhan
    Very 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.
  • Aakashdeep Chauhan
    Wed, 11-Sep-2019
    Aabhi Soni
    Explained in a technically comprehensible manner.
  • Aabhi Soni
    Wed, 11-Sep-2019
    Shauree Rastogi
    Worth of knowledge.
  • Shauree Rastogi
    Fri, 13-Sep-2019
    Anthra Srivas
    Excellent Course to strengthen your fundamentals and learn futuristic technologies.
  • Anthra Srivas
    Mon, 16-Sep-2019
    Kushit Malik
    Good course, which covers all the necessary skills required for database developer.
  • Kushit Malik
    Mon, 16-Sep-2019
    Baloo Naran
    Overall satisfied with the course.
  • Baloo Naran
    Tue, 17-Sep-2019
    Abhyank Mishra
    The course covers Installation to application of Mysql. I can now do cloning, importing, exporting and many more data extraction related functions.
  • Abhyank Mishra
    Wed, 18-Sep-2019
    Harmil Das
    I learnt SQL in my first year of an engineering, this SQL course has great content and lucid structuring.
  • Harmil Das
    Thu, 19-Sep-2019
    Shaurya Batra
    The access was given as an added course for joining data science. SQL helps in data scrapping, so I am learning it. Excellent course structure.
  • Shaurya Batra
    Fri, 20-Sep-2019
    Chetan Parekh
    I learned this to enhance my scholastic titles, however, I now realize that it is highly recommend for a data scientist.
  • Chetan  Parekh
    Fri, 20-Sep-2019
    Sanjay Sachdev
    Sql helps in data compilation and scrapping, hence I intend to complete and achieve the certification.
  • Sanjay Sachdev
    Fri, 20-Sep-2019
    Navin Naidu
    SQL is explained in a lucid manner.
  • Navin Naidu
    Fri, 20-Sep-2019
    Tejas Singh
    SQL being used in Data Science I wanted to learn it and I am content with this course structure
  • Tejas Singh
    Fri, 20-Sep-2019
    Shivansh Rao
    I never learned SQL, so learning I am learning it for the first time, I feel that content wise it looks informative.
  • Shivansh Rao
    Fri, 20-Sep-2019
    Shusmita Kulkarni
    I am a programmer, hence I used SQL in my professional life, but learning once again through this course is fun.
  • Shusmita Kulkarni
    Wed, 01-Jan-2020
    Varun Tk

free

EMI starts at 0/month for 0 months. View Plan >
Includes:
  • Self-Paced Training
  • 2:34:06 Hours Videos
  • 18 Lessons
  • Certification Course
  • All Levels