Course Introduction - Database Management System এর জন্য SQL এর ব্যবহার
Course Introduction - Database Management System এর জন্য SQL এর ব্যবহার
Al-Mamun Sarkar
- Share On:
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