SQL SERVER DEVELOPMENT

2567 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

Our Courses

Drop A Query