Sushil Sheth photo

Sushil Sheth

Software Programmer

Viman Nagar, Pune, India- 411014.

UrbanPro students 14 Students (14 from UrbanPro)

Phone Verified Email Verified
Are you Looking to Learn?

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

Class Location

Student'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

Course Duration provided

1-3 months

Seeker background catered to

Educational Institution, Corporate company, Individual

Certification provided

Yes

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Python Training classes

1

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

Class Location

Student'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

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

Class Location

Student'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

Class Location

Student'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

Data_science_techniques

Machine learning

Class Location

Student's Home

Tutor's Home

Online (video chat via skype, google hangout etc)

Years of Experience in Data Science Classes

7

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

Class Location

Student'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

"I post my Ad, please help me on how to do this?" in   IT Courses/Data Science

Please check your post.

0
|
0

"How to Schedule Tasks on Linux?" in   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.

1
|
0

"What is the best python institute" in   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....

0
|
0

"I am looking for Part time Oracle Trainer work. I found few profiles as well near to my location but unable to get the contact details. Please help me out..!!!" in   IT Courses/Oracle Training/Oracle Database, IT Courses/Oracle Training/Oracle Database/Oracle 10g DBA

Apply in NIIT they are looking for Oracle trainer

0
|
0

"Hi what is the Normalization? and the types?" in   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 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

0
|
0
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.

Share this Profile

Similar Profiles

Sundararaman R photo

Sundararaman R

Sundararaman R photo Pappanaickenpudur, Coimbatore

From MRI-based brain research in MATLAB to statistical network analysis in Python, my programming career has had rich and...


Featured
Bigdata Data Science Python Perl Trainer photo

Bigdata Data Science Python Perl Trainer

Bigdata Data Science Python Perl Trainer photo Airoli Railway Station, Mumbai

Big data is buzz word in the market. There are very few professional who really have good understanding of big data. I started...


Sarnya kaur photo

Sarnya kaur

Sarnya kaur photo Viman Nagar, Pune

Mongodb, bigdata, hadoop, python expert trainer last 10 years . I have trained students and training centers and have conducted...


Mukesh Shende photo

Mukesh Shende

Mukesh Shende photo Miyapur, Hyderabad

I am a technical fellow by choice, a commerce graduate by education and PMI certified Project Manager Professional. I...


Harshal Suresh Patil photo

Harshal Suresh Patil

Harshal Suresh Patil photo Pimpri PF Office, Pune

I am an experienced, qualified tutor with over 3+ years of experience in data science and machine learning. I have crafted...


SS SHETH photo

SS SHETH

SS SHETH photo Vashi, Mumbai

I have 9 years of experience in core programming domain. Work on project for banking security and network automation etc....


Raviteja Jyosula photo

Raviteja Jyosula

Raviteja Jyosula photo Electronic City, Bangalore


Arko Biswas photo

Arko Biswas

Arko Biswas photo Electronic City, Bangalore

Been in IT industry for around two and half years now. Database administration and data analysis are the sectors where I...


Bhargav photo

Bhargav

Bhargav photo Jayanagar East End Main Road, Bangalore

I have done a PG specialization in Big Data Analytics & Data Science and am currently working in a Fortune 100 company. I...


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