SQLServer is most and one of the basic back ends
Most of these topics are asked by interviewers
Basic database concepts * Investigation process, data requirements * Data Integrity Concepts (Domain Integrity, Constraints (PK, FK, Unique) Check constraint Datatypes, Null * Relations between tables and columns
Logical and Physical database design (Entity, Attributes, Degree of Normalization) * Entity, Attributes, Degree of Normalization
ER Model
Database Objects (Tables, Stored Procedures, UDF, Views, Synonyms, Triggers etc)
Basic SQL Syntax * Retrieving Data - Select * Filtering Data - Where
SQLPlus / Query Analyzer other tools
Grouping and Summarizing Data - Group by, compute, Top, Having, Cube, Rollup etc
Jions, Unions, SubQuery, IN, Exists etc
Using Transactions, Inserting. Deleting, Updating data
Cursors Packages Functions @, @@
Clustered and Non Clustered, Unique indexes
Index Architecture * Index and Heap * Index Options, maintaining indexes, Statistics * Index tuning, performance considerations
Selectivity, Density, Distribution of Data
Query Optimizer, Analyzer
Distributed Querying
Linking Servers Clustering Servers
Replication
Adhoc Query
Resource Maintenance (CPU, I/O, Memory, Processors)
Trace, System Monitor
Transactions and Locks
Managing Transactions (Execute, Rollback or cancel)
Locking (Tables, Columns, Rows)
Concurrency Issues
Lock Capabilities
Dynamic Locking, Lock Options
Security NT authentication
Data Base * ODBC, JDBC, Type of Drivers * ODBC Vs JDBC * OLE-DB, ADO, ADO Parameters * Distributed databases 2 phase commit
SQL Trace Server side logging
MTS, Weblogic, WebSphere - Connection Pooling, Transactions, Isolation Levels, Locking
Entity Beans Container managed, Bean managed
Handling Null fields
Persistency
RAID - Levels, usage
Any other topic related to SQL Server
List the versions you can work with
OLAP types (ROLAP, MOLAP, HOLAP)
Multi Dimentional Databases, Drilldown, Slicing, Dicing
Aggregations
OLAP tools, evaluation of tools, Business analysis applications
Pivot table services, cubes, virtual cubes, cognos transformer, cognos powerplay
DTS, BCP, Data Import/Export, DTS Object Model, DTS package internals
SQL-XML
ActiveX Objects, Data Providers
ActiveX Scripts
Packaging Scheduling and execution
Data warehouse software(SQL2K, Prism Solutions)
Backup, Recovery and Restore
Security (Toolbased, Privileges, Roles, Profiles, Users)
Query tools, performance Multiple Data Sources
|
No responses found. Be the first to respond and make money from revenue sharing program.
|