- Introduction to DBMS
- Why DBMS
- What is Data
- What is Information
- What is Database
- What is DBMS
- FMS or FDMS
- HMS or HDMS
- NDBS
- RDMS
- One to One relationship
- One to Many Relationship
- Many to Many Relationship
- CODD Rules
- Properties of RDBMS
- ER Diagram
- Introduction to SQL Server
- SQL Server
- Working with SQL Server
- Server Type
- Server Authentication
- How to connect to SQL Server
- What is Object Explorer
- How to create a User Database
- Data Types
- Integer Data types
- Decimal Data types
- Money Data Type
- Date and Time Data types
- Character Data types
- Binary Data type
- Structured Query Language
- Overview
- Features of SQL
- Data Definition Language
- Create
- Rules for Creating a Table
- ALTER
- SP_RENAME
- TRUNCATE
- DROP
- SP_HELP
- Data Manipulating Language
- DML Overview
- INSERT
- UPDATE
- DELETE
- Truncate and Delete
- SELECT
- Projection
- Selection
- WHERE Conditions
- ALIAS
- IDENTITY
- Built In Functions
- Mathematical Functions
- Absolute
- CEILING
- FLOOR
- SQUARE
- SQRT
- SIGN
- PI
- LOG
- LOG 10
- SIN
- COS ()
- TAN ()
- String Functions
- ASCII ()
- CHAR ()
- CHARINDEX ()
- LEFT ()
- LEN ()
- LOWER ()
- RIGHT ()
- UPPER ()
- LTRIM ()
- LEFT
- RIGHT
- REPLACE
- REPLICATE
- REVERSE
- SPACE
- Date and Time Functions
- GETDATE
- DAY
- MONTH
- YEAR
- GETUTCDATE
- DATE NAME
- DATE PART
- DATE ADD
- DATE DIFF
- Conversion Functions
- CAST
- CONVERT
- Aggregate or Group functions
- AVG
- MAX
- MIN
- COUNT
- Distinct
- Overview
- SUM
- Operators in SQL
- What is an operator in SQL?
- Assignment Operator
- Arithmetic Operator
- Comparison Operators
- Logical Operator
- Queries using Update with Where clause
- Set Operators
- UNION ALL
- INTERSECT
- UNION
- EXCEPT
- Clauses in SQL
- Where Clause
- Order By Clause
- Top N Clause
- Group By Clause
- Having Clause
- Where and Having clause differences
- Synonym
- What is Synonym
- Syntax for Synonym
- Syntax to Creating a table from an existing table
- Copying data from one existing table to another table
- Constraints in SQL
- Why Constraints in SQL
- Entity Integrity
- Referential Integrity
- Domain Integrity
- Types of Constraints
- Unique Key
- Not null Constraint
- Check Constraint
- Primary Key
- Adding primary key after creating a table
- Foreign Key
- How to create a Foreign Key
- Joins in SQL
- What are Joins
- EQUI JOIN
- INNER JOIN
- OUTER JOIN
- LEFT OUTER JOIN
- RIGHT OUTER JOIN
- FULL OUTER JOIN
- NON EQUI JOIN
- SELF JOIN
- CROSS JOIN
- NATURAL JOIN
- Joins with Three Tables
- Transaction Control Language
- Transaction
- BEGIN TRANSACTION
- COMMIT
- ROLLBACK
- SAVEPOINT
- Sub Query
- What is sub query
- Sub Query Examples
- Indexes in SQL
- Why do we need Indexes
- What is Index
- Clustered Index
- Non-Clustered Indexes
- Syntax for Index
- Views in SQL
- What is a View
- Simple View
- Complex View
- T/SQL Programming
- What is Transact Structure Query Language
- Anonymous Blocks
- Sub Programs
- Declaring Variables
- Assigning Values to Variables
- Printing Values of Variables
- Structure of T/SQL Program
- Conditional Statements
- If Else Statement
- While Loop
- Stored Procedures
- Why we need Stored Procedure
- Advantages of Stored Procedure
- How to Create Stored Procedure without parameter
- How to Call a Stored Procedure
- Procedure without Parameter
- Passing Parameters to Procedures
- Procedures with Parameters
- Drop a Stored Procedure
- Stored Functions
- Scalar Valued Function
- How to Call Scalar valued Functions
- Table Valued Function
- How to Call a Table Valued Function
- How To Drop Functions
- Difference between Function And Procedure
- Triggers
- What is a Trigger
- DML Triggers
- Dropping DML Triggers
- DDL Triggers
- Dropping DDL Triggers
- Magic Tables
- Inserted Magic Table
- Deleted Magic Table
- Update the Record in Table
- Exception Handling
- Handling Errors In SQL Server
- Cursors
- What is a Cursor
- Implicit Cursors
- Explicit Cursors:
- Steps To Create Cursor
- Examples To Work with Cursor
- Forward only and Scroll Cursors
- Static & Dynamic Cursors
- Data Control Language
- What is Data Control Language
- GRANT
- REVOKE
- Normalization
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Fourth Normal Form (4NF)
- Fifth Normal Form (5NF)
Why DBMS
Human needs have increased tremendously. Now people are doing much more complex tasks than ever before. The society has become very complex; a person has to work with huge amount of information every day. In order to work with the enormous information, we must have a system where we can store, manipulate and share the information all over the world. It is one of the core reasons for introducing Database Management Systems (DBMS) as well as Relational Database Management Systems (RDBMS) now-a-days.
So, one thing is clear to us that we store and manipulate data / information into a database, where the database contains various types of tables for storing various types of data / information.
ChatGPT
Python
PowerShell
PL/SQL
Spring Boot
CSS
