
- 4 days Instructor-Led Face to Face Classroom training
- We are a TESDA Registered Training Center
- Offering Flexible Schedules – Both Weekdays and Weekends Classes
- Get Trained by a certified Expert Instructor with Over 15 Years of Industry Experience
- In-House MTA Testing Facility
- No. 1 Training Center for Database Administration Courses
- We Guarantee the Best Price for Database Courses
- 4 days Instructor-Led Live Online Classroom
- Webex Virtual Class for interactive near-classroom experience
- Access to Remote Lab PC for Hands-On activities
- Unlimited Practice exams
- In-House MTA Testing Facility
- Integrated Courseware in the Learning Management System
- Step by Step guide for challenging hands-on lab activities
- Flexible Schedules – Both Weekdays and Weekends Classes
- Get Trained by Database Certified Expert Trainer with Over 15 Years of Industry Experience
- No. 1 Training Center for Database Administration Courses
- E-learning Access for Pre-course and Post-Training Support
- Best Price Guaranteed
- Gain the technical skills needed in the workplace. 1 on 1 training is the best way to learn
- The quickest way to master any of our course offerings.
- Experience superb hands-on laboratory activities and unobstructed attention from your trainer.
- Guaranteed to start the Training
TRAINEE FEEDBACKS
ABOUT THE COURSE:
This instructor-led course upgrades your knowledge and skills with databases, including relational databases such as Microsoft SQL Server or Windows Azure SQL Database. It covers core database concepts and implementing security for databases such as objects, tables, and views, graphical tools, and T-SQL scripts
WHO SHOULD ATTEND
This course is for organizations and individuals who are looking to administer, set up, install, maintain, secure, and support a database management system
Certification Exam:
Exam 98-364 Database Administration Fundamentals
Prerequisite:
Familiarity with basic database concepts and minimal hands-on experience with database technologies
EMPLOYMENT OBJECTIVES
Upon completion of the course, trainees will be qualified to be a Junior Database Administrator
Database Administration Fundamentals Syllabus
Chapter 1: Understanding Core Database Concepts
- Understanding Database Concepts
- Understanding Flat-Type Databases
- Understanding Hierarchical Databases
- Understanding Relational Databases
- Understanding Database Fundamentals
- Understanding Relational Database Concepts
- Using the SQL Server Management Studio Interface
- Understanding Data Manipulation
- Language (DML)
- Understanding Data Definition Language (DDL)
- Using DDL Statements
Chapter 2: Creating Database
- Defining Data Types
- Using Built-in Data Types
- Using Exact Numeric Data Types
- Using Approximate Numeric Data Types
- Creating and Using Tables
- Creating Views
- Creating Stored Procedures
- Understanding SQL Injections
Chapter 3: Manipulating Data
- Using Queries to Select Data
- Combining Conditions
- Using the BETWEEN Clause
- Using the NOT Clause
- Using the UNION Clause
- Using the EXCEPT and INTERSECT Clauses
- Using the JOIN Clause
- Using Queries to Insert Data
- Inserting Data
- Updating Data and Databases
- Using the UPDATE Statement
- Deleting Data
- Using the DELETE Statement
- Truncating a Table with TRUNCATE TABLE
- Deleting a Table with DROP TABLE
- Using Referential Integrity
Chapter 4: Understanding Data
- Normalizing a Database
- Understanding Normalization
- Understanding the First Normal Form
- Understanding the Second Normal Form
- Understanding the Third Normal Form
- Understanding the Fourth Normal Form
- Understanding the Fifth Normal Form
- Understanding Primary Keys
- Understanding Foreign Keys
- Understanding Composite Primary Keys
- Understanding Clustered and Non-clustered
- Understanding Clustered Indexes
- Understanding Non-clustered Indexes
- Creating a Non-clustered Table
Chapter 5: Administering a Database
- Securing Databases
- Understanding Server-Level Security
- Understanding Database-Level Security
- Understanding Windows Security
- Understanding SQL Authentication
- Understanding Database Server Roles
- Granting Access to a Database
- Understanding Fixed Database Roles
- Understanding Object Permissions
- Managing Roles
- Understanding Ownership Chains
- Reviewing a Sample Security Model
- Backing Up and Restoring Databases
- Understanding Recovery Models
- Understanding Database Backups
- Understanding Backup Devices
- Understanding Database Restores
COURSE FEE
COURSE SCHEDULES
4 days / 9am - 5pm (32hrs)

Call Us for more information
Tel: (+632) 8285-2936 / (+632) 8736-2032
SMART: 09603525899 / 09603525900
GLOBE: 09665816139
GET STARTED
Request Course Quotation
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 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 location of choice. Register Now!
FAQ
You earn Microsoft Technology Associate (MTA) certification by passing Exam 98-364: Database Fundamentals.
The Exam cost for Exam 98-364: Database Fundamentals certification when taking your exam in the Philippines is USD69.
You can take this exam at any Authorized Pearson Vue Test Center. You can take your Exam at CNCTC, Inc if you are in the Philippines
Yes, This exam will be retired on June 30, 2022