SQL Training

SQL stands for Structured Query Language It is used to storing, manipulating and retrieving data in database. SQL statements are used to perform tasks on database such as insertion, deletion, update, create and drop.

In the data driven world everyone need insights to form strategy, marketing and other operations. SQL is a basic skills that everyone should know.

Features Of SQL:

• Flexible & Scalable
• Provides robust transactional support
• Delivers high security and easy management
• Highly compatible with databases like MS Access, Microsoft SQL Server, MySQL, Oracle Database, SAP HANA, SAP Adaptive Server, etc
• Open source programming Language

Course Content:

• Introduction of SQL
• What is RDBMS?
• SQL Create Database Statement
• SQL Drop Database Statement
• SQL Create Table Statement
• SQLDescStatement
• SQL Drop Table Statement
• SQL Show Table Statement
• SQL Constraints
• PRIMARY KEY Constraint
• FOREIGN KEY Constraint
• NOT NULL Constraint
• UNIQUE Constraint
• CHECK Constraint
• DEFAULT Constraint
• Adding a column
• Dropping a column
• Modifying acolumn
• Add Constraints Using ALTER Statement
• Drop Constraints Using ALTER Statement
• Adding Table Rows
• Listing Table Rows
• Updating Table Rows
• Deleting Table Row
• SQL WHERE Clause
• SQL IN Operator
• SQLBETWEEN Operator
• SQL LIKE Operator
• SQL WILDCARD Operators
• SQL Aliases
• SQL Logical Operators
• SQL AND Operator
• SQL OR Operator
• SQL NOT Operator