A 3rd-year student of Mechanical Engineering at NIT Durgapur. Qualified JEE MAINS 2015. 

Divyansh Srivastava

In this course the very fundamentals of MySQL is dealt with.This course basically teaches you the core concepts required for working on MySQL.

Ace in Class XI Examination by understanding all the concepts of Mathematics and Science, with these courses.

CBSE Class 11

English

Basics of MySQL

Database Management System

Database Concepts and the SQL

Information Practices

Class 6-12

Become a topper in your school and ace your board exams by learning from best educators in the country

CBSE

CBSE (Central Board of Secondary Education)

Overview

Basics of MySQL- Brief discussion on MySQL definition, syntax and DDL.

Fundamentals of MySQL-1

Brief introduction of DML, TCL and DCL statement.

Fundamentals of MySQL-2

Basics of Database, difference between database and spreadsheet, brief introduction of database design.

Fundamentals of MySQL-3

Various kinds of keys usedin database- Primary Key, Foreign Key and Unique Key. Relational Schema etc.

Keys used in Database

Discussion on various types of data used in MySQL

Data types in MySQL

A discussion on Primary Key, Foreign Key, Not Null, Default Constraint and Indexes

Constraints used in MySql

Aggregate Functions: AVG, COUNT, SUM, MAX, MIN.

Functions used in MySQL

A discussion on Where clause, wildcard character etc.

Use of Where, And, and Between functions

A discussion on Group By and Having Clause.

Use of Group By, Alias,Having Clause

Use of joins, difference between join and where clause etc.

Use of Joins, coalesce in MySQL

UG KLUian | ECE student | aspirant to teach | love programming

Srija Kalyanam

This course contains basics of DBMS. If you are going to attend an interview from non-IT background and have knowledge about dbms it creates more impression on you . So at first learn this basics in the first course.One can understand the next course only if they have complete knowledge of this one. Here i illustrated dbms charecteristics,advantages,cardinality ,degree of relationship, entity relation , types of data models , data base languages , data base administrator.

Fundamentals of Database Management System (DBMS)

My name is Saurav Chauhan [10CGPA in 10th and 96% in 12th (Non-Med)]. I am very passionate about teaching and have been teaching students a

Saurav Chauhan

This course covers all concepts related to Relational Database Management Systems and has been created as per Class XI CBSE syllabus.

Lessons

11 lessons • 1h 33m

Invalid Date

NaN

Overview

Invalid Date

NaN

Fundamentals of MySQL-1

Invalid Date

NaN

Fundamentals of MySQL-2

Invalid Date

NaN

Fundamentals of MySQL-3

Invalid Date

NaN

Keys used in Database

Invalid Date

NaN

Data types in MySQL

Invalid Date

NaN

Constraints used in MySql

Invalid Date

NaN

Functions used in MySQL

Invalid Date

NaN

Use of Where, And, and Between functions

Invalid Date

NaN

Use of Group By, Alias,Having Clause

+ See all lessons