sql server training in janakpuri

Professional SQL Server Training



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




    Quick Enquiry