UrbanPro
true
Sushil Sheth MongoDB trainer in Pune

Sushil Sheth

Software Programmer

Viman Nagar, Pune, India - 411014.

13 Students

Referral Discount: Get ₹ 500 off when you make a payment to start classes. Get started by Booking a Demo.

Details verified of Sushil Sheth

Identity

Education

Know how UrbanPro verifies Tutor details

Identity is verified based on matching the details uploaded by the Tutor with government databases.

Overview

I have 9+ years of IT experience. Have worked for many project on security, automation reporting and network management as Lead programmer.
- I have development experience on PERL, PYTHON, POWER SHELL, SHELL scripting.
- Worked as DEVOPS Program manager, manage a team of 8 people
- Deliver training on skills like Devops, Data science, perl, python, powershell, shell scripting, Unix/Linux, Database(Mysql, Oracle, Netezza, Sandra, MongoDB, PostgreSql etc), Java.
- Oracle certified
- Experience in corporate, Individual training. I have being part of many technical seminar as presenter.

Languages Spoken

English

Education

Mumbai 2009

Bachelor of Engineering (B.E.)

Address

Viman Nagar, Pune, India - 411014

Verified Info

Phone Verified

Email Verified

Report this Profile

Is this listing inaccurate or duplicate? Any other problem?

Please tell us about the problem and we will fix it.

Please describe the problem that you see in this page.

Type the letters as shown below *

Please enter the letters as show below

Teaches

MongoDB Training
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MongoDB Training

3

Teaching Experience in detail in MongoDB Training

MongoDB course content • Chapter 1: Introduction to MongoDB - History - Why mongoDB - Dependencies - Pros and cons - challenges - basic skill set • Chapter 2: Installation - Installation - software dependencies - Basic requirement - platform dependencies - Installation on open source - practice • Chapter 3: Data modeling - Basic knowledge on database - what is NOSQL DB - CAP rule - ACID property - Logic to design database - Tips on data analyst • Chapter 4: Working with Database - create database - Drop Database - explore database - admin responsibility - Data modification • Chapter 5: Working with Database - Create database - Drop Database - Explore options in database • Chapter 6: Collection in mogoDB - working with collection - Object for collection - limitation for collection • Chapter 7: Data type and example for same - Data type in mongoDB - playing with variables - example • Chapter 8: Manage document and manipulate - CAP implementation - insert, update, delete operation on document - manipulate document • Chapter 9: Projection operation - projecting data - modify the data with the help of project - control on data view - examples on projection • Chapter 10: Sorting and controlling output - control on data and datatype - Sort operation - control record output • Chapter 11: Index operation - create index - delete and manipulate index - complex index - drawback of index on document - best practice of index - working with object and index - query optimization • Chapter 12: Aggregation and replication - Data aggregation - Different function for aggregation - replace data - conditional based function • Chapter 13: Manage backup - Backup database - restore implemented database - modify database • Chapter 14: Referencing - working with data referencing - advance database modification - working with multiple databases • Chapter 15: Analytical operation - complex query - analytical results - embedded documents • Chapter 16(a): Regex - implement regular expression - object in regex - optimization - improve search operation - text search optimization • Chapter 16(b): Auto-Increment - implement auto increment - improve sequencing - imprve sequence with object ID

Python Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Python Training classes

8

Course Duration provided

1-3 months

Seeker background catered to

Educational Institution, Individual, Corporate company

Certification provided

Yes

Python applications taught

Web Development with Python , Automation with Python , GUI (Graphical User Interfaces) with Python , Networking with Python , Data Science with Python, Testing with Python, Text Processing with Python, Game Development with Python, Data Visualization with Python, Scipy Stack with Python , Data Extraction with Python , Data Analysis with Python , Machine Learning with Python, Regular Expressions with Python , Web Scraping with Python

Teaching Experience in detail in Python Training classes

I deliver training on python for banking security and network automation. I conduct online classes with flexible timing. My training will include assignment and live practice. I cover automation, database/network topics with python, unix scripting examples too. I have experience of personal as well as corporate training. 5+ years of experience in corporate training for python. (client wipro, Tcs, cognizant etc)

Perl Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Perl Training classes

7

Teaching Experience in detail in Perl Training classes

I have 7 years of experience as programmer. Work on project for banking security and network automation. We conduct online classes with flexible timing. My training includes assignment and live examples. I cover automation program, database/network topics, unix scripting examples etc. I have experience of personal as well as corporate training. 5+ years of experience in corporate training for python. (client wipro, Tcs, cognizant, IBM etc) Course content : Course Duration : (22 to 26) hrs Course Content Introduction ? History of evolution ? Why Perl ? Uses of Perl ? Perl on Linux, windows ? Real life examples ? Books on perl Perl Fundamentals ? First program with minimal explanation ? Variables : scalar, array, hash ? Operators ? Print statements ? Comments ? Executing the program ? Use of use strict and use warnings pragma ? Subroutines Control structure and loops ? if, if else, if elsif else, nested if else ? for, foreach, while, do while ? next, unless, return, exit, last, until, redo ? Ternary operators, goto label, ? Given and when similar to switch and case Useful/necessary functions to memorize ? chop and chomp ? sort and reverse ? caller, wantarray ? exec, system and eval ? uc, ucfirst, lc lcfirst ? grep and map ? length ? undef ? qw, qq,q, qx, qr ? warn, die Array Functions ? push and pop ? join and split ? slice and splice ? shift and unshift Hash Functions ? keys ? values ? exists ? defined ? delete ? each Array and hash manipulation ? Array and hash reference ? Anonymous reference ? Sorting array and hash elements Inbuilt special variables Regular Expressions basics ? Regexp basics ? Modifiers, quantifier, metacharacters ? Pattern matching, search and replace, transliteration File Handling ? Read, write, append, open , close files ? Binary file manipulation using binmode ? File testing ? Open directory, read files into it etc Introduction to Modules and Packages ? CPAN modules ? How to work with CPAN modules ? use, require, do ? Object Oriented Perl basics Database Connectivity ? Connection to the database ? Manipulating the fetched values from databases ? Inserting/updating database Program on Network and security ? Connection to the network devices ? Fragmenting multiple data from various component ? Monitoring network bandwith ? Control network device

Windows Powershell
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Willing to travel

Tutor's Home

Years of Experience in Windows Powershell

8

Teaching Experience in detail in Windows Powershell

Hello, I have 9+ years of experience in IT industries. Work on window powershell for projects on banking security and network optimization. I conduct online classes for data science. Class include multiple examples with case study on various algorithms. Algorithm are most important topic in data science, algorithm help to increase data security in optimize way. I conduct corporate training for various companies like Wipro, TCS etc Regards, Sushil SHETH 7045037679 (whatsup)9004336423 Course content : Course Duration : (16 to 19) hrs Module 1: Getting Started with Windows Power Shell Lesson 1: Overview and Background Lab A: Configuring Windows PowerShell Lesson 2: Finding and Learning Commands Lesson 3: Running Commands Lab B: Finding and Running Basic Commands Module 2: Working with the Pipeline Lesson 1: Understanding the Pipeline Lesson 2: Selecting, Sorting, and Measuring Objects Lab A: Using the Pipeline Lesson 3: Converting, Exporting, and Importing Objects Lab B: Converting, Exporting, and Importing Objects Lesson 4: Filtering Objects Out of the Pipeline Lab C: Filtering Objects Lesson 5: Enumerating Objects in the Pipeline Lab D: Enumerating Objects Module 3: Understanding How the Pipeline Works Lesson 1: Passing Data in the Pipeline By Value Lesson 2: Passing Data in the Pipeline By Property Name Lab: Working with Pipeline Parameter Binding Module 4: Using PS Providers and PS Drives Lesson 1: Using PS Providers Lesson 2: Using PS Drives Lab: Using PS Providers and PS Drives Module 5: Formatting Output Lesson 1: Using Basic Formatting Lesson 2: Using Advanced Formatting Lesson 3: Redirecting Formatted Output Lab: Formatting Output Module 6: Querying Management Information by Using WMI and CIM Lesson 1: Understanding WMI and CIM Lesson 2: Querying Data by Using WMI and CIM Lesson 3: Making Changes by Using WMI and CIM xvi 10961A: Automating Administration with Windows PowerShell® Lab: Working with WMI and CIM Module 7: Preparing for Scripting Lesson 1: Using Variables Lesson 2: Scripting Security Lab: Working with Security in Windows Power Shell Module 8: Moving from Command to Script to Module Lesson 1: Moving from Command to Script Lab A: Moving from Command to Script Lesson 2: Moving from Script to Function to Module Lab B: Moving from Script to Function to Module Lesson 3: Implementing Basic Error Handling Lab C: Implementing Basic Error Handling Lesson 4: Using Basic Scripting Constructs Lab D: Creating an Advanced Function Lesson 5: Exploring Other Scripting Features Module 9: Administering Remote Computers Lesson 1: Using Basic Remoting Lesson 2: Using Advanced Remoting Techniques Lab A: Using Basic Remoting Lesson 3: Using Remoting Sessions Lab B: Using Remoting Sessions Lesson 4: Using Remoting for Delegated Administration Lab C: Using Remoting for Delegated Administration Module 10: Putting it All Together Lesson 1: Provisioning a New Server Core Instance 1 Lab: Provisioning a New Server Core Instance Module 11: Using Background Jobs and Scheduled Jobs Lesson 1: Using Background Jobs Lab A: Using Background Jobs Lesson 2: Using Scheduled Jobs Lab B: Using Scheduled Jobs Module 12: Using Profiles and Advanced Windows Power Shell Techniques Lesson 1: Using Advanced Windows Power Shell Techniques Lesson 2: Creating Profile Scripts Lesson 3: Working with Alternative Credentials

Database Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Database Training classes

7

Teaching Experience in detail in Database Training classes

