Gandhi Nagar 1st lane
Berhampur
+91 8018033055
Mon-Fri 8:30am-7:30pm
info@aceit.com
24 X 7 online support

SQL

Course Details
  • RDBMS Introduction
  • Normalization in RDBMS
  • Create database objects i.e. Create Table
  • Delete database objects i. e. Delete Database
  • Alter database objects i.e. Change Column Name
  • Create, alter and delete constraints
  • Relation Database Management System (RDBMS)
  • Normalization
  • Create Database objects
  • Data Types in SQL
  • Alter Table Statements
  • Drop Table Statements
  • Various Constraints
  • Creating Views
  • Hands-on/Demo/Use-case:
  • Create Table With Predefine Columns
  • Add New Column to Existing Table
  • Check the constraints on a table
  • Add Primary Key and Foreign Key on Table
  • Remove Unique Constraint
  • Insert record/data in tables
  • Modify/Update the existing data
  • Retrieve the data from database from single table
  • Use of operators for data retrieval
  • Delete the data from tables
  • Insert Statements
  • Insert As- Select Statement
  • Update Statements
  • Delete Statements
  • Truncate Statements
  • Select Statement
  • Sorting and Filtering
  • SQL wildcard
  • CASE Expression
  • Self-Join
  • Inner Join
  • Left Join
  • Right Join
  • Cross Join
  • Conversion Function
  • Logical Functions
  • Math Function
  • Aggregate Functions
  • String Functions
  • Date Functions
  • Trigger
  • Procedure
  • SQL Maintenance