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 non matched 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 non matching rows
Functions in SQL
SUM
AVG and COUNT
MAX and MIN
GROUP BY
HAVING
Creating Nested Queries
Applying sub queries
Testing the existence of rows
Including sub queries in expressions
Placing sub queries in the column list
Complex expressions

Duration

30 Hrs

Schedule

1.5 Hrs (Monday - Fridays)

2.5 Hrs (Saturday & Sunday)