[LinuxCBT] LinuxCBT DBMS Edition feat. PostgreSQL [2011, ENG]

Обучающие материалы по линукс, юникс
Торрент Сидеров Личеров Размер
18 5 1.27 ГБ
Аватара пользователя
Сообщения: 9024
Зарегистрирован: 17 янв 2012, 23:53

[LinuxCBT] LinuxCBT DBMS Edition feat. PostgreSQL [2011, ENG]

Сообщение Tutorial » 08 май 2012, 12:10

LinuxCBT DBMS Edition feat. PostgreSQL
Год выпуска: 2011
Производитель: LinuxCBT
Сайт производителя: http://www.linuxcbt.com
Продолжительность: 17 часов
Тип раздаваемого материала: Видеоурок
Язык: Английский
LinuxCBT DBMS Edition feat. PostgreSQL focuses on the implementation of PostgreSQL DBMS.
PostgreSQL is a widely used open source ORDBMS engine due to its: non-commercial implications, flexible license, long academic development history @ UC Berkeley, object-oriented and relational nature, cross-platform prowess and considerable scaleability.
If you are/will be responsible for PostgreSQL and/or an environment of SQL flavors (MS SQL, Oracle, MySQL, etc.), broaden your knowledge of SQL implementations by exploring PostgreSQL. The benefits will be realized in any SQL arena.
Let LinuxCBT DBMS Edition feat. PostgreSQL cost-effectively strengthen your SQL skills.
Recommended Prerequisites for LinuxCBT DBMS Edition feat. PostgreSQL:
Basic Experience with Linux | Unix or any LinuxCBT OS Course /EL|SLES|Deb/)
Open mind & determination to master Linux and related open-source applications
Basic understanding of networking concepts
Access to a PC to follow the exercises

Код: Выделить всё

PostgreSQL - DBMS
Introduction - Topology - Features
Identify key systems to be used
Discuss key PostgreSQL features
Identify sources
Download & Install
Explore post-installation environment
'psql' - Terminal Monitor Usage
Discuss features and benefits
Connect to PostgreSQL instance
Explore usage
Access Control
Identify configuration
Explore default environment
Enable subnet access
Evaluate results
Log Configuration
Discuss features and benefits
Peruse default setup
Alter configuration to log simultaneously to multiple destinations
Generate log data
Evaluate results
Data Types
Enumerate supported data types
Discuss pros and cons of various types
Identify types in default configuration
Compare and contrast intra-category types
SQL - Data Definition Language (DDL) - Constraints
Use CREATE to generate objects
Use DROP to remove objects
Use ALTER to change structural definitions of ojbects
Define constraints on DB objects to suit storage requirements
Evaluate results
SQL - Data Manipulation Language (DML)
Populate tables with INSERT
Bulk-copy items to tables with COPY
Query tables using SELECT
Combine tables with JOINs
Define VIEWs on queries of interest
Quantify table data with Aggregate Functions
Modify table data using UPDATE
Remove table data using DELETE
Discuss features and benefits
Explore defaults
Generate queries that hit and miss indices
Create table indices
Evaluate results
PostgreSQL - Functions
Discuss features and benefits
Explore built-in functions
Apply functions to data sets
Nest functions
Evaluate results
Model: /var/log/messages
Create data model
Generate SQL schema
Transform & Import data
Perform queries
Write Perl script to parse & transform: /var/log/messages for importation
Install 'libpg' & Update Perl script to connect to PostgreSQL
Evaluate results
SQL Object Permissions
Extend access control discussions
Explore default permissions
Discuss PostgreSQL permissions-set
Use GRANT to assign & test various privileges
Use Revoke to unassign & test various privileges
Create test users and apply various permissions
Evaluate results
DBMS Archival & Restoration
Explore available tools & methods
Archive: DBs & Tables
Test restorations
Restore cross-platform to Windows
Restore cross-system to disparate distribution
Evaluate results
Peruse default clear-text environment with: TCPDump
Construct SSH tunnels to secure transport layer
Initiate 'psql' sessions across SSH tunnels
Bolster security with SSL
Generate usage keys & update PostgreSQL configuration appropo
Test SSL communications
Intercept SSL traffic with: TCPDump for analysis
Evaluate results
Файлы примеров: не предусмотрены
Формат видео: QuickTime (.mov)
Видео: AVC, 800x600, 5.00fps ~100kbps
Аудио: AAC, 44100Hz, mono, 64kbps
Доп. информация: Demo

У вас нет необходимых прав для просмотра вложений в этом сообщении.