Technical Interview Prep

Crash Course on SQL

Free

Course cost

Total Classes
7

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 DBMS
    Wed, 16 Dec, 6:10 PM IST
    1 hr
  • Normalization, ER Model and DB Design
    Thu, 17 Dec, 6:10 PM IST
    1 hr
  • MySQL Basics
    Fri, 18 Dec, 6:10 PM IST
    1 hr
  • Aggregate functions and Views
    Mon, 21 Dec, 6:10 PM IST
    1 hr
  • Joins
    Wed, 23 Dec, 6:10 PM IST
    1 hr
  • Subqueries
    Thu, 24 Dec, 6:10 PM IST
    1 hr
  • Hands-on
    Mon, 28 Dec, 6:10 PM IST
    1 hr

About the Mentor

Ms. Sampriti Chatterjee

Great Learning

Profile

Sampriti has been working in the field of data science and has expertise in languages such as Python, SQL, and Java. She also has expertise in the field of deep learning and has worked with deep learning frameworks such as Keras and TensorFlow 2.0. She is been in the technical content side for the last few years.
X
popup asset

Welcome to Great Learning Academy