Hello, I have 9 years of experience in Database management. I work for multiple live project for bank security, MIS reporting and network optimization. We conduct online classes with flexible timing. My training will include assignment and live practice. I have experience of personal as well as corporate training. 7+ years of experience in corporate training (client wipro, Tcs, cognizant etc) Regards, Sushil SHETH 7045037679 (whatsup)9004336423 Course content : Course Duration : (14 to 18) hrs Theory, Terminology and Concepts • Client/Server Concepts • Database and Database Objects Mysql Architect • Structure of mysql DB • System object to improve performance of mysql • Security in mysql • Optimization of mysql Oracle DB • Inbuilt function • Complex query using oracle function • Architect • Optimization Data Definition using SQL • Databases • Data Types • DDL, DML and DCL • Tables • Constraints and Indexes • Views Basic Data Manipulation using SQL • Recurring SQL Constructs • Adding data • Modifying data • Removing data • Searching data Advanced Data Manipulation using SQL • Expressions • Grouping and Aggregate Functions • Joining Tables • Complex join • Sub query • Inbuilt functions Transactions • Transaction Concepts • SQL for working with Transaction Import/Export • Tools for Import/Export • SQL for Import/Export

Unix Shell Scripting Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Unix Shell Scripting Training classes

5

Teaching Experience in detail in Unix Shell Scripting Training classes

Hello, I have 7 years of experience as programmer. Work for Shell scripting project. I work for multiple project for bank security, MIS reporting and network optimization. We conduct online classes with flexible timing. My training will include assignment and live practice. I have experience of personal as well as corporate training. 7+ years of experience in corporate training (client wipro, Tcs, cognizant etc) Regards, Sushil SHETH Shell Scripting - Shell Basics 1. Types of shells 2. Shell functionality 3. Environment - Writing first script 1. Writing script & executing basic script 2. Debugging script 3. Making interactive scripts 4. Variables (default variables) 5. Mathematical expressions - Conditional statements 1. If-else-elif 2. Test command 3. Logical operators-AND,OR,NOT 4. ase –esac - Loops 1. While 2. For 3. Until 4. Break & continue - Command line arguments 1. Positional parameters 2. Set & shift 3. IFS 4. Break & continue - Functions & file manipulations 1. Processing file line by line 2. Functions - Regular Expression & Filters 1. What is regular expression 2. Grep,cut ,sort commands 3. Grep patterns - SED & AWK - Processes 1. Concept of process in Unix 2. Background processes 3. Scheduling processes -At, batch & Cron - Misc 1. Trapping signals 2. String substitutions / manipulations Advanced Shell Scripting - Advanced Scripting Techniques 1. Providing command line options to scripts 2. Shell & subshells 3. Exporting variables 4. Arrays 5. Remote shell execution 6. Dialog boxes - SQL with Shell 1. Connecting to MySQL using shell 2. Running SQL queries from a shell script - Essential System Administration jobs 1. Managing disk space/file system 2. Startup-Shutdown scripts 3. Backup-cpio-tar 4. Monitoring , health check

Data Science Classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Data Science Classes

7

Data science techniques

Machine learning

Teaching Experience in detail in Data Science Classes

I have 9+ years of experience in IT industries. Work on project for banking security and network optimization. I conduct online classes for data science. Class include multiple examples with case study on various algorithms. Algorithm are most important topic in data science, algorithm help to increase data security in optimize way. I conduct corporate training for various companies like Wipro, TCS, IBM etc Regards, Sushil SHETH 7045037679 (whatsup)9004336423 Topics: Duration : 45 days Introduction Brief history Concept and scope Enabling technology Data mining prerequisite Algorithm prerequisite Software prerequisite Algorithm Data mining goal Data mining algorithm Data mining using R, python Sequence mining using BigML : sequene 1 Sequence mining using BigML : sequene 2 Algorithm 2 Fraud detection Disease control Simulation Network security Statistic visualization BI architect (Business intelligence) RDBM and ORM Syntax of RDBMS Inbuilt function Limitation Overview of different database RDBM and ORM: 2 Complex query Multi join Sub query and limitation of same Data reduction Data reduction and its goal Data reduction in R Data reduction in python Data reduction in Orange Data reduction using rapid miner Data mining in Clustering Clustering data Clustering in R Clustering in python Clustering in BigML Clustering in orange Data Classification Classification of Data in various type Classification in R Classification in python Classification in Rapid miner Classification in KNIME Anomaly detection Anomaly data detection Anomaly data detection in R, Python, BigML, RapidMiner Analysis of data Analysis goal and data Analysis in R, python , Orange, KNIME Regression analysis Regression Analysis goal and data Analysis in R, python , Orange, KNIME Regression analysis

Finance Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Finance Training classes

8

Teaching Experience in detail in Finance Training classes

I work for Technofinance project. I deliver training on fundamental of finance module. Course cover how bank work on daily basis, cash flow, AML, Basel norms, role and responsibility of a bank.

Reviews (13)

4.9 out of 5 13 reviews

Sushil Sheth https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/2508021-small.jpg Viman Nagar
4.90513
Sushil Sheth
A

Python Training

"Thank sir for completing python class with good exercise. Examples were good. Only 3 student in 1 batch helped us to get proper understanding on topic and good concentration in class. "

Sushil Sheth
S

Python Training

"The lecture was really good online training from basic to real time automation project and example helped me to gain good knowledge. "

