Database Developer
Core Programming with Databases will always be in demandLearn Databases indepth with Suven
Mr. Darshan Panchal
BE IT, K.J. Somaiya College
Completed Full Stack Software Engineering track from Suven. Was very helpful for the growth of my career; teaching of Rocky sir is excellent. The notes provided for each subject is up to date with lots of programs for practice. Simran Ma'am really worked hard to improve my soft skills & my resume.
Mr. Venkat Iyer
Atharva Educational Trusts College of Engineering, Malad
Suven is the best training institute when it comes to enhance and sharpen the required tech skills. I completed Full Stack Software Dev Track, did internship projects under the guidance of Rocky Sir and Niraj Sir. Got Selected at Accenture @ 3.3LPA. Cracked the very first interview.
HR, Revolux Solutions
We connected with "Suven Consultants" some time in early 2017. We found that their trained students are doing good work in Java technology. They are trained well in core concepts and have hard working attitude. We look forward to hire more skilled resources from them, in the future.
Mr. Priyank Patil
University of Mumbai, Full Stack Developer
I've undergone training at Suven Consultants for Full Stack Course in my third year of engineering. The teaching methodologies used by Rocky Jagtiani Sir are result oriented and focused on making students understand the core fundamentals of programming concepts, by the end of the training program we had the opportunity to work on challenging internship projects and also received guidance from industry experts. They have very strong industry connects. I got selected at Accenture in the very first Interview.
Oracle SQL & PL/SQL
Oracle Database SQL & PL/SQL
SQL Syllabus
| Basics of Databases |
| Types of Statements : DDL,DML,TCL,DRL |
| Power of Select Simple to Complex Queries |
| Joins - Its Type & Applications |
| DML - insert, update,delete & merge |
| DDL - create, drop, truncate & alter |
| Table & Views |
| Constraints - Type & Applications |
| Indexes - Its Type & Applications |
| Sequences - Its Type & Applications |
| Synonyms - Its Type & Applications |
| Data Dictionary Tables & Views |
| Oracle SQL Mock Test dumps |
| 5 hrs (Assessment) Test on Hackerank.com |
| Certificate of Completion issused to only Individuals completing the Hackrrank Test |
| Post this training one can easily clear Oracle SQL test |
| Look at the new Batch Dates here |
PL/SQL Syllabus
| PL/SQL Language Fundamentals |
| PL/SQL Control Statement |
| PL/SQL Collection Types |
| PL/SQL Cursors |
| PL/SQL Errors and Exceptions |
| PL/SQL Stored Procedure and Function |
| PL/SQL Triggers |
| PL/SQL Dynamic SQL |
| PL/SQL Packages |
| PL/SQL Database Interaction |
| Oracle PL/SQL Mock Test dumps |
| 1-2 hrs (Assessment) Technical Interview on video call |
| Post this training one can easily clear Oracle PLSQL test |
| Look at the new Batch Dates here |
Download Section
Course Download
1) Oracle Database Express Edition 11g Download Or use live SQL
2) Installation Steps - Oracle DB 11g - By Rocky Sir Download
3) How to run java-database programs from my PC ?Download
4) One-full-day(8 hrs) - 100% Practical Microsoft SQL Server Workshop
5) Must Read Information about Oracle Architecture Download
6) About a Multitenant Environment_oracle 12c Download
7) PL/SQL Oracle Home practice _file_1 Download
8) PL/SQL Oracle Home practice _file_2 Download
9) Oracle SQL Practice Queries Download_1 Download_2
11) Oracle PL/SQL Practice Queries Download_1 Download_2
12) Solution (by Rocky Sir) to HackerRank > SQL problems Download ReadMe.txt
13) Oracle SQL & Pl/SQL and Database Interview Questions_difficult Download
14) Sample Resume Format Download 1 Download 2
15) Oracle Pearson Vue centres for giving Oracle certification exams Download
MUST READ SECTION
1) Why using bind variables in PL/SQL improves performance ? Read
2) All, Any and Some operators in SQL - Important !! Must See Once
3) Exists clause - Important !! Must See Once
4) ROWSCN, UID and USER Pseudo columns - Important !! Must See Once
5) Foreign Key Constraint Example -- important !! Must See Once
6) Learn Oracle SQL : The Hierarchical Query Clause Must See Once
7) Top-N queries in Oracle SQL Must See Once
8) Understanding Analytic Functions in Oracle SQL Must See Once
9) Overview of Regular Expressions in Oracle 11g Must See Once
10) How and why to create clusters ? Must See Once
11) complete list of single row functions Must See Once
12) complete list of Aggregate ( Group ) functions Must See Once
13) Enhancements done in Oracle 12C over previous versions Must See Once
14) Format models use in conversion function_Oracle_11g(same applies to 12c) Must See Once
15) Whats new in Oracle PL/SQL ( Release 1 and 2 ) Must See Once
16) Must Read Oracle PL/SQL Building Packages and Reference Types Must See Once
17) How to Create USER, GRANT and REVOKE rights ? Read-1 Read-2
18) SQL - A Practical Introduction Must See Once
Placements on Mind
Register for Suven Mentorship & Placement Programme
9000+ students & professionals benefitted till date !!
Inquire. NOWSuven Consultants & Technology Pvt. Ltd.
Ms Simran (Head for Operations & Recruitment) is an thorough HR professional coming with an expertise in hiring people laterally across levels from Junior to Senior. With 15 years of experience hiring talent right from fresher to CEO level, has a flair for writing and nurturing talent from very basic.She along with her team strongly believes in fitting the right peg to the right hole. Her team likes working with level headed and out of the box thinkers. Do fill in the form below to enable us to connect.