[caption id="attachment_1293" align="alignright" width="290" class=" "] Oracle Database 11g[/caption] Производитель: VTC Год выпуска: 2012 Продолжительность: 8:33:06 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: Veteran VTC instructor Bobby Rogers facilitates this review course for the Oracle Certified Associate on Solaris 11 certification exam. Designed for both novice and experienced administrators, the course will cover all exam objectives for the 1Z0-821 exam, including installing Solaris 11, the Image Packaging System, administering Oracle Solaris Zones, the ZFS file system, networking, controlling access to systems and files, and managing users. This course also covers Solaris 11.1 updates. [wpspoiler name="Подробное описание" ] Introduction - Installing Oracle Solaris 11 - Updating and Managing Packages - Administering Services - Administering Data Storage - Administering Oracle Solaris Zones - Administering a Physical Network - Administering User Accounts - System and File Access - System Processes and Tasks - Conclusion [/wpspoiler]

[caption id="attachment_1293" align="alignright" width="290" class=" "] Oracle Database 11g[/caption] Производитель: CBT Nuggets Год выпуска: 2011 Продолжительность: 12:33:06 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: In this Oracle10-11ExpressDBA course, trainer Tim Warner will teach you how to install and administer Oracle 11g databases from scratch and ensure the integrity and security of your organization's data. Related Area of Expertise: Database Administration Become your company's database deity. Tim Warner's course even shows you how to apply your existing SQL Server, MySQL, or DB2 skills directly to Oracle platforms! After watching, you'll be able to pass the Oracle10-11ExpressDBA exam, and you'll have the vocab, experience and confidence you need to impress hiring managers and clients. [wpspoiler name="Подробное описание" ] 1. Course Introduction (00:19:22) What is Oracle? About Oracle Certification. How This Course Works. Tackling the 1Z0-052 Exam. Summary: In this nugget we introduce the series. We describe Oracle Database 11g, learn how Oracle certification works, determine your best path through this training, and finally pick up important metadata concerning the 1Z0-052 test. 2. Exploring the Oracle Database Architecture (00:57:16) Database Basics. Memory Structures. Process Structures . Storage Structures. Summary: We begin our training my examining the architectural underpinnings of Oracle Database 11g. This theory is important not only for our exam success, but also to give us a framework for later lessons on performance tuning and troubleshooting. Related Exam Objectives: Explain the Memory Structures; Describe the Process Structures; Overview of Storage Structures 3. Preparing the Database Environment (00:40:29) Planning an Oracle Database Installation. Installing the Oracle software. Summary: In this nugget we learn how to install and configure Oracle Database 11g software. We'll learn that while installation on Windows is far easier than installation on NIX, the basic installation process is the same, thanks to the Oracle Universal Installer (OUI) Java application. Related Exam Objectives: Plan an Oracle Database installation; Install the Oracle software by using Oracle Universal Installer (OUI) 4. Creating an Oracle Database (00:50:04) Using the Database Configuration Assistant. Oracle Database Administration Tools. Summary: This nugget serves as a nice bookend to what we covered in the previous nugget. Whereas in the previous lesson we learned how to install the Oracle 11g instance (that is, background processes and memory structures), in this nugget we install an actual database by using the Database Configuration Assistant (DBCA) utility. Related Exam Objectives: Identify the tools for Administering an Oracle Database; Create a database by using the Database Configuration Assistant (DBCA) 5. Managing the Oracle Instance Part 1 (00:49:25) Stages of Database Startup and Shutdown. Database Initialization Parameters. Summary: Now that we have Oracle Database 11g fully set up, we learn how to manage the startup and shutdown processes (these are actually more complex than you might initially think). We also introduce the critical subject of initialization parameters and how they are stored in the server parameter file (SPFILE). Related Exam Objectives: Setting database initialization parameters; Describe the stages of database startup and shutdown 6. Managing the Oracle Instance Part 2 (00:31:32) Alert Log and Trace Files. The Data Dictionary. Dynamic Performance Views. Summary: As we delve deeper into Oracle DBA concepts, we examine the alert and trace logs, both rich sources of diagnostic and performance information. We also formally define the data dictionary and learn to query both data dictionary views and dynamic performance views to gather instance/database metadata. Related Exam Objectives: Using alert log and trace files; Using data dictionary and dynamic performance views 7. Configuring the Oracle Network Environment (00:47:20) Configuring and Managing the Oracle Network. Using the Oracle Shared Server Architecture. Summary: As you know, Oracle Database 11g is a client/server relational database management system (RDBMS). To that end, in this lesson we learn how to configure the Oracle network environment for maximum reliability, performance, and security. We also differentiate between the dedicated server and shared server process architectures, weighing the relative pros and cons of each approach. Related Exam Objectives: Configure and Manage the Oracle Network; Using the Oracle Shared Server architecture 8. Managing Database Storage Structures (00:39:54) Reviewing Oracle Data Storage. Understanding Tablespaces and Datafiles. Creating and Managing Tablespaces. Summary: As we know, the physical files are what comprises the Oracle 11g database, proper. To wit, in this nugget we review the relevant terminology: stuff like datafiles, control files, and the logical storage construct known as the tablespace. Related Exam Objectives: Overview of tablespace and datafiles; Create and manage tablespaces; Space management in tablespaces 9. Administering User Security (00:47:49) Creating and Managing Database User Accounts. Granting and Revoking Privileges. Creating and Managing Roles. Creating and Managing Profiles. Summary: Oracle databases often contain highly sensitive data. Therefore, keeping the database as secure as possible is a chief task of any Oracle DBA. In this lesson we learn how to create and manage user accounts. We then examine how best to grant and revoke permissions by using roles. Finally, we learn how to institute password complexity rules and resource utilization limits by rolling out profiles. Related Exam Objectives: Create and manage database user accounts; Grant and revoke privileges; Create and manage roles; Create and manage profiles 10. Managing Data and Concurrency (00:40:26) Understanding Transactions. Monitoring and Resolving Locking Conflicts. Summary: Any RDBMS worth its salt will support multiuser access. Oracle 11g is known particularly for its adherence to the ACID properties of database transactions. By concluding this nugget you will understand how to define and manage transactions in Oracle. You will also learn how to diagnose and resolve user process locking problems. Related Exam Objectives: Monitor and resolve locking conflicts; Transactions and undo data 11. Managing Undo Data (00:29:31) Multiplexing the Redo Log Files. Understanding Undo. Managing Undo. Summary: Undo data in Oracle enables us to restore previous data values if needed as well as provides us with multi-user access to database data. In this nugget we'll learn how to multiplex the redo log files and manage the undo tablespace and datafiles. Related Exam Objectives: Overview of Undo; Transactions and undo data; Managing undo 12. Implementing Oracle Database Security (00:34:00) Reviewing Database Security Tasks. Using Standard Database Auditing. Summary: Here we revisit the subject of database security (it's a really important concept if you haven't put that together yet). Specifically, here we concentrate on a "laundry list" of security-related DBA tasks. Then we transition into a consideration of standard database auditing. Related Exam Objectives: Database Security and Principle of Least Privilege; Work with Standard Database Auditing 13. Database Maintenance (00:42:01) Managing Optimizer Statistics. Managing Automatic Workload Repository. Using Advisory Framework. Setting Alerts. Summary: Like a vehicle or most other mechanical possessions, we need to perform regular maintenance to keep those items tuned up. The same thing goes for Oracle Database 11g. In this nugget we get a flying head start on the myriad self-tuning options supported by Oracle Database 11g. Sometimes we might think that Oracle does self-management so well that we can leave the DBA business! Related Exam Objectives: Use and manage optimizer statistics; Use and manage Automatic Workload Repository (AWR); Use advisory framework; Manage Alerts and Thresholds 14. Performance Management (00:26:20) Using Automatic Memory Management. Using Memory Advisors. Troubleshooting Invalid and Unusable Objects. Summary: While performance tuning is a major subject on the Oracle Certified Professional (OCP) exam, here we cover the basics. We learn to tune memory and then discover and correct invalid/unusable database objects. Related Exam Objectives: Use Automatic Memory Management; Use Memory Advisors; Troubleshoot invalid and unusable objects 15. Intelligent Infrastructure Enhancements (00:34:50) Using the Enterprise Manager Support Workbench. Managing Patches. Summary: Oracle support is not free, but if you have it you'll doubtless find it very comprehensive and extremely helpful. In this nugget we learn the basic mechanics of how to file issues with Oracle Support. Related Exam Objectives: Use the Enterprise Manager Support Workbench; Managing Patches. 16. Backup and Recovery Concepts (00:31:41) Identifying Oracle Database Types of Failure. Tuning Instance Recovery. Checkpoints, Redo Log Files, and Archived Log Files. Configuring ARCHIVELOG Mode. Summary: Like performance tuning, backup and recovery is the other "centerpiece" subject on the OCP exams. Here we, again, cover the basic principles of this vast subject. Specifically, here we focus on backup and recovery concepts and the notion of database recovery. Related Exam Objectives: Identify the types of failure that can occur in an Oracle database; Describe ways to tune instance recovery; Identify the importance of checkpoints, redo log files, and archived log files; Overview of flash recovery area; Configure ARCHIVELOG mode 17. Performing Database Backups Part 1 (00:37:23) Creating Consistent Database Backups. Performing a Hot Backup. Creating Incremental Backups. Summary: This is part one of a three-part nugget miniseries on performing Oracle backups and restores. This particular nugget teaches you the "nuts" and bolts of performing backups by using both the RMAN utility as well as Oracle Enterprise Manager (OEM). Related Exam Objectives: Create consistent database backups; Back up your database without shutting it down; Create incremental backups 18. Performing Database Backups Part 2 (00:31:32) Automating Database Backups. Managing Backups. Viewing Backup Reports. Summary: In this nugget we continue our discussion from the previous lesson. Here we examine how to script out/automate database backups and examine backup reports. Related Exam Objectives: Automate database backups; Manage backups, view backup reports and monitor the flash recovery area 19. Performing Database Recovery (00:29:45) Understanding Data Recovery Advisor. Performing Recovery (Control file, Redo Log File and Data File). Summary: In this nugget we look at the other side of the disaster recovery coin: that is, how to restore all or part of an Oracle 11g database by using RMAN and OEM. Related Exam Objectives: Overview of Data Recovery Advisor; Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file) 20. Moving Data (00:32:26) Moving Data (Directory Objects, SQL*Loader, External Tables). Understanding Oracle Data Pump. Using Data Pump Export and Import. Summary: We complete the training by learning to use the built-in Oracle tools for performing data import and export. This supports technologies and scenarios such as data warehousing and Extract-Transform-Load (ETL). Related Exam Objectives: Describe and use methods to move data (Directory objects, SQL*Loader, External Tables); Explain the general architecture of Oracle Data Pump; Use Data Pump Export and Import to move data between Oracle databases [/wpspoiler]

