SQL Training

We offers SQL Training by industry specialists, our SQL training program covers essential to propel level of SQL. Nowadays SQL is the most demanding technology in analysis field.

x

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
x

Duration

30 Hrs

x

Schedule

1.5 Hrs (Monday - Fridays)

2.5 Hrs (Saturday & Sunday)

Contact Us

Verify Captcha Code:


Can't read the image? click
Dwarka Centre

A-66 , 2nd & 3rd floor, Sector 7, Dwarka , New Delhi-110075

011-45613139,

9999-850-802

Coding Tutorial

codermantra.com