PPSC Test Preparation for Computer Science Lecturer | Session 2 | Database Systems Part 1 Syllabus, Books, Course Outline. Test Preparation Guideline. #PPSC #PPSCLecturerjobs2020 #ComputerScience. PPSC Lecturer jobs 2020 has been announced in previous week. PPSC test preparation for lecturer computer Sciences was started in many online and physical academies. In First Session OOP was explained in detail.
PPSC Lecture Computer Science Syllabus – Tentative
Peoples are sharing many PPSC computer science past papers with tentative syllabus for the post of lecturer computer Science. Punjab Public Service Commission had not officially announced any Syllabus for PPSC Lecturer Jobs for any subject. Aspirants of PPSC Lecturer jobs 2020 can start their test preparation for the post of lecturer from intermediate syllabus of their subject, graduation and Masters classes syllabus.
Similarly there is no PPSC lecturer Computer Sciences syllabus is announced. We have proposed that as around the globe, subject competency is measured with GAT- Subject Test. Hence PPSC will take Test for Lecture computer Science from GAT- Subject Computer Sciences Syllabus. Secondly we saw the Official PPSC Computer Science syllabus for their PMS exam which we found same for GAT- Subject computer Science. Hence on our personal experience we are working on this tentative PPSC computer science lecturer syllabus discussed in this video. For Test Preparation we have started these session and online computer science MCQs bases quizzes.
PPSC and GAT- Subject Syllabus for Computer Sciences – Database Systems
Basic database concepts; Entity Relationship modelling, Relational data model and algebra, Structured Query language; RDBMS; Database design, functional dependencies and normal forms; Transaction processing and optimization concepts; concurrency control and recovery techniques; Database security and authorization. Physical database design: Storage and file structure; indexed files; b-trees; files with dense index; files with variable length records; database efficiency and tuning.PPSC Computer Science Syllabus – GAT Subject Computer Science – Database System
PPSC Lecturer Computer Science Test Preparation Session 2 – DBMS Part 1
In today’s Test preparation Session we will discuss Database Concepts as per PPSC and GAT- Subject computer science syllabus mentioned.
1. Database definitions 2. Importance of the Databases 3. Databases and Traditional File Processing Systems 4. Advantages of Databases 5. Difference between Data and Information 6. Further Advantages of Database Systems 7. Cost Involved 8. Importance of Data 9. Levels of Data
10. Users of Database Systems 11. Database Architecture 12. The Architecture 13. External View (Level, Schema or Model) 14. Conceptual or Logical View 15. Internal or Physical View / Schema 16. Data Independence 17. Functions of DBMS 18. Database Development Process 19. Preliminary Study 20. Database Development Process: Approach 2
21. Tools Used for Database System Development 22. Data Flow Diagrams 23. Types of DFD 24. Detailed Data Flow Diagram 25. Data Dictionary 26. Database Design Phase 27. Database Management System (CS403) VU 28. Data Model Types of Data Models 29. Types of Database Design 30. Entity-Relationship Data Model
31. The Entity Classification of entity types 32. Attribute 33. Types of Attributes 34. Attributes 35. The Keys 36. Relationships 37. Types of Relationships 38. Roles in Relationships 39. Dependencies 40. Enhancements in E-R Data Model 41. Super-type and Subtypes