[caption id="attachment_1293" align="alignright" width="290" class=" "] Oracle Database 11g[/caption] Производитель: CBT Nuggets Год выпуска: 2011 Продолжительность: 12:33:06 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: In this Oracle Database 11g DBA 1 1Z0-052 course, trainer Tim Warner will teach you how to install and administer Oracle 11g databases from scratch and ensure the integrity and security of your organization's data. Related Area of Expertise: Database Administration Become your company's database deity. Tim Warner's course even shows you how to apply your existing SQL Server, MySQL, or DB2 skills directly to Oracle platforms! After watching, you'll be able to pass the Oracle 1Z0-052 exam, and you'll have the vocab, experience and confidence you need to impress hiring managers and clients. [wpspoiler name="Подробное описание" ] 1. Course Introduction (00:19:22) What is Oracle? About Oracle Certification. How This Course Works. Tackling the 1Z0-052 Exam. Summary: In this nugget we introduce the series. We describe Oracle Database 11g, learn how Oracle certification works, determine your best path through this training, and finally pick up important metadata concerning the 1Z0-052 test. 2. Exploring the Oracle Database Architecture (00:57:16) Database Basics. Memory Structures. Process Structures . Storage Structures. Summary: We begin our training my examining the architectural underpinnings of Oracle Database 11g. This theory is important not only for our exam success, but also to give us a framework for later lessons on performance tuning and troubleshooting. Related Exam Objectives: Explain the Memory Structures; Describe the Process Structures; Overview of Storage Structures 3. Preparing the Database Environment (00:40:29) Planning an Oracle Database Installation. Installing the Oracle software. Summary: In this nugget we learn how to install and configure Oracle Database 11g software. We'll learn that while installation on Windows is far easier than installation on NIX, the basic installation process is the same, thanks to the Oracle Universal Installer (OUI) Java application. Related Exam Objectives: Plan an Oracle Database installation; Install the Oracle software by using Oracle Universal Installer (OUI) 4. Creating an Oracle Database (00:50:04) Using the Database Configuration Assistant. Oracle Database Administration Tools. Summary: This nugget serves as a nice bookend to what we covered in the previous nugget. Whereas in the previous lesson we learned how to install the Oracle 11g instance (that is, background processes and memory structures), in this nugget we install an actual database by using the Database Configuration Assistant (DBCA) utility. Related Exam Objectives: Identify the tools for Administering an Oracle Database; Create a database by using the Database Configuration Assistant (DBCA) 5. Managing the Oracle Instance Part 1 (00:49:25) Stages of Database Startup and Shutdown. Database Initialization Parameters. Summary: Now that we have Oracle Database 11g fully set up, we learn how to manage the startup and shutdown processes (these are actually more complex than you might initially think). We also introduce the critical subject of initialization parameters and how they are stored in the server parameter file (SPFILE). Related Exam Objectives: Setting database initialization parameters; Describe the stages of database startup and shutdown 6. Managing the Oracle Instance Part 2 (00:31:32) Alert Log and Trace Files. The Data Dictionary. Dynamic Performance Views. Summary: As we delve deeper into Oracle DBA concepts, we examine the alert and trace logs, both rich sources of diagnostic and performance information. We also formally define the data dictionary and learn to query both data dictionary views and dynamic performance views to gather instance/database metadata. Related Exam Objectives: Using alert log and trace files; Using data dictionary and dynamic performance views 7. Configuring the Oracle Network Environment (00:47:20) Configuring and Managing the Oracle Network. Using the Oracle Shared Server Architecture. Summary: As you know, Oracle Database 11g is a client/server relational database management system (RDBMS). To that end, in this lesson we learn how to configure the Oracle network environment for maximum reliability, performance, and security. We also differentiate between the dedicated server and shared server process architectures, weighing the relative pros and cons of each approach. Related Exam Objectives: Configure and Manage the Oracle Network; Using the Oracle Shared Server architecture 8. Managing Database Storage Structures (00:39:54) Reviewing Oracle Data Storage. Understanding Tablespaces and Datafiles. Creating and Managing Tablespaces. Summary: As we know, the physical files are what comprises the Oracle 11g database, proper. To wit, in this nugget we review the relevant terminology: stuff like datafiles, control files, and the logical storage construct known as the tablespace. Related Exam Objectives: Overview of tablespace and datafiles; Create and manage tablespaces; Space management in tablespaces 9. Administering User Security (00:47:49) Creating and Managing Database User Accounts. Granting and Revoking Privileges. Creating and Managing Roles. Creating and Managing Profiles. Summary: Oracle databases often contain highly sensitive data. Therefore, keeping the database as secure as possible is a chief task of any Oracle DBA. In this lesson we learn how to create and manage user accounts. We then examine how best to grant and revoke permissions by using roles. Finally, we learn how to institute password complexity rules and resource utilization limits by rolling out profiles. Related Exam Objectives: Create and manage database user accounts; Grant and revoke privileges; Create and manage roles; Create and manage profiles 10. Managing Data and Concurrency (00:40:26) Understanding Transactions. Monitoring and Resolving Locking Conflicts. Summary: Any RDBMS worth its salt will support multiuser access. Oracle 11g is known particularly for its adherence to the ACID properties of database transactions. By concluding this nugget you will understand how to define and manage transactions in Oracle. You will also learn how to diagnose and resolve user process locking problems. Related Exam Objectives: Monitor and resolve locking conflicts; Transactions and undo data 11. Managing Undo Data (00:29:31) Multiplexing the Redo Log Files. Understanding Undo. Managing Undo. Summary: Undo data in Oracle enables us to restore previous data values if needed as well as provides us with multi-user access to database data. In this nugget we'll learn how to multiplex the redo log files and manage the undo tablespace and datafiles. Related Exam Objectives: Overview of Undo; Transactions and undo data; Managing undo 12. Implementing Oracle Database Security (00:34:00) Reviewing Database Security Tasks. Using Standard Database Auditing. Summary: Here we revisit the subject of database security (it's a really important concept if you haven't put that together yet). Specifically, here we concentrate on a "laundry list" of security-related DBA tasks. Then we transition into a consideration of standard database auditing. Related Exam Objectives: Database Security and Principle of Least Privilege; Work with Standard Database Auditing 13. Database Maintenance (00:42:01) Managing Optimizer Statistics. Managing Automatic Workload Repository. Using Advisory Framework. Setting Alerts. Summary: Like a vehicle or most other mechanical possessions, we need to perform regular maintenance to keep those items tuned up. The same thing goes for Oracle Database 11g. In this nugget we get a flying head start on the myriad self-tuning options supported by Oracle Database 11g. Sometimes we might think that Oracle does self-management so well that we can leave the DBA business! Related Exam Objectives: Use and manage optimizer statistics; Use and manage Automatic Workload Repository (AWR); Use advisory framework; Manage Alerts and Thresholds 14. Performance Management (00:26:20) Using Automatic Memory Management. Using Memory Advisors. Troubleshooting Invalid and Unusable Objects. Summary: While performance tuning is a major subject on the Oracle Certified Professional (OCP) exam, here we cover the basics. We learn to tune memory and then discover and correct invalid/unusable database objects. Related Exam Objectives: Use Automatic Memory Management; Use Memory Advisors; Troubleshoot invalid and unusable objects 15. Intelligent Infrastructure Enhancements (00:34:50) Using the Enterprise Manager Support Workbench. Managing Patches. Summary: Oracle support is not free, but if you have it you'll doubtless find it very comprehensive and extremely helpful. In this nugget we learn the basic mechanics of how to file issues with Oracle Support. Related Exam Objectives: Use the Enterprise Manager Support Workbench; Managing Patches. 16. Backup and Recovery Concepts (00:31:41) Identifying Oracle Database Types of Failure. Tuning Instance Recovery. Checkpoints, Redo Log Files, and Archived Log Files. Configuring ARCHIVELOG Mode. Summary: Like performance tuning, backup and recovery is the other "centerpiece" subject on the OCP exams. Here we, again, cover the basic principles of this vast subject. Specifically, here we focus on backup and recovery concepts and the notion of database recovery. Related Exam Objectives: Identify the types of failure that can occur in an Oracle database; Describe ways to tune instance recovery; Identify the importance of checkpoints, redo log files, and archived log files; Overview of flash recovery area; Configure ARCHIVELOG mode 17. Performing Database Backups Part 1 (00:37:23) Creating Consistent Database Backups. Performing a Hot Backup. Creating Incremental Backups. Summary: This is part one of a three-part nugget miniseries on performing Oracle backups and restores. This particular nugget teaches you the "nuts" and bolts of performing backups by using both the RMAN utility as well as Oracle Enterprise Manager (OEM). Related Exam Objectives: Create consistent database backups; Back up your database without shutting it down; Create incremental backups 18. Performing Database Backups Part 2 (00:31:32) Automating Database Backups. Managing Backups. Viewing Backup Reports. Summary: In this nugget we continue our discussion from the previous lesson. Here we examine how to script out/automate database backups and examine backup reports. Related Exam Objectives: Automate database backups; Manage backups, view backup reports and monitor the flash recovery area 19. Performing Database Recovery (00:29:45) Understanding Data Recovery Advisor. Performing Recovery (Control file, Redo Log File and Data File). Summary: In this nugget we look at the other side of the disaster recovery coin: that is, how to restore all or part of an Oracle 11g database by using RMAN and OEM. Related Exam Objectives: Overview of Data Recovery Advisor; Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file) 20. Moving Data (00:32:26) Moving Data (Directory Objects, SQL*Loader, External Tables). Understanding Oracle Data Pump. Using Data Pump Export and Import. Summary: We complete the training by learning to use the built-in Oracle tools for performing data import and export. This supports technologies and scenarios such as data warehousing and Extract-Transform-Load (ETL). Related Exam Objectives: Describe and use methods to move data (Directory objects, SQL*Loader, External Tables); Explain the general architecture of Oracle Data Pump; Use Data Pump Export and Import to move data between Oracle databases [/wpspoiler]

