Syllabus of DBMS Using My SQL course
Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.
Brief Syllabus:
- Introduction to RDBMS
- Database terminology, table, field, record, Making database, making tables, entering and editing data
- Searching, Sorting & Filtering
- Making Form, Reports
- Introduction to SQL, Concept of query
- Using different types of Query
- Transaction processing
- Backup and Database security