Radical Technologies
  • Starting Data Science and Analytics with Spark Scala R and Python…Devops with- Chef Puppet Docker Ansible Salt Stack Jenkins Git Nagios Jira….VMWARE VCP 5.5 + 6.0 and 6.5 On Cisco UCS Server ….AWS | Salesforce | Openstack | Azure – Implementation,Migration  and  certification oriented Training …Windows SCCM And Server Deployment training with real time examples……Starting Training on Netapp Data Ontap Cluster Mode + 7.0 Mode 

  • COMBO COURSES

    RedHat Linux, Vitualization, Cloud, Hadoop,Datawarehousing Combo Courses with Discounted Price.....

    Readmore..

  • ONLINE TRAINING

    Radical Technologies provides best Online Training with Real-time Projects by Industry Experts....

    Online Schedule

  • BATCH SCHEDULE

    Best Classroom Training from Industry Consultants on High end Real-time Enterprise servers...

    Classroom Schedule

  • CERTIFICATIONS

    Authorized Exam Center for RedHat, Oracle, IBM, Microsoft, Cisco, Salesforce, AWS etc...

    Readmore..

SQL SERVER DEVELOPMENT

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