SQL Server training in pune

sql


Course Features

 

   Ability to attend missed sessions

    Complete documentation

   Resume preparation

   Certification preparation.

   Interview preparation

   Placement assistance

Syllabus

 

Introduction to MEAN

  • SQL server introduction
  • Normalisation forms
  • Relational Database Design Principles
  • Using the Database Diagrammer Tool 

Working with SQL Server Management Studio

  • Getting Started with SSMS
  • Exploring the Object Explorer
  • Working with the Query Editor 

Working with Pig Latin - I

  • Exporting the data from DB to txt/xlsx/csv files
  • Importing the data to DB from txt/xlsx/csv files 

Working with Pig Latin - II

  • Understanding Transact-SQL
  • Working with Table Column Data Type
  • CREATE TABLE by Script & Using Object Explorer
  • The SELECT Statement
  • The WHERE Clause
  • Using ORDER BY to Sort Data
  • The GROUP 

 Working with Hive

  • Inserting Data
  • Updating Data
  • Deleting Data
  • Enforcing Data Integrity
  • Understanding Transaction Isolation 

 Transact-SQL Programming

  • Overview of Transact-SQL
  • Using Built-In Functions
  • Ranking Results
  • Limiting Results using TOP
  • Inner Joins with 2 or more tables
  • LEFT, RIGHT, FULL Outer joins
  • Working with String Functions
  • Working with DateTime functions
  • Using ROWNUMBER and RANK functions
  • Using Aggregate Functions
  • Changing Data Types using CAST and CONVERT
  • Displaying alternate values using CASE
  • Using Common Table Expressions
  • Writing Recursive Queries using Common Table Expressions 

Transactions and Error Handling

  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Using TRY/CATCH Error Handling 

What Is a View?

  • Creating Views
  • Updating Data Using a View
  • Using Computed Columns
  • Indexed Views
  • Partitioned Views 

 Creating Stored Procedures and Triggers

  • Creating Stored Procedures
  • Input/Ouput parameters and Return Values
  • Creating Triggers 

Creating User-Defined Functions

  • User-Defined Function Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Procedures

Indexing For Performance

  • Introducing Indexes
  • Creating Indexe
  • Understanding Query Execution plans and SQL server profiler 

SQL Server Data Management

  • Using the bcp Command Line Utility
  • Using SQL Server Import and Export Wizard
  • Using Bulk Insert

CLICK HERE TO PAY REGISTRATION FEES ONLINE

Gallery

no images were found

More

top
ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
19th Oct 2019 – Pimple Saudagar – Data Science : 4pm | AI : 4pm | Python : 12pm | AWS : 9am | Informatica : 11am | Salesforce : 11am | Tableau : 6pm(sun) | Devops : 2pm | Baner – Blockchain : 3.30pm | AWS : 9.30am | Nal Stop – Data Science : 6.30pm/5.30pm(wed) | Salesforce : 1pm | AWS : 4pm | Kharadi – Python : 3pm | Vashi – Devops : 11am | Data Science : 5pm | Python : 4.30pm | AWS : 2pm | Informatica : 4pm |