Sushil Sheth
M

Machine Learning

"Thank you sir for deep dive in machine learning. The explanation is very clear to understand the topic. "

Sushil Sheth
R

R Programming

"Thanks for completing R language with best practical session. It was wonderful training session. You are very down to earth, I really appreciate your nature and training session. "

Have you attended any class with Sushil Sheth? Write a Review

FAQs

1. Which classes do you teach?

I teach Data Science, Database Training, Finance Training, MongoDB, Perl Training, Python Training, Unix Shell Scripting Training and Windows Powershell Classes.

2. Do you provide a demo class?

Yes, I provide a free demo class.

3. How many years of experience do you have?

I have been teaching for 3 years.

Answers by Sushil Sheth (12)

Answered on 14/05/2017 Learn IT Courses/Data Science

Please check your post.
Answers 5 Comments
Dislike Bookmark

Answered on 21/02/2017 Learn IT Courses/DevOps Training

Cronjob -e to edit. Add full path of the command and full path of the file that u want to schedule. To set timings you have to insert sec date month day detail. And save the file.
Answers 7 Comments
Dislike Bookmark

Answered on 17/09/2016 Learn IT Courses/Programming Languages/Python

All the institute is good .....its all about how good the trainer is ....how best he can guide you...Trainer working for python project is good to guide you since he has industrial experience to share with you ...I too deliver training on python....you can connect to me....
Answers 26 Comments
Dislike Bookmark

Answered on 03/09/2016 Learn IT Courses/Oracle Training/Oracle PL/SQL

Normalization of Database Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process... ...more
Normalization of Database Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables. Normalization is used for mainly two purpose, Eliminating reduntant(useless) data. Ensuring data dependencies make sense i.e data is logically stored. Problem Without Normalization Without Normalization, it becomes difficult to handle and update the database, without facing data loss. Insertion, Updation and Deletion Anamolies are very frequent if Database is not Normalized. To understand these anomalies let us take an example of Student table. S_id S_Name S_Address Subject_opted 401 Adam Noida Bio 402 Alex Panipat Maths 403 Stuart Jammu Maths 404 Adam Noida Physics Updation Anamoly : To update address of a student who occurs twice or more than twice in a table, we will have to update S_Address column in all the rows, else data will become inconsistent. Insertion Anamoly : Suppose for a new admission, we have a Student id(S_id), name and address of a student but if student has not opted for any subjects yet then we have to insert NULL there, leading to Insertion Anamoly. Deletion Anamoly : If (S_id) 401 has only one subject and temporarily he drops it, when we delete that row, entire student record will be deleted along with it. Normalization Rule Normalization rule are divided into following normal form. First Normal Form Second Normal Form Third Normal Form BCNF First Normal Form (1NF) As per First Normal Form, no two Rows of data must contain repeating group of information i.e each set of column must have a unique value, such that multiple columns cannot be used to fetch the same row. Each table should be organized into rows, and each row should have a primary key that distinguishes it as unique. The Primary key is usually a single column, but sometimes more than one column can be combined to create a single primary key. For example consider a table which is not in First normal form Student Table : Student Age Subject Adam 15 Biology, Maths Alex 14 Maths Stuart 17 Maths In First Normal Form, any row must not have a column in which more than one value is saved, like separated with commas. Rather than that, we must separate such data into multiple rows. Student Table following 1NF will be : Student Age Subject Adam 15 Biology Adam 15 Maths Alex 14 Maths Stuart 17 Maths Using the First Normal Form, data redundancy increases, as there will be many columns with same data in multiple rows but each row as a whole will be unique. Second Normal Form (2NF) As per the Second Normal Form there must not be any partial dependency of any column on primary key. It means that for a table that has concatenated primary key, each column in the table that is not part of the primary key must depend upon the entire concatenated key for its existence. If any column depends only on one part of the concatenated key, then the table fails Second normal form. In example of First Normal Form there are two rows for Adam, to include multiple subjects that he has opted for. While this is searchable, and follows First normal form, it is an inefficient use of space. Also in the above Table in First Normal Form, while the candidate key is {Student, Subject}, Age of Student only depends on Student column, which is incorrect as per Second Normal Form. To achieve second normal form, it would be helpful to split out the subjects into an independent table, and match them up using the student names as foreign keys. New Student Table following 2NF will be : Student Age Adam 15 Alex 14 Stuart 17 In Student Table the candidate key will be Student column, because all other column i.e Age is dependent on it. New Subject Table introduced for 2NF will be : Student Subject Adam Biology Adam Maths Alex Maths Stuart Maths In Subject Table the candidate key will be {Student, Subject} column. Now, both the above tables qualifies for Second Normal Form and will never suffer from Update Anomalies. Although there are a few complex cases in which table in Second Normal Form suffers Update Anomalies, and to handle those scenarios Third Normal Form is there. Third Normal Form (3NF) Third Normal form applies that every non-prime attribute of table must be dependent on primary key, or we can say that, there should not be the case that a non-prime attribute is determined by another non-prime attribute. So this transitive functional dependency should be removed from the table and also the table must be in Second Normal form. For example, consider a table with following fields. Student_Detail Table : Student_id Student_name DOB Street city State Zip In this table Student_id is Primary key, but street, city and state depends upon Zip. The dependency between zip and other fields is called transitive dependency. Hence to apply 3NF, we need to move the street, city and state to new table, with Zip as primary key. New Student_Detail Table : Student_id Student_name DOB Zip Address Table : Zip Street city state The advantage of removing transtive dependency is, Amount of data duplication is reduced. Data integrity achieved. Boyce and Codd Normal Form (BCNF) Boyce and Codd Normal Form is a higher version of the Third Normal form. This form deals with certain type of anamoly that is not handled by 3NF. A 3NF table which does not have multiple overlapping candidate keys is said to be in BCNF. For a table to be in BCNF, following conditions must be satisfied: R must be in 3rd Normal Form and, for each functional dependency ( X -> Y ), X should be a super Key. BCNF Normal Form
Answers 10 Comments
Dislike Bookmark

