If you want best experience and 100% practical training with certifications then Chandigarh institute is the best place for you to join.

BENEFITS: Transact-SQL Reference (Transact-SQL)

  • You will be able to do lot of data mining and data analysis over the data coming from various databases in SQL server
  • Will be able to make your career and give a kick to your career growth in the world of Databases and Tables
  • You may be able to look your next career as Data Analyst to Database Manager
  • Able to design databases in practical office situations
  • You will be able to create fresh database and, also working on the ready databases using SQL Server Management Studio
  • Able to write your own SQL queries to a professional level
  • You will start understanding the power of SQL Server and its relationship with the. NET Framework and languages

Course Syllabus

1. Basic Database Concepts

  • Concepts Of DBMS And RDBMS
  • Introduction To SQL Server And Features Of SQL Server
  • SQL Server Data Types
  • Basics Of SQL
  • Database Design
  • Creating Databases
  • Management Studio
  • Data Types, Expressions, Operators
  • Working With Queries and Clauses
  • SELECT Into Statement
  • INSERT Statement
  • UPDATE Statement
  • Statement
  • Sub Queries
  • DISTINCT Clause
  • FROM Clause
  • WHERE Clause
  • ORDER BY Clause
  • BY Clause
  • HAVING Clause
  • SQL Server SQL Functions
  • SUM Function
  • COUNT Function
  • AVG Function
  • MIN Function
  • MAX Function
  • SQL Server Conditions
  • AND Condition
  • OR Condition
  • LIKE Condition
  • IN Condition
  • NOT Condition
  • IS NULL Condition
  • IS NOT NULL Condition
  • BETWEEN Condition
  • EXISTS Condition

2.Introduction To JOIN [New T-SQL Functions in SQL Server 2017]

  • INNER JOIN
  • OUTER JOIN
  • CROSS JOIN
  • UNION and UNION ALL
  • SQL Server Tables And Views
  • CREATE TABLE
  • SELECT INTO
  • ALTER TABLE
  • DROP TABLE
  • Local Temp Tables
  • Global Temp Tables
  • View
  • Data Types
  • Sub Queries
  • Nested Sub Queries
  • Correlated Sub Queries
  • Working With Stored Procedures
  • Working With Indexes and Views
  • Creating, Dropping Indexes
  • Working With Multiple Tables
  • Types Of Constraints
  • Data Definition Language(Ddl)
  • Creation Of Table
  • Modifying The Structure Of A Table
  • Dropping A Table
  • Working With Different Options
  • Inserting, Updating and Deleting Operations
  • Operators, Built-In Functions, Grouping
  • Introduction To Stored Procedures
  • Creating, Executing, Modifying, Dropping Store Procedures
  • Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *