Call :+91 8055223360
SQL SERVER DEVELOPMENT
Satisfied Learners
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