Teaches

MongoDB Training
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in MongoDB Training

3

Teaching Experience in detail in MongoDB Training

MongoDB course content • Chapter 1: Introduction to MongoDB - History - Why mongoDB - Dependencies - Pros and cons - challenges - basic skill set • Chapter 2: Installation - Installation - software dependencies - Basic requirement - platform dependencies - Installation on open source - practice • Chapter 3: Data modeling - Basic knowledge on database - what is NOSQL DB - CAP rule - ACID property - Logic to design database - Tips on data analyst • Chapter 4: Working with Database - create database - Drop Database - explore database - admin responsibility - Data modification • Chapter 5: Working with Database - Create database - Drop Database - Explore options in database • Chapter 6: Collection in mogoDB - working with collection - Object for collection - limitation for collection • Chapter 7: Data type and example for same - Data type in mongoDB - playing with variables - example • Chapter 8: Manage document and manipulate - CAP implementation - insert, update, delete operation on document - manipulate document • Chapter 9: Projection operation - projecting data - modify the data with the help of project - control on data view - examples on projection • Chapter 10: Sorting and controlling output - control on data and datatype - Sort operation - control record output • Chapter 11: Index operation - create index - delete and manipulate index - complex index - drawback of index on document - best practice of index - working with object and index - query optimization • Chapter 12: Aggregation and replication - Data aggregation - Different function for aggregation - replace data - conditional based function • Chapter 13: Manage backup - Backup database - restore implemented database - modify database • Chapter 14: Referencing - working with data referencing - advance database modification - working with multiple databases • Chapter 15: Analytical operation - complex query - analytical results - embedded documents • Chapter 16(a): Regex - implement regular expression - object in regex - optimization - improve search operation - text search optimization • Chapter 16(b): Auto-Increment - implement auto increment - improve sequencing - imprve sequence with object ID

Python Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Python Training classes

8

Course Duration provided

1-3 months

Seeker background catered to

Educational Institution, Individual, Corporate company

Certification provided

Yes

Python applications taught

Web Development with Python , Automation with Python , GUI (Graphical User Interfaces) with Python , Networking with Python , Data Science with Python, Testing with Python, Text Processing with Python, Game Development with Python, Data Visualization with Python, Scipy Stack with Python , Data Extraction with Python , Data Analysis with Python , Machine Learning with Python, Regular Expressions with Python , Web Scraping with Python

Teaching Experience in detail in Python Training classes

I deliver training on python for banking security and network automation. I conduct online classes with flexible timing. My training will include assignment and live practice. I cover automation, database/network topics with python, unix scripting examples too. I have experience of personal as well as corporate training. 5+ years of experience in corporate training for python. (client wipro, Tcs, cognizant etc)

Perl Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Perl Training classes

7

Teaching Experience in detail in Perl Training classes

I have 7 years of experience as programmer. Work on project for banking security and network automation. We conduct online classes with flexible timing. My training includes assignment and live examples. I cover automation program, database/network topics, unix scripting examples etc. I have experience of personal as well as corporate training. 5+ years of experience in corporate training for python. (client wipro, Tcs, cognizant, IBM etc) Course content : Course Duration : (22 to 26) hrs Course Content Introduction ? History of evolution ? Why Perl ? Uses of Perl ? Perl on Linux, windows ? Real life examples ? Books on perl Perl Fundamentals ? First program with minimal explanation ? Variables : scalar, array, hash ? Operators ? Print statements ? Comments ? Executing the program ? Use of use strict and use warnings pragma ? Subroutines Control structure and loops ? if, if else, if elsif else, nested if else ? for, foreach, while, do while ? next, unless, return, exit, last, until, redo ? Ternary operators, goto label, ? Given and when similar to switch and case Useful/necessary functions to memorize ? chop and chomp ? sort and reverse ? caller, wantarray ? exec, system and eval ? uc, ucfirst, lc lcfirst ? grep and map ? length ? undef ? qw, qq,q, qx, qr ? warn, die Array Functions ? push and pop ? join and split ? slice and splice ? shift and unshift Hash Functions ? keys ? values ? exists ? defined ? delete ? each Array and hash manipulation ? Array and hash reference ? Anonymous reference ? Sorting array and hash elements Inbuilt special variables Regular Expressions basics ? Regexp basics ? Modifiers, quantifier, metacharacters ? Pattern matching, search and replace, transliteration File Handling ? Read, write, append, open , close files ? Binary file manipulation using binmode ? File testing ? Open directory, read files into it etc Introduction to Modules and Packages ? CPAN modules ? How to work with CPAN modules ? use, require, do ? Object Oriented Perl basics Database Connectivity ? Connection to the database ? Manipulating the fetched values from databases ? Inserting/updating database Program on Network and security ? Connection to the network devices ? Fragmenting multiple data from various component ? Monitoring network bandwith ? Control network device