[caption id="attachment_1293" align="alignright" width="290" class=" "] Oracle Database 11g[/caption] Производитель: Специалист Год выпуска: 2011 Продолжительность: 15:11:00 Тип материала: Видеоурок Язык: Русский Стоимость: 3999 рублей Описание: Данный видеокурс познакомит слушателей с базовыми знаниями SQL, позволяющими разработчику писать запросы к одной или нескольким таблицам, модифицировать данные таблиц и создавать объекты базы данных. Основным инструментом разработки, используемым в курсе, является Oracle SQL Developer, в качестве дополнительного используется SQL Plus. Требуемая подготовка: Успешное окончание курса Основы программирования и баз данных или эквивалентная подготовка. [wpspoiler name="Подробное описание" ] Модуль 1. Введение в базу данных Oracle 11g • Обзор основных возможностей БД Oracle 11g • Обсуждение основных концепций, а также теоретических и физических аспектов реляционной базы данных • Классификация команд SQL как стандартного языка реляционных баз данных • Обзор данных, используемых в курсе • Использование SQL Developer для установления сеанса связи с базой данных • Сохранение результатов запросов в файлы и использование скрипт-файлов в SQL Developer Модуль 2. Извлечение данных при помощи команды SELECT языка SQL • Обзор возможностей команды SELECT • Создание отчета при помощи базовой команды SELECT • Выбор всех столбцов • Выбор конкретных столбцов • Заголовки столбцов по умолчанию • Арифметические выражения • Понимание приоритетов операторов • Использование команды DESCRIBE для вывода структуры таблицы Модуль 3. Ограничение и сортировка данных • Использование предложения WHERE для выборки необходимых строк • Использование операторов сравнения и логических операторов в предложении WHERE • Описание правил приоритета операторов сравнения и логических операторов • Использование символьных литералов в предложении WHERE • Сортировка строк с использованием предложения ORDER BY команды SELECT • Сортировка результата в порядке возрастания и убывания значений Модуль 4. Использование однострочных функций в команде SELECT • Демонстрация различий между однострочными и многострочными функциями SQL • Преобразование строк при помощи символьных функций, используемых в списке SELECT и предложении WHERE • Преобразование чисел при помощи функций ROUND, TRUNC и MOD • Использование арифметических операций с датами в предложении SELECT • Использование функций для работы с датами Модуль 5. Использование функций преобразования и условных выражений • Неявное и явное преобразование типов данных • Использование функций преобразования TO_CHAR, TO_NUMBER и TO_DATE • Вложенные однострочные функции • Применение функций NVL, NULLIF и COALESCE к датам • Использование логических условий IF THEN ELSE в команде SELECT Модуль 6. Агрегирование данных с использованием групповых функций • Использование групповых функций в команде SELECT для создания аналитических отчетов • Создание групп данных при помощи предложения GROUP BY • Исключение групп данных при помощи предложения HAVING Модуль 7. Выборка данных из нескольких таблиц • Написание команды SELECT для доступа к данным более чем одной таблицы • Просмотр данных из таблиц при помощи внешнего соединения • Соединение таблицы с самой собой (self join) Модуль 8. Использование подзапросов • Типы проблем, решаемые при помощи подзапросов • Определение подзапросов • Типы подзапросов • Однострочные и многострочные подзапросы Модуль 9. Использование операторов работы над множествами • Описание операторов работы над множествами • Использование операторов работы над множествами для объединения нескольких запросов в один • Сортировка результатов при использовании операторов работы над множествами Модуль 10. Манипулирование данными • Синтаксис команд DML • Добавление строк в таблицу при помощи команды INSERT • Использование команды UPDATE для изменения строк таблицы • Удаление данных из таблицы при помощи команды DELETE • Использование скриптов для манипулирования данными • Сохранение и откат изменений при помощи команд COMMIT и ROLLBACK • Что такое согласованность чтения Модуль 11. Использование команд DDL для создания и управления таблицами • Основные объекты БД, рассматриваемые в курсе • Обзор структуры таблицы • Основные типы данных, используемые при создании столбцов таблицы • Использование простого синтаксиса для создания таблиц • Какие правила целостности могут быть определены при создании таблицы • Как работают объекты схемы: (команды ALTER,DROP) Модуль 12. Создание других объектов схемы • Создание простого и сложного представления • Доступ к данным через представление • Создание, изменение и использование последовательностей • Создание и сопровождение индексов • Создание частных и публичных синонимов Модуль 13. Контроль доступа пользователя • Отличия системных привилегий от объектных • Создание пользователей • Предоставление системных привилегий • Выдача привилегий на таблицы • Создание роли и предоставление ей привилегий • Смена пароля пользователя • Предоставление объектных привилегий • Отнятие привилегий Модуль 14. Управление объектами схемы • Добавление, изменение и удаление столбца • Добавление и удаление ограничений • Включение и отключение ограничений, отложенная проверка ограничений • Создание и удаление индексов • Создание индексов, основанных на функциях • Выполнение операции FLASHBACK • Создание и использование внешних таблиц Модуль 15. Управление объектами при помощи словаря данных • Словарь данных • Использование представлений словаря • Представления USER_OBJECTS и ALL_OBJECTS • Информация о таблицах и столбцах • Просмотр информации об ограничениях • Просмотр информации о последовательностях, индексах и синонимах • Как добавить комментарии к таблице и столбцам Модуль 16. Манипулирование большими наборами данных • Манипулирование данными с использованием подзапросов • Описание особенностей многотабличной команды INSERT • Использование различных типов многотабличной команды INSERT • Слияние строк при помощи команды MERGE • Отслеживание изменений в данных за определенный период времени Модуль 17. Сопровождение данных различных временных зон • Использование различных типов данных даты и времени для хранения дробных долей секунды, а также сопровождения данных различных временных зон • Использование интервальных типов данных для хранения разницы между двумя значениями, содержащими время • Практическое применение ряда функций даты и времени для глобализации приложений Модуль 18. Выборка данных с использованием усложнённых подзапросов • Многостолбцовые подзапросы • Использование скалярных подзапросов в SQL • Круг проблем, решаемых при помощи коррелированных подзапросов • Модификация и удаление строк при помощи коррелированных подзапросов • Использование операторов EXISTS и NOT EXISTS • Применение предложения WITH Модуль 19. Поддержка регулярных выражений • Преимущества применения регулярных выражений • Использование регулярных выражений для поиска соответствия и замещения строк [/wpspoiler]

