All Courses
Call Us (02) 8285-2936

CNCTC, Inc.

Your IT Career Starts Here. We build Achievers

T: (02) 8285-2936 / (02) 8351-1431 / 8736-5196
SMART: 09073576583 / 09993302327
GLOBE: 09776468236 / 09776932556

Email: cnctcinc@yahoo.com

CNCTC, Inc
Rm 210 Dona Amparo Bldg., Espana Blvd. corner G. Tolentino St. Sampaloc Manila

  • Home
  • About Us
  • All Courses
    • CISCO Training
      • CCNA Bootcamp
      • CCNP Enterprise Bootcamp
      • CCNP – ENCOR
      • CCNP – ENARSI
      • CCNP Security Bootcamp
      • CCNP – SCOR
      • CCNP – SSNGFW
    • SQL Databases
      • Introduction to SQL Databases
      • Querying Microsoft SQL Server
      • Database Design with Microsoft SQL Server
      • Database Administration Fundamentals
      • Administering Microsoft® SQL Server® 2014 Databases
      • Administering a SQL Database Infrastructure
      • Oracle Databases PL/SQL Language References
    • Python Programming
      • Python Programming for Beginners
      • Django Python Framework Bootcamp
    • Microsoft .NET Programming
      • Developing ASP.NET Core MVC Web Applications
      • Microsoft VISUAL BASIC.NET 2015
      • Programming with C# for Beginners
    • Java Programming
      • Java Programming Bootcamp – Complete Introduction
      • Java Spring Framework
    • PHP and MySQL
      • PHP & MySQL Programming
      • Laravel PHP Framework Programming
    • COMPTIA Courses
      • COMPTIA A+ Essentials and Practical application
      • COMPTIA Network+ bootcamp
      • CompTIA Security+
      • CompTIA CySA+
      • CompTIA Linux+
    • Linux Courses
      • LPIC-1 Linux Professional Bootcamp
      • LPIC-2 Linux Professional Bootcamp
      • Red Hat System Administration I
      • Red Hat System Administration II
      • Red Hat Certified System Administrator Bootcamp (Fast Track)
    • TESDA CSS NCII
      • PC Assembly, Hardware and Software Troubleshooting/Repair and Data Recovery w/ OJT
      • PC Networking and Administration
      • TESDA CSS NCII
    • Microsoft Office 365
      • MS-Word, Excel, Power point and Internet For Beginners
      • Microsoft Power BI Training
      • Microsoft Excel for Intermediate
      • Microsoft Excel for Advanced
      • Advanced Data Analysis using Excel
    • Microsoft Azure
      • Microsoft Azure Fundamentals
      • Microsoft Azure Administrator Associate
    • Microsoft Active Directory
      • Windows Server 2019 Administration
      • MCSA – Windows 2016 Server Bootcamp
    • VMware
      • VMware Certified Technical Associate – Data Center Virtualization 2021
      • VMware Certified Professional – Network Virtualization 2021
    • ITIL
      • ITIL Foundation v4
    • Mobile App Development
      • Android App Development Bootcamp
      • iOS App Development Bootcamp
    • Web Design and Dev
      • Vue.JS Application Development Fundamentals
      • JavaScript & JQuery for Beginners Training
      • Web Design with HTML and CSS
      • Web Design with WordPress (CMS) Training Course
    • Adobe Graphics Design
      • Adobe Photoshop CC
      • Adobe Illustrator CC
      • Adobe InDesign CC
      • Adobe Animate CC
    • Amazon Web Services
      • AWS Certified Solutions Architect – Associate
      • AWS Certified Cloud Practitioner Bootcamp
    • View All Courses
  • Schedules
  • Live Online Training
  • Enroll Now
    • Enroll a Course
    • Reserve a Course
    • Manage Reservations
    • Testing Center
    • Career Center
    • Our Clients
    • Verify Certificate
    • Evaluate Us
    • Facilities
    • Testimonials
  • Contact Us
GETQuotation
  • Home
  • Databases SQL
  • Database Administration Fundamentals
May 8, 2022

Database Administration Fundamentals

by CNCTC / Wednesday, 04 December 2019 / Published in Databases SQL
Database Design
Live Online
Classroom
1 on 1

Key Features

  • 5 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

Key Features

  • 5 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 Database 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 Best Price for Database Courses

Key Features

  • Gain the technical skills needed in the workplace. 1 on 1 training is the best way to learn
  • 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

Natuto ako ng matiwasay, 100% na alam n’ya yung bawat tinuturo sya sa amin.

Paolo Comida
Metro Manila

I switched career, from a boring accounting job, into an IT career, the training I received from CNCTC help me a lot into settling down on my new chosen career, now am working abroad as a system specialist….ganda pa ni Ma’am Rose sa makati campus:)

Felix
Makati City

