Kameswara Sarma Uppuluri
(MCT, MCPD, MCTS, MCAD, MCDBA, MCSD)

 

SQL Server 2012 Development

Your Instructor for this course is Kameswara Sarma Uppuluri.

He is an accomplished Senior Technical Corporate Trainer here in India and a consultant. He has been a Microsoft Certified Trainer since 2004 and a Microsoft Certified Professional since 1998. He has delivered various trainings at client places, on Microsoft Technologies for top MNC's in India .

He is passionate about teaching developers how to make the most out of their chosen technologies and doing web development in the best way possible.

He has spent years of developing course materials and teaching professional developers online throughout the world.

He has worked in technology for 16 years, specializing in web Development,Content Management Systems,databases and business intelligence.

He is an independent consultant that enjoys development and teaching.

He is a consultant based in Hyderabad, India. He has over 16 years of experience in the IT field, and over a decade of experience as a trainer.

He is an expert in SharePoint Development/Configuration/,Administration and .NET development and Database business intelligence technologies.

 

Watch Free Training Videos

See our Microsoft Certified Expert Trainers in action!

We've got Free Videos for you.

ITAcademy.IN has hours of free IT training videos online for each course.
Watch these videos taken directly from our "Live Instructor-led training sessions.

These videos are exactly the same quality that you get if you purchase one of our courses.


Our Complete List of
Free Videos
.

What is SQL Server?
  • SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL).
What is the objective of this course?

• Teaches how to write SQL statements that retrieve and update the data in a database.
• Teaches how to work with inner and outer joins, Summary Queries, SubQueries,data types and functions.
• How to use the new FILESTREAM storage feature to work with large amounts of binary data,such as
image,sound and video files…
Audience Profile:

This course is equally beneficial for those people who want to learn SQL SERVER from scratch or who are already involved in developing scripts using earlier versions of SQL Server / MySQL / Oracle or any other RDBMS.


Prerequisites

Prior knowledge of any other database system would be an added advantage. No particular programming experience is required.


Our Trainer's Profile :
  • Our Trainers speak from Experience
  • Our Trainers Are Subject Matter Experts
  • Our Trainers Are Expert instructors
  • Our Trainers are Microsoft Certified
  • Our Trainers have more than 13+ years of experience on Microsoft Technologies
Career Path :

After completing this course you will be able to take up the roles of
  • SQL Server Database Developer

Certification Path:

The course helps students to prepare for the following Microsoft Certification Exams:
  • Exam 70-461: TS: Querying Microsoft SQL Server 2012

SQL Server 2012 Development

   

Due to your time schedule / time zone differences, If you cannot attend our courses live, you can now as well buy the complete course videos from us. You can download our videos and can be played offline at your end.

Course
:
SQL Server 2012 Development
Author
:
Kameswara Sarma U (MCT,MCPD,MCTS,MCAD,MCDBA,MCSD)
Level
:
Beginners to Advanced
Release Date
:
05-Feb-2013
Exercise Files
:
Yes
We have got Free Videos for you, Please Click here.

Lesson 1 - Introduction to SQL Server

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:55:44
  • SQL Server Editions, Components, and Tools
  • Using SQL Server Management Studio (SSMS)
  • Working with Tables and Queries
  • New Transact-SQL Features
  • Business Intelligence Services

Lesson 2 - Installing SQL Server

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:29:49
  • Preparing for Installation
  • Upgrading an Earlier Version
  • Installation Steps
  • Configuring the Server



Lesson 3 - Designing and Create a Database

In this lesson, we will cover the following topics.

duration (hh:mm:ss):00:37:09

  • Relational Database Design Principles
  • Implementing the Design

Lesson 4 - Data Selection Queries

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:52:12
  • Understanding Transact-SQL
  • The SELECT Statement
  • The WHERE Clause
  • Using ORDER BY to Sort Data
  • The GROUP BY Clause
  • Joining Tables

Lesson 5 - Modifying Data

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:46:44
  • Modifying Data
  • Inserting Data
  • Updating Data
  • Deleting Data
  • Enforcing Data Integrity
  • Understanding Transaction Isolation

Lesson 6 - Working with SQL Server Management Studio

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:50:29
  • Getting Started with SSMS
  • Exploring the Object Explorer
  • Working with the Query Editor


Lesson 7 - TSQL Programming

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:50:40
  • Overview of Transact-SQL
  • Using Built-In Functions
  • Controlling Flow
  • 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


Lesson 8 - Transactions and Error Handling

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:45:07
  • Transaction Concepts
  • Applications and Transactions
  • Creating Explicit Transactions
  • Using TRY/CATCH Error Handling

Lesson 9 - Working with Views

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 01:03:06
  • What Is a View?
  • Creating Views
  • Updating Data Using a View
  • Using Computed Columns
  • Indexed Views
  • Partitioned Views

 

Lesson 10 - Creating Stored Procedures and Triggers

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 01:04:27
  • Creating Stored Procedures
  • Input/Ouput parameters and Return Values
  • Creating Triggers


Lesson 11 - Creating User-Defined Functions

In this lesson, we will cover the following topics.