[caption id="attachment_1293" align="alignright" width="290" class=" "] Oracle Database 11g[/caption] Автор: Производитель: CBT Nuggets Год выпуска: 2011 Продолжительность: 11:31:43 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: This Oracle Database 11g SQL Fundamentals 1 1Z0-051 course, trainer Timothy Warner will cover retrieving, restricting, manipulating, and sorting data, subqueries, database security, and more. He will also provide the information necessary to pass the 1Z0-051 exam. Related Area of Expertise: Database Development Data, data everywhere…take control of your database and learn to manipulate it with the tried-and-true Structured Query Language (SQL) in Oracle Database 11g. Whether you're an IT pro who wants to add Oracle DBA and SQL querying to your tool belt, a DBA in another technology who wants to dive into Oracle, or a newcomer to relational databases who yearns to learn SQL, this course will give you what you need to reach your goal. In this course, you'll gain SQL proficiency and be able to take control of your data. Best of all, you can apply the skills you learn not only to Oracle, but to almost any RDBMS platform! And, trainer Tim Warner gives you all sorts of cool supplemental learning references -– all of the SQL work files can be downloaded free at nuggetlab.com, and the course is filled with recommendations for white papers, Web sites and more. Once you've finished this Nugget course, you'll be fully prepared to pass the 1Z0-051 SQL Fundamentals exam – and be ready to move on to the next in line for the Oracle DBA OCA track. More importantly, you'll gain an extremely useful and portable tool that will help you make the most of your database. [wpspoiler name="Подробное описание" ] 1. Course Introduction (00:18:23) In this nugget, we start by defining what Oracle is and how it fits into the concepts of the database, relational database, and relational database management system. Next we perform a deep-dive into the Oracle certification program, learning exactly how the current course maps to the Oracle Certified Associate (OCA) credential. We also provide tips and tricks for getting the most out of the training, and give suggestions on how to pass the 1Z0-051 exam with a minimum of muss or fuss. 2. About SQL (00:41:33) In this nugget, we set the stage for the rest of the training. Here we formally define the Structured Query Language (SQL), explaining its basic modes of operation, as well as how Oracle's implementation of SQL stacks up to the ANSI/ISO standard as well as other vendors' implementations. We complete this nugget with quick-start tutorials on how to use SQL*Plus as well as Oracle SQL Developer. 3. Retrieving Data By Using the SELECT Statement (00:38:10) The SELECT statement is the universal workhorse of SQL. In this nugget we discuss both the theory and practice of using SELECT to retrieve query results from Oracle database. 4. Restricting and Sorting Data (00:37:24) In this nugget we continue our discussion of the SQL SELECT statement, this time learning how to pare down our query results by employing the powerful WHERE clause. We also learn how to sort our query results by leveraging the ORDER BY statement, and finally begin to write more dynamic, interactive SQL by using substitution variables. 5. Using Single-Row Functions to Customize Output (00:36:51) In this nugget we introduce the concept of the function, both from a general mathematics standpoint, and then with sharper focus on Oracle Database 11g. We spend our time learning to master the basic character, number, and date functions that you'll be expected to understand on the SQL Fundamentals certification exam. 6. Reporting Aggregated Data Using the Group Functions (00:30:04) In this nugget we apply many of the function-related principles we picked up in the previous nugget. Here we learn how to aggregate data across multiple table rows by employing both grouping functions as well as the GROUP BY SQL statement. We also will understand how to filter grouped rows by using the HAVING clause. 7. PL/SQL Basics (00:36:03) In this nugget we truly round out our Oracle SQL skills by conducting a survey of PL/SQL, Oracle's procedural programming extensions to the Structured Query Language. By the end of this nugget you will not only understand the basic nomenclature and syntax of PL/SQL, but you'll also be able to write basic PL/SQL blocks, both the anonymous and named varieties. 8. Displaying Data from Multiple Tables (00:38:11) In this nugget we truly begin to see the great beauty of the relational database model. Here we learn how to query across multiple related tables by using joins. In addition to learning all about the supported join types in Oracle Database, we will also flirt around with the concept of constraints, two of which (primary key and foreign key) are crucial to our understanding of the relational model. 9. Using Subqueries (00:24:21) In this nugget we broaden and deepen our usage of the SELECT statement by learning how to embed one SELECT inside of another SELECT; this is called a subquery. As we'll learn, subqueries are useful for data load scenarios as well as when we aren't quite sure which row(s) we need to evaluate in a WHERE clause. By the end of this nugget you will not only understand how subqueries work, but you'll be able to write both single-row and multi-row subqueries in either the simple or correlated processing formats. 10. Using the Set Operators (00:23:51) SQL is a set-oriented database access language. In this nugget we learn various methods of combining multiple result sets. Here we master the use of the UNION, MINUS, and INTERSECT keywords in combining multiple queries into a single result set. 11. Using DDL Statements to Create and Manage Tables (00:46:29) In this nugget we formally treat the subject of creating, altering, and dropping database objects; this collection of SQL commands is formally called Data Definition Language, or DDL. In this nugget we start with a high-level overview of the major database objects. We then follow up with learning how to design and create tables, and then conclude with a consideration of the importance and use of integrity constraints in database tables and views. 12. Creating Other Schema Objects Part 1 (00:31:43) In this nugget we continue the discussion we opened in the previous nugget on DDL statements in Oracle Database 11g. Here we learn how to design and implement sequences and views. 13. Creating Other Schema Objects Part 2 (00:34:39) Indexes, when properly designed and used, can dramatically speed up query performance in an RDBMS. In this nugget we cover the fundamental points concerning indexes. We also learn just what synonyms are--not in the English grammar context, but instead in the Oracle database nomenclature. 14. Manipulating Data Part 1 (00:30:32) Thus far in the course we have covered the use of SELECT and the DDL command suite. Formally speaking, SELECT is actually one of the Data Manipulation Language (DML) statements in SQL. In this nugget we cover two of the major DML players, namely the INSERT and UPDATE statements. 15. Manipulating Data Part 2 (00:30:34) In this nugget we "book end" our discussion from Nugget #14, wrapping up our consideration of basic DML by investigating the finer points of the DELETE statement. We also define and discuss what database transactions are as well as how to control their operation in Oracle Database 11g. 16. Basic Oracle Database Security (00:35:14) Relational database security is a huge topic and can constitute a very lucrative career for those who are so talented and interested. In this nugget we survey some of the major principles behind user account security in Oracle Database 11g. In particular, we learn how to create and administer Oracle user accounts. We then delve into access control, learning how to leverage the GRANT and REVOKE statements. We complete this nugget with some best-practice advice on leveraging database roles to make our database security more efficient and effective. 17. Accessing the Data Dictionary (00:22:19) The data dictionary in Oracle Database 11g is a read-only collection of tables that stores metadata about the database. As such, an understanding of the data dictionary is crucial for anyone who presents himself or herself as an Oracle DBA. By the conclusion of this nugget you will not only be able to intelligently discuss the data dictionary, but you will also know how to query the data dictionary views as an ordinary schema (user) and as a DBA. 18. Referencing the Oracle Documentation (00:22:24) While Oracle's documentation library is presented to the public at no charge, Oracle keeps much of the "good stuff" behind a paywall for, well, paying Oracle Support customers. The purpose of this nugget is to deeply familiarize you with the free and excellently written/organized corpus of technical documentation in the Oracle Web site. This is a best-kept secret of Oracle, and you should make the official Oracle Documentation a daily read as you build your skill set up and out. 19. Using Oracle Flashback Query (00:24:57) In the life of the DBA, restoring data that was accidentally or intentionally dropped or deleted can be a fairly regular occurrence. Here we turn to the nifty Flashback technology in Oracle Database 11g to learn first of all how Flashback works, and then how we can leverage Flashback to recover individual rows or entire tables from the ether. We'll also spend some time with the Oracle Recycle Bin. 20. Query Optimization Basics (00:25:41) In this concluding nugget of the course we apply everything we've learned over the course of this training and pick up some practical advice on how to tune and optimize our SQL queries. To start with we will explain how Oracle parses (interprets) SQL. We will then practice using the EXPLAIN PLAN statement to view the fine details of Oracle's query execution plans. Finally, we finish up with a "laundry list" of strategies for customizing how Oracle builds its execution plans. [/wpspoiler]

