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