- Lecture 1: introduction. What is a database management system.
Lecture 1, pdf 6 slides to a page
Lecture 1 ppt - Lecture 2: relational algebra.
Lecture 2, pdf 6 slides to a page
Lecture 2 ppt - Lecture 3: relational data integrity.
Lecture 3, pdf 6 slides to a page
Lecture 3 ppt - Lecture 4: Entity-relationship modelling.
Lecture 4, pdf 6 slides to a page
Lecture 4 ppt - Lecture 5: From ER diagrams to tables; creating database tables in SQL.
Lecture 5, pdf 6 slides to a page
Lecture 5 ppt - Lecture 6: Changing tables, inserting tuples; SELECT statements.
Lecture 6, pdf 6 slides to a page
Lecture 6 ppt - Lecture 7: SELECT statements.
Lecture 7, pdf 6 slides to a page
Lecture 7 ppt - Lecture 8: more SELECT; nested queries.
Lecture 8, pdf 6 slides to a page
Lecture 8 ppt - Lecture 9: more SELECT; order by, group by, having.
Lecture 9, pdf 6 slides to a page
Lecture 9 ppt - Lecture 10: NULLs.
Lecture 10, pdf 6 slides to a page
Lecture 10, ppt - Lecture 11: Normalisation (1NF, 2NF,3NF).
Lecture 11, ppt - Lecture 12: Relational algebra revision, lossless decomposition, BCNF
Lecture 12, pdf 6 slides to a page
Lecture 12 ppt - Lecture 13: Physical DB issues, indexing, query optimisation.
Lecture 13 ppt - Lecture 14: Transactions and recovery.
Lecture 14, pdf 6 slides to a page
Lecture 14 ppt - Lecture 15: Concurrency control: using locks.
Lecture 15, pdf 6 slides to a page
Lecture 15 ppt - Lecture 16: Deadlock. Timestamping protocol.
Lecture 16, pdf 6 slides to a page
Lecture 16 ppt - Lecture 17: Security and Integrity.
Lecture 17, pdf 6 slides to a page
Lecture 17 ppt - Lecture 18: `Modern' datatbases.
Lecture 18 ppt
Lecture 18 pdf one slide to a page - Lecture 19: Revision.
Lecture 19 pdf one slide to a page - Lecture 20: Java and SQL.
Lecture 20 pdf one slide to a page
Free download PPT,PDF,HTML, Video Lectures, Presentation, MCQs and seminars of Computer Science, Web Design & Development, Programming, Networking, Software Engineering, Databases,System Analysis and Design, Software Project Management,Operating system, Algorithm, Data Structure, Numerical Method,Computer Communication, Data Mining, Machine Learning, Graphic design, C & C++ and more Education etc.
Database System Lectures
(Click to Download Slides)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment