Design, Implementation, and Management of Database Systems
LENGTH : 5 days
ABOUT THE COURSE:
This course will cover all the theories, best practices, and practical ways to design, implement and manage systems databases. You will learn and implement advanced database concepts and designs. Configure Database security and interconnectivity with web technologies.
PREREQUISITE:
Basic knowledge of Structured Query Language
Basic knowledge of any Relational Database Management System
TRAINING DELIVERY MODES:
- Classroom Training
- Live Online Training
- 1 on 1 Training
- Corporate Group Training
EMPLOYMENT OBJECTIVES
Upon completion of the course, trainees will be qualified to be a database administrator, database developer or database architect
COURSE CURRICULUM
Course Syllabus
Chapter 1 Database Concept
- Database Systems
- Data Models
Chapter 2 Design Concepts
- The Relational Database Model
- Entity Relationship (ER) Modelling
- Advanced Data Modelling
- Normalization of Database Tables
Chapter 3 Advanced Design and Implementation
- Introduction to Structured Query Language (SQL)
- Advanced SQL
- Database Design
Chapter 4 Advanced Database Concepts
- Transaction Management and Concurrency Control
- Database Performance Tuning and Query Optimization
- Distributed Database Management Systems
- Business Intelligence and Data Warehouse
- Big Data and NoSQL
Chapter 5 Database and the Internet
- Database Connectivity and Web Technol0gies
Lesson 6 Database Administration
- Database Administration and Security
TRAINEE FEEDBACKS
Next Level Course
Virtual/Webex Learning
Take advantage of CNCTC 's latest interactive Instructor-Led Live Online Training. Online Courses are delivered using WebEx to bring the classroom to your home or at your workplace and can be accessed directly on your own computer with an internet connection. By using Cisco’s WebEx, and integrating our Computer lab facilities, we can provide a near-classroom experience remotely to your own location of choice. Register Now!