Database Design with Microsoft SQL Server
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
- Unlimited Practice exams
- 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 Design with Microsoft SQL Server Expert Trainer with Over 15 Years of Industry Experience
- No. 1 Training Center for Database Design with Microsoft SQL Server Courses
- E-learning Access for Pre-course and Post Training Support
- Best Price Guaranteed for Database Design with Microsoft SQL Server 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 Database Design with Microsoft SQL Server Expert Instructor with Over 15 Years of Industry Experience
- No. 1 Training Center for Database Design with Microsoft SQL Server Courses
- We Guarantee Best Price for Database Design with Microsoft SQL Server 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
ABOUT THE COURSE:
This course will provide you the vital skills in designing and implementing a database using Microsoft SQL Server. This course is designed for beginners who wish to venture in managing database running in Microsoft SQL It covers fundamentals of relational database, database design, Structured Query Language (SQL) and database management and administration.
CERTIFICATION:
Training Certificate will be provided after completing the training
ENTRY REQUIREMENTS:
No Required prerequisite but should have basic computing and computer database skills
COURSE OUTCOME:
After completing this course you will learn how to:
- Learn Database Concepts
- Familiarize MS SQL Server
- Plan and Create Databases
- Learn Constraints and Data Integrity
- Learn Structured Query Language (SQL) and T-SQL
- Retrieve Data with SQL and T-SQL
- Creating Views, Stored Procedures and UDF
- Learn T-SQL Programming
- Understanding Indexes and database Normalisation
- Migrating, Importing and Exporting Database
- Implement Database security
- Back Up and Restore database
EMPLOYMENT OBJECTIVES
Upon completion of the course, trainees will be qualified to be a database administrator, database developer or database architect
COURSE CURRICULUM
Database Design with Microsoft SQL Server Syllabus
CHAPTER 1 - Database Concepts and Introduction of MS SQL Server
- Database and DBMS
- Database Types
- Flat-type databases
- Hierarchical databases
- Relational databases
- Editions of MS SQL Server 2008, 2012, 2014 and 2016
- Installing and Configuring Microsoft SQL Server
- Introduction to SQL Server Management Studio
CHAPTER 2 - Planning and Creating Databases
- Planning Your Database
- Creating a SQL Server database
- Creating tables
- Data types in SQL Server
- Defining Primary keys and Identity Specification
- Inserting, Updating and Deleting records
- Creating default values
CHAPTER 3 - Constraints and Data Integrity
- Introduction of Database Constraints
- Unique Key Constraint
- Primary and Foreign Key Constraint
- Relationships in a Database
- Composite Primary Keys
- Creating Database Diagram
- Referential Integrity
- Setting Cascade Update and Delete
CHAPTER 4 - Structured Query Language (SQL) and T-SQL
- Introduction of SQL and Transact-SQL (T-SQL)
- Introduction of Data Definition Language (DDL)
- USE Command
- Create Databases using T-SQL
- Drop Databases using T-SQL
- Creating, Altering and Removing Tables using T-SQL
- TRUNCATE TABLE Command to delete data
- Commenting and Saving T-SQL
- Introduction of Data Manipulation Language (DML)
- INSERT statements
- UPDATE statements
- DELETE statements
- Difference between DELETE and TRUNCATE
Assessment Exam
CHAPTER 5 - Retrieving Data with SQL and T-SQL
- Using SELECT statements
- Using WHERE for filtering
- Using the NOT operator
- Using the LIKE operator
- Using IS NULL and IS NOT NULL
- Using ORDER BY for sorting
- Using DISTINCT to find unique values
- Concatenating Columns
- Creating Calculated Field
- Limiting Results by using TOP Clause
CHAPTER 6 - Retrieving Data with SQL and T-SQL
- Using SQL Server Built-in Functions
- Using Scalar Functions
- Using Aggregate functions: AVG, MIN, MAX, SUM and COUNT
- Using GROUP BY clause
- SQL HAVING Clause
- SQL UNION and UNION ALL Operators
- SQL EXCEPT and INTERSECT Operators
- Using Subqueries
- Joining multiple tables together
CHAPTER 7 - Creating Views, Stored Procedures and UDF
- Introduction of Views
- Creating Views using T-SQL
- Using View Designer Tools
- Creating User Defined Functions
- Creating Stored Procedures
Assessment Exam
CHAPTER 8 - T-SQL Programming
- Variables
- Control Flow - IF…ELSE
- CASE Statement/Expression
CHAPTER 9 - Database Normalization
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Understanding Indexes
- Introduction of Indexes
- Clustered Indexes
- Non-clustered Indexes
- Creating Indexes
CHAPTER 10 - Migrating, Importing and Exporting
- Generate SQL Scripts
- Import and Export Wizard
- Import Data into SQL Server
- Exporting DataDatabase security
- Introduction of Database Security
- Authentication Methods
- Creating and Managing Logins
- Creating and Managing Database Users
- Using SQL Server Roles
- Managing Permissions
CHAPTER 11 - Backing Up and Restoring
- Introduction of Database Backups
- Types of Database Backup
- Creating backups
- Restoring databases
Assessment Exam
COURSE FEE
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
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!