Have a question?
Message sent Close

Certification in SQL

Instructor
cqs
0
0 reviews
  • Description
  • Reviews
Java (24)

Certification in SQL

1 Introduction
  • SQL Server
  • SSMS
  • Installation
  • Building Blocks of SQL
2 Database
  • Create DB
  • Select DB
  • Rename DB
  • Drop DB
  • Create Table
  • Rename Table
  • Drop Table
  • Delete Table
  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Alter Table
  • Truncate
  • Select Into
  • Insert Into
3 View in SQL
  • Create View
  • Update View
  • Drop View
4 Aggregate Function
  • min()
  • max()
  • sum()
  • avg()
  • count()
5 Operators
  • Arithmetic Operators
  • Comparison Operator
  • Logical Operator
  • Like Operator
  • Union Operator
  • Intersect Operator
  • Except Operator
6 Alias
  • for Table
  • for Column
7 Constraints
  • not null
  • unique
  • Primary Key
  • Foreign Key
  • Check
  • Default
8 Clauses
  • select
  • where
  • distinct
  • Order By
  • Group By, cube and rollup
  • Having
9 Keys
  • Primary Key
  • Foreign Key
  • Composite Key
  • Unique Key
10 Joins
  • Inner Join
  • Full Outer Join
  • Right
  • Left
11 Conditional and Loop
  • If
  • If else
  • Case
  • while Loop
12 Exception
  • try
  • catch
13 Stored Procedure
  • Create Stored Procedure
  • Execute procedure
14 Triggers
  • Intro
  • Types of trigger
  • DML
  • DDL
15 Functions
  • Types of Function
  • Scalar
  • Table-Valued
16 Index
  • Clustered index
  • Non-Clustered index
17 Cursor
  • methods
  • variable
18 Transaction
  • Introduction
  • Control and State
  • Commit
  • Rollback
  • Savepoint