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 209 Students Enrolled
Created By Imurgence Learning Last Updated Fri, 17-May-2019
+ 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.
  • 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.
  • Tue, 21-May-2019
    Pradeep Gandhi
    I never did sql so learning it for the first time, content wise it looks informative.
  • Tue, 04-Jun-2019
    Pooja Rajput
    As a part of Data Science related learning, SQL helps in Data Scrapping, hence I am learning it.
  • Tue, 04-Jun-2019
    Surya Joshi
    Sql helps in Data Compilation and Scrapping hence I am learning it for Certification.
  • Tue, 04-Jun-2019
    Jay Dikshit
    Sql explanation is easy to comprehend.
  • 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.
  • Wed, 05-Jun-2019
    Ravi Sharma
    Explanation provided for Sql's course is easy to comprehend.
  • 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.
  • Wed, 05-Jun-2019
    Rakesh Jadhav
    I learnt this in college, however, doing it again as a revision.
  • Fri, 05-Jul-2019
    Darpan Jha
    The course is good but they don’t provide support for the complimentary courses.
  • Mon, 08-Jul-2019
    Mitesh Purohit
    I was able to scrap some website data using the skills learned from this course.
  • Tue, 09-Jul-2019
    Gautam Kumar
    I already learned some concepts, so was manageable for me. Good course.
  • 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.
  • Thu, 11-Jul-2019
    Balendra Singh
    Excellent Course to learn advanced MySQL.
  • 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.
  • 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.
  • 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.
  • 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.
  • Wed, 17-Jul-2019
    Harish Reddy
    Worth of knowledge.
  • 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.
  • Thu, 29-Aug-2019
    Parth Modi
    The explanation provided in this SQL course is easy to learn and practice.
  • 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.
  • 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.
  • 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.
  • 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.
  • Wed, 11-Sep-2019
    Aabhi Soni
    Explained in a technically comprehensible manner.
  • Wed, 11-Sep-2019
    Shauree Rastogi
    Worth of knowledge.
  • Fri, 13-Sep-2019
    Anthra Srivas
    Excellent Course to strengthen your fundamentals and learn futuristic technologies.
  • Mon, 16-Sep-2019
    Kushit Malik
    Good course, which covers all the necessary skills required for database developer.
  • Mon, 16-Sep-2019
    Baloo Naran
    Overall satisfied with the course.
  • 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.
  • 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.
  • 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.
  • 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.
  • Fri, 20-Sep-2019
    Sanjay Sachdev
    Sql helps in data compilation and scrapping, hence I intend to complete and achieve the certification.
  • Fri, 20-Sep-2019
    Navin Naidu
    SQL is explained in a lucid manner.
  • 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
  • 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.
  • 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.

free

Includes:
  • Self-Paced Training
  • 2:34:06 Hours Videos
  • 18 Lessons
  • Certification Course
  • All Levels