Email: mail@radicaltechnologies.co.inPhone: 080-42041080 +91 9611824441

SQL SERVER DEVELOPMENT

Satisfied Learners

Our Courses

Drop A Query

Introduction to SQL Server

  • 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 

Export  Import Wizard 

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

Data Selection Queries 

  • 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 

Modifying Data  Modifying Data

  • 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
STILL NOT SURE WHAT TO DO?

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

X
Quik Enquiry