Windows Powershell
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Willing to travel

Tutor's Home

Years of Experience in Windows Powershell

8

Teaching Experience in detail in Windows Powershell

Hello, I have 9+ years of experience in IT industries. Work on window powershell for projects on banking security and network optimization. I conduct online classes for data science. Class include multiple examples with case study on various algorithms. Algorithm are most important topic in data science, algorithm help to increase data security in optimize way. I conduct corporate training for various companies like Wipro, TCS etc Regards, Sushil SHETH 7045037679 (whatsup)9004336423 Course content : Course Duration : (16 to 19) hrs Module 1: Getting Started with Windows Power Shell Lesson 1: Overview and Background Lab A: Configuring Windows PowerShell Lesson 2: Finding and Learning Commands Lesson 3: Running Commands Lab B: Finding and Running Basic Commands Module 2: Working with the Pipeline Lesson 1: Understanding the Pipeline Lesson 2: Selecting, Sorting, and Measuring Objects Lab A: Using the Pipeline Lesson 3: Converting, Exporting, and Importing Objects Lab B: Converting, Exporting, and Importing Objects Lesson 4: Filtering Objects Out of the Pipeline Lab C: Filtering Objects Lesson 5: Enumerating Objects in the Pipeline Lab D: Enumerating Objects Module 3: Understanding How the Pipeline Works Lesson 1: Passing Data in the Pipeline By Value Lesson 2: Passing Data in the Pipeline By Property Name Lab: Working with Pipeline Parameter Binding Module 4: Using PS Providers and PS Drives Lesson 1: Using PS Providers Lesson 2: Using PS Drives Lab: Using PS Providers and PS Drives Module 5: Formatting Output Lesson 1: Using Basic Formatting Lesson 2: Using Advanced Formatting Lesson 3: Redirecting Formatted Output Lab: Formatting Output Module 6: Querying Management Information by Using WMI and CIM Lesson 1: Understanding WMI and CIM Lesson 2: Querying Data by Using WMI and CIM Lesson 3: Making Changes by Using WMI and CIM xvi 10961A: Automating Administration with Windows PowerShell® Lab: Working with WMI and CIM Module 7: Preparing for Scripting Lesson 1: Using Variables Lesson 2: Scripting Security Lab: Working with Security in Windows Power Shell Module 8: Moving from Command to Script to Module Lesson 1: Moving from Command to Script Lab A: Moving from Command to Script Lesson 2: Moving from Script to Function to Module Lab B: Moving from Script to Function to Module Lesson 3: Implementing Basic Error Handling Lab C: Implementing Basic Error Handling Lesson 4: Using Basic Scripting Constructs Lab D: Creating an Advanced Function Lesson 5: Exploring Other Scripting Features Module 9: Administering Remote Computers Lesson 1: Using Basic Remoting Lesson 2: Using Advanced Remoting Techniques Lab A: Using Basic Remoting Lesson 3: Using Remoting Sessions Lab B: Using Remoting Sessions Lesson 4: Using Remoting for Delegated Administration Lab C: Using Remoting for Delegated Administration Module 10: Putting it All Together Lesson 1: Provisioning a New Server Core Instance 1 Lab: Provisioning a New Server Core Instance Module 11: Using Background Jobs and Scheduled Jobs Lesson 1: Using Background Jobs Lab A: Using Background Jobs Lesson 2: Using Scheduled Jobs Lab B: Using Scheduled Jobs Module 12: Using Profiles and Advanced Windows Power Shell Techniques Lesson 1: Using Advanced Windows Power Shell Techniques Lesson 2: Creating Profile Scripts Lesson 3: Working with Alternative Credentials

Database Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Database Training classes

7

Teaching Experience in detail in Database Training classes

Hello, I have 9 years of experience in Database management. I work for multiple live project for bank security, MIS reporting and network optimization. We conduct online classes with flexible timing. My training will include assignment and live practice. I have experience of personal as well as corporate training. 7+ years of experience in corporate training (client wipro, Tcs, cognizant etc) Regards, Sushil SHETH 7045037679 (whatsup)9004336423 Course content : Course Duration : (14 to 18) hrs Theory, Terminology and Concepts • Client/Server Concepts • Database and Database Objects Mysql Architect • Structure of mysql DB • System object to improve performance of mysql • Security in mysql • Optimization of mysql Oracle DB • Inbuilt function • Complex query using oracle function • Architect • Optimization Data Definition using SQL • Databases • Data Types • DDL, DML and DCL • Tables • Constraints and Indexes • Views Basic Data Manipulation using SQL • Recurring SQL Constructs • Adding data • Modifying data • Removing data • Searching data Advanced Data Manipulation using SQL • Expressions • Grouping and Aggregate Functions • Joining Tables • Complex join • Sub query • Inbuilt functions Transactions • Transaction Concepts • SQL for working with Transaction Import/Export • Tools for Import/Export • SQL for Import/Export

