Database Courses

Course Feedback
View All Feedbacks

Training Certification Courses

Microsoft SQL Server 2000

Database Administration and SQL for Developer

(Certification towards MCDBA)

Microsoft SQL Server Certification	£690
Oracle OCP + MS SQL 2000	£1800

MCDBA Certification Exam and Course Highlight

MCDBA Certification Exam 70–228:	Installing, Configuring, and Administering SQL Server 2000
MCDBA Certification Exam 70–229:	Designing and Implementing Databases with SQL Server 2000

Microsoft SQL Server 2000 Course Highlight

SQL Server Certification Overview
Overview of MS-SQL Server
SQL Server and Features
Installation and Upgrading SQL Server
Management and Configuration
SQL Languages
PRIMARY, FOREIGN KEY constraints
Programming Business LogicConfiguration and Tuning SQL Server
Data Storage and Managing Databases
Managing SQL Server Users and Security Features
Database Backup and Recovery
Extracting and Transforming Data with SQL Server 2000(XML)
Importing and Exporting Data

End 2 End Process

		Enrolment Phone or In Person Course Fee £690

		Books and Course Material Included

		Hands-on instructor led Training for 4 weeks, Unlimited Pratice Hours

		Free MCDBA Mock Exam

		Actual SQL Exam towards MCDBA Exam done @ BCOC Fee not included

		Certified towards MCDBA

Nearest starting Dates for MS SQL 2000

SQL Server 2000 Course Overview
Whether it is web commerce, accounting, finance, record keeping, data entry, and marketing or applications developer occupation, one of the basic tools used in many organisations in London and globally is RDBMS (SQL). SQL Server courses can prepare you for a career in database management on highly diverse level of industries in London and worldwide. Our courses for Microsoft SQL certification can also be useful for job encroachment in London because you can use the skills you gain immediately to increase your efficiency. Our SQL courses will give you clear understanding of the structure and function of a relational database system, use Microsoft SQL Server to create a relational database and use good design principles to optimise data storage and retrieval. Our courses in Microsoft SQL Server are gaining popularity, which, together with Microsoft .NET framework courses, promises to endow you to produce results via sophisticated database capabilities and information management. The SQL server course focuses primarily on developing proficiency with Microsoft SQL Server and on gaining solid skills for setting up and maintaining a database in a Microsoft Windows platform.

Exam 70–228 - Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition

Overview of MS-SQL Server
Introduction to SQL Server`
Client/Server Architecture
Role of Network Administrator
Role of Database Administrator
Role of Web Master
DBA Responsibility

SQL Server and Features
Architecture, Reliability
Service Manager, Enterprise Manager, Query Analyser

Installation and Upgrading SQL Server
Planning and Installation, Upgrade

Management and Configuration
Starting, Stopping SQL server, Enterprise Manager,
Registering Server, Connecting to SQL Server,
Manager Server Configurations, Logins, Server Roles,
Manage Database, Users and Object,
Monitor User Activity,
Manage Logs and Errors

SQL Languages
Create Statement
Insert Statement,
Select Statement,
Update Statement,
Alter Statement
Stored procedures,
Triggers,
Views, and user-defined functions
Sub Queries

Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints
Specify attributes that uniquely identify records.
Specify attributes that reference other entities.
Programming Business Logic
Manage data manipulation by using stored procedures,
Transactions, triggers, user-defined functions, and views

Configuration and Tuning SQL Server
Configuring SQL Server and Client
Memory, Configuring Parameters

Data Storage and Managing Databases
Creating Database
Viewing Information
Database Options
Renaming Database
Deleting Database
Moving Database Files

Managing SQL Server Users and Security Features
SQL Server Login
Configure mixed security modes or Windows Authentication.
Considerations include client connectivity,
Client operating system, and security infrastructure.
Create and manage logons.
Create and manage database users.
Add and remove users from roles
Create roles to manage database security
Set permissions in a database
Considerations include object permissions, object ownership, and statement permissions
Guest User, Permission
Managing Logins
Database Access and Database Roles
Removing Logins
Changing Passwords
Lever of Security
Granting and Revoking Object Permissions
Role-Base Security Management
Stored Procedure for Data Security

Database Backup and Recovery
Backup and Recovery Overview
Planning Backups
Performing a Backup
Automating Backups
Backup Strategies
Restoring User Database
Auto Recovery

Extracting and Transforming Data with SQL Server 2000
Set up IIS with the XML
Importing and Exporting Data

Exam 70-229 - Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Developing a Logical Data Model

Define entities. Considerations include entity composition and normalization.
• Specify entity attributes.
• Specify degree of normalization.

Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints.
• Specify attributes that uniquely identify records.
• Specify attributes that reference other entities.

Design attribute domain integrity. Considerations include CHECK constraints, data types, and nullability.
• Specify scale and precision of allowable values for each attribute.
• Allow or prohibit NULL for each attribute.
• Specify allowable values for each attribute.

Implementing the Physical Database

Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements.
• Specify space management parameters. Parameters include autoshrink, growth increment, initial size, and maxsize.
• Specify file group and file placement. Considerations include logical and physical file placement.
• Specify transaction log placement. Considerations include bulk load operations and performance.

Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views.
• Specify table characteristics. Characteristics include cascading actions, CHECK constraints, clustered, defaults, FILLFACTOR, foreign keys, nonclustered, primary key, and UNIQUE constraints.
• Specify schema binding and encryption for stored procedures, triggers, user-defined functions, and views.
• Specify recompile settings for stored procedures.
• Specify index characteristics. Characteristics include clustered, FILLFACTOR, nonclustered, and uniqueness.

Alter database objects to support replication and partitioned views.
• Support merge, snapshot, and transactional replication models.
• Design a partitioning strategy.
• Design and create constraints and views.
• Resolve replication conflicts.

Retrieving and Modifying Data

Import and export data. Methods include the bulk copy program, the Bulk Insert task, and Data Transformation Services (DTS).
• Manipulate heterogeneous data. Methods include linked servers, OPENQUERY, OPENROWSET, and OPENXML.
• Retrieve, filter, group, summarize, and modify data by using Transact-SQL.
• Manage result sets by using cursors and Transact-SQL. Considerations include locking models and appropriate usage.
• Extract data in XML format. Considerations include output format and XML schema structure.

Programming Business Logic
• Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views.
• Implement error handling in stored procedures, transactions, triggers, and user-defined functions.
• Pass and return parameters to and from stored procedures and user-defined functions.
• Validate data.

Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views.
• Specify trigger actions.
• Design and manage transactions.
• Manage control of flow.
• Filter data by using stored procedures, triggers, user-defined functions, and views.

Troubleshoot and optimize programming objects. Objects include stored procedures, transactions, triggers, user-defined functions, and views.

Tuning and Optimizing Data Access
• Analyze the query execution plan. Considerations include query processor operations and steps.
• Capture, analyze, and replay SQL Profiler traces. Considerations include lock detection, performance tuning, and trace flags.
• Create and implement indexing strategies. Considerations include clustered index, covering index, indexed views, nonclustered index, placement, and statistics.
• Improve index use by using the Index Tuning Wizard.
• Monitor and troubleshoot database activity by using SQL Profiler.

Designing a Database Security Plan
• Control data access by using stored procedures, triggers, user-defined functions, and views.
• Apply ownership chains.
• Use programming logic and objects. Considerations include implementing row-level security and restricting direct access to tables.

Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY.
Create and manage application roles.