Microsoft SQL Server
SQL Server is the Database Management System(RDBMS) that allows to store huge Databases and manage the same easily. It is an enterprise database management and analysis system.
SALIENT FEATURES
XML Support: Simplify the integration of your back-end systems and data transfer across firewalls using XML.
High Availability : Maximize the availability of your business applications with log shipping, online backups.
Automated Tuning : Automatic tuning and maintenance features enable administrators to focus on other critical tasks.
Improved Developer Productivity : User-defined functions, cascading referential integrity, and the integrated Transact-SQL debugger allow you to reuse code to simplify the development process.
Security : Ensure your applications are secure in any networked environment, with role-based security and file and network encryption.
Data Transformation Services : Automate routines that extract, transform, and load data from heterogeneous sources.
APPLICATIONS
· Multinational Companies with huge database to be maintained
· Banking Industry
· Production Industry
· Data warehousing companies
· Educational / Training Industry
· Air-transportation Service Industry
· Any business or service industry that stores database
TOPICS COVERED
· Basics of RDBMS
· Introduction to SQL (Structured Query Language)
· Querying data from SQL Server database
· Developing various objects like tables, views
· Data Integrity - Constraints, Rules, Defaults
· Programming in SQL Server
· Security in SQL Server - Creating users and ensuring authentication.
· Creating stored programs
· Procedures
· Functions
· Triggers
· Working with SQL Enterprise Management window.
· SQL Server new features.
