Key Features
- 3 days Instructor-Led Live Online Classroom
- Webex Virtual Class for interactive near classroom experience
- Access to Remote Lab PC for Hands-On activities
- 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 Developer Expert Trainer with Over 15 Years of Industry Experience
- No. 1 Training Center for Database Courses
- Best Price Guaranteed for Database Courses
Key Features
- 3 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 Certified Database Developer Instructor with Over 15 Years of Industry Experience
- No. 1 Training Center for Database 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 FEEDBACK
ABOUT THE COURSES
This Instructor-led course upgrades your knowledge and skills with databases concepts including database types, database languages, and database designs. It will lay the groundwork to kick start your career in becoming a Database professional
WHO SHOULD ATTEND
This course is for individuals who are moving into a database professional role, or whose role has expanded to include database technologies.
COURSE OUTCOME
After completing this course you will learn the following:
- Key database concepts in the context of SQL Server 2016
- Database languages used in SQL Server 2016
- Data modelling techniques
- Normalization and denormalization techniques
- Relationship types and effects in database design
- Effects of database design on performance
- Commonly used database objects
ENTRY REQUIREMENTS:
This is a fundamental course so it requires only basic computer literacy
OCCUPATIONAL OBJECTIVES
Upon completion of the course, trainees will be qualified to be junior database professional , database developer or database administrator.
COURSE CURRICULUM
Introduction to SQL Databases Syllabus
Chapter 1: Introduction to databases
- Introduction to relational databases
- Other types of database
- Data analysis
- Database languages in SQL Server
Lab : Exploring and querying SQL Server databases
- Describe what a database is
- Understand basic relational aspects
- Describe database languages used in SQL Server
- Describe data analytics
Chapter 2: Data Modelling
- Data modelling
- ANSI/SPARC database model
- Entity relationship modelling
Lab : Identify components in entity relationship modelling
- Understand the common data modelling techniques
- Describe the ANSI/SPARC database model
- Describe entity relationship modelling
Chapter 3: Normalization
- Fundamentals of Normalization
- Normal form
- Denormalization
Lab: Normalizing data
- Describe normalization benefits and notation
- Describe important normalization terms
- Describe the normalization levels
- Describe the role of denormalization
Chapter 4: Relationships
- Introduction to relationships
- Planning referential integrity
Lab: Planning and implementing referential integrity
- Describe relationship types
- Describe the use, types, and effects of referential integrity
Chapter 5: Performance
- Indexing
- Query performance
- Concurrency
Lab : Performance issues
- Discuss the performance effects of indexing
- Describe the performance effects of join and search types
- Describe the performance effects of concurrency
Chapter 6: Database Objects
- Tables
- Views
- Stored procedures, triggers and functions
Lab : Using SQL server
- Describe the use of tables in SQL Server
- Describe the use of views in SQL Server
- Describe the use of stored procedures in SQL Server
- Describe other database objects commonly used in SQL Server
COURSE FEE
(₱20500) Now ₱ 17500
COURSE SCHEDULES
3 days / 8am - 6pm (30hrs)
Next Level Course
Call Us for more information
Tel: (+632) 8285-2936 / (+632) 8736-2032
SMART: 09204282022 / 09603525900
GLOBE: 09773282627 / 09563346864
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!