The PRP at WIPRO
The Project Readiness Program started with RDMS,and continued through SQL and PL/SQL.The class is very good,the madam teaching us all these are very enthusiastic about the subject so the class is very interesting,i can see even the non-IT people enjoying her class.Her arrangment of the topics is very good,putting across right examples.The RDBMS course is just one day still it covered the expectations.From day two onwards she started with SQL.
RDBMS Topics
- What is RDBMS ?
- Benefits and Features of RDBMS.
- Relations,Tuples,Attributes,degree.
- Keys:-Super Key,Candidate Key,Primary Key,Alternate Key.
- Designing using Entity-Relationship Model.
- E-R Diagrams,Case Studies 1 or 2.
- Normalization,1NF,2NF,3NF.
SQL Topics
- Basic understanding on SQL.
- Relational Operators,Logical Operators & expressions.
- WHERE clause,ORDER BY clause.
- Order of execution of SQL statements.
- SQL Functions-
- Single Row Number Functions-abs(),Ceil(),exp(),sqrt().
- Char Functions-concat(),initcap(),ltrim(),rtrim(),substr().
- Date functions-addmonths(),extract(),round().
- nvl(),nvl2().
- Types of Join.
- Group Functions.
- Sub-Queries.
- Oracle Architecture.
- Data Definition Language.
- DML.
- Transactions,Views.
- DCL Statements.
These topics are mainly covered in RDBMS and SQL classes.Hope that gave a small idea on the preparations.I forgot to mention about the FRP questions.As i have told earlier am putting so SAMPLE FRP questions.These are what I studied for the FRP.Hope that helps.
Related posts:








Hi thanks for the useful resources..
Can u post the details of Real Life Lab…
What kind of stuffs we will get in this (RLL)..
Thanks
Leave your response!