We’ve just finished our training with CNCTC, and we’re looking forward in enrolling in another class with them! KUDOS! (lots and lots of it) 🙂

AreCee
Metro Manila

Kudos to our trainer who taught us the best methods of programming in the most efficient way.

We thank you for this training. We have learned a lot in Microsoft VB.Net programming. Godbless CNCTC, Inc.

HOMER CAESAR JUBILO

maraming salamat po sa lahat ng knowledge na shinare nyo, di po kayo nagdamot na ibigay ung mga natutunan nyo…Hanga po ako sa galing nyo,,,saludo po…Makakatulong po ito ng malaki sa akin at sa trabaho ko,sana po marami pa kaung matulungan,,,salamat po…saludo po…

Ronald Magpantay
Central Luzon

Very approachable Trainer/mentor and very good teaching skills well prepared about the training subject

Jared Tolentino
distriphil

Feedback The Instructor is very accommodating. I dont have any hesitation to ask if I have some questions. I have learned a lot. Keep up the good work!

Joel Fuentebella
Mandaluyong City

One of the Best IT training provider. I really like the hands on instructions and my trainer was great in all aspects. Kudos!

Samantha Bautista
Caloocan City

Training at CNCTC is memorable and it’s worth the cost. Theories combined with real-life and industry-based application will really equip you in your field of specialization in IT. The Trainer plays an essential role in uplifting the quality of training at CNCTC. No dull moments. He masters his craft. He has a wide array of industry experience and the wit and wisdom to keep the hands-on training lively and beneficial to trainees. Thanks Sir for the knowledge, skills, and attitude you’ve imparted with us. Your labor for us is not wasted… WE LOOK FORWARD TO TRAINING SOON AT CNCTC IN OTHER TOPICS… MORE POWER TO YOU!

Raymond Cabrera
Central Luzon

Trainor is evidently highly skilled and is a master of the subject matter.

Byron Joseph Hallar
Mariano Marcos State University

I’ve learned a lot of things. I’ve never expected that the training would be like this. Its more than what I expected. Good job to the trainer!

Ronald Vargas
Metro Manila

The trainer is very knowledgeable to the subject and his teaching can be categorized as expert level.

Computers and software are well provided. The area is comfortable and the staff is friendly and entertains all our needs.

MICHAEL MERCADO

Very approachable teacher/mentor and very good teaching skills well prepared about the training subject

Jared Tolentino
Distribution Solutions Phils., Inc

Excellent Instructor and excellent in communicating with the students and in teaching.

Deneb Corilla
Metro Manila

It’s a knowledgeable training course. the trainer is very good and approachable. Very interesting. I can recommend this training center to any of my friends.

Annife Degamo
Cubao Quezon City

I switched career, from a boring accounting job, into an IT career, the training I received from CNCTC help me a lot into settling down on my new chosen career, now am working abroad as a system specialist…. ganda pa ni Ma’am Rose sa Makati campus:)

Felix
Makati City

My training at CNCTC beefed up my credentials to get to where I am now, a Chief of Systems Management at a government office.

Mario Tuscan N. Naz
Mandaluyong City

My training at CNCTC beefed up my credentials to get to where I am now, a Chief of Systems Management at a government office.

Mario Tuscan N. Naz
Mandaluyong City

What I like here in CNCTC is that even though the training is somewhat fast, i was able to learn alot in just a short period of time. Also the fee in the training is not that expensive compare to other training centers.

CARLA JEAN PINILI
Metro Manila

A good learning center. More power and keep up the good work!!

john paul bromeo
Paranaque City

Excellent Instructor. Answers clearly all questions raised.

NELSON GATBUNTON
Makati City

Done great Sir Amed! thanks for the knowledge!

John Dominick A. Agarin
Makati City

Kudos to the Trainer for being patient and understanding of his students’ proficiency on the entire course. Thank you.

Melissa Jolinda Lucas
Professional Regulatory Commission

Add Feedbacks

Request a Quote
Course Schedules

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, setup, 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

COURSE CURRICULUM

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

(₱14500) ₱ 12500
(USD302) USD 260

COURSE SCHEDULES

Current Month
Instructor-Led Live OnlineTraining or Classroom Training

sun08may(may 8)9:00 amsun29(may 29)3:00 pmDatabase Administration FundamentalsSQL Server9:00 am - 3:00 pm (29)

Database Fundamentals

Date and Time

8 (Sunday) 9:00 am - 29 (Sunday) 3:00 pm

Training Mode

Instructor-Led Live Online

Training or Classroom Training

Health Guidelines for Face to Face Classroom Training

Masks Required
Temperature Checked At Entrance
Physical Distance Maintained
Classroom Area Sanitized

Schedules

View All

Course Details

Learn More

Enroll Now

CalendarGoogleCal

