About this Live Course
This Live course will cover all the concepts of Databases and MySQL. This course is specially designed to help you understand the basic concepts of SQL that you need help in. This course will help you with interview questions around Databases, SQL and MySQL queries that are required for cracking jobs such as Data Analyst and Database Administrator
- Total Live Course Duration: 7 hours
- Live Classes: Weekdays, 6:10 PM - 7:10 PM
Online Classes Advantage with Great Learning Academy:
- Live Interactive Classes
- Structured Classes & Schedule
- Access recording of missed classes
Concepts covered
-
Introduction
-
Introduction to DBMS - RDBMS
-
Architecture
-
DB design
-
ER Model and Normalization
-
Aggregate functions and Views
-
Basics of Join
-
Inner Join
-
Outer Join
-
Self Join
-
Cross Join
-
...
Class Schedule
-
Introduction to DBMSWed, 16 Dec, 6:10 PM IST 1 hr
-
Normalization, ER Model and DB DesignThu, 17 Dec, 6:10 PM IST 1 hr
-
MySQL BasicsFri, 18 Dec, 6:10 PM IST 1 hr
-
Aggregate functions and ViewsMon, 21 Dec, 6:10 PM IST 1 hr
-
JoinsWed, 23 Dec, 6:10 PM IST 1 hr
-
SubqueriesThu, 24 Dec, 6:10 PM IST 1 hr
-
Hands-onMon, 28 Dec, 6:10 PM IST 1 hr
About the Mentor
Ms. Sampriti Chatterjee
Great Learning