Have Queries? Ask our Experts
Hands on Training
Projects for hands-on learning
Practical assignments
Lifetime access to support team
Feel & Decide after a Free Demo Class with our Experts.
Call us : +91-8939915572 and Become a SAS Developer.
Launch Your Career with a SAS Credential. Master the skills required for the SAS Base Programmer certification.
Learn moreGrow Your Career with a SAS Credential. Master the skills required for the SAS Advanced Programming Professional certification.
Learn more
Launch Your Career with a SAS Credential. Master the skills required for the SAS Visual Business Analyst Certification
Learn more
Explore a career in the pharmaceutical industry. Become a SAS certified SAS Clinical Trials Programmer.
Learn more
As a Trainer, Rajesh is an experienced statistician and data miner with more than 18+ years of Analytics experience in predictive modeling , time series, segmentation, decision trees, advanced algorithms using Base SAS, SAS BI tools like DI Studio, OLAP Cube studio, IDP, Web Reporting studio, Enterprise Guide and Management console and a passion for building analytical solutions and is very keen in delivering the BEST SAS Trainings.
10+ years of Data Analytic, Statistical Programming experience across various domains using SQL, MSBI, Python and R
Experience in providing End to End SAS Training Program with Job Guarantee.
Trained 1200+ professionals
Prepare participants to get IT job ready in 12 weeks
Conducting regularly online- training for US peoples in all time zones (PST, CST, EST, HST, MST).
100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
Flexible Timings / Weekend classes Available.
Talk to the Trainer @ +91-89399 15572Instructor Led live online training
Instructor Led classroom training
Customized and Exclusive training based on your requirement
Customized Corporate Training
Course Price Starts at
Recruiters are looking for you! All you need is Learn from beginner, advanced, expert to architect of SAS with Greens Technologies, Become SAS Certified Professional And Get JOB with our Placement Assurance Program
Greens Technologies, SAS Training offers flexible training options including Class room and Online training for your learning needs. Choose what to learn, and when and how to learn it. With SAS -accredited instructors in a hands-on learning environment.
Feel & Decide after a Free Demo Class with our Real Time SAS Experts.
Call us : +91-8939915572 and Book your Seat Now!
SAS Certified Professionals stand apart from the pack. Join them.
Put your potential to work.
SAS Certification is more than just a piece of paper. Certification exams measure not only knowledge, but also real deployment skills, ensuring that SAS Certified Professionals know exactly how to deliver a successful project. Get certified, showcase your skills and share your knowledge. Earning certification helps you as an IT professional establish credibility with both your employer and the greater IT industry.
100% Placement & Interview Program - Learn how to tilt the interview in your favor & aligning your needs with the organization. We will send you for interviews till you get a JOB.
The dedicated and experts of Greens Technologies placement team is known for their regular scheduling of interviews to the learners with the biggest IT company in the world. Being a leading software Training and Placements provider for the past 15 years, Greens Technologies has global tie-ups with multinational giants
60 Hours of Instructor-led Classes.
We ensure that each student gets a SAS certification based on your internal assignments and practical session performances.
Big data management, advanced analytics, machine learning and data visualization, along with the essential communication skills needed by data scientists today.
Database administrator, Data warehouse architect, Data warehouse specialist, ETL specialist, Developer, Business analyst, Financial analyst, Marketing analyst, Securities analyst, Statistics programmer, Statistician, Quality analyst, Clinical data programmer, Report programmer, Database programmer
Software Developers, IT Professionals, Engineers, Analysts, Freshers wanting to kick-start career in software development.
Bachelor's Degree is mandatory. No coding experience required.
Dear Rajesh! This e-mail is to say BIG THANK YOU..for all teaching you done in our SAS training sessions. I GOT JOB as SAS Developer after almost 2 months of struggle here in Chennai. I must Thank you for such a good and rocking lessons. to tell you frankly you made me to like/love/crazy about SAS though i have no idea about it before joining your classes." This is my first job in IT after my studies and i am a bit tensed how things will be after joining in the company. your suggestions are more helpful for me to get on well in the company as good developer.
I attended the Base SAS and Advanced SAS course class room sessions. The outline of the each course were well prepared and presented using latest video technology. The instructor is very talented and expert on Analytics concepts both theoretically and practically. I would highly recommend this institute to any one who wants to learn SAS ." I joined "Greens Technology" because of their proven expertise in SAS practical training. Here, I learnt the Magic of SAS . The constant and personal interaction with the Trainer, Live Projects, Certification Training and Study material are the best part. The trainers are extremely proficient in their knowledge and understanding of the topics. The instructors I had were both skillful and possessed the knowledge required to present the material to the classes. The SAS Certification training program has provided me with the necessary skill sets to prepare me for the corporate world. "Greens Technology" is the stepping stone to my success in the IT world. The money invested is well worth the reward. On my personal experience I recommend "Greens Technology" heart fully as the best training institute for IT Business Intelligence education. Thank you "Greens Technology" for helping me achieve my dream of becoming an SAS Certified Professional.
The course delivery certainly is much better than what I expected. I am glad that I decided to choose Greens Technology for the SAS course. Wonderful learning experience and I like the way classes are organized and good support staff. Greens Technology provides quality learning experience within affordable price. Also thanks to my educator Dinesh , his teaching inspires and motivates to learn
No:11,
First Street,
Padmanabha Nagar,
Adyar,
Chennai-600 020.
4th Floor, W122, 3rd Ave,
W Block, Annanagar East, Chennai,
Tamil Nadu - 600040.
(Landmark : Above Erode
Amman Mess Restaurant)
Plot No.19,
Balamurugan Garden,
OMR Road,Kancheepuram District,
Okkiam, Thoraipakkam,
Jain college bus stop,
No.1, Apparao Colony,
Tambaram,
Sanatorium,
Near HP Petrol Bunk,
Chennai-600 020.
149, 1C/1D,
1st Floor,
Opp to DLF IT Park,
Ramapuram,
Chennai-600 020.
1st Floor, No. 19 &20,
American Advent Christian Layout,
Sholinganallur to Medavakkam Main
Road, Perumbakkam,
Chennai-600 020.
No. 05,
Bakthavachalam Street,
West Tambaram,
Chennai - 600045.
51-A, 2nd floor,
Velachery Road,
Dhadeswaram Nagar,
Velachery,
Chennai 600042.
Link : Group functions
1) Write a query to print the following
Input String:12341234123123456
OutputString:abcdabcdabcabcdef
SELECT TRANSLATE('12341234123123456','123456','abcdef')
FROM DUAL;
Output:
2) Write a query to concatenate(join) the employee_number to a comma separated string
example:'101,102,103,104.,,,,'
SELECT LISTAGG(EMPLOYEE_ID, ’,’) WITHIN GROUP(ORDER BY EMPLOYEE_ID ASC)
FROM EMPLOYEES;
3) Write a anonymous block to print numbers from 1 to 100, if the number is divisible by 3 then print as 'FOO', if the number is divisible by 5 then print as 'BAR', if the number is divisible by both (3&5) then print 'FOOBAR' else print the actual number.
begin for i in 1..100 loop if mod(i,3)=0 and mod(i,5)=0 then dbms_output.put_line('foobar'); elsif mod(i,3)=0 then dbms_output.put_line('foo'); elsif mod(i,5)=0 then dbms_output.put_line('bar'); else dbms_output.put_line(i); end if; end loop; end; /
4) Write a query to print the following from emp table department wise Department Total_Salary_dept Min_salary_dept Max_salary_dept Overall_min_salary Overall_avg_salary
DEPT-10 TOTAL SALARY MIN-SALARY MAX SALARY
Overall_min_salary Overall_avg_salary
DEPT-20 TOTAL SALARY MIN-SALARY MAX SALARY
Overall_min_salary Overall_avg_salary
DEPT-30 TOTAL SALARY MIN-SALARY MAX SALARY
Overall_min_salary Overall_avg_salary
select department_id,min(salary),max(salary),sum(salary),round(avg(salary)) as avg from employees
group by (department_id) order by department_id;
Output:
Link : SQL Loader
.jpeg)
.jpeg)
1. Diff between procedure and functions
2. Can we use return statement in procedure
3.can we return output of select query in stored procedure
4.can we use function in select query.?
5. Can we use function in the from clause in select query
6.what are the views?
7.how to store datas in view?
8.mview syntax
9. Any Specific key word in mview
10. What u know abt Collection
11. Did u worked on set operators.?
12. Types of joins
13. Query optimization
14. What is nested loop and hash join
15. Types of subquery
16. T1 has id column with 2 rows ie. 1 and 1
T2 has I'd column with 2 rows ie. 1 and 0
Join two tables what will be the output if in case of equi join, full outer join, right outer join, left outer join
17.3rd max salary? Why not rank or row number
18. Display dept wise total salary and also over all total salary
19. Emp table has 5 columns named ...
I'd, name, salary, manager_id , dept....
Write a query to output as
I'd, manager I'd, salary, manager name
20. Table t1 has 10 column and table t2 has 0 column. How many column we will get if we do cross join.
21. Query to get cumulative sum.
22. How you will store result of query?
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
Company name:craft silicon
Name:Mary nancy
Ph no:+91 73581 96990
Mail id:marynancy.r@craftsilicon.com
Indhu: +918778972194
Object frontier software (OFS)
Shushma.chellapandi@object-frontier.com
+91 81899 32190
Name:Selli
Company: TCS
Client : ally bank
Expectation: 6 + years
Email : pavithra.gopalakrishnan@csscorp.com
Phone No : 8428334425
keerthi@dreammakershr.com- Beyontec solutions
Greetings form Mindgate Solution!!
We are CMMI 3 product based company dealing with UPI payment & banking domain.
We provide payment solution to banking sector.
For more details please go through www.mindgate.in
Mindgate (www.mindgate.in) is hiring for below position :
Position: Database Developer
Job Location: Guindy Chennai
Employment Type : Permanent
Notice Period: Immediate to 15 days
Primary Skills -
Should have relevant 3 to 4.5 years experience primarily in Oracle or Mysql or Sql server
Should have expertise level skill in writing efficient and complex queries, Procedures, Functions and analyses/debug issues.
Person should have 3 -6 years of experience working in any one the database like Oracle/MySQL/SQL
Must have experience in Query tuning/Performance Tuning
Must have worked on Linux
DB migration is required
Soft Skill :
Good to have worked on Banking projects
Should be a good team player who can coordinate and work closely with front-end developers.
Team cooperation &commitment towards the work is required.
Interested candidates can send their profiles at rachana.mishra@mindgate.in with below details
Total Exp -
Database Development Exp
Linux Exp -
Query Tuning Exp -
SQL Queries -
Shell Scripting -
Ctc -
Exp Ctc -
Notice -
Current location -
Interested for Guindy Chennai
Mail I'd: rachana.mishra@mindgate.in
Contact No: 8925222645
Intellectual design arena
Irfana 073059 99525
Robert bosch
HR. +919916374007
For bangalore location
Looking for 4+ years
Hi,
We have Opening for " PLSQL Developer "with one of our leading clients BNP PARIBAS
for working on their Applications
You will be taken on Permanent payroll with MITS IT Services (www.mitsit.in) and placed at the client site BNP Paribas (www.bnppispl.com) in Mumbai
BNP Paribas India Solutions (BNPPISPL) is a global delivery centre for BNP Paribas Group, one of the largest banking groups in the world. Its strength is more than 2000 people in India. BNPPISPL has its presence in Mumbai and Chennai.
MITS IT services provides onsite services to large IT companies and offshore development centres for companies like BNP PARIBAS, HSBC, ANZ, Sears, Societe Generale etc.
We provide facilities like PF, Mediclaim, Training, Bench Support .
Job Profile : PLSQL Developer
Experience : 4 to 9. years
Location : Chennai (Global Infocity )
Notice Period :0 to 45 days only
Job Description :
5-8 years experience as a Oracle developer.
ODI/OBIEE good to have.
If interested, please revert with you updated CV only in "word format" along with the following details asap; Bhagyashree@mitsit.in
* Current CTC:
* Expected CTC:
* Notice period:
PAN Card No :
Current location (Chennai /Hometown ) :
Comfortable for Payroll:
* Your full name:
* Marital status:
--
Thanks & Regards,
Bhagyashree Pashte
IT - Recruitment
MITS Global Consulting Pvt.Ltd
Ph: 91-9137875045
Website: www.mitsit.in
HR name rachana
+91 89252 22645
Database developer position
Job Description·
* Person should have 3 -6 years of experience working in any one the database like Oracle/MySQL/SQL
* Must have experience in Query tuning, Shell Scripting, Performance tuning & Sql queries
* Must have worked on Linux
* DB migration
* Must be ready to work from Office location whenever notified
this is from KG information system Pvt. Ltd
HR name Ravi Kumar
+91 96885 17095
Guhan optimum solution
8973274866
9600787106 Gayathri bhawan cyber
9600170667 Ashok bhawan cyber
Mohan Bawan Cybertek
+91 87546 08866
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
