• Structured Query Language In Tamil

Structured Query Language

Become a Database developer by learning from Basic to Advanced level.If you want to learn SQL from scratch this master course is for you.

Join Demo
Enroll now

Course Details

Starting Date

05/06/2024

Course Duration

2 months

Mode Of Teaching

Online

WeekDay Sessions

Mon-Fri

Teaching Language

Tamil

Batch Timings

Evening: 08:00 PM – 09:00 PM

Slot Closes On

05/06/2024

Next Batch Starts On

-

Fee Structure

₹3999

Course Syllabus

  • Why SQL?
  • Why My SQL?
  • Career Oppurtunities In SQL
  • What is Data?
  • Information vs Data
  • What is RDBMS?
  • What Database?
  • Uses Of Databases?
  • Types Of Database?
  • What is Query?
  • Rules Of E.F Codd
  • What is Relational Database?
  • What is Non Relational Database?
  • What are Spreadsheets?
  • What is DataType?
  • Types Of DataTypes
  • Char datatypes
  • Varchar/Varchar 2 DataType
  • Date Datatype
  • Number DataType
  • Large Objects
  • Char Large Objects
  • Binary Large Objects
  • What is SQL Tables?
  • How to Create Tables?
  • How to Show Tables?
  • How to Rename Tables
  • How to Clone Tables?
  • How to Alter Tables?
  • How to Show Tables?
  • How to Delete Tables?
  • What is Declarative Language?
  • Keywords in SQL
  • What is Data Definition Language(DDL) ?
  • What is Data Manipulation Language(DML) ?
  • What is Data Control Language(DCL) ?
  • What Transaction Control Language(TCL) ?
  • What is Data Query Language(DQL) ?
  • What is SQL Constraints?
  • UNIQUE Constraint
  • NOT NULL Constraint
  • CHECK Constraint
  • PRIMARY KEY Constraint
  • FOREIGN KEY Constraint
  • Difference between PRIMARY KEY AND FOREIGN KEY
  • WHERE clause
  • AND clause
  • OR clause
  • WITH clause
  • AS clause
  • HAVING clause
  • Arithmetic Operators
  • Relational Operators
  • Comparison Operators
  • Concatenation Operators
  • Logical Operators
  • Special Operators
    • IN
    • NOT IN
    • BETWEEN
    • NOT BETWEEN
    • IS
    • IS NOT
    • LIKE
    • NOT LIKE
  • SubQuery Operators
  • Single Row Function
  • Build In Function
  • Multi Row Function
  • User Defined Function
  • What is Sub Query?
  • Types Of Sub Queries?
  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Nested Queries
  • Multi Column  Sub Queries
  • Correlated Sub Queries
  • CREATE Command
  • DROP Command
  • ALTER Command
  • TRUNCATE Command
  • COMMENT Command
  • RENAME Command
  • SELECT Command
  • INSERT Command
  • UPDATE Command
  • DELETE Command
  • LOCK Command
  • GRANT Command
  • REVOKE Command
  • COMMIT Command
  • ROLLBACK Command
  • SAVEPOINT Command
  • What are Joins?
  • Inner Joins
  • Outer Joins
  • Right Joins
  • Left Joins
  • Self Joins
  • COUNT() Function
  • AVG() Function
  • SUM() Function
  • MIN() Function
  • MAX() Function
  • FIRST() Function
  • LAST() Function
  • Candidate Key
  • Primary Key
  • Super Key
  • Alternate Key
  • Foreign Key
  • Composite Key
  • What are Stored Procedures?
  • How to Create Stored Procedures?
  • How to Create Stored Procedures With One Parameter?
  • How to Create Stored Procedures With Default Parameter?
  • How to Create Stored Procedures With Output Parameter?
  • How to Create Encrypted Stored Procedures?
  • How to Create Temporary Stored Procedures?
  • How to Modify Stored Procedures?
  • How to Rename Stored Procedures?
  • What is A Trigger in SQL?
  • Types Of Triggers
  • DDL Triggers
  • DML Triggers
  • Logon Triggers
  • What are Virtual Views in SQL?
  • CREATE Statement
  • SELECT Statement
  • UPDATE Statement
  • DELETE Statement

What We Will Provide

Online Coummunity

An Online coummunity will be created on the first day of class where students can discuss their doubts with other students eventhough our instructors are available 24/7

Study Material

We provide study materials once the classes gets completed everyday 

Mock Interview

Mock interviews will be conducted regulary to get realtime interview exposure and to be prepared with the concepts thoroughly

Certification

We provide certification once all the sesions gets completed provided maintaining attendance and completion of projects

Join Our 2 Days Free Demo Class

03rd and 04th June
08:00 PM - 09:00 PM

Frequently Asked Questions

The training given by That One Programmer is well structured anyone from fresher to experiened can able to understand the concepts easily.At end of the class students can able to attend the interviews without hesitation

Anyone from any education background can join the course,as this course is structured for fresher to experienced level.

You can enroll for the course by clicking “enroll” button and through the payment page you can do the payment 

Yes if students is absent on that day for valuable reasons,backup classes will be scheduled.Students can learn without missing the topics

No 3 days demo class is completely free.Students can decideto join after demo class.

Sorry,No Refunds will be provided

We Provide Career guidance in classes,mock interviews and resume building sessions and daily job updates