- SQL Introduction to DBMS
- SQL - DBMS
- SQL - Data
- SQL - Information
- SQL - Database
- SQL - What is DBMS
- SQL - FMS or FDMS
- SQL - HMS or HDMS
- SQL - NDBS
- SQL - RDMS
- SQL - One to One Relationship
- SQL - One to Many Relationship
- SQL - Many to Many Relationship
- SQL - CODD Rules
- SQL - Properties of RDBMS
- SQL - ER Diagram
- SQL Introduction to SQL Server
- SQL - Introduction
- SQL - Working with SQL Server
- SQL - Server Type
- SQL - Server Authentication
- SQL - How to connect to SQL Server
- SQL - What is Object Explorer
- SQL - How to create a User Database
- SQL - Data Types
- SQL - Integer Data Type
- SQL - Decimal Data Type
- SQL - Money Data Type
- SQL - Date and Time Data Type
- SQL - Character Data Type
- SQL - Binary Data Type
- SQL Structured Query Language
- SQL - Overview
- SQL - Features of SQL
- SQL - Data Definition Language
- SQL - Create
- SQL - Rules for Creating a Table
- SQL - ALTER
- SQL - SP_RENAME
- SQL - TRUNCATE
- SQL - DROP
- SQL - SP_HELP
- SQL Data Manipulating Language
- LEFT
- RIGHT
- SQL - DML Overview
- SQL - INSERT
- SQL - UPDATE
- SQL - DELETE
- SQL - Truncate and Delete
- SQL - SELECT
- SQL - Projection
- SQL - Selection
- SQL - WHERE Conditions
- SQL - ALIAS
- SQL - IDENTITY
- SQL - Built In Functions
- SQL - Mathematical Functions
- SQL - Absolute
- SQL - CEILING
- SQL - FLOOR
- SQL - SQUARE
- SQL - SQRT
- SQL - SIGN
- SQL - PI
- SQL - LOG
- SQL - LOG 10
- SQL - SIN
- SQL - COS
- SQL - TAN
- SQL - String Functions
- SQL - ASCII
- SQL - CHAR
- SQL - CHARINDEX
- SQL - LEFT
- SQL - LEN
- SQL - LOWER
- SQL - RIGHT
- SQL - UPPER
- SQL - LTRIM
- SQL - REPLACE
- SQL - REPLICATE
- SQL - REVERSE
- SQL - SPACE
- SQL Date and Time Functions
- SQL - YEAR
- SQL - GETUTCDATE
- SQL - DATE NAME
- SQL - DATE PART
- SQL - DATE ADD
- SQL - DATE DIFF
- SQL - GETDATE
- SQL - DAY
- SQL - MONTH
- SQL Conversion Functions
- SQL - CAST
- SQL - CONVERT
- SQL Aggregate or Group functions
- Overview
- SQL - SUM
- SQL - AVG
- SQL - MAX
- SQL - MIN
- SQL - COUNT
- SQL - Distinct
- SQL Operators in SQL
- SQL - Operator
- SQL - Assignment Operator
- SQL - Arithmetic Operator
- SQL - Logical Operator
- SQL - Queries using Update with Where clause
- SQL - Set Operators
- SQL - UNION ALL
- SQL - INTERSECT
- SQL - UNION
- SQL - EXCEPT
- SQL - Clauses in SQL
- SQL - Where Clause
- SQL - Order By Clause
- SQL - Top N Clause
- SQL - Group By Clause
- SQL - Having Clause
- SQL - Where and Having clause Differences
- SQL - Comparison Operators
- SQL Synonym
- SQL - What is Synonym
- SQL - Syntax for Synonym
- SQL - Syntax to Creating a table from an existing table
- SQL - Copying data from one existing table to another table
- SQL Constraints in SQL
- SQL - Why Constraints in SQL
- SQL - Entity Integrity
- SQL - Referential Integrity
- SQL - Domain Integrity
- SQL - Types of Constraints
- SQL - Unique Key
- SQL - Not null Constraint
- SQL - Check Constraint
- SQL - Primary Key
- SQL - Adding Primary key after creating a table
- SQL - Foreign Key
- SQL - How to create a Foreign Key
- SQL Joins
- SQL - What are Joins
- SQL - EQUI JOIN
- SQL - INNER JOIN
- SQL - OUTER JOIN
- SQL - LEFT OUTER JOIN
- SQL - RIGHT OUTER JOIN
- SQL - FULL OUTER JOIN
- SQL - NON EQUI JOIN
- SQL - SELF JOIN
- SQL - CROSS JOIN
- SQL - NATURAL JOIN
- SQL - Joins with Three Tables
- SQL Transaction Control Language
- SQL - Transaction
- SQL - BEGIN TRANSACTION
- SQL - COMMIT
- SQL - ROLLBACK
- SQL - SAVEPOINT
- SQL Sub Query
- SQL - What is Sub Query
- SQL - Sub Query Examples
- SQL Indexes
- SQL - Why do we need Indexes
- SQL - What is Index
- SQL - Clustered Index
- SQL - Non-Clustered Indexes
- SQL - Syntax for Index
- SQL Views
- SQL - What is a View
- SQL - Simple View
- SQL - Complex View
- SQL T/SQL Programming
- SQL - What is Transact Structure Query Language
- SQL - Anonymous Blocks
- SQL - Sub Programs
- SQL - Declaring Variables
- SQL - Assigning Values to Variables
- SQL - Printing Values of Variables
- SQL - Structure of T/SQL Program
- SQL - Conditional Statements
- SQL - If Else Statement
- SQL - While Loop
- SQL - Stored Procedures
- SQL - Why we need Stored Procedure
- SQL - Advantages of Stored Procedure
- SQL - How to Create Stored Procedure without parameter
- SQL - How to Call a Stored Procedure
- SQL - Procedure without Parameter
- SQL - Passing Parameters to Procedures
- SQL - Procedures with Parameters
- SQL - Drop a Stored Procedure
- SQL - Stored Functions
- SQL - Scalar Valued Function
- SQL - How to Call Scalar valued Functions
- SQL - Table Valued Function
- SQL - How to Call a Table Valued Function
- SQL - How To Drop Functions
- SQL - Difference between Function And Procedure
- SQL Triggers
- SQL - What is a Trigger
- SQL - DML Triggers
- SQL - Dropping DML Triggers
- SQL - DDL Triggers
- SQL - Dropping DDL Triggers
- SQL - Magic Tables
- SQL - Inserted Magic Table
- SQL - Deleted Magic Table
- SQL - Update the Record in Table
- SQL - Exception Handling
- SQL - Handling Errors In SQL Server
- SQL Cursors
- SQL - What is a Cursor
- SQL - Implicit Cursors
- SQL - Explicit Cursors
- SQL - Steps To Create Cursor
- SQL - Examples To Work with Cursor
- SQL - Forward only and Scroll Cursors
- SQL - Static & Dynamic Cursors
- SQL Data Control Language
- SQL - What is Data Control Language
- SQL - GRANT
- SQL - REVOKE
- SQL - Normalization
- SQL - First Normal Form (1NF)
- SQL - Second Normal Form (2NF)
- SQL - Third Normal Form (3NF)
- SQL - Fourth Normal Form (4NF)
- SQL - Fifth Normal Form (5NF)
LEFT
LEFT ()
Returns the left part of a character string with the specified number of characters.
Example: Select LEFT (‘SUDHAKAR’, 5)
Result: SUDHA
ChatGPT
Python
PowerShell
PL/SQL
Spring Boot
CSS
