Tutors

DataTrained Assesments

PROGRAM OVERVIEW

To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.

CURRICULUM

  Read_First_Before_Starting

  • Refer the serial number video for the respective topics.

  Introduction to Database and Tables

  • Introduction to Database and Tables

  SQL with command prompt

  • SQL with command prompt

  Need of SQL

  • Need of SQL

  Data Definition Language(DDL)

  • Data Definition Language(DDL)

  Data Control Language(DCL)

  • Data Control Language(DCL)

  Data Manipulation Language (DML)

  • Data Manipulation Language (DML)

  SQL_Python_1

  • SQL_Python_1

  SQL_Python_2

  • SQL_Python_2

  SQL_Python_3

  • SQL_Python_3

  Comparison operators

  • Comparison operators

  Logical Operators

  • Logical Operators

  Aggregate Functions

  • Aggregate Functions

  Joins

  • Joins

  Parent_Child_Primary_Foreign_keys

  • Parent_Child_Primary_Foreign_keys

  Subquery_NestedQuery

  • Subquery_NestedQuery

  Practice Questions

  • Check your SQL skills with these MCQ.