shaalaa.com
S

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

Account
User


Login
Register


      Forgot password?
Share
Notifications

View all notifications
Books Shortlist
Your shortlist is empty
Subject  Computer Science
Topic  Python - Databases and SQL - Structured Query Language

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