SQL Server Lessons
Hi, I'm an automation test engineer and a certified s/w test engineer (CSTE - QAI). I work with databases at a beginner level but I'm planning to master working with databases. I'm interested in taking a certification exam as-well. I am not interested in making a career switch but want to add it to my skill set. Considering my background, what training/certification should I go for? Please also suggest some beginner level certifications that would be helpful for me to add to my skill set.
Show previous answers
Johnson Edakalathoor | 12 Mar
Hi Kumar, Automation has lots of scope in current world of RPA. I worked in SQL Server Database as DBA and Architect for last 15+ years and currently managing a team of developers and Automation developers and analysts. To get into more on Automation, you don't need to get Database Knowledge, but yes, it gives automation a boost especially when you do Automation integrate with current process. You can take up any basic courses to learn about that. Even in youtube you can get those info. Since you don't want to change your area of interest in Automation, try to get certify in BluePrism, Automation Anywhere type of tools which will give you a real boost. And if you want to learn database basics and its use, you can try the "MTA: Database" from Microsoft. The reason I suggest for this option is, most of the Automation tools are based out .Net technology and it works seamlessly with SQL Server. I am not against with Oracle or other tools, but in automation domain, I have come across the about tools and those tools have very well maintained libraries which can integrate with any Databases like SQL, Oracle, Sybase, MySQL etc. So its fine with any DB stream. Hope this helps you.
Chandu Patel | 12 Mar
You can learn SQL server sql queries easily or oracle SQL for query writing. We can train you online or personally at Bangalore. You can call me we can guide you on that. No need to take certification. You can call me to discuss further we can guide you on that.
In postgresql 9.4 server streaming replication, from where wal files are transfer to standby? whether from wal buffer or pg_xlog
Show previous answers
Agama IT Solutions | 13/11/2016
If you want to retain only WAL segments after the latest base backup, you simply run pg_archivecleanup in standalone mode for the latest .backup file (not for those older than the latest). But do you really want to have only one available backup? First of all, you won't be able to restore to the point before the last backup. Second, it makes sense to have some backups just in case (corruptions, etc). And it seems strange to archive segments to local disk and then rsync them elsewhere. Why not putting your rsync (and then sync to flush OS buffers to disk) into archive_command? This ensures that the segment won't be removed from pg_xlog before it reaches the destination.
Sacheen | 24/11/2016
Your question is not related to Microsoft SQL, please post with PostgreSQL category to get quick answer.
My name is Rajesh , working as a Recruiter from past 6 years and thought to change my career into software (development / admin/ testing ) am seeking for some suggestion which technology I need to learn ? Any job after training ? Or where I can get job within 3 months after finishing my training programme- your advices are highly appreciated
Show previous answers
Satya Lakkoju | 14/09/2016
Good Decision Mr.Rajesh I prefer you to choose server ( Admin ) side . because now there's a good demand for administration in coming days also server maintenance will increase. You should learn Websphere or Weblogic Administration training for good Career Satya from Manuchandra technologies
Gurushankar M | 16/09/2016
Welcome to Software World Mr. Rajesh.(The Moment you decided to enter Software your are half way through:) ). My personal advice for you, get trained on Testing(Manual
Show previous answers
Ram M | 01/03/2016
I will provide you the class in tamil
Manas Rath | 09/03/2016
Mr Murthy, I have 13+years of experience in SQL Server Programming and Performance Tuning. I would say It's better to complete the course using English as the communication language as at the end you will be working in a Software company where your mode of communication will be english. Also it doesnot matter whether you are learning in english or Tamil, what matters is are you getting the concepts of SQL Server programming right or not. You can reach me in case you need training on the same
Thousands of experts Tutors, Trainers & other Professionals are available to answer your questionsAsk a Pro
Recommended for you
Why Should you Learn Microsoft Office
Microsoft Office is a very popular tool which is commonly used at home, schools and offices for organizing, handling and presenting data and information. It includes a number of tools: Excel, Word, PowerPoint and Outlook. There are some valid reasons which justify why one should learn Microsoft Office. Office has been such a success for so long that 90% of corporate professionals rely on it. Office has a major share in Microsoft s success and profit. In fact, Office could possibly be one of the reasons...
Make a Career as a BPO Professional
Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to preserve their position in the marketplace. BPO sector is a key employment source in country like India which has a huge youth population. Importance of BPO Professionals BPO professionals...
Make a Career in Mobile Application Programming
Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business documents, emails and whatnot, and larger devices seem bulky and restraining. The 21st century is a revolution for the mobile application development and a lot new companies...
Why Should you Become an IT Consultant
Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does an IT consultant provide advice to business owners but also prepare estimates and deploy manpower to carry on the important tasks like managing and administering Information Technology...
8 Hottest IT Careers of 2014!
Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a significant" increase in demand for IT professionals in 2014 as compared to 2013, a steady demand for IT professionals is rest assured this year. Not only the big IT companies but also new start-ups mushrooming are looking for people with high-demand IT skill sets. Now the question arises - What are these high-demand...
Learn Microsoft Excel
Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important and powerful software of all time. It is primarily used for organizing, storing and manipulating data which could be in the form of text, numbers or formulas. The properties...
Have a Question?
Thousands of expert tutors are available to answer your question
Looking for SQL Server Training?
Find best SQL Server Training in your locality on UrbanPro.