info@smashgaps.com +91.7391.042.951 020 2565 4714

Sql Server Development

SQLServer Developer - Best Job Oriented IT Training Institutes and certification courses In Pune, Maharashtra India
Category Name : Database
Certification Name : MCSE: SQL 2012
Exam Id : 70-464
Number of Questions : 55
Passing Score : 70%
Time Limit : 120 mins
Examination Format : MCQ
Count : 10 Seats
Duration: XX Classes | XX Hours | Weekdays: 40 Days | Weekends: 16 Days
Batch Timings: Mon-Fri: 30 Days | Sat-Sun (Weekend): 8 Weekends Mon-Fri: 9 AM to 11 AM | Sat-Sun (Weekend): 10 AM to 4 PM
Batch Schedule: Starts from 01-Sep-2107
Review

Features:

Microsoft SQL Server Development is a computer application used to create desktop, enterprise, and web-based database applications. It is used at different levels and with various goals. This web site provides lessons and topics on how to use Microsoft SQL Server 2012 to create and manage databases

Audience:

The SQL Server Development exam is meant to be taken by database professionals who build and implement databases across the organization, while ensuring high levels of data availability. You should be about the perform tasks including creating database files, create data types, tables, plan create and optimize indexes, Implement data integrity, Implement views, stored procedures and functions, manage transactions and locks.

Prerequisites:

Basic Knowledge of database and understanding of RDBMS.

 

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

Can I upgrade my certification from MCSE 2008 to MCSE 2012?

You can upgrade MCSE 2008 to MCSE 2012 by giving exam 464.

Is there any certification available for the courses?

Yes,certifications are available for almost every course offered by Microsoft

I have already started down the path to earn a certification on one of the technology that will be updated. What should I do?

Regardless of the SQL certification level you are currently pursuing, we encourage you to continue down the path for your certification as upgrade paths become available.