Training

Opensoft Inc. offers instructor-led remote training on Unix Admin SQL Server DBA and Developer courses. An impeccable training course that is exclusively designed with Basics through Advanced concepts. The course is designed as per Microsoft Official Curriculum (MOC) addressing all features of SQL Database Administration including Data Collection and Clustering. Study Material, Practice Material and Certification Guidance are included in the training program.

Unix Admin 2013 Training Highlights:

UNIX system administration issues and goals

UNIX origins and vendors

Working as root

System administration shells

On-line help and resources

OS Installation and Software Management

Preparing for installation

Installation methods and sources

Identify software release

Manipulating software packages

Applying software patches

UNIX Devices

The /dev directory; logical and physical device names

Major and minor device numbers and device naming conventions

Block and character devices

Removable media

Disk slicing information

Exploring and configuring hardware

Files and Directories

Directory structure: file system concepts, inodes and links

Permission bits and access control, including SUID, SGID and sticky bit

Configuring 'shared group' directory attributes

Introduction to ACL (Access Control List)

Processes

Processes & daemons

Processes interrogation tools (e.g. ps, top)

Communicating with processes: signals and traps

Postponing tasks with at and batch

Long term scheduling with crontab

Monitoring and Logging

What to monitor & why

Monitoring with sar

Auditing and logging

Basic UNIX log files

Simple touch, tail, tail -f, grep for working with logs

Syslog daemon; rotating logs

Generic Startup and Shutdown

Bootstrap procedure

Single and multi-user run levels

System startup files (rc files)

The init process and the /etc/inittab file

Clean shutdown procedure

Bootstrapping in specific versions

File systems

Disk terminology

File system overview: structure and types

Making filesystem with mkfs command

Mounting disks with mount

Maintaining and troubleshooting filesystems

Filesystem utilities; fsck, sync, df, du, quotas

Storage Management

Overview of disk partitioning

Using fdisk to create physical partitions

LVM structure

Creating, formatting and mounting logical volumes

RAID 0, 1, 3 and 5

Managing user accounts

Requirements for a user account

Main configuration files: /etc/passwd, /etc/group, /etc/shadow

Adding, modifying and deleting users with useradd, usermod and userdel

Managing passwords with passwd

Secure User Considerations

User types and their accounts

The sudo utility

SQL SERVER 2013 DBA Training Highlights :

SQL Server 2012 production cluster/standalone setup

Point in time recovery procedures

Disaster recovery setup

SQL Server 2012 mirroring

SQL Server 2012 log shipping

Replication technologies

Real time production performance and tuning issues

Rebuild master and recover production databases

SQL server 2012 encryption, compression and auditing

SQL Server 2012 Policy Based Management/ Resource Governor

SQL SERVER 2013 R2 BI DEVELOPER (TSQL/SSIS/SSRS/SSAS) TRAINING Highlights :

SSIS Architecture and components

SQL Server 2012 Policy Based Management/ Resource Governor

Installing and Configuring SSIS components

Complex Data Transformations

SSIS Auditing and logging

SSIS performance and tuning

Deployment and Scheduling SSIS Packages

SSRS Architecture and components

Installation and Setup

BIDS environment and the Report Designer IDE

Report Development Lifecycle

Reporting Services Report Designer

Designing and Developing Reports with Reporting Services

Report Deployment

Report Builder

Grouping and Sorting

Parameters

Expressions, Functions, and Custom Code

Report Management

Adhoc Reporting

Report security and Scheduling

SSAS Cubes / MDX / DW

For more details contact us info@opensoftinc.net