Software Testing full Course | Non IT to IT best course | Testing Jobs | Software testing Interview
this conference will now be recorded okay so some are coming from 19 some are coming from iit or iitv different background different experience so first of all you should understand what is this testing and where the ctl testing is falling in which category what kind of work will be done so coming to this id industry one is development another each testing then production and after that infrastructure development like this few teams will be there so infrastructure for admin is one team who will be responsible for deploying the build or install in the production server they can install into testing server or development servers so first of all development happen then testing happen whatever development people do the ori same thing will be tested by the testing team using the functionality those features are working properly or not once that is done everything it will go for the release then testing people will hand over to the production staff of team and those support team will be responsible for small small issue with the client for whom the project is going on so this is the continuous process happened in every idea organization in ireland on top of that some small small different teams also it is farming nowadays technology but basically these are the four types of teams are available starting from last 40 years to till today it is following okay so development will not concentrate all of you are coming for testing now come to this testing site in testing software testing is the common part whether you are having experience not experience first time second time whatever it may be software testing is the base part or the initial or prerequisites we can tell coming into it industry as a testing site so here what are available what is testing how to do the testing when to start how to end what documents we have to refer what documents we can prepare what tricks need to use any formula is there or not then what kind of models are using so all those things are present under this after testing construction this is nothing but the concepts testing concepts many are telling it as manual testing some are telling us software testing some are telling qa some are telling different so at the end these are the testing concepts only the concepts of testing that is testing concepts so these testing concepts we can use for doing the testing in any kind of project so fewer manual and fewer if not using any kind of tools technology simply manually we are doing by using these concepts and that is called as manual testing it can be application it can be web based which can be anything so no need of any programming language no need of any application no need of any tools no need of any technologies nothing simply some normal webpage or something can be provided and using those we can use all the concepts of testing you do that that is called as manual testing so anybody can do this minimal testing as a tracer experience for mid college students or standard 10 class 12 class standard students also they can do that that's why only manual testing demand is not there in market previously it was fine before 20 years back whenever testing came to the it industry only manual testing was there that is fine but right now anybody can do that so there is no scope or no more opportunity will be available even if somewhere it is there very less sales they are giving so to make our area in very good way to build the proper area we have to go with one of the automation manual is compulsory everybody should know and another is automation so some of the automations are pure automation 100 application level and some are semi automation so out of all this functional automation testing which is demand now selenium purely application automation 100 code is required purely java based putting only more demand here many are not liking or failing in their javascript another is non-functional automation j meter and all these are available for this non-functional also some programming language but based on the tools and again nowadays back into the picture some cloud related web service testing robotic process automation so these are different different automations some are semi automation some are full automation and out of all those another kind of automation is enterprise data testing which everybody is telling us etl list which is one part etl is one part of data testing for enterprise testing so here this is no not containing any coding purely query based only with very easy heart or core of this enterprise testing for data testing well intel is one of them one of the part so any kind of testing you can do these are these or these are these and many more are available sap testing main frame testing lot of lot of testing are available so any kind of testing you can go software testing concept is most required for learning if not required also fine but whenever appearing the interview these concepts will come in interview as well as if working in any company any project also these concepts will be required which is the pre-requisites for any kind of testing you can do now we will not concentrate more on other kinds of testing we focus on this enterprise or data testing and in which level it is following you etl and down the line what is the expectation if experience is increasing then what company is expecting okay so level 0 i have mentioned here software testing so this is required for everybody to work for database testing etl testing mainframe testing sua testing web service testing any kind of testing the software testing or testing concept is most required so i have mentioned it at level 0 so under that software testing and qa concepts required agile methodology nowadays many companies are using almost not more than 95 company so that agile methodology is required any one of the test management tool is fine jira hpl and these two are only majorly using nowadays in many organizations apart from that also a lot of goods are available really adu and lot of lot of tools are available so anyone is fine so who already worked or who already did the course for them fine who have not worked or not did the course don't have the knowledge no worry for learning the ctl testing individually you can learn but at the end this is required so if you want to join separately this bench you can join otherwise take it freely with the previous class recordings and documents and you can log yourself come up with the doubts one two hours or three hours you can clarify it so many people are doing that and getting succeeded also without joining the live session so that will be help out up to zero to two years around if experience is increasing then it will not help out only this manual testing something need to be added so if experience is increasing then next two levels which you are coming you need to learn this is required if you are coming it into enterprise testing or data related tests nowadays it is called as data qa engineers okay because this is purely data related not application not web service not any other related purely data start work with data and with data everywhere in middle and everywhere will be handling with the data so here this is two parts one is database and another is data warehouse so database is consist of sql pl sql is not required that is for developers some people are asking so highlighted this some are getting confused pls can require some are telling not required so no need to read pls sql is part of development side not for testing site if you know well don't know also nothing will happen if you want to learn your self-learning then can be provided with the previous class recordings documents everything you can learn in your own interest but not mandatory not compulsory for connecting the database in many organizations they are using deviator sql developer a few more tools so these two tools we can also use in our post whenever we do the practice which two are majorly using in many organizations to connect the database if these are ready then you are eligible for data centric testing data quality testing back-end testing data migration testing all these data related you are eligible but only database demand is again not more not much so to come up with the good requirements good package and all those things with good carrier on top of that at our house also need to learn so data warehouse business intelligence and edl using all these concepts one of the tools informatica power center which is demanded in market if that is also added with all these concepts you are eligible for database related with etl testing bi testing data warehouse testing and all bi tool is not required for tester that is for developer developer people are using these tools generating the report placing into some portals once in that portal it is available testers need to do the test so we will cover what kind of testing you need to do as part of business influence testing also from testing side so once everything is ready up to this then you are eligible to apply with two years four years five years six years up to eight nine years also it will be healthy but again experience in increasing something extra knowledge also required for companies are also expecting it is not like the two year and eight year will be the same knowledge you are expecting more salary as per the experience level company also expecting more knowledge so again experience is increasing unique sales script is required need to learn as per the experience level having an experience is increasing big data about testing which is the next level of database in data etl few of the components which are demanded need to learn right now spark is demand part one and high impala also using in some company not outdated but the very initial time for it was there if unix environment hdfs so after three years or four years whenever you will plan to learn once you will become six year or eight year or five year in your choice at that time maybe some new components will come to the market so need to upgrade in that level but right now spa high school hdfs is more than sufficient for this big data after this experience is increasing if you are not liking into testing size slowly you can move into data on a list also that is one best advantage of this etl or data related course if you are learning so data analyst also huge demand little bit of migration you have to do with advanced section some business statistics and python after that you are eligible for data analyst also and meanwhile if some problem happen in the job or you want to switch another profile development kind of thing or production support also you can switch without knowing anything also directly you can jump into production software that is again helpful unix sql and like testing concept production support concepts is required nowadays aws is expected okay so any moment you can switch your career into products and supporters so these are the advantages and different different levels and nowadays again the next level it is called as data engineer so slowly you can migrate into data engineer also by having some cloud knowledge with all so in the data engineer big data parties require unique series for database and data accounts is required so this will help you to make your multiple career not only in idea testing so slowly you can move into production support or data analyst or you can go into big data engineer if you are upgrading this skill set and if you are learning with some cloud knowledge with all these things then you are eligible for cloud data engineers so multiple skills multiple roles multiple features you can implement you can make your area it is not only stick to only one course on one room that is etl test so these are the different area path for carrier levels for the current market situation it can change also after one year or two year after year because nowadays everything keeps changing very frequently okay so this is the bad platform and no coding is there very the main intention main focus here and we start with the query only and in very deep level we can go and uh parallely we can do that so database we are doing in weekdays monday to friday data our house related this level we are doing is on the weekend so that parallel if you will do 45 days around it is taking to complete if one by one for only weekends or only weekdays three months around it will take it is very lengthy course and in deep level we are doing so every people are getting succeeded so it will take some time it is not like one month or something that's why parallel is the best option we are doing one nodule only we will do every day then it will be happy for heavily loaded so split two parts one part database one part data is coming combinedly parallely one by one for everybody it will be helpful in that we will be doing this okay now come to this atl etl is one part one level of this data engineer or the data related qa data related testing side if you are coming database is the first level etl is the second layer so using these two levels only at a time we will do so that more opportunity more demand more requirements you can face so what is the ctl then everybody came for etl at least in first session for demonstration you should know what exactly the cpr etl for means extract transform and load so what it will extract what it will transform but it will load okay so it will extract the data from some upstream system if you are joined in one company ibm accenture cognizant infosys somewhere you will work with some client so those clients will give some data like any banking client healthcare sector client then retail domain client so various clients are available telecoms and border phone key mobile after a tst these are coming under telecom industry telecom sector telecom client and banking client credit suisse city bank like the different different banks those are the banking clients so any clients who can work they will provide the data suppose here we can take one small example citibank client you are working citibank is providing the data unlocked customer information they have given and out of all those unlock customer information they need the business due to business only that bank is going on due to our benefit only we are a customer we are using that account we are using citibank so everybody should be get benefited so one last customer information they have provided to the company who is working this year and they are telling that give us the future data who are the women customers or latest customers who are leaving senior city with greater than 68 and who did the transactions of minimum 20 000 in last summer season now last two months of this current summer season may and june this is their criteria so using this they will do the business will get the benefit both side are benefited available so once this data is coming to the picture coming to this company we can cater all these unlock customer information data who are only ladies email mail both customers are there if it is categories only latest customer then out of one lock maybe it will be 40 again senior citizenship is there so senior citizenship will filter then again maybe 10 000 ladies customers again out of all those who need the transactions of 20 000 using their credit card or debit card or anything in last two months may and june summer month so again finally it will be 5 these 5000 will be provided to the customer account this will go to the customer so customer will not understand in technical ways using oracle database or data hours or big data so how it will be done how it will be sent to the customer how they will do the business for that using this so this final data 5000 customers informations will be put into some target location that target locations can be a high if it is up to some mega white if it is up to some gigabyte it can be placed into any database or a current data mariad sql server many databases are there if it is going up to some terabyte then it will place into some data warehouse environment if it is going up to some pita it will go to big data environment and again uh continuously it is migrating with the previous new in the cloud platform and it can be loaded into any cloud so big data and cloud environment that is next level another 45 hours of 50 hours it will take for that so in this level level 1 and level 2 will concentrate on this edl part with database i and in data balance how the data will be kept so after keeping the data the reports will be generated which is called as business intelligence report this report why it is required why it generates in all the projects because this data will be used for business enhancement business analysis and some separate team will be there and higher management authority will involved skills of big data that our they don't have be house cloud database they can't understand so to understand in a better way for everybody as a customer as a owner business person investor for everybody it will be very feasible and easy we report certainty like histogram pie chart and all those things so using all those diagrams for reports it is very easy for understanding working investing and for everybody it will be helpful not only for technical personnel and free persons okay so in that way these reports are generating and here everything will be data only we are getting the data we are transforming the data these are one one transformations we are loading the data we can extract we can transform we can load into target locations finally reports will be generated to make it more understand about the report one small report we can see here okay so some share price we can take we prove okay so here by opening this page only green color is displaying me something positive is there green is positive red is negative everybody know that no need to explain if you need small skills also nowadays they are known about this color combination so here if you receive plus 4.50 means four rupees fifty five and fifty percent profit happen when today so last closing day is friday means yesterday it happened this is the lifetime monday to friday they are trading happening many people are doing this hair trading by sitting from home also with small small investment okay so which company it is mentioned we flow company one d is mentioned this is for one day so in one day means last friday only it started in this price for 37 rupees again it picked up 440 dragon is picked up picked up picked up 441 like that so five rupees four and a half rupees around profit happened who purchased in this time and sold out since some time five rupees of profit for once they are they got already 1 000 who purchased yesterday they got 5000 rupees benefit profit so this is for one day if we are planning to do some investment in this year trade no need of any qualification nothing is required in the mobile only we can do with one of our trading accounts and bank account which both will be linked so one day analysis if you will do then maybe it cannot be succeeded it can be payloads we have to understand with some six months one year five years then only we can come up with the computer we are the end user customer we are as a customer we can invest something so some other investors also there are some amount who are investing some different companies are there so this report is designed with it for everybody it will be done now five days we can see five days also it is really good but we cannot conclude five days is good means we can go for investment next five days what will happen at least one year we are continuously giving profit then only we can get some faith or confidence one month we can see one month not more profit for 20 now it is 420 so only 20 rupees again in below down down but anyway on an average green color six months six months totally not good from 600 to 400 each cap year to date means current year only no red color one year no red color so one year six month eight month we are seeing not good five years five year or so 200 up to 2020 it was not good and after covered only lot of requirement happens due to workforce and all the startup projects they got so immediately picked up for one year after that again downfall started so overall if you are seeing five years also not within five years only one year is good maximum if you will see that 20 years later xktv so in 20 years it is fluctuated not more good only this 2020 21 one year around only it is doing so at the end what will be concluded don't go for wipro it is not doing good in last 20 years only one year only doing so how we can go for the conclusion no similarly this is iot company so similarly five or 10 id company you can just do the analysis which is good work similarly 10 or 20 retail sector company then banking company like the different different categories if you will see somewhere you can conclude that last 10 years continuously giving the property so we can get some confidence and we can go for the investment we can invest one luck or two something something we can get which will be better than best 10 percent or something we will get in bed here 25 30 we we can get that we are getting that confidence level because last 10 years continuously it is giving profit even if in the food situation so using this diagram using this in business intelligence report it is easy to understand for enhancement to come up with new conclusion or going with some new and business profitable engaging in some new activity for everything it will be helpful that's right business intelligence reports is required so who generates double numbers people generate using some tools like exam power bi or anything then they will put it into some portal or application testers need to test it so our requirement our rules will be from each phases everywhere wherever data is related extracting yes transforming yes loading yes after generate the data with the report yes in that report again we have to check so everywhere data related we have to start our work with data close with the work with data and everywhere it will be data data data that's why using data sql is more important one this is purely data related activity can be done using sql which is the heart or core part of etl bi and data our host activity so more and more knowledge with deeper knowledge but we start with this skill and paralleling other other technology also we can now come to this data everywhere data is there so what kind of data are available and what data we can use okay so data is three types one is structure data second is semi-structured data and third one is constructure data so what kind of data we can tell is structure the data which is containing row and column both individually row we are getting some meaning individually column we are getting some meaning those kind of data are called structure data and if structure data is there relational database is required to use and for relational database sql languages need to structure query language and another kind of data is semi-structured semi-structured data content only rows not columns if column we are considering individually there is no meaning the rows we are considering individually yes meaning so those kind of data are called as semi structure so semi-structured data will be used with non-relational database and the language used is no sql no sql is derived from sp which is coming recently so if no sql you know about sql you can assume you know about no experience within two hours it can be learned main part is sql earlier no sql was not there now recently few years back only it came to the market so what are the examples of this structure database xml sorry excel then we can take csv then we can take any database data and all those so here these are purely structure based so this is one excel sheet we can take roll number one column student name mobile number of them ct list from where they are joining their mail id any column we can take simply normally randomly suppose this column selected so list of the cities from where students are joining we are getting some meaning list of the student names we are getting some meaning okay so column wise we are getting meaning now row we can take any loop randomly take this row so roll number two student name is sony if a mobile number is something coming from bangalore city and mail id sony at direct gmail.com so one complete information of one student similarly for another student similarly for another student so any row we can consider we are getting some meaningful information any column we are considering we are getting some meaningful information so individually column wide individually row-wise which is giving the complete information and meaningful information those kind of data are called as structure data so this is a structure data database data tabular information data excel data or any other cr crm application erp application those are giving the structure data then what kind of that are semi structures which are giving row-wise information but columnar is no specific information xml dhtml log5 json chart and all this so json log file dhtml maybe you are not aware or you have not seen that if not work in any technology so leave that come to this chart so you are going chat with many people friends groups or many activities from day to day means from morning to evening using whatsapp very young messenger facebook or many social medias are available so how chatting hi friend how are you he is replying i am fine again you are asking what are you doing now did you take lunch is replying no what you are doing like that conversation is going on what is this this is also one kind of data we are just doing chit chat with one of our friends or in a group message but this is also data what kind of data this is semi structured data so any line you can pick higher how are you did you take lunch so meaning is there but if we are taking any column there is no meaning first column i am i did no any meaning no these are the list of city meaning is there second column how m you nominee so column wise there is no meaning but row y yes meaning is there those kind of data are called as semi structure that are semi partial 50 50 so for that no sql that language will be used and non-relational database will be used and another kind of data is unstructured data there is no row and no column so now those kind of data are not using maybe we can expect after one year or two year down the line that also it will come hugely so what kind of data is that what do you video then scanning if any scan we are going for any document then if any shopping mall is going sensor is there so all these are also capturing the data storing the data which are not having any row not having any color any audio you are taking in increase in [Music] in some social media in some company somewhere some teams are there they are working on testing some are working in development so everything is datum so our main concentration here in the ctl part is structure data using sql so if upgrading into next level of skills big data with some component then semi-structured data with no sql also requires some more components okay so these are about the data what kind of data are available what exactly this edl now some questions are coming from different candidates so we can just see what are the pre-requisites who can be eligible and all those things so this is database data warehouse business intelligence and etl related testing nowadays also it is called as data qa engineer so purely we'll do the real-time oriented only how it is affected how it is working in the job not like pressure or college level so live online all offline also available who are means of going for selfish they can use that also take the materials document videos of early sessions exercise without joining live sessions you can go through so prerequisites is testing already tool testing qa concepts any one of the test management tools agile methodology if you need to join safari page you can join otherwise take all the self plan based come up with the doubts clarify that computer fundamental that is expected from everybody like windows or excel powerpoint and some very basic knowledge of computer from room chip processor and all these at least need to open and any error is coming in laptop then need to understand that that is enough and the qualification any highest degree qualification has a degree is fine any highest degree it should be degree not only be any degree is fine b b 10 and c h m a msc ms me m tech so these are professional degree first priority company are giving then second priority they can give for other also dca dsc become and claim graduates so at the end what is the minimum criteria only degree minimum degree is fine if professional degree first priority non-professional degree and second priority division but resource shortage is there so any degree is fine knowledge is private if knowledge is there with one degree then that is fine for experienced candidates also it will be helpful for professors also it will be helpful who are planning to build their career in the data side database data warehouse etl big data business intelligence who are planning to build their career in these sectors it will be helpful which will be the entry point or entry uh courses we can say so professionally it is this course is specially for testing so testing will be more helpful hundred percent production support also easily can go if somebody plan for development in future eighty percent will be the same syllabus few extra parts are there for development which will be pls sql and few more informatica transformations so if anybody interrupted take those recordings also you can utilize in future otherwise listed if not going for development and slowly slowly in near future if experience is increasing target for data engineer and data analyst which will give more good career and in this line it is purely non-coding even if you can go for development or support or testing coding is not available only as actual query is the article and deep level that need to know the time duration relational database sql from basic to advance 30 hours it is taking purely practical or three hours around theory rest of the things are practical it can extend the time also then etl business intelligence that our house is one module which is purely theory concepts need to understand otherwise you cannot understand the flow of the project and do it and everything and now as you mentioned it is also extending another three to four hours extra and one etl will do informatica power center 15 hours around that is purely practical so all those together 55 it is mentioned but it is extending another 10 15 hours okay after that if everybody is interested we can plan for some work of interview preparation session how to start giving the interview starting with self introduction who are coming for first time they are not able to tell clearly about their self introduction also in which we what point need to cover within how much time everything will be discussed then how this screening round will happen from a church side or any management people are calling some non-technical questions some companies are taking the round direct around or that will be from some other higher management management so they and they will not ask the technical things what kind of non-technical they can ask then puzzle analytical some logical skill set of course few companies are asking not on so around 10 to 15 questions are there they are only repeating everywhere we'll discuss all those then from our syllabus that our house business intelligence atl concepts with project descriptions how to give all those things will come up with your preparation these are the mock-up interview 15 hours around it is taking so this three hours are not learned earlier fine software testing course and those are related also come up with your preparation will ask the questions some real-time scenario real-time technical decay non-technical agile model and everything from the software testing side so this course is designed such as very easily you can click the interview out of 100 500 candidates three positions are there five positions are there easily you can track in that position in that way it is design and providing already proved also a lot of people got in that way and after joining in any company no need of job support nothing required independently you can able to work many are calling nowadays i need job support i need job support that is very means uh negative things if you don't have the proper knowledge then only it is required the job support and that will not go for long run a lot of demerits are there learn properly job support is not required but even if anybody is interested in looking for that we have separate team they can help with that okay so if you are planning for certification which test any exam also easily you can click which will be reimbursed in the company if you are joining related to software testing ist qb or database related or this data warehouse related easily you can track those certification exams if planning for any certification to make good career or mentioned in the region training kits will be provided all these which are part of the syllabus anyway those will be given which are not part of the syllabus or pre-requisites you can take it which will be not taken live session with live session then i can separately need to pay the fees even not live sessions take the recordings document come up with the preparation and doubts plsp is not part of the syllabus if you want you can take that informatica development you want you can take the testing side anyway it will be covered in the class unix line of subscript also can be given for python if you want you can take hazard and some domain knowledge like insurance banking retail which is required or you join in any company any project any domain if some knowledge are required related can be provided lot of faq are there printer preparation everything you will get each class will be recorded get the recordings running class notes will be given for practice lot of exercises are there in the class slide will be prepared using this go to meeting the slide tag will be given many important documents for interview preparation as well as project one will be given some will be soft copy some will be hard copy and softwares are there job assistance we have separate team if anybody want any help or scheduling any calls or anything you can take the help with that thing it works for code it is required also we have separate team but nobody is taking our support who are learning here so first focus on the knowledge only everything okay so software content these are different tools and all these databases am i related without vmware related informatica some data connection to database connection tools sub copy contain around 500 queries few exercise 150 around multiple choice few concepts related documents and class notes few hard copies are there which is prepared for some company some agreement is there and they were only telling that same exact soft copy cannot be provided due to the agreement our copy only you can take which are prepared in very good way and those companies are using all those so thousands of queries are available a lot of concepts examples screenshot exercise and lot of a lot of question answers are there subjective objective multiple choice mini program scripts and interview preparation related details so easily you can understand real-time project how it is happening end-to-end for achieving any certification in your career you can utilize this if any job support assistance is required also you can take that advantage and from your side one thing is required own a part of two hours per day up to two months this will not help you cannot give this time totally it will be not help to anybody this is time waste money restaurant so two hours of effort per day is most required that depend upon some candidate four hours but on an average it invents two hours so mostly 70 to 80 percent candidates who are doing two hours of day effort they are getting succeeded if not able to do not able to remember maybe you can extend also three hours that depend upon okay so this is
2022-08-13 03:06
