Program Description Comp-70680: Microsoft Windows 7 In this Windows 7 training course, you will gain the knowledge and skills you need to successfully administer, maintain, and troubleshoot Windows 7 computers. Comp-70640: Windows Server 2008 - Active Directory Configuration In this comprehensive course you will not only discuss the crucial concepts and best practices of Active Directory, but you will also discover through hands-on exercises the Active Directory roles available in Windows Server 2008 and Windows Server 2008 R2. You will gain the knowledge and skills to configure Active Directory Domain Services (AD DS) in Windows Server 2008 and Windows Server 2008 R2 distributed environments, and you will create and configure Group Policies, perform backup and restore, and monitor and troubleshoot Active Directory-related issues. Comp-70642: Windows Server 2008 - Network Infrastructure Configuration Gain the knowledge and skills necessary to configure and troubleshoot Windows Server 2008 and Windows Server 2008 R2 SP1 network infrastructures. This course covers the networking technologies most commonly used with Windows Server 2008 and Windows Server 2008 R2 SP1, such as DNS, DHCP, IPv4 and IPv6 network addressing, Network Policy Server and Network Access Protection, and configuring secure network access. You will learn to implement fault-tolerant storage technologies, network storage and routing and remote access, monitoring, and compliance updates. Comp-70646: Application Infrastructure Configuration In this course, student will be able to plan and implement a Windows Server 2008 and Windows Server 2008 R2 environment. It incorporates both the planning of the server infrastructure and key aspects of the implementation, management and maintenance of Active Directory and Network Infrastructure. It is the primary training resource for Exam 70-646 preparation (MCITP: Server Administrator certification). It covers the most important job tasks for Server Administrators who are responsible for the planning, operations, and day-to-day maintenance of Windows Server 2008 and Windows Server 2008 R2 servers in the enterprise.
Microsoft Certified IT Professional MCITP/MCTS Program Length Total Contact Hours Clock Hours 360 Theory Hours 160 Weeks 16 Lab Hours 200 Externship Hours Total Hours 360 Course Number Course Title Theory Hours Lab Hours COMP-70698 Installing and Configuring Windows 10 40 COMP-70410 Installing and Configuring Windows Server 2012 40 COMP-70411 Administering Windows Server 2012 40 COMP-70412 Configuring Advanced Windows Server 2012 Services 40 Clock Hours 160 Lab Hours Breakdown COMP-70698 Installing and Configuring Windows 10 50 COMP-70410 Installing and Configuring Windows Server 2012 50 COMP-70411 Administering Windows Server 2012 50 COMP-70412 Configuring Advanced Windows Server 2012 Services 50 Lab Hours 200 Total Hours 360 Program objective Prepare the student to be able to design, manage, install and troubleshoot Microsoft Windows Network Infrastructure professionally and efficiently. Upon completion of this training the student will be able to work as a Network and Computer System Administrator, Computer Network Engineer. Program Description 1- Installing and Configuring Windows 10 Implementing Windows Prepare for installation requirements Install Windows Configure devices and device drivers Perform post-installation configuration Implement Windows in an enterprise environment Configure and Support Core Services Configure networking Configure storage Configure data access and usage Implement Apps Configure remote management Manage and Maintain Windows Configure updates Monitor Windows Configure system and data recovery Configure authorization and authentication Configure advanced management tools 2- Installing and Configuring Windows Server 2012 Install and Configure Windows Server 2012. Describe AD DS. Manage Active Directory objects. Automate Active Directory administration. Implement IPv4. Implement Dynamic Host Configuration Protocol (DHCP). Implement Domain Name System (DNS). Implement IPv6. Implement local storage. Share files and printers. Implement Group Policy. Use Group Policy Objects (GPOs) to secure Windows Servers. Implement server virtualization using Hyper-V. 3- Administering Windows Server 2012 Deploy and Maintain Server Images Configure and Troubleshoot DNS Maintain Active Directory Domain Services (AD DS). Manage User and Service Accounts Implement a Group Policy Infrastructure Manage User Desktops with Group Policy Configure and Troubleshoot Remote Access Install, Configure and Troubleshoot Network Policy Server (NPS) role Implement Network Access Protection (NAP) Optimize File Services Configure Encryption and Advanced Auditing Implement Update Management Monitor Windows Server 2012 Configuring Advanced Windows Server 2012 Implement advanced network services. Implement advanced file services. Implement Dynamic Access Control. Implement distributed Active Directory Domain Services (AD DS) deployments. Implement AD DS sites and replication. Implement Active Directory Certification Services (AD CS). Implement Active Directory Rights Management Services (AD RMS). Implement Active Directory Federation Services (AD FS). Implement network load balancing (NLB). Implement failover clustering. Implement failover clustering with Hyper-V. Implement disaster recovery.
MCSD Web Applications Certification Programming in HTML5 with JavaScript & CSS3 480 Developing ASP.net 4.5 MVC Web Applications 486 Developing Windows Azure and Web Services 487 Programming in HTML5 with JavaScript & CSS3 480 Implement and Manipulate Document Structures and Objects (24%) Create the document structure. This objective may include but is not limited to: structure the UI by using semantic markup, including for search engines and screen readers (Section, Article, Nav, Header, Footer, and Aside); create a layout container in HTML Write code that interacts with UI controls. This objective may include but is not limited to: programmatically add and modify HTML elements; implement media controls; implement HTML5 canvas and SVG graphics Apply styling to HTML elements programmatically. This objective may include but is not limited to: change the location of an element; apply a transform; show and hide elements Implement HTML5 APIs. This objective may include but is not limited to: implement storage APIs, AppCache API, and Geolocation API Establish the scope of objects and variables. This objective may include but is not limited to: define the lifetime of variables; keep objects out of the global namespace; use the “this” keyword to reference an object that fired an event; scope variables locally and globally Create and implement objects and methods. This objective may include but is not limited to: implement native objects; create custom objects and custom properties for native objects using prototypes and functions; inherit from an object; implement native methods and create custom methods Implement Program Flow (25%) Implement program flow. This objective may include but is not limited to: iterate across collections and array items; manage program decisions by using switch statements, if/then, and operators; evaluate expressions Raise and handle an event. This objective may include but is not limited to: handle common events exposed by DOM (OnBlur, OnFocus, OnClick); declare and handle bubbled events; handle an event by using an anonymous function Implement exception handling. This objective may include but is not limited to: set and respond to error codes; throw an exception; request for null checks; implement try-catch-finally blocks Implement a callback. This objective may include but is not limited to: receive messages from the HTML5 WebSocket API; use jQuery to make an AJAX call; wire up an event; implement a callback by using anonymous functions; handle the “this” pointer Create a web worker process. This objective may include but is not limited to: start and stop a web worker; pass data to a web worker; configure timeouts and intervals on the web worker; register an event listener for the web worker; limitations of a web worker Access and Secure Data (26%) Validate user input by using HTML5 elements. This objective may include but is not limited to: choose the appropriate controls based on requirements; implement HTML input types and content attributes (for example, required) to collect user input Validate user input by using JavaScript. This objective may include but is not limited to: evaluate a regular expression to validate the input format; validate that you are getting the right kind of data type by using built-in functions; prevent code injection Consume data. This objective may include but is not limited to: consume JSON and XML data; retrieve data by using web services; load data or get data from other sources by using XMLHTTPRequest Serialize, deserialize, and transmit data. This objective may include but is not limited to: binary data; text data (JSON, XML); implement the jQuery serialize method; Form.Submit; parse data; send data by using XMLHTTPRequest; sanitize input by using URI/form encoding Use CSS3 in Applications (25%) Style HTML text properties. This objective may include but is not limited to: apply styles to text appearance (color, bold, italics); apply styles to text font (WOFF and @font-face, size); apply styles to text alignment, spacing, and indentation; apply styles to text hyphenation; apply styles for a text drop shadow Style HTML box properties. This objective may include but is not limited to: apply styles to alter appearance attributes (size, border and rounding border corners, outline, padding, margin); apply styles to alter graphic effects (transparency, opacity, background image, gradients, shadow, clipping); apply styles to establish and change an element’s position (static, relative, absolute, fixed) Create a flexible content layout. This objective may include but is not limited to: implement a layout using a flexible box model; implement a layout using multi-column; implement a layout using position floating and exclusions; implement a layout using grid alignment; implement a layout using regions, grouping, and nesting Create an animated and adaptive UI. This objective may include but is not limited to: animate objects by applying CSS transitions; apply 3-D and 2-D transformations; adjust UI based on media queries (device adaptations for output formats, displays, and representations); hide or disable controls Find elements by using CSS selectors and jQuery. This objective may include but is not limited to: choose the correct selector to reference an element; define element, style, and attribute selectors; find elements by using pseudo-elements and pseudo-classes (for example, :before, :first-line, :first-letter, :target, :lang, :checked, :first-child) Structure a CSS file by using CSS selectors. This objective may include but is not limited to: reference elements correctly; implement inheritance; override inheritance by using !important; style an element based on pseudo-elements and pseudo-classes (for example, :before, :first-line, :first-letter, :target, :lang, :checked, :first-child) Developing ASP.net 4.5 MVC Web Applications 486 Design the Application Architecture Plan the application layers. This objective may include but is not limited to: plan data access; plan for separation of concerns; appropriate use of models, views, and controllers; choose between client-side and server side processing; design for scalability Design a distributed application. This objective may include but is not limited to: design a hybrid application (on premise vs. off premise, including Windows Azure); plan for session management in a distributed environment; plan web farms Design and implement the Windows Azure role life cycle. This objective may include but is not limited to: identify and implement Start, Run, and Stop events;identify startup tasks (IIS configuration
Oracle Database 10g: Administration Workshop I Release 2
$3,273.00
0 Available seats
This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you’ll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course is designed to prepare you for the corresponding Oracle Certified Associate exam. Introduction (Database Architecture) Describe course objectives Explore the Oracle 10g database architecture Installing the Oracle Database Software Explain core DBA tasks and tools Plan an Oracle installation Use optimal flexible architecture Install software with the Oracle Universal Installer (OUI) Creating an Oracle Database Create a database with the Database Configuration Assistant (DBCA) Create a database design template with the DBCA Generate database creation scripts with the DBCA Managing the Oracle Instance Start and stop the Oracle database and components Use Enterprise Manager (EM) Access a database with SQL*Plus and iSQL*Plus Modify database initialization parameters Understand the stages of database startup View the Alert log Use the Data Dictionary Managing Database Storage Structures Describe table data storage (in blocks) Define the purpose of tablespaces and data files Understand and utilize Oracle Managed Files (OMF) Create and manage tablespaces Obtain tablespace information Describe the main concepts and functionality of Automatic Storage Management (ASM) Administering User Security Create and manage database user accounts Authenticate users Assign default storage areas (tablespaces) Grant and revoke privileges Create and manage roles Create and manage profiles Implement standard password security features Control resource usage by users Managing Schema Objects Define schema objects and data types Create and modify tables Define constraints View the columns and contents of a table Create indexes, views and sequences Explain the use of temporary tables Use the Data Dictionary Managing Data and Concurrency Manage data through SQL Identify and administer PL/SQL Objects Describe triggers and triggering events Monitor and resolve locking conflicts Managing Undo Data Explain DML and undo data generation Monitor and administer undo Describe the difference between undo and redo data Configure undo retention Guarantee undo retention Use the undo advisor Implementing Oracle Database Security Describe DBA responsibilities for security Apply the principal of least privilege Enable standard database auditing Specify audit options Review audit information Maintain the audit trail Configuring the Oracle Network Environment Use Enterprise Manager for configuring the Oracle network environment Create additional listeners Create Net Service aliases Configure connect-time failover Control the Oracle Net Listener Test Oracle Net connectivity Identify when to use shared versus dedicated servers Proactive Maintenance Use statistics Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe advisory framework Set alert thresholds Use server-generated alerts Use automated tasks Performance Management Use Enterprise Manager pages to monitor performance Use the SQL Tuning Advisor Use the SQL Access Advisor Use Automatic Shared Memory Management Use the Memory Advisor to size memory buffers Use performance related dynamic views Troubleshoot invalid or unusable objects Backup and Recovery Concepts Identify the types of failure that may occur in an Oracle Database Describe ways to tune instance recovery Identify the importance of checkpoints, redo log files, and archived log files Configure ARCHIVELOG mode Performing Database Backups Create consistent database backups Back your database up without shutting it down Create incremental backups Automate database backups Monitor the flash recovery area Performing Database Recovery Recover from loss of a control file Recover from loss of a redo log file Perform complete recovery following the loss of a data file Performing Flashback Describe Flashback database Restore the table content to a specific point in the past with Flashback Table Recover from a dropped table View the contents of the database as of any single point in time with Flashback Query See versions of a row over time with Flashback Versions Query View the transaction history of a row with Flashback Transaction Query Moving Data Describe available ways for moving data Create and use directory objects Use SQL*Loader to load data from a non-Oracle database (or user files) Explain the general architecture of Data Pump Use Data Pump Export and Import to move data between Oracle databases Use external tables to move data via platform-independent files
This course advances your success as an Oracle professional in the area of database administration. In this class, you’ll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. You will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. You will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database. The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam. Introduction Grid Computing Oracle Enterprise Manager 10g Product Controls Database Architecture Review Configuring Recovery Manager Recovery Manager Features and Components Using a Flash Recovery Area with RMAN Configuring RMAN Control File Autobackups Retention Policies and Channel Allocation Using Recovery Manager to connect to a target database in default NOCATALOG mode Displaying the current RMAN configuration settings Altering the backup retention policy for a database Using Recovery Manager RMAN Command Overview Parallelization of Backup Sets Compressed Backups Image Copy Whole Database and Incremental Backups LIST and REPORT commands Enable ARCHIVELOG mode for the database Use Recovery Manager Oracle Secure Backup Installation and Configuration Implement the Oracle suggested strategy RMAN and Oracle Secure Backup Database and File-system files backup/restore to tape Using obtool and web interface to configure Oracle Secure Backup devices (CLI/GUI) Configuring EM for Oracle Secure Backup and test backup to tape (EM) Using RMAN to backup your database to tape (CLI) Using the OB Web tool to backup file system files Recovering from Non-critical Losses Recovery of Non-Critical Files Creating New Temporary Tablespace Recreating Redo Log Files, Index Tablespaces, and Indexes Read-Only Tablespace Recovery Authentication Methods for Database Administrators Loss of Password Authentication File Creating a new temporary tablespace Altering the default temporary tablespace for a database Incomplete Recovery Recovery Steps Server and User Managed Recovery commands Recovering a Control File Autobackup Creating a New Control File Incomplete Recovery Overview Incomplete Recovery Best Practices Simplified Recovery Through RESETLOGS Point-in-time recovery using RMAN Flashback Flashback Database Architecture Configuring and Monitoring Flashback Database Backing Up the Flash Recovery Area Using V$FLASH_RECOVERY_AREA_USAGE Flashback Database Considerations Using the Flashback Database RMAN interface Using Flashback Database EM Interface Managing and monitoring Flashback Database operations Dealing with Database Corruption Block Corruption Symptoms: ORA-1578 DBVERIFY Utility and the ANALYZE command Initialization parameter DB_BLOCK_CHECKING Segment Metadata Dump and Verification Using Flashback for Logical Corruption and using DBMS_REPAIR Block Media Recovery RMAN BMR Interface Dumping and Verifying Segment Metadata Monitoring and Managing Memory Oracle Memory Structures Automatic Shared Memory Management SGA Tuning Principles Database Control and Automatic Shared Memory Management Behavior of Auto-Tuned and Manual SGA Parameters Resizing SGA_TARGET PGA Management Resources Using the Memory Advisor Automatic Performance Management Identifying Tunable Components Oracle Wait Events and System Statistics Troubleshooting and Tuning Views Direct Attach to SGA for Statistic Collection Workload Repository Advisory Framework ADDM Scenarios and Usage Tips Using the SQL Tuning and SQL Access Advisor Monitoring and Managing Storage I Database Storage Structures Space Management Overview Oracle-Managed Files (OMF) Row Chaining and Migrating Proactive Tablespace Monitoring Managing Resumable Space Allocation SYSAUX Tablespace Monitoring table and index space usage Monitoring and Managing Storage II Automatic Undo Management Redo Log Files Table Types Partitioned Tables Index-Organized Tables (IOT) Managing index space with SQL Configure optimal redo log file size View “Automatic Tuning of Undo Retention” Automatic Storage Management ASM General Architecture and Functionalities Dynamic Performance View Additions Managing an ASM Instance ASM Disk Groups Using asmcmd Command Line Migrating Your Database to ASM Storage Creating an ASM instance in a separate Oracle Home Migrating a tablespace to use ASM storage VLDB Support Creating Bigfile Tablespaces Packages and data dictionary changes to support VLDB Creating and maintaining temporary tablespace groups (TTG) Partitioning and Partitioned Indexes Skipping unusable indexes Creating and using hash-partitioned global indexes DML Error Logging Interpreting Bigfile ROWIDs Managing Resources Database Resource Manager Concepts and Configuration Creating a New Resource Plan Active Session Pool Mechanism Maximum Estimated Execution Time Creating a Complex Plan Administering and Monitoring Resource Manager Resource Plan Directives Creating Resource Consumer Groups Automating Tasks with the Scheduler Scheduler Concepts Creating a Job Class and a Window Managing Jobs, Programs, Chains, Events, Schedules, priority Viewing and Purging Job Logs Creating a program and a schedule Creating a job that uses a program and a schedule Altering the program and schedule for the job and observing the behavior change of the job Monitoring job runs Database Security Virtual Private Database: Overview Creating a Column-Level Policy Writing a Policy Function Policy Types Column level VPD with column masking Transparent Data Encryption Setting the listener password Implement VPD Data Movement External Tables Concepts Creating a Directory object and External Table Data Pump Transport Database RMAN CONVERT DATABASE Command Transport Tablespace Create a Directory Object Create a Temporary Table Using Globalization Support Globalization Support Features Encoding Schemes Database Character Sets and National Character Sets Specifying Language-Dependent Behavior Locale Variants Using Linguistic Comparison and Sorting Data Conversion Between Client and Server Character Sets Determining the Default NLS Settings Workshop Workshop Methodology, requirements, and setup Scenario 1: Database performance Scenario 2: Finding and Tuning Inefficient SQL Scenario 3: SGA Management – REDO Scenario 4: Running out of Undo Space Scenario 5: Missing datafile Scenario 6: Managing space in a tablespace – REDO Scenario 7: Missing TEMP data file
Personal time management skills are essential for professional & personal success in any area of life. Those able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis.