Course Introduction - Database Management System এর জন্য SQL এর ব্যবহার

Author: Al-mamun Sarkar Date: 2020-04-16 06:10:39

Database Management System এর জন্য SQL এর ব্যবহার 

 

Course outline: 

  • Database Management System
  • Mapping Cardinalities
  • Entity Relationship Diagram (ERD)
  • What is SQL
  • SQL Syntax
  • SQL SELECT
  • SQL WHERE Clause
  • SQL Logical Operators
  • SQL ORDER BY
  • SQL INSERT
  • SQL NULL Values
  • SQL UPDATE
  • SQL DELETE
  • SQL TOP, LIMIT or ROWNUM
  • SQL MIN and MAX
  • COUNT, AVG, and SUM
  • SQL LIKE Operator
  • SQL Wildcard Characters
  • The SQL IN Operator
  • The SQL BETWEEN Operator
  • SQL Aliases
  • SQL Joins
  • SQL INNER JOIN
  • SQL LEFT JOIN
  • SQL Full Join
  • SQL Self Join
  • SQL Union
  • SQL Group By
  • SQL Having
  • SQL Exists
  • SQL Any, All
  • SQL Select Into
  • SQL Insert Into Select
  • SQL Case
  • SQL Null Functions
  • SQL Stored Procedures
  • SQL Comments
  • SQL Create DB
  • SQL Drop DB
  • SQL Backup DB
  • SQL Create Table
  • SQL Drop Table
  • SQL Alter Table
  • SQL Constraints
  • SQL Not Null
  • SQL Unique
  • SQL Primary Key
  • SQL Foreign Key
  • SQL Index
  • SQL Auto Increment
  • SQL Dates
  • SQL Views
  • SQL Injection
  • SQL Transactions