Programme Outcome:

SQL Fundamental

Need of SQL as database activity

Describing the building blocks and standards

Data Types, Operators and Expressions in SQL

Creating Tables Using SQL

Creating tables with CREATE TABLE

Modifying structure of table with ALTER TABLE

Adding columns to an existing table

Removing table definition with DROP TABLE

Protecting Data

Data integrity and constraints

Preventing Duplicacy with Primary key constraints

Enforcing integrity with foreign key constraints

Imposing rules with check constraints

Improving performance

Creating indexes in SQL

Important guidelines for index creation

Manipulating Data

Adding table data with INSERT

Updating content with UPDATE

Removing records with DELETE

Controlling Transactions

COMMIT and ROLLBACK

BEGIN TRANSACTION in SQL Server

SELECT Statement in SQL

Retrieving data with SELECT

Accessing Specific column

Sorting rows with ORDER BY

Working with NULL values

Multiple Tables Query

Matching rows with INNER JOIN

Accessing nonmatched rows with OUTER JOIN

CROSS JOIN

From and Where Clause

Testing for equality

Applying wildcard characters

Avoiding NULL values

Combining results

Arrange results with UNION

Identify matching rows with INTERSECT

EXCEPT to find nonmatching rows

Functions in SQL

SUM

AVG and COUNT

MAX and MIN

GROUP BY

HAVING

Creating Nested Queries

Applying subqueries

Testing the existence of rows

Including subqueries in expressions

Placing subqueries in the column list

Complex expressions

Duration:35 Hours

Week Days(Monday-Friday):1.5 Hour/day

Weekends(Saturday-Sunday): 2.5 Hour/day

Other Courses

Java Training J2EE Training Python Training PHP Training Full-Stack Developent UI-UX Training Web Designing Android Training Power Bi SQL Server Data Analytics C Language C++ Training