duration (hh:mm:ss):00:47:07
  • User-Defined Function Overview
  • Scalar Functions
  • Inline Table-Valued Functions
  • Multi-Statement Table-Valued Functions
  • Using Functions, Views, and Stored Procedures

Lesson 12 - Using .NET Code in SQL Server

In this lesson, we will cover the following topics.

duration (hh:mm:ss):00:57:39
  • Writing SQLCLR Code
  • SQLCLR Code Modules
  • Managing Code Modules
  • SQLCLR Security
  • T-SQL vs. .NET Code


Lesson 13 - Advanced Query Techniques

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:53:59
  • Full-Text Search
  • Generating XML with FOR XML
  • Using APPLY
  • Creating Recursive Queries
  • Creating Pivot Queries
  • Executing Dynamic SQL



Lesson 14 - SQL Server Data Management

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:41:19
  • Using the bcp Command Line Utility
  • Using BULK INSERT
  • Using OPENROWSET
  • Using SQL Server Import and Export Wizard


Lesson 15 - T-SQL Enhancements

In this lesson, we will cover the following topics.

duration (hh:mm:ss): 00:53:12
  • New T-SQL Data Types
  • T-SQL Syntax
  • Sparse Columns and Column Sets
  • Table-Valued Parameters
  • Grouping Sets
  • MERGE Statement
  • Storing and Manipulating Unstructured Data
  • Row Constructors
  • HierarchyID Data Type
  • Date and Time Data Type
  • Table Valued Parameters
Why you should choose ITAcademy.IN as your Online Training provider?

• We are into training industry for more than 13+ years.
• Scenario Based Training.
• Certification Exam preparation.
• Our trainers are certified and qualified with Real-World experience.
• Our Large List of Satisfied Students & Clients Around the World.
• Demo of live project including Source Code and other resources will be provided to the students.
• Students will have access to soft copies of all the Case Studies and other examples used during the sessions.
• We provide complete guidance towards MCP Certification Exams.
• Step by Step Lab Manuals and Course Materials.
• Resume and Interview Preparation Guidance.
Due to your time schedule / time zone differences, If you cannot attend our courses live, you can now as well buy the complete course videos from us. You can download our videos and can be played offline at your end.

Q)How do i get access to demo videos of this course?
A)Please write to "support@itacademy.in" to have our "Live Demo Videos". We shall arrange you 2 demo videos to your end. Upon watching the same, if you find yourself happy, you can buy the complete videos of this course.

Q)What payment options do i have?
A)Please Write to "Support@itacademy.in" for payment options or for any other queries, you may have related to buying the course videos.

Q)How have you recorded these sessions?
A)Please be noted, all these videos are of live recording videos. It means, while our trainers delivers online training to participants, these sessions were recorded. Thus at times, you might hear the conversation between the participants and trainer as doubts being clarified.

Q)What should I do, if i find a faulty video file / corrupted video file?
A)We have ensured to a greater extent, that our videos are free from any kind of noise disturbances. If we have overlooked any such video, and you find any video of such type, please write back to us and we shall replace the video file with a fresh one, within 3 days from the date of your request at free of cost.

Q)What do I do, if i get a doubt, while watching videos?
A)While watching videos, if you get any doubts, you can write to "support@itacademy.in" and our trainer will attend your query, either by email with in 24 hrs from the date of receipt of your query, if that can be clarified so, else, our trainer will invite you for a live meeting on a specific date at free of cost.

Q)When do i get access to your videos?
A)Upon receiving the payment, we shall send you "URL's" to download our complete course videos. Please be noted, you are supposed to complete downloading the videos within 7 days from the day, download URL is been arranged to you by email. Afterwards, URL will be deactivated automatically.

Q)How do i play your videos?
A)You can play the videos using "Windows Media Player". All our video files, have an extension of ".WMV".

Q)Can i download exercise files as well?
A)Yes, all exercise files, that were used by the trainer as part of sessions, are downloadable along with the videos.

Q)Will i have access to future videos of this course?
A)Yes, as and when, we add new set of topics to courses, we intimate you to download new set of videos by email.

Q)What do i get from you, once I buy a course?
A)You get access to download complete course videos along with Exercise files.

Q)Will i get discount offers, if i wish to buy more courses from you?
A)Yes, you can write to "support@itacademy.in" stating the same and we shall assist you on the same.

Final Note : We request you to use these videos, for your personal purpose. We hope you understand, the efforts that our trainers / any trainer for that matter, puts up in making these videos.
 
Client Testimonials
 

I have learned SQL Server 2012 Development course with ITAcademy.IN. I am absolutely, an happy Customer. Thanks to Google for putting me at the right place.

Madhu
Dallas
 

 

Client Testimonials
 

It's an amazing experience of getting trained by Kameswara Sarma Uppuluri, on SQL Server 2012 Development Course. I could master so much stuff in less time. Thanks to you, Mr.  Uppuluri! for helping me to settle down well here.

Nithin
UK
 

 

 

© Copyright 2010 - 2014 | ITAcademy.IN | All trademarks and logos are the sole property of their respective owners.