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

paid 0(0 Ratings) 9 Students Enrolled
Created By Imurgence Learning Last Updated Thu, 18-Apr-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
About The Instructor
  • 7 Reviews
  • 102 Students
  • 21 Courses
+ View More
A Data Science Training Company
Powered by Simple & Real Analytics
Student Feedback
0
Average Rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 0%
Reviews
4000 10000
Buy Now
Includes:
  • Self-Paced Training
  • 2:34:06 Hours Videos
  • 18 Lessons
  • Certification Course
  • All Levels