[caption id="attachment_1290" align="alignright" width="300" class=" "] Microsoft Visual Studio[/caption] Автор: Производитель: Специалист Год выпуска: 2012 Продолжительность: 11:31:43 Тип материала: Видеоурок Язык: Русский Стоимость: 7999 рублей Описание: По окончании курса Вы будете уметь: Описывать исходную архитектуру и дизайн веб приложения Применять передовую практику и находить компромиссные решения на основе бизнес-требований при разработке веб-приложений Разрабатывать MVC модели Разрабатывать MVC контроллеры Разрабатывать MVC виды Оптимизировать дизайн веб-приложения для обнаружения поисковыми системами Создавать код на стороне сервера для веб-форм Оптимизировать управление данными для веб-форм Обеспечивать качество через отладку, тестирование модулей и рефакторинг Обеспечивать безопасноcть веб-приложения Использовать шаблоны и CSS для последовательного применения UI Разрабатывать клиентские сценарии и сервисы для управляемого, функционального и интерактивного интерфейса Внедренять продвинутый AJAX в веб-приложениях Развертывать веб-приложения Разрабатывать веб-приложения с использованием Silverlight Описывать базовую архитектуру ASP.NET 4.0 Выявлять новые возможности ASP.NET 4.0 Описывать компоненты MVC Framework Описывать структуру MVC приложения Описывать жизненный цикл страницы веб-форм Описывать жизненный цикл страницы MVC Описывать различия между жизненными циклами страницы веб-форм и страницы MVC [wpspoiler name="Подробное описание" ] Модуль 1. Обзор модуля Проектирование веб-приложения Обзор IIS 7.0 Обзор ASP.NET 4.0 Введение в MVC Framework Обзор жизненного цикл запроса Лабораторные работы: Изучение Adventure Works веб-сайта Упражнение 1: Исследование Adventure Works веб-сайта Exercise 1: Explore the Adventure Works Web Site Упражнение 2: Сравнение веб-форм и MVC Упражнение 3: Работа с жизненным циклом страницы веб-форм 3 Модуль 2. Разработка веб-приложения Веб-приложения: Анализ проблемы Основы разработки веб-приложений Руководство для определения области применения веб-форм и MVC Инструменты Visual Studio 2010 и технологии для проектирования веб-приложения Лабораторные работы: Переделывание Adventure Works веб-сайта Упражнение 1: Пересмотр Adventure Works веб-сайта Упражнение 2: Переделывание Adventure Works веб-сайта Упражнение 3: Добавление MVC возможностей к сайту Adventure Works 3 Модуль 3. Разработка MVC моделей Изучение путей создания модели MVC Создание хранилищ данных Лабораторные работы: Разработка модели MVC Упражнение 1: поиск путей для создания MVC Моделей Упражнение 2: Создание хранилищ данных 3 Модуль 4. Разработка MVC контроллеров Реализация MVC Контроллеров Создание методов действий Лабораторные работы: Разработка MVC Контроллеров Упражнение 1: Создание MVC контроллера Упражнение 2: Добавление кода к списку записей блога Упражнение 3: Добавление кода для создания новой записи в блоге Упражнение 4: Добавление кода для редактирования записи в блоге Упражнение 5: Добавление код для удаления записи в блоге 3 Модуль 5. Разработка MVC views Внедрение MVC views Реализация строго типизированных MVC views Реализация частичных MVC view Лабораторные работы: Разработка MVC views Упражнение 1: Разработка списка MVC View Упражнение 2: Разработка Подробная информация MVC View Упражнение 3: Разработка a Details Создать MVC View Упражнение 4: Разработка a Create MVC View Упражнение 5: Разработка редактируемого MVC View 3 Модуль 6. Обеспечение видимости Обзор SEO Создание файлов Sitemap и robots Использование ASP.NET маршрутизации Лабораторные работы: Обеспечение видимости Упражнение 1: Отображение URL-адресов веб-форм Упражнение 2: Создание файла Sitemap Упражнение 3: Создание инфраструктуры приложений 3 Модуль 7. Написание серверного кода для веб-форм Обзор структуры веб-приложений Управление ViewState Локализация веб-приложений Сохранение данных на странице веб-форм Проверка пользовательского ввода Лабораторные работы: Написание серверного кода для веб-форм Упражнение 1: Изменение страницы веб-форм для отображения локализованного контента Упражнение 2: Сохранение данных на странице веб-форм Упражнение 3: Изучение Viewstate Упражнение 4: Добавление валидации на страницы веб-форм 3 Модуль 8. Оптимизация управления данными веб-форм Управление данными с помощью объектных запросов Использование элементов управления источником данных Использование динамических данных ASP.NET Лабораторные работы: Оптимизация управления данными для веб-форм Упражнение 1: Управление данными с помощью объектных запросов Упражнение 2: Настройка GridView Упражнение 3: Использование ListView, DetailsView | Графики Упражнение 4: Управление данными с помощью динамических данных ASP.NET 3 Модуль 9. Обеспечение качества, отладка, тестирование модулей и рефакторинг Отладка и рефакторинг кода Модульное тестирование кода Обработка необработанных исключений Test Driven разработка Лабораторная работа: Отладка, модульного тестирования и рефакторинга Упражнение 1: Настройка обработки ошибок Упражнение 2: отладка кода Упражнение 3: Вход Упражнение 4: Создание модульных тестов Упражнение 5: Внедрение испытанной методологии разработки 2 Модуль 10. Обеспечение безопасности веб-приложений Настройка аутенфикации Настройка членства ASP.NET Управление авторизацией на основе ролей ASP.NET Лабораторные работы: Защита веб-приложений Упражнение 1: Настройка членства и ролей ASP.NET Упражнение 2: Аутентификация Упражнение 3: Авторизация 2 Модуль 11. Применение шаблонов и CSS Применение шаблонов Применение CSS, Скинов и тем Лабораторные работы: Применение шаблонов и CSS Упражнение 1: Изменить шаблон Упражнение 2: Создать вложенный шаблон Упражнение 3: Интегрировать шаблон Упражнение 4: Управлять Скинами Упражнение 5: Примение стилей, тем 3 Модуль 12. Разработка клиентских сценариев и сервисов Разработка клиентских сценариев Внедрение AJAX Создание служб Лабораторные работы: разработка сценариев и сервисов на стороне клиента Упражнение 1: Создание клиентских сценариев Упражнение 2: Расширенный JQuery Упражнение 3: Создание службы WCF 2 Модуль 13. Внедрение расширенной технологии AJAX в веб-приложение Внедрение Ajax в ASP.NET MVC страниц с помощью Microsoft Ajax Внедрение Ajax в ASP.NET и MVC страницы с помощью JQuery Работа с JQuery и Ajax событиями Лабораторные работы: внедрение передовых Ajax для веб-приложений AdventureWorks Упражнение 1: Использование AJAX в сценарии страницы MVC Упражнение 2: Использование JQuery в странице MVC Упражнение 3: Работа с событиями JQuery и Ajax 3 Модуль 14. Внедрение веб-приложения Обзор развертывания веб-приложения Обзор развертывания веб-сайта Развертывание AdventureWorks Лабораторные работы: Развертывание AdventureWorks Упражнение 1: Развертывание проекта веб-приложения с помощью One-Click Publish Упражнение 2: Развертывание веб-приложения с помощью пакета Web Deployment Упражнение 3: Развертывание веб-сайта с помощью инструмента Copy Web Site Упражнение 4: Развертывание веб-сайт при помощи утилиты Publish Web Site 2 Модуль 15. Разработка веб-приложений с помощью Silverlight Введение в многофункциональные интернет-приложения Обзор Silverlight Создание приложения Silverlight Лабораторные работы: разработка веб-приложений с использованием Silverlight Упражнение 1: Создание проекта Silverlight Упражнение 2: Создание службы WCF Silverlight Упражнение 3: Отображение данных с помощью элементов управления Silverlight [/wpspoiler]

