::SQL Server 2005::






you will learn how to Administer SQL Server 2005 with SQL Server Management Studio and Transact-SQL Create and manage databases, transaction logs and database snapshots Implement login and database security and manage permissions Develop a backup and recovery strategy Manage complex multistep jobs with SQL Server Agent Deploy and manage transactional replication Build databases, queries and reports for SQL Server 2005 Create and manage databases with SQL Server Management Studio Generate Transact-SQL statements for data retrieval and modification Implement security and back up databases to protect critical data Configure merge replication and handle data conflicts Explore business intelligence solutions using Integration, Analysis and Reporting Services Course benefits SQL Server 2005, with its advanced scalability, availability and security features, is a vital tool for an organization's mission-critical applications. To effectively administer SQL Server 2005, database administrators must learn how to take advantage of its robust feature set. This in-depth course provides extensive experience using SQL Server 2005 tools to perform real-world administrative tasks. You learn to install SQL Server, create and modify data structures, back up and recover databases, and manage security. Who should attend This course is valuable for administrators, engineers, consultants, analysts and others interested in database administration Hands-on training Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2005. Exercises include: Administering SQL Server 2005 with graphical tools and Transact-SQL Creating databases Managing database snapshots Implementing security for logins, databases and objects Encrypting data with passwords Backing up and restoring system and user databases Setting up Database Mail, jobs and alerts Installing SQL Server 2005 Creating databases with SQL Server Management Studio Adding primary and foreign key constraints to tables Retrieving and joining data from tables Securing database object access Defining a database maintenance plan Recovering a damaged database Synchronizing databases with merge replication Importing data from text files using SSIS Building a multidimensional cube with Analysis Services Rendering a report in HTML using Reporting Services Course content INTRODUCING SQL SERVER 2005 Overview of database fundamentals Client/Server RDBMS SQL Server 2005 editions Express Standard Enterprise Workgroup Mobile Developer SQL Server components and tools SQL Server Management Studio Business Intelligence Development Studio SQL Server Agent Database engine SQL Server Management Studio Transact-SQL SQLCMD Surface Area Checker ASSEMBLING A DATABASE Building a database Choosing file names and locations Determining file size and growth parameters Utilizing schemas to partition tables Designing tables Defining columns and attributes Selecting appropriate datatypes Setting the primary keys and indexes Modifying or removing columns Applying declarative constraints Enforcing check constraints Protecting relationships with foreign keys Validating the existing data DEVELOPING DATABASE APPLICATIONS Retrieving data with Transact-SQL Writing SQL queries with Management Studio Sorting the final result sets Joining columns from different tables Aggregating data by groups Refining result sets with subqueries Altering data with SQL commands INSERT UPDATE DELETE Storing query definitions Generating views with Management Studio Simplifying data access with views Server-side and client-side programming Constructing a stored procedure Executing stored procedures Exploring functions and triggers Integrating SQL Server with Office MANAGING SQL SERVER SECURITY AND ADMINISTRATION Administering security Creating SQL Server logins Implementing a security plan Defining database roles Deploying the Maintenance Plan Wizard Checking database consistency Verifying index pointers Backing up the database and log Reporting on maintenance plan success Automating administration Defining operators Generating and scheduling jobs Notifying operators of job outcome REPLICATING DATA Designing replication strategies Configuring the distribution server Publishing data with merge replication Pulling or pushing subscriptions Resolving conflicts using priorities LEVERAGING BUSINESS INTELLIGENCE SQL Server Integration Services (SSIS) Importing data into SQL Server Exporting data to text or CSV format Changing packages with SSIS Designer Analysis Services Storing multidimensional data Pivoting cubes in Microsoft Excel Detecting patterns with data mining SQL Server 2005 Reporting Services Authoring and deploying reports Extracting data from Analysis Services Viewing reports from a Web site PROVIDING APPLICATION SOLUTIONS WITH SQL SERVER Upsizing from Microsoft Access Displaying data on the Web with ASP.NET Exploiting XML B2B capabilities Investigating .NET Common Language Runtime (CLR) assemblies INSTALLING SQL SERVER SQL Server 2005 installation Choosing installation options Employing multiple instances Upgrading from previous versions Configuring SQL Server Manipulating configuration settings Enabling network protocols MANAGING DATABASES Disk structures Examining storage structures Creating databases and transaction logs Space management strategies Handling dynamic database growth Reclaiming unused space Working with database snapshots Taking database snapshots Improving performance with snapshots Moving databases Detaching and attaching databases Copying databases with the Copy Database Wizard CONTROLLING SERVER AND DATABASE SECURITY Login security Contrasting Windows and SQL Server authentications Authorizing logins Making logins members of server roles Enforcing password policy Database security Designing schemas Adding users Defining new roles Delegating privileges with pre-defined roles Assigning users to roles Permissions Granting server, database, schema-scoped and object permissions Interaction of roles and permissions Securing Common Language Runtime (CLR) assemblies Encrypting sensitive data Selecting encryption algorithms Choosing asymmetric or symmetric keys Implementing certificate-based encryption MONITORING SQL SERVER Studying ongoing activity Determining whether or not your hardware is adequate Identifying bottlenecks Capturing data for trend analysis Deploying the SQL Server Health and History Tool (SQLH2) Scheduling SQLH2 data collection Interrogating the SQLH2 repository BACKUP AND RECOVERY Planning for and recovering from disasters Transaction log architecture Choosing a recovery model Performing full, log and differential backups Recovering system and user databases Implementing database mirroring Selecting a mirroring architecture Configuring the mirror and witness servers Monitoring database mirroring AUTOMATING TASKS WITH JOBS AND ALERTS The SQL Server Agent Configuring the Agent Setting up Database Mail Multistep jobs Defining jobs to handle routine tasks Creating alerts and operators Associating alerts with jobs DEPLOYING REPLICATION Replication concepts Publish/subscribe metaphor Replication types Replication agents Managing transactional replication Configuring the Publisher and Distributor Establishing publications Subscribing to publications





Address: 230 Thosapol Land Bldg 2, Rachada-pisak Road, Huaykwang, Bangkok 10320 T. 02-2740864-8, 02-6925201-3 F. 02-2740869 Map For questions or comments: infodesk@cyberthai.com