Sushil Sheth

Viman Nagar, Pune, India- 411014.

Sushil Sheth photo

Sushil Sheth

Software Programmer

Viman Nagar, Pune, India- 411014.

14 Students taught

4.3
UrbanPro Rating

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.

MongoDB Training 4.3

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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 5.0

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Python Training classes

1

Course Duration provided

1-3 months

Seeker background catered to

Educational Institution, Corporate company, Individual

Certification provided

Yes

Teaching Experience in detail in Python Training classes

I have 7 years of experience in python scripting. Work on project for banking security and network automation. We 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) Course content : Course Duration : (18 to 26) hrs Core Python Introduction History Features Working with Python Basic Syntax Python Interpreter and its Environment Variable and Data Types Numbers, Strings, Unicode Strings Conditional Statements If If- else Nested if-else Operator Arithmetic Operators Assignment Operators Comparison Operators Logical (relational) operator Conditional (or ternary) operator Comparison Operators Looping For While Nested loops Looping Techniques over arrays, dictionary, etc The range () Function Control Statements Break Continue Pass String Manipulation Accessing Strings Basic Operations String slices Function and Methods Lists Introduction Accessing list Operations Working with lists Function and Methods Tuple Introduction Accessing tuples Operations Working Functions and Methods Dictionaries Introduction Accessing values in dictionaries working with dictionaries Properties Functions Functions Defining a function Calling a function Types of functions Function Arguments Anonymous functions Global and local variables Modules Importing module Math module Random module Packages Composition excel database Input-Output Printing on screen Reading data from keyboard Opening and closing file Reading and writing files Functions Exception Handling Exception Exception handling except clause try? Finally clause User Defined Exceptions Advance Python OOPs concept Class and object Attributes Inheritance Overloading Overriding Data hiding Regular expressions Match function Search function Modifiers Patterns Advance Scripting Introduction Architecture Automation scripting File upload File management File upload File management Database Introduction Connections Executing queries Transactions Handling error Networking Network programming Module Methods Multithreading Thread starting a thread threading module Synchronizing threads Multithreaded Priority Queue Sending email Introduction for architect Mailing script Debugging Step to debug Various approach Debug function.

Perl Training classes 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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 4.8

Class Location

Willing to travel

Tutor's Home

Online (video chat via skype, google hangout etc)

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 4.8

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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 4.8

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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 4.9

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

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

R Programming 4.4

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in R Programming

3

Teaching Experience in detail in R Programming

I have 7+ years of experience in programming domain. I work for Data scientist project on Reporting and analytical assignment. I have done training on R language for various corporate batch. Solving complex puzzle using programming skill set is part of my development assignment. Created practical predictive models with statistical and machine learning methods including decision tree, random forests, generalized linear models( logistic regression) and cluster analysis to solve business problems. - Data Structure - Matrices - Data Frames - Working with IO operation - Statement handling - Loops and Function - R operations and algorithm - Visualization in R

this is test message this is test message this is test message this is test message this is test message this is test message this is test message

Answers by Sushil Sheth (12)

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

Please check your post.
Answers 5 Comments
Dislike Bookmark

Answered on 21/02/2017 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 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 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... read 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 read less
Answers 10 Comments
Dislike Bookmark

Enquire

Load More

Sushil Sheth describes himself as Software Programmer. He conducts classes in Data Science, Database Training and MongoDB. Sushil Sheth is located in Viman Nagar, Pune. Sushil Sheth takes at students Home and Online Classes- via online medium. 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

Post your Learning Need

Let us shortlist and give the best tutors and institutes.

or

Send Enquiry to Sushil Sheth

Let Sushil Sheth know you are interested in their class

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.

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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