[caption id="attachment_1273" align="alignright" width="300" class=" "] Microsoft System Center Configuration Manager SCCM 2012[/caption] Автор: Производитель: Специалист Год выпуска: 2011 Продолжительность: 11:31:43 Тип материала: Видеоурок Язык: Русский Стоимость: 7999 рублей Описание: Microsoft System Center Service Manager — программный комплекс, входящий в состав решения по управлению ИТ-инфраструктурой Microsoft System Center. Данный продукт позволяет организовать управленческую деятельность по организации работы ИТ-службы предприятия в соответствии с лучшими практиками ITIL и методикой MOF v. 4.0. Курс актуален для руководителей ИТ-отделов, департаментов, ИТ-специалистов, занятых в службе поддержки, руководителей и аналитиков консалтинговой практики в области ИТ-услуг. По окончании курса Вы будете уметь: Развертывать, настраивать, конфигурировать и сопровождать Microsoft System Center Service Manager в соответствии с организацией ИТ-службы на основе лучших практик ITIL и методик MOF.

[caption id="attachment_1281" align="alignright" width="300" class=" "] System Center SCOM 2007[/caption] Автор: Производитель: Специалист Год выпуска: 2011 Продолжительность: 18:22:57 Тип материала: Видеоурок Язык: Русский Стоимость: 7999 рублей Описание: На этом пятидневном курсе Вы овладеете знаниями и навыками, необходимыми для планирования, внедрения и управления Microsoft System Center Configuration Manager 2007 R3. На курсе особое внимание уделяется планированию и реализации сайтов и клиентов, конфигурации процесса развёртывания программного обеспечения и операционных систем и управлению обновлениями программного обеспечения. В ходе обучение Вы также рассмотрите средства удаленной работы и другие возможности SCCM. System Center Configuration Manager (SCCM), ранее Systems Management Server (SMS), представляет собой продукт Microsoft для управления большими группами Windows-систем. Configuration Manager обеспечивает инвентаризацию и контроль использования оборудования и программного обеспечения, управление обновлениями, распространение программного обеспечения, развертывание операционных систем, а также защиту доступа к сети. Данный курс предназначен для ИТ-специалистов с опытом работы по поддержке большого количества рабочих станций и серверов под управлением Microsoft Windows в средних и больших организациях, в которых планируется применение Configuration Manager 2007. Также этот курс будет полезен администраторам, которые конфигурируют и управляют одним или несколькими сайтами Configuration Manager 2007 и обслуживают поддерживаемые системы. По окончании курса Вы будете уметь: Планировать и развертывать сайт SCCM Планировать и развертывать клиентов Configuration Manager 2007 Проводить инвентаризацию аппаратного и программного обеспечения Следить за использованием программных продуктов Составлять запросы и готовить отчеты Управлять распространением программного обеспечения Развертывать виртуальные приложения с использованием Configuration Manager 2007 Развертывать операционные системы с помощью Configuration Manager 2007 Управлять обновлениями для программного обеспечения Конфигурировать требуемые конфигурации Использовать инструменты удаленного управления и возможности WakeOnLAN Поддерживать и устранять проблемы в Configuration Manager 2007 Планировать и конфигурировать иерархию из нескольких сайтов [wpspoiler name="Подробное описание" ] Модуль 1. Обзор Microsoft System Center Configuration Manager 2007 Обзор Configuration Manager 2007 Возможности Configuration Manager 2007 Сценарии развертывания Configuration Manager 2007 Обзор клиентов Configuration Manager 2007 3 Модуль 2. Планирование и развертывание архитектуры с одним сайтом Планирование и развертывания сайта Configuration Manager 2007 Подготовка к развертыванию сайта Configuration Manager 2007 Установка сервера сайта Configuration Manager 2007 Выполнение конфигурационных задач после установки Обнаружение ресурсов Средства мониторинга и устранения неполадок Configuration Manager 2007 Лабораторная работа: Развертывание сервера сайта Configuration Manager 2007 Управление пользователями, настройка границ сайта и определение методов обнаружения Мониторинг и устранение неполадок Configuration Manager 2007 3 Модуль 3. Планирование и выполнение развертывания клиентов Методы развертывания клиентов Развертывание клиентов Управление клиентами Configuration Manager 2007 Использование системы отчетов Configuration Manager 2007 при инсталляции клиентов Лабораторная работа: Развертывание клиентов Configuration Manager 2007 Проверка клиентов Configuration Manager 2007 3 Модуль 4. Инвентаризация, контроль использования программного обеспечения и аналитика активов Обзор инвентаризации Инвентаризация аппаратного обеспечения Инвентаризация программного обеспечения Управление инвентаризацией и устранение неполадок Аналитика активов Анализ использования программного обеспечения Лабораторная работа: Инвентаризация Использование аналитики активов Настройка контроля использования программного обеспечения 3 Модуль 5. Запросы и система отчетов Введение в запросы Управление запросами Настройка и развертывание точки формирования отчетов SQL Server Reporting Services в Configuration Manager 2007 Отчеты состояния клиента в Configuration Manager 2007 Лабораторная работа: Использование запросов и отчетов Использование SQL Server Reporting Services Установка и настройка отчетов состояния клиентов 3 Модуль 6. Развертывание программного обеспечения с использованием System Center Configuration Manager 2007 Обзор процесса развертывания программного обеспечения Подготовка к развертыванию программного обеспечения Обзор точки распространения Создание и заполнение коллекций Настройка свойств коллекции Создание и настройка пакетов и программ Развертывание пакетов Объявление программ Мониторинг и устранение неполадок развертывания программного обеспечения Лабораторная работа: Подготовка к развертыванию программного обеспечения Создание и настройка коллекций Создание пакетов и настройка программ Развертывание приложений с использованием службы развертывания программного обеспечения 3 Модуль 7. Развертывание виртуальных приложений с использованием System Center Configuration Manager 2007 Настройка инфраструктуры для поддержки системы виртуализации приложений Развертывание и управление пакетами виртуальных приложений Использование программ виртуальных приложений Лабораторная работа: Развертывание виртуальных приложений на клиентах Configuration Manager 3 Модуль 8. Развертывание системы обновлений программного обеспечения и управление ей Обзор обновлений программного обеспечения Подготовка сайта Configuration Manager 2007 для системы обновлений программного обеспечения Управление обновлением программного обеспечения Мониторинг и устранение неполадок системы обновлений программного обеспечения Лабораторная работа: Развертывание системы обновлений программного обеспечения и управление ей 2 Модуль 9. Развертывание операционных систем с использованием System Center Configuration Manager 2007 Обзор процесса развертывания операционных систем Подготовка к развертыванию операционных систем Последовательность задач и процесс развертывания операционных систем Снятие образа операционной системы Управление данными пользователей Развертывание операционных систем Лабораторная работа: Подготовка к снятию образа и развертыванию операционной системы Снятие образа эталонного компьютера Выполнение обновления операционной системы с использованием жестких ссылок 3 Модуль 10. Работа с управлением требуемыми конфигурациями Обзор управления требуемыми конфигурациями Настройка управления требуемыми конфигурациями Просмотр и устранение неполадок результатов проверки на соответствие Лабораторная работа: Настройка управления требуемыми конфигурациями 3 Модуль 11. Настройка технологии WakeOnLAN, управления питанием и удаленных средств Обзор технологии WakeOnLAN Обзор управления питанием Обзор средств удаленного управления Configuration Manager 2007 Настройка клиентского агента средств удаленного управления Лабораторная работа: Настройка и использование средств удаленного управления 3 Модуль 12. Планирование и настройка иерархии с несколькими сайтами Обзор иерархий сайтов Configuration Manager 2007 Настройка взаимодействия сайтов Configuration Manager 2007 Установка сервера для дополнительного сайта Роуминг в иерархии с несколькими сайтами Вывод из эксплуатации сайтов и иерархий Лабораторная работа: Планирование иерархий Configuration Manager 2007 и установка основного дочернего сайта Установка вторичного сайта и прокси-точки управления Роуминг между сайтами Configuration Manager 2007 3 Модуль 13. Сопровождение и мониторинг System Center Configuration Manager 2007 Задачи управления Configuration Manager 2007 Резервное копирование и восстановление Configuration Manager 2007 Использование монитора производительности Windows для мониторинга Configuration Manager 2007 Лабораторная работа: Резервное копирование и восстановление системы основного сайта 3 Модуль 14. Основной режим Microsoft System Center Configuration Manager 2007 и управление Интернет-клиентами Введение в основной режим Configuration Manager 2007 Требования инфраструктуры открытого ключа для основного режима Настройка сайтов для основного режима Управление Интернет-клиентами Лабораторная работа: Настройка основного режима Настройка сайта для управления Интернет-клиентами [/wpspoiler]