Instructor-Led Live OnlineTraining or Classroom Training

sat14may(may 14)9:00 amsat11jun(jun 11)3:00 pmDatabase Administration FundamentalsSQL Server9:00 am - (june 11) 3:00 pm

Database Fundamentals

Date and Time

May 14 (Saturday) 9:00 am - June 11 (Saturday) 3:00 pm

Training Mode

Instructor-Led Live Online

Training or Classroom Training

Health Guidelines for Face to Face Classroom Training

Masks Required
Temperature Checked At Entrance
Physical Distance Maintained
Classroom Area Sanitized

Schedules

View All

Course Details

Learn More

Enroll Now

CalendarGoogleCal

Instructor-Led Live OnlineTraining or Classroom Training

sat28may(may 28)9:00 amsat25jun(jun 25)3:00 pmDatabase Administration FundamentalsSQL Server9:00 am - (june 25) 3:00 pm

Database Fundamentals

Date and Time

May 28 (Saturday) 9:00 am - June 25 (Saturday) 3:00 pm

Training Mode

Instructor-Led Live Online

Training or Classroom Training

Health Guidelines for Face to Face Classroom Training

Masks Required
Temperature Checked At Entrance
Physical Distance Maintained
Classroom Area Sanitized

Schedules

View All

Course Details

Learn More

Enroll Now

CalendarGoogleCal

Instructor-Led Live OnlineTraining or Classroom Training

sun29may(may 29)9:00 amsun19jun(jun 19)3:00 pmDatabase Administration FundamentalsSQL Server9:00 am - (june 19) 3:00 pm

Database Fundamentals

Date and Time

May 29 (Sunday) 9:00 am - June 19 (Sunday) 3:00 pm

Training Mode

Instructor-Led Live Online

Training or Classroom Training

Health Guidelines for Face to Face Classroom Training

Masks Required
Temperature Checked At Entrance
Physical Distance Maintained
Classroom Area Sanitized

Schedules

View All

Course Details

Learn More

Enroll Now

CalendarGoogleCal

Next Level Course

Querying Microsoft SQL Server

Call Us for more information

Tel: (+632) 8285-2936 / (+632) 8736-2032

Smart: 09073576583 / 09993302327

Globe: 09776468236 / 09776932556

GET STARTED

Request Course Quotation

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!

Contact Us for a Demo

FAQ

How to become database Certified?

You earn Microsoft Technology Associate (MTA) certification by passing Exam 98-364: Database Fundamentals.

How much is the Exam Cost of Database Fundamentals certification?

The Exam cost for Exam 98-364: Database Fundamentals certification when taking your exam in the Philippines is USD69.

Where to take the Database Fundamentals Exam?

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

Does MTA Database Fundamentals certification expires?

Yes, This exam will be retired on June 30, 2022

Popular Courses

  • A+
  • Network+
  • CCNA
  • CCNP
  • TESDA
  • Windows Server 2019 Administration
  • Linux
  • PHP
  • SQL Server
  • Java
  • Azure
  • Python
  • Database Administration Fundamentals

News and Articles

  • Career Center
  • News and Articles
  • Certification Exam Fees
TESDA
Pearson Vue Test Center
Facebook
blank
Verify Certificate
blank


CNCTC, Inc.: Main Office: 2nd Flr. Dona Amparo Bldg Espana Blvd. corner G Tolentino St. Sampaloc, Manila 1008 Philippines
22+ years In Greater Metro Manila Area

Branch Office: 101C 18th Avenue Corner P Tuazon Ave. Cubao Quezon City

Email: cnctcinc@yahoo.com  Call Us: (02)  8285-2936 |(02) 8351-1431 | 09993302327 | 09776932556   

ABOUT CNCTC

blank

Based in the University belt Area of Manila. CNCTC is a TESDA registered training center serving the IT Training needs of thousands of successful IT professionals and corporate clients from around the world. For the past 20 years of its operations, CNCTC provided superior quality of training and service to all. [Read More] 

FIND YOUR CLASS

blank
blank

Courses Offered


blank

Learning Methods


blank

Testing Center


COURSE CATEGORIES

  • CCNA Courses
  • CCNP Courses
  • TESDA CSS NCII
  • CompTIA
  • Linux
  • Microsoft Certifications
  • Microsoft .NET
  • Databases SQL
  • Java
  • Amazon Web
  • Azure Programming
  • PHP Programming
  • Python
  • ITIL Courses
  • VMware
  • C# Programming
  • Microsoft Office
  • Graphics Design
  • Mobile App Development
  • Network Security
  • PMP Certification
  • Web Design
  • GET SOCIAL
CNCTC, Inc.

Terms and Conditions | Privacy Policy
Copyright © 2000-2021. All rights reserved. | www.cnctc.edu.ph

TOP
X