All exams are online now due to COVID related precautions read more

SQL Table of Contents


Table of Content
 

 

Database Basics

  • Client/Server Basics
  • What is a Data?
  • What is a Database?
  • What is DBMS or Database Management System?
  • Data Models
  • Relational Theory
  • Relational Model
  • Databases and Tables
  • What is RDBMS?
  • RDBMS Architecture
  • Database Communication Protocols
  • SQL and the Relational Model
  • Relational Operations
  • SQL Evolution

SQL Syntax

  • SQL Lexical Structure
  • SQL Identifiers
  • SQL Literals
  • SQL Escape Characters
  • SQL Statements
  • SQL Whitespaces
  • Case Sensitivity in SQL
  • SQL Comments
  • SQL Reserved Words

SQL Keys

  • Constraints in SQL
  • Primary Key
  • Foreign Key
  • Other Constraints in SQL

SQL Database Statement

  • Database Schema
  • Creating Database Schemas
  • Alter Schema
  • Drop Schema
  • Create Database
  • Alter Database
  • DROP TABLE

SQL Table Statement

  • Create Table
  • Alter Table
  • Drop Table

SQL Select Statement

  • The SELECT Statement
  • The SQL SELECT LIMIT
  • SELECT TOP Statement

SQL Clause Statement

  • DISTINCT clause
  • FROM Clause
  • WHERE Clause
  • GROUP BY
  • HAVING Clause

SQL Order By Statement

SQL Insert Statement

SQL Update Statement

SQL Delete Statement

SQL Join Statement

  • Cross Join
  • Inner Join
  • Outer join
  • Self-join

SQL Expressions

  • Boolean Expressions
  • Numeric Expression
  • Date Expressions

SQL Operators

  • Arithmetic Operators
  • Comparison Operators
  • Character Operators
  • Logical Operators
  • Set Operators

SQL Functions

  • Types of Function
  • Mathematical Functions
  • String Functions
  • Aggregate Functions
  • Branch Functions
  • Date/Time Functions

Miscellaneous Topics

  • SQL Subquery
  • Stored Procedures
  • Trigger
  • Views
  • Transactions
  • Database Design
  • Database Normalization
  • SQL Standards
  • SQL Coding Standard



Apply Now!

https://www.vskills.in/certification/databases/sql-language-Certification

 For Support