[caption id="attachment_1281" align="alignright" width="300" class=" "] System Center SCOM 2007[/caption] Автор: Производитель: CBT Nuggets Год выпуска: 2010 Продолжительность: 08:44:27 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: This video training course with Greg Shields covers the 2007 version of Microsoft Systems Center Configuration Manager, such as deploying SCCM clients, managing software usage, and more. Recommended skills: A year of experience using Systems Management Server (SMS) or Configuration Manager 2007 Experience using Active Directory and the Windows server Recommended equipment: Microsoft System Center Configuration Manager 2007 Related certifications: Microsoft Certified Technology Specialist (MCTS): System Center Configuration Manager 2007, Configuration Microsoft Certified Systems Administrator (MCSA) on Windows Server 2003 Microsoft Certified Systems Engineer (MCSE) on Windows Server 2003 Related job functions: IT professionals Wouldn't it be great to configure an entire system-wide OS deployment from your workstation? Microsoft Systems Center Configuration Manager (SCCM) gives you that power. Instructor Greg Shields is a systems pro. He understands SMS and SCCM, and his unique experience with the production elements of both is evident in this course. Greg's training brings you up-to-speed fast and shows you how SCCM 2007 can make your working life so much easier. Become your organization's OS configuration expert, as you prepare to pass Microsoft MCTS certification exam 70-401. All trademarks and copyrights are the property of their respective holders. [wpspoiler name="Подробное описание" ] 1. Introduction to System Center, SCCM, and our Learning Style (00:17:40) This video introduces the course, System Center and SCCM themselves, and how the course will discuss both the exam components and useful best practices that are based on Greg’s experience. 2. SCCM Components (00:23:01) We first talk about the various components that come together to make an SCCM infrastructure. This video explains and introduces those components and how they interrelate. 3. Installing SCCM & Upgrading from SMS 2003 (00:42:02) Once we understand the individual components, we then need to get them installed. This video discusses the SCCM installation process as well as how to upgrade an existing SMS 2003 environment to SCCM 2007. 4. Discovering Resources (00:24:34) After installation, the next step is to configure SCCM to discover the resources on the network. Using multiple discovery mechanisms, we’ll understand how resources are discovered and how their information gets into the SCCM database for later client installation. 5. Deploying SCCM Clients (00:38:25) Discovering resources is only the first step. Client software must be installed if we’re to get inventory information and truly interact with discovered machines. Here, we’ll discuss the client deployment process and best practices for getting client software onto candidate machines. 6. Inventory & Basic Collections (00:26:59) Client software installed to candidate machines is the first step in pulling down rich inventory information to populate our SCCM database. This nugget explains the inventory process, what can be inventoried, and some of the very basic processes used to create collections of computers. 7. Queries & Query-based Collections (00:28:16) The static collections created in the last nugget are just that…static. In order for your collections to truly represent your environment, you need to base them on characteristics of computers rather than actual computer names. In this nugget we follow on with the collection-creation process by showing how to use inventory information and queries to create collections. 8. Reports & Dashboards (00:25:51) Inventory information isn’t used just for creating collections. It’s also useful for understanding what kinds of software and hardware are in the environment. SCCM has a rich web-based reporting engine for showing the contents of the SCCM database. This nugget will talk about creating reports and dashboards of reports for viewing a heads-up display of that information. 9. Software Distribution Part 1: The Art (00:16:39) Once we’ve got our hands around the data portion of SCCM, we then move on to the idea of updating computers with software. Part 1 of software distribution talks about the art of software packaging, and best practices for getting software to install "silently", which is a major requirement of successful software distribution. 10. Software Distribution Part 2: The Science (00:39:42) After this software is packaged, we then need to get it deployed - the "science" of the process. Getting those software packages uploaded into the SCCM infrastructure and ultimately pushed out to clients is the subject of this nugget. 11. Deploying Operating Systems (00:43:22) But software packages only update individual pieces of systems. What if we want to deploy an entire system? This nugget talks about the very cool and exciting tools and techniques native to SCCM that enable the deployment of operating systems to clients. 12. Deploying Software Updates (00:31:10) Also a newly native tool with SCCM 2007 with much improved functionality is the update deployment process. Pushing patches with SMS 2003 was hard, a process that gets much easier in SCCM 2007 with its new integration with WSUS. We’ll talk about that integration and how to successfully keep your machines patched. 13. Metering Software Usage (00:09:17) A short but powerful nugget, metering software usage will help you understand exactly how often your users actually use the software you deploy to them. With this knowledge, you can determine if they actually need the software they say they do. We’ll talk about how to set up metering and how to see reports of actual minute-by-minute software usage. 14. Desired Configuration Management (00:24:00) Sometimes you don’t want to manage a software package as a full package, but only a few settings within that package - maybe for security or compliance reasons. DCM is a native SCCM tool that allows you to create reports on computers that haven’t met a desired configuration you’ve enabled. 15. Remote Tools & Wake On LAN Features (00:15:50) The troubleshooting and update process requires you to sometimes look over the shoulder of your users. Doing that with SCCM is easy with the built-in remote tools interface. This nugget talks about how to set up and use remote tools. It also finishes with a look at the Walk On LAN features that allow you to bring computers out of various sleep states before you attempt to update or patch them. 16. Network Access Protection (00:28:35) SCCM integrates with NAP, and makes its enforcement of updates much easier. You’ve got to have a NAP infrastructure in place to use the integration, but once it’s in place, SCCM is a great add-on. This nugget talks about that integration and what you can expect when using SCCM as another database for NAP enforcement. 17. Mobile Devices (00:25:25) Mobile devices are computers too! So, understanding their inventory, managing their configuration, and ensuring they’ve got the right software and patches are all parts of your job as systems administrator. SCCM has some great mobile device management capabilities built in. We’ll talk about those abilities, how to get clients onto mobile devices, and how to manage their configuration once you do. 18. Backups and Troubleshooting (00:29:03) Managing your SCCM infrastructure means ensuring that it’s continuously available. Backups, logs, and security rights are all necessary security and protection components of your daily administrator "care and feeding" of your servers. This nugget will discuss all of the components you need to understand to keep your infrastructure happy. 19. Planning an SCCM Hierarchy (00:21:44) Not all environments are made up of a single site. Most have multiple sites in multiple locations with all kinds of different network connectivity. Depending on the presence or absence of remote site IT, the network speed between sites, and the desire to keep servers in those remote locations, you have options with SCCM on how to manage them. This nugget will discuss those options and what and how you should deploy SCCM to best suit those needs. 20. Mixed Mode vs. Native Mode & Internet-based Clients (00:12:52) Lastly, SCCM also has a more-powerful security mode called "native mode" that ensures encryption of virtually all traffic and enables internet-based clients to talk with your SCCM infrastructure. This final nugget will discuss the move to native mode, the need for certificates, and what benefits you can plan to get out of Internet-based client management. [/wpspoiler]

