-
Posted By:
GR Placements, Hyderabad
-
Address:
-
Date Posted:
5th Feb 2010
-
Salary:
Negotiable
-
Location:
High Tech City
(500001)
-
Reference Code:
-
Views Since Posting:
123
-
Full Description:
Roles and Responsibilities: SQL Server - L4, DB Modeling - L1
Skill & Job Requirements: SQL Server - L4 - RDBMS - ? Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc ? Ability to understand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques MS SQL - ? SQL Constructs Ablility to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, System Functions, Joins, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views ? SQL Query Tuning Basics: Understanding of concepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN, Introduction to the Optimizer, Indexes and Basic Access Methods, Gathering Statistics, Optimizer Hints, Monitoring queries, Optimizing queries. ? Adv SQL: COMPUTE Clause, Advanced INSERT, Transact-SQL conditions and expressions, Dealing with collation sequences, Using scalar and aggregate functions, Multiple Table Queries ? Tools Level 1 usage T-SQL Programming - ? Database Programming Basics: Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Cursors, Error Handing, Creating Procedures and Creating Database Triggers ? Adv Database Programming: Ability to understand and implement programming with locks and isolation and working with temporary tables ? Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc ? Ability to understand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques ? Woking knowledge of DB Design/Modeling techniques(Logical and Physical DB modeling) ? SQL Constructs Ablility to understand and implement Data Types, Basic SQL SELECT Statements, Restricting and Sorting Data, System Functions, Joins, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views ? SQL Query Tuning Basics: Understanding of concepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN, Introduction to th
Note: Recruiters should never request bank account details or any kind of payment upon applying for a job or during the application process.
Should you receive a request for such information or believe a recruiter has acted inappropriately in relation to your application, please Contact Us with details of the recruiter and the position being advertised. We advise candidates to fully check the nature of any vacancy before attending an interview as we cannot be responsible for the accuracy of vacancies posted on this site.