Follow on Google News News By Tag * Sql Sever 2008 * Sql Server 2005 * Database Developer * Databade Administartor * Mcts * Mcitp * MICROSOFT * More Tags... Industry News News By Place Country(s) Industry News
Follow on Google News | FREE SEMINAR on SQL Server 2008 Database Developer & Administrator TrackDatabases Concepts & Theory, Creating & Implementing Database Objects (Tables, Views, Indexes, Stored Procedures, UDTs etc), T-SQL, Transactions, Users & Security Management, Mining & Optimizing Databases
By: EVS Proffessional Training Institute offers Certified SQL Server 2008 Specialist Free Seminar on Saturday June 19, 2010 at 06:00 PM in Lahore Introduction SQL Server offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximize the benefits of SQL Server. Participants gain a solid ground on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and reporting through reporting services. Objectives After this course student will be able to: • Install & Configure SQL Server 2008 • Understand Database Concepts & Normalization • Create and Manage Databases, Transaction Logs & Database Snapshots • Create Tables, Views, Stored Procedure & Functions • Implement Constraints, Triggers, Indexes & User Defined Data Types • Write Transact-SQL Statements for Retrieving and Manipulating Data • Implement login and database security and manage permissions • Manage Complex Multi-Step Jobs with SQL Server Agent • Design Transactions that Maximize Concurrency and Minimize Contention • Manage XML Data & Implement HTTP End-Point • Implementing High Availability and Disaster Recovery • Maintain Databases (Backup, Restore & Replication) • Analyze and Cure Performance Problems using SQL Server's Tools Course Schedule & Duration 29th Batch in Lahore Duration Frequency Start Date June 26 , 2010 Contents • Overview of SQL Server & Tools • Installing & Configuring SQL Server • Database Concepts & Theory • Understanding Data Warehousing & Data Mining • Designing & Implementing Databases • Retrieving & Manipulating Data using T-SQL • Applying additional query techniques • Creating UDTs, Functions & Triggers • Implementing Indices & Full-Text search • Managing XML data in SQL Server • Implementing HTTP Endpoints • Implementing Service Broker Components • Configuring & Manage SQL Server Security • Configuring Linked Servers • Implementing Database Mirroring & Log Shipping • Managing Database Snapshots • Implementing & Maintaining SQL Server Agent Jobs • Managing Backup & Restoration of Databases • Planning & Implementing Replication of Data • Monitoring & troubleshooting SQL Server • Optimizing SQL Server Performance • SQL Server Reporting Services Training Methodology • Lectures & Demos by industry experts • Project Driven Hands-On approach • Focus on latest tools, technologies & industry practices • Projects, assignments & quizzes for student’s evaluation Project Participants will develop a commercial level distributed database with the help of their trainer. they will also plan and implement its replication of the data on multiple servers as well as backup and restoration of database. Audience • Database Designers, database administrators, Programmers, analysts, Project Managers etc • IT/Computer Science graduates • Any other person having good basic understanding of databases Certifications • EVS Certified SQL Server Professional • MCITP: • MCITP: For further details contact Lahore Branch Call: 042-111- Walk: 349 Ferozepure Road, M-Block Gulberg, Lahore Visit: http://www.evslearning.com Rawalpindi Branch Call: 051-111- Walk: 92, 6th Road Block A, Satellite Town, Rawalpindi Visit: http://www.evslearning.com # # # EVS is training division of eVentureSolutionsPvtLtd.The institute was established to produce trained human resource in latest tools and technology for IT industry of Pakistan. To achieve this objective EVS has developed branches in Lahore and Rawalpindi. End
Account Email Address Disclaimer Report Abuse
|
|