[caption id="attachment_1281" align="alignright" width="300" class=" "] System Center SCOM 2007[/caption] Автор: Производитель: CBT Nuggets Год выпуска: 2010 Продолжительность: 07:17:14 Тип материала: Видеоурок Язык: Английский Стоимость: 1999 рублей Описание: Exam 70-400 was retired July 31, 2013. However, this course retains value as a training resource. This video training course with Greg Shields covers Microsoft System Center from installation to customizing tasks to collective and business critical client monitoring. Recommended skills: A year of experience using Microsoft Operations Manager (MOM) 2005 or System Center Operations Manager 2007 for medium-sized to large organizations Experience with Active Directory Experience configuring and deploying management packs Recommended equipment: Microsoft System Center Operations Manager 2007 Related certifications: Microsoft Certified Systems Administrator (MCSA) on Windows Server 2003 Microsoft Certified Systems Engineer (MCSE) on Windows Server 2003 Related job functions: IT professionals Take the frustration out of your day-to-day, problem-solving efforts by using the powerful monitoring tools in Microsoft System Center Operations Manager (SCOM). Trainer Greg Shields leaves no loose ends as he shows you SCOM's full monitoring power. After watching this video course you'll become the proactive problem solver your system needs. The training is mapped to the Microsoft MCTS certification exam 70-400 -- a test that Greg describes as "down and dirty," because all the questions relate directly to skills you need to configure, deploy and maintain your system. All trademarks and copyrights are the property of their respective holders. [wpspoiler name="Подробное описание" ] 1. Introduction to SCOM & the 70-400 Exam (00:17:49) The introduction to this course talks about our learning style, the development of the network we will use for demonstrations throughout this course, and introduces the learning objectives for the MCTS certification exam; 70-400. 2. Operations Management & SCOM Components (00:20:15) Before we can begin our discussion on SCOM, we must first understand how it relates to the overarching topics of operations management in general. Here, we talk about operations management and the need for proactive monitoring, achieved in SCOM through state-based monitors and roll-up health status. Also in this training we go over the components that make up a SCOM infrastructure. 3. Installing SCOM (00:26:51) MCTS certification training content covered in this training Nugget will go through what you need to know on install SCOM. 4. Configuring Management Group Settings (00:24:41) Once installed, the next step is to configure the organization-level settings required by SCOM. This nugget goes over those settings with an eye towards their proper setting based on the size and needs of your infrastructure. 5. Discovering Resources & Installing Agents (00:24:31) Resources are discovered and agents are typically installed by SCOM through its wizard-based interface. But there are some "gotchas" associated with managing assets in your organization. We’ll discuss each of these topics in this nugget. 6. Understanding, Finding, & Importing Management Packs (00:21:26) Management Packs are the life blood of any SCOM infrastructure. Once assets have been discovered and are ready to ingest data into SCOM’s database, Management Packs provide the logic that assists administrators with knowing what events are useful and need to be featured. Management Packs also provide the knowledge that helps administrators understand what to troubleshoot when a server is no longer healthy. 7. Configuring Alerting & Notifications (00:20:02) Management Packs can provide the logic for alerting administrators, but SCOM itself has a rich capability for limiting how notifications and alerts actually make their way to pagers. In fact, setting up notifications correctly so that there aren’t too many nor too few can be one of the biggest success factors in any SCOM implementation. Learn the best practices here. 8. Day-to-Day SCOM Operations (00:28:20) Now that we’ve got our basic configuration down, this nugget will talk about the daily operations of a SCOM infrastructure in production. Here you’ll learn about resolving alerts and tuning resolution states, you’ll understand how and why you should put servers in maintenance mode when working with them, and understand the views you’ll see, and later create, that display the right data for the right administrator. 9. Customizing Monitors & Rules (00:35:16) Management Packs downloaded from the Microsoft catalog or third parties are all sealed, which means their configuration cannot be changed. But sometimes the settings that dictate what behaviors are good and which are bad aren’t properly tuned for your particular IT environment. This nugget will discuss at length the sometimes complex process of tuning monitors and rules in your Management Packs to ensure they make sense for your needs. 10. Customizing Attributes, Groups, & Views (00:27:51) Following on from the previous nugget, we then look into the monitoring of individual attributes on a system as well as how to create groups of computers and customized views of data for the other administrators in your environment. It is here that you’ll learn how to best gather together the right amount of data for consumption by the various groups in your IT infrastructure. 11. Customizing Tasks (00:17:23) Tasks are yet another hot topic with SCOM, providing a way for you to automatically run a process or script right from within the SCOM console. This nugget will show you how to create a task as well as make it available for use by other administrators through their console views. 12. Understanding & Creating Synthetic Transactions (00:13:28) True operations management requires a look at IT services not only from the server’s view but also from the perspective of the client. One way in which clients can verify that their needed services remain up and running is by sending synthetic transactions to the servers they work with. This nugget will explain the ideas behind synthetic transactions as well as how to set them up. 13. Understanding & Creating Distributed Applications (00:21:43) With the client perspective fully in-hand, we can now begin the creation of fullly distributed applications, which are the creation of comprehensive monitoring solutions across every element that makes up an IT service. These are custom creations, as they work across the servers and applications in your infrastructure. In this nugget you’ll learn how to use SCOM’s designer to create your own distributed applications with the goal of creating a health roll-up across multiple elements at once. 14. Coverting Legacy Management Packs (00:14:33) One element that’s critical for the exam but also critical if you want to use older Management Packs in your SCOM 2007 environment is the converting of legacy MPs. This nugget will discuss the process as well as explain some of the gotchas associated with their use. 15. Installing, Using, & Creating Reports (00:28:16) SCOM leverages SQL Reporting Services for the generation of its reports. Yet the process to install it and ingest its needed models for the creation of good reports can be a complex undertaking. This nugget will explain everything you need to know to set up reporting and begin creating your own custom reports for management updates, historical tracking, and even planning. 16. Managing Users & User Roles (00:11:35) SCOM has the ability to present views, tasks, and reports to users based on who they are. It also has the ability to aggregate users by role, making user administration much easier. This nugget will explain the process of user management in SCOM as well as the creation of user roles. 17. Configuring Audit Collection Services (00:24:14) SCOM, by default, collects system and application data from the Windows event log. But if you want to get security data, you’ll need to install its add-on ACS component. ACS is no picnic to install and use, lacking even the most basic of GUI controls. In this nugget we’ll discuss its installation and use and talk about how you might leverage ACS as a separate-but-controlled mechanism for storing audit data. 18. Configuring Agentless Exception Monitoring (00:20:02) Dr. Watson gets a bad rap and so does Microsoft’s Customer Experience Improvement Program for sending data to Microsoft. You can control that flow of data and even store it locally for the generation of global reports on system errors and behaviors with Agentless Exception Monitoring. You’ll find that adding SCOM to Microsoft’s Corporate Error Reporting service makes the gathering of this bug check data much more valuable to you and your organization. 19. Collective & Business Critical Client Monitoring (00:19:49) SCOM isn’t just for servers. Its also a great tool for monitoring the clients on your network. But you probably don’t want to monitor all your clients, just the ones that are critical to the daily flow of your business. This nugget explains the need for client monitoring as well as how to set it up. You’ll also learn more about how monitored clients can become the basis for the very client perspectives that we discussed earlier in creating distributed applications. 20. SCOM Backup & Restore (00:19:09) Every IT service has the need for some level of backup and restore. SCOM is no different. Yet SCOM’s mechanisms for backing itself up are complex at best. This nugget will help you identify exactly what you need to back up and the order of restoration in case of a failure. [/wpspoiler]