Database Administration - MS-SQL SERVER 2012

Part- 1

MS-SQL SERVER 2012

• GETTING STARTED WITH SQL SERVER 2012
• WHAT'S NEW SQL SERVER 2012
• SQL SERVER DATABASE ENGINE - BACKWARD COMPATIBILITY
• DATABASE ENGINE FEATURES AND TASKS
• TRASACT - SQL REFERENCE
• ANALYSIS SERVICES
• INTEGRATION SERVICES
• DATA QUALITY SERVICES
• REPORTING SERVICES

Part- 2

STARTING SQL SERVER STUDIO EXPRESS

• Starting SQL Server Management Studio (SSMS)
• Connecting with Registered Servers and Object Explorer
• Changing the Environment Layout
• Display the Query Window
• Show the Object Explorer Details page
• Select the Keyboard Shortcut Scheme
• Set the Startup Options
• Restore the Default SQL Server Management Studio Configuration
• Summary: Basic Navigation

Part- 3

WRITING TRANSACT SQL

• Connecting with Query Editor
• Adding Indentation
• Maximizing Query Editor
• Using Comments
• Using Multiple Code Windows
• Script options

Part- 4

WORKING WITH TEMPLATES, SOLUTIONS AND SCRIPTS

• Create Scripts Using Templates
• Create Custom Templates
• Save Scripts as Projects and Solutions
• Summary

Part- 5

SQL Constraints

• PRIMARY KEY
• FOREIGN KEY
• NULL UNIQUE
• CHECK DEFAULT
• AUTO INCREMENT or IDENTITY
• ALTER TABLE
• INSERT INTO
• UPDATE
• WILDCARDS
• AND/OR OPERATORS