Complete MySQL from Scratch for Data Analysis


15
Learners

Learn everything about MySQL

Course Faculty
Sekhar Metla
Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passion... more>>
Basic Course Offerings
54 Lecture Topics
8+ Hours of Video Lectures
Course Specials
Interactive Discussion Forum
4+ Course Files
Course Completion Certificate
courseware
( Can be downloaded as pdf )
Question Bank
( Can be downloaded as pdf )
Basic Plan

  • 30 days Free access to Basic Course Offerings covering HD Video Lectures delivered by Industry Experts.
  • Videos may contain ads
INR 0
Enrol Now
EFY Times
Standard Plan

  • 180 days access to basic course offerings covering HD video lectures
  • Course specific discussion forum for anytime doubt resolution
  • Ad-free Videos
  • Lifetime access to Course Specials(courseware, Question Bank)
  • Course Completion Certificate
USD 5.31/USD 4.42
Enrol Now
Enterprise Plan

  • Ideal for multiple participants.
  • Single payment option for instant multi user on-boarding.
  • Attractive discounts on bulk purchases.
  • Option to include white labelled LMS with custom dashboard report.
  • Multi course selection available.
Course Overview

Learn all about MySQL through this detailed course that covers basics to advanced. Its a complete course for anyone wanting to learn all about MySQL


Course Curriculum
1 Introduction Preview 04:17
2 Course Curriculum overview 05:28
3 Overview of Databases 10:24
4 MySQL Installation 15:50
5 MySQL Workbench Installation 09:05
6 Connecting to MySQL using Console 09:01
7 Overview of Challenges 03:44
8 SQL Statement Basic 15:31
9 SELECT Statement 09:20
10 SELECT DISTINCT 04:51
11 Column AS Statement 11:44
12 COUNT Function 11:04
13 SELECT WHERE Clause – One 04:37
14 SELECT WHERE Clause – Two 10:41
15 ORDER BY 07:42
16 LIMIT 08:35
17 BETWEEN 11:19
18 IN 10:41
19 LIKE and ILIKE 11:12
20 Overview of GROUP BY 05:40
21 Aggregation Function SUM() 08:52
22 Aggregation MIN() and MAX() 05:30
23 GROUP BY - One 09:14
24 GROUP BY – Two 11:46
25 HAVING 05:05
26 Overview Assessment Test 1 02:00
Assessment Test 1  
Solution for Assessment Test 1  
27 Overview of JOINS 03:36
28 Introduction to JOINS 04:02
29 AS Statement 03:05
30 INNER Joins 18:30
31 Full Outer Joins 11:11
32 Left Outer Join 07:54
33 Right Outer Join 07:46
34 Union 06:45
Assessment Test 2  
Solution for Assessment Test 2  
35 Basic of Advanced SQL Commands 03:38
36 Timestamps 12:23
37 Extract from Timestamp 09:59
38 Mathematical Functions 11:40
39 String Functions 22:16
40 Sub Query / Inner Query 13:26
41 Basic of Database and Tables 06:10
42 SQL Data Types 10:30
43 Primary and Foreign Keys 05:33
44 iCreate Table in SQL Script 13:13
45 Insert statement 10:47
46 Update statement 07:09
47 Delete statement 04:09
48 Alter Table statement 09:31
49 Drop Table statement 05:21
50 NOT NULL Constraint 07:55
51 UNIQUE Constraint 09:15
52 Overview of Databases and Tables 04:51
53 Creating a Database backup 12:28
54 Restoring a Database from backup 07:03

Eligibility Criteria

There are no pre-requisites for this course, however, some fundamentals knowledge about DBMS will be beneficial.

Basic knowledge of computers

No prior technical experience is required! All you need a computer with internet access!



-----No Ratings & Reviews Yet-----

Frequently Asked Questions

There are no limitations in accessing the course. You can assess the course through the web (ApnaCourse.com) on any device

Most courses are self paced courses with a free access of 30 days. The 30 days access (basic plan) is only on the videos. To extend access by 180 days or to get course specials like question bank, course completion certificate, exam etc, you will have to enrol into the standard (paid) plan.

Yes. If your access to a course expires, you can extend that through an online payment and continue from where you left of.

We engage only experienced and certified faculties for each course. Each faculty has decades of relevant teaching / training experience that they bring to ApnaCourse. For details of our faculty partners, please visit the Faculty section in the website.

We offer a course completion certificate on most courses. This certificate is jointly given by our partner trainer or training instiute who delivered the course.

For any course specific doubts, there is an Online forum on ApnaCourse called Social Circle for every Course. Access to the Social Circle is available only in the paid plan. Post your questions there and an expert would be able to respond to it. For general payment or enrolment related information, please email at support@apnacourse.com.

Pl visit our detailed FAQ section at https://www.apnacourse.com/about/faq. If you still have doubts, feel free to email at support@apnacourse.com.


×
×
Course Expert
Sekhar Metla
Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants make a strong bridge the gap between the software companies requirements and the beginners.
×
All batches are currently full