shaalaa.com
S

Video tutorials - Computer Science: Python - Databases and SQL - Structured Query Language (Central Board of Secondary Education (CBSE))

Account
User


Login
Register


      Forgot password?
Share
Notifications

View all notifications
Books Shortlist
Your shortlist is empty

shaalaa.com | Introduction

shaalaa.com


Next video


shaalaa.com


Introduction [00:31:50]
S

Feedback

Description

  • General Concepts Data Types SQL COMMANDS SQL functions
  • Data Types: NUMBER/DECIMAL,CHARACTER/VARCHAR/VARCHAR2, DATE;
  • SQL COMMANDS: CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ....SET...., INSERT, DELETE; SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY; SQL funct ons: SUM ( ), AVG ( ), COUNT ( ), MAX ( ) AND MIN ( ); Obtaining results (SELECT query) from 2 tables using equi-join, Cartesian product and Union
    Note: Implementation of the above mentioned commands could be done on any SQL supported software on one or two tables.
S