Alignment:This course covers Microsoft 2778 and more ..
You will get a copy of this book as part of the course Bookings : You can find the course registration form from our home page or by clicking here Duration and Pricing : 5 days full-time (R6995 excl VAT) 5 weeks part-time (2 nights per week, 3 hour sessions) (R7995 excl VAT)
Schedule:On the calender on the page below.Intended Audience:
- This course is for database developers and administrators at beginner level.
- Some familiarity with relational databases and basic SQL might be helpful. Some programming experience might be helpful.
Prerequisites: - Matric
- Although not required, it is highly recommended that you should know DB Design fundamentals well.
Further Training: Certificate: - Upon successful completion of the course, you will qualify for an attendance certificate.
You will also write a test to asses your knowledge of these topics. If you pass this test with 75%, you will get an additional academic certificate.
Course Contents:
Day 1: - Data and Tables - a place for everything
- The SELECT Statement - gifted data retrieval
Day 2:- DELETE and UPDATE - a change will do you good
- Smart table design - why be normal?
- ALTER - Rewriting the past
Day 3:- Advanced SELECT - Seeing your data with new eyes
- Multi-table Database Design - Outgrowing your table
Day 4:- Subqueries - Queries within queries
- OUTER JOINS, SELF JOINS and UNIONS - new maneuvers
- JOINS and multi table operations - Can’t we all just get along?
Day 5:- Constraints, Views and Transactions - Too many cooks spoil the database
- Security - protecting your assets
| 