Unix Shell Scripting Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Unix Shell Scripting Training classes

5

Teaching Experience in detail in Unix Shell Scripting Training classes

Hello, I have 7 years of experience as programmer. Work for Shell scripting project. I work for multiple project for bank security, MIS reporting and network optimization. We conduct online classes with flexible timing. My training will include assignment and live practice. I have experience of personal as well as corporate training. 7+ years of experience in corporate training (client wipro, Tcs, cognizant etc) Regards, Sushil SHETH Shell Scripting - Shell Basics 1. Types of shells 2. Shell functionality 3. Environment - Writing first script 1. Writing script & executing basic script 2. Debugging script 3. Making interactive scripts 4. Variables (default variables) 5. Mathematical expressions - Conditional statements 1. If-else-elif 2. Test command 3. Logical operators-AND,OR,NOT 4. ase –esac - Loops 1. While 2. For 3. Until 4. Break & continue - Command line arguments 1. Positional parameters 2. Set & shift 3. IFS 4. Break & continue - Functions & file manipulations 1. Processing file line by line 2. Functions - Regular Expression & Filters 1. What is regular expression 2. Grep,cut ,sort commands 3. Grep patterns - SED & AWK - Processes 1. Concept of process in Unix 2. Background processes 3. Scheduling processes -At, batch & Cron - Misc 1. Trapping signals 2. String substitutions / manipulations Advanced Shell Scripting - Advanced Scripting Techniques 1. Providing command line options to scripts 2. Shell & subshells 3. Exporting variables 4. Arrays 5. Remote shell execution 6. Dialog boxes - SQL with Shell 1. Connecting to MySQL using shell 2. Running SQL queries from a shell script - Essential System Administration jobs 1. Managing disk space/file system 2. Startup-Shutdown scripts 3. Backup-cpio-tar 4. Monitoring , health check

Data Science Classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Data Science Classes

7

Data science techniques

Machine learning

Teaching Experience in detail in Data Science Classes

I have 9+ years of experience in IT industries. Work on project for banking security and network optimization. I conduct online classes for data science. Class include multiple examples with case study on various algorithms. Algorithm are most important topic in data science, algorithm help to increase data security in optimize way. I conduct corporate training for various companies like Wipro, TCS, IBM etc Regards, Sushil SHETH 7045037679 (whatsup)9004336423 Topics: Duration : 45 days Introduction Brief history Concept and scope Enabling technology Data mining prerequisite Algorithm prerequisite Software prerequisite Algorithm Data mining goal Data mining algorithm Data mining using R, python Sequence mining using BigML : sequene 1 Sequence mining using BigML : sequene 2 Algorithm 2 Fraud detection Disease control Simulation Network security Statistic visualization BI architect (Business intelligence) RDBM and ORM Syntax of RDBMS Inbuilt function Limitation Overview of different database RDBM and ORM: 2 Complex query Multi join Sub query and limitation of same Data reduction Data reduction and its goal Data reduction in R Data reduction in python Data reduction in Orange Data reduction using rapid miner Data mining in Clustering Clustering data Clustering in R Clustering in python Clustering in BigML Clustering in orange Data Classification Classification of Data in various type Classification in R Classification in python Classification in Rapid miner Classification in KNIME Anomaly detection Anomaly data detection Anomaly data detection in R, Python, BigML, RapidMiner Analysis of data Analysis goal and data Analysis in R, python , Orange, KNIME Regression analysis Regression Analysis goal and data Analysis in R, python , Orange, KNIME Regression analysis

Finance Training classes
15 Students

Class Location

Online (video chat via skype, google hangout etc)

Student's Home

Tutor's Home

Years of Experience in Finance Training classes

8

Teaching Experience in detail in Finance Training classes

I work for Technofinance project. I deliver training on fundamental of finance module. Course cover how bank work on daily basis, cash flow, AML, Basel norms, role and responsibility of a bank.

Answers by Sushil Sheth (12)

Answered on 14/05/2017 Learn IT Courses/Data Science

Please check your post.
Answers 5 Comments
Dislike Bookmark

Answered on 21/02/2017 Learn IT Courses/DevOps Training

Cronjob -e to edit. Add full path of the command and full path of the file that u want to schedule. To set timings you have to insert sec date month day detail. And save the file.
Answers 7 Comments
Dislike Bookmark

Answered on 17/09/2016 Learn IT Courses/Programming Languages/Python

All the institute is good .....its all about how good the trainer is ....how best he can guide you...Trainer working for python project is good to guide you since he has industrial experience to share with you ...I too deliver training on python....you can connect to me....
Answers 26 Comments
Dislike Bookmark

Answered on 03/09/2016 Learn IT Courses/Oracle Training/Oracle PL/SQL

Normalization of Database Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process... ...more
Normalization of Database Database Normalisation is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a multi-step process that puts data into tabular form by removing duplicated data from the relation tables. Normalization is used for mainly two purpose, Eliminating reduntant(useless) data. Ensuring data dependencies make sense i.e data is logically stored. Problem Without Normalization Without Normalization, it becomes difficult to handle and update the database, without facing data loss. Insertion, Updation and Deletion Anamolies are very frequent if Database is not Normalized. To understand these anomalies let us take an example of Student table. S_id S_Name S_Address Subject_opted 401 Adam Noida Bio 402 Alex Panipat Maths 403 Stuart Jammu Maths 404 Adam Noida Physics Updation Anamoly : To update address of a student who occurs twice or more than twice in a table, we will have to update S_Address column in all the rows, else data will become inconsistent. Insertion Anamoly : Suppose for a new admission, we have a Student id(S_id), name and address of a student but if student has not opted for any subjects yet then we have to insert NULL there, leading to Insertion Anamoly. Deletion Anamoly : If (S_id) 401 has only one subject and temporarily he drops it, when we delete that row, entire student record will be deleted along with it. Normalization Rule Normalization rule are divided into following normal form. First Normal Form Second Normal Form Third Normal Form BCNF First Normal Form (1NF) As per First Normal Form, no two Rows of data must contain repeating group of information i.e each set of column must have a unique value, such that multiple columns cannot be used to fetch the same row. Each table should be organized into rows, and each row should have a primary key that distinguishes it as unique. The Primary key is usually a single column, but sometimes more than one column can be combined to create a single primary key. For example consider a table which is not in First normal form Student Table : Student Age Subject Adam 15 Biology, Maths Alex 14 Maths Stuart 17 Maths In First Normal Form, any row must not have a column in which more than one value is saved, like separated with commas. Rather than that, we must separate such data into multiple rows. Student Table following 1NF will be : Student Age Subject Adam 15 Biology Adam 15 Maths Alex 14 Maths Stuart 17 Maths Using the First Normal Form, data redundancy increases, as there will be many columns with same data in multiple rows but each row as a whole will be unique. Second Normal Form (2NF) As per the Second Normal Form there must not be any partial dependency of any column on primary key. It means that for a table that has concatenated primary key, each column in the table that is not part of the primary key must depend upon the entire concatenated key for its existence. If any column depends only on one part of the concatenated key, then the table fails Second normal form. In example of First Normal Form there are two rows for Adam, to include multiple subjects that he has opted for. While this is searchable, and follows First normal form, it is an inefficient use of space. Also in the above Table in First Normal Form, while the candidate key is {Student, Subject}, Age of Student only depends on Student column, which is incorrect as per Second Normal Form. To achieve second normal form, it would be helpful to split out the subjects into an independent table, and match them up using the student names as foreign keys. New Student Table following 2NF will be : Student Age Adam 15 Alex 14 Stuart 17 In Student Table the candidate key will be Student column, because all other column i.e Age is dependent on it. New Subject Table introduced for 2NF will be : Student Subject Adam Biology Adam Maths Alex Maths Stuart Maths In Subject Table the candidate key will be {Student, Subject} column. Now, both the above tables qualifies for Second Normal Form and will never suffer from Update Anomalies. Although there are a few complex cases in which table in Second Normal Form suffers Update Anomalies, and to handle those scenarios Third Normal Form is there. Third Normal Form (3NF) Third Normal form applies that every non-prime attribute of table must be dependent on primary key, or we can say that, there should not be the case that a non-prime attribute is determined by another non-prime attribute. So this transitive functional dependency should be removed from the table and also the table must be in Second Normal form. For example, consider a table with following fields. Student_Detail Table : Student_id Student_name DOB Street city State Zip In this table Student_id is Primary key, but street, city and state depends upon Zip. The dependency between zip and other fields is called transitive dependency. Hence to apply 3NF, we need to move the street, city and state to new table, with Zip as primary key. New Student_Detail Table : Student_id Student_name DOB Zip Address Table : Zip Street city state The advantage of removing transtive dependency is, Amount of data duplication is reduced. Data integrity achieved. Boyce and Codd Normal Form (BCNF) Boyce and Codd Normal Form is a higher version of the Third Normal form. This form deals with certain type of anamoly that is not handled by 3NF. A 3NF table which does not have multiple overlapping candidate keys is said to be in BCNF. For a table to be in BCNF, following conditions must be satisfied: R must be in 3rd Normal Form and, for each functional dependency ( X -> Y ), X should be a super Key. BCNF Normal Form
Answers 10 Comments
Dislike Bookmark

Contact

Load More

Sushil Sheth describes himself as Software Programmer. He conducts classes in Data Science, Database Training and Finance Training. Sushil Sheth is located in Viman Nagar, Pune. Sushil Sheth takes at students Home and Regular Classes- at his Home. He has 8 years of teaching experience . Sushil Sheth has completed Bachelor of Engineering (B.E.) from Mumbai in 2009. He is well versed in English. Sushil Sheth has got 13 reviews till now with 100% positive feedback.

X

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more