SQL Server: Queries and PL/SQL samples

SQL Server Basics

• SQL Server Datatypes | Table Column Types

SQL Server DDL

• SQL Server: How to create or Drop Database? | Command to Create or Drop DB

• SQL Server: How to create a table? | SQL command to create a table

• SQL Server: How to define constraints in Table Creation? Constraints in SQL Server

SQL DML Commands

• SQL Server: Table with identity field and Record insertion with full and partial fields

• Creating backup-table by an insert into SQL command | Copying into an empty table.

• SQL Select query with conditions | SQL where Clause

• SQL Aggregate functions usage in queries | Aggregate functions in SQL

• SQL Server: Update columns or fields in SQL Server | SQL Update command.

DML Commands (Intermediate Level)

• SQL Server: Order by, Group by clauses | Sorting and Grouping in SQL Server

• SQL Server: Group by, Having Clause and Sub-Query Examples.

Queries on Multiple Tables (Primary Key & Foreign Key usage)

• SQL Server: Select query on multiple tables | Combining more than one table to get the result

• SQL Server: Query to combine results of many tables | Jewellery Shop Billing Model

Stored Procedures, Functions, and Triggers

• SQL Server: Real-time usage of database trigger | SQL Server Update Trigger Sample

• SQL Server: After Insert trigger Usage | Populate related tables automatically?

Joins

• Types of Joins - Left Join, Right Join, and Inner Join 

• SQL Server: SQL Inner Join using multiple tables | Jewellery Shop Model