Database & SQL Training

nrclc_certImprove your knowledge and skills with Database training at the NR Computer Learning Center’s Certification Boot-camp.  Our fast paced Boot-camp program is recommended for busy professionals and recent graduates looking for an edge in the workplace.  Here at the NR Computer Learning Center Certification Boot Camp, students receive thorough hands-on training from industry professionals.  Job-seekers and professionals can complete the time-saving and informative program to help pass the Database Certification exam.

Database Design

Introduction to Database Design

In this course, the students will learn to design a database based on the requirements document.  The students will learn about the phases of building a data model from requirements document. The students will learn the database concepts, such as entity, attribute, constraints, relationships, normalization and entity-relationship model. The students will also learn the basics of SQL language to implement a database with a table, view, index, and constraints.

Prerequisite: Knowledge of computer basic or equivalent.

Technology: Microsoft SQL Server

Topic:

  • Introduction to Relational Database Management System (RDBMS)
  • Introduction to Database Architecture
  • One-tier Architecture
  • Client/Server Architecture
  • N-Tier Architecture
  • Understanding Requirement analysis phase
  • Understanding data requirements
  • Identifying supporting data and business rule
  • Ten step process from requirement to developing a data model
  • Designing a database
  • Identifing  Entities, Attributes and Relationships
  • Identify Key Attributes, Candidate, Primary, and Foreign
  • Database Normalization
  • Entity -Relationship DesignIns
  • Installing & Configuring a Database
  • Starting a Database
  • Implementing a database
  • Creating table, View, and Index
  • Adding constraints
  • Using Queries
  • Importing Sample Database
  • Introduction to Stored Procedure
  • Introduction to Trigger and Functions
  • Database Certification Exam Overview: MTA, CIW, and Oracle
  • Lab 1: School Database
  • Lab 2: BookStore Database
  • Lab 3: Personal Database
  • Lab 4: Student Database
  • Lab 5: Flight Database
  • Lab 6: Category Database
  • Lab 7: AdeventureWorks Database
  • Lab 8: Clothing Department Store

SQL Language

Introduction to SQL Language

The students will learn to write a simple to complex SQL queries to add, delete, update, edit, sort and search data in a database. SQL is an ANSII-standard database query language that used for managing data using either the ad-hoc query or through embedding it into an application. It is also used for analyzing data and generating business reports.

Prerequisite: Introduction to Database Design.

Technology: Microsoft SQL Server

Topics:

  • Introduction to SQL Language
  • Data definition language (DDL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Various DataType
  • Creating/dropping Table
  • Constraints: Primary Key & Foreign Key
  • More Constraint: Unique, Check, Default, Not Null
  • Drop and Create Index
  • Drop and Create a View
  • Using Index & Views
  • Alter command
  • Insert, Select, Update and Delete Command
  • Difference between Truncate and Delete
  • Relational Algebra: Selection, Projection, Cartesian Product
  • Union, Difference
  • Joins: Simple, Inner, outer, left, right, cross
  • Grant/Revoke Command
  • Logical Operator
  • Using Expression in Select statement
  • Using Null, Like, Update
  • Using subquery
  • Using Update, Delete & Insert Command
  • Database Certification Overview; MTA, CIW & Oracle
  • Lab 1: Supplier, Course, Student Database
  • Lab 2: Student Record Database
  • Lab 3: Books Database
  • Lab 4: Contacts Database
  • Lab 5: Warehouse
  • Lab 6: Inventory Database
  • Lab 7: T-SQL: Script to Display data

Database Scripting

Database Scripting: SQL, T-SQL, Stored Procedure & Functions

The students learn to develop a script using Microsft/Sybase procedural language known as T-SQL (Transact-SQL) to develop Stored Procedures and Functions. T-SQL is an extended form of SQL that allows users to add extra programming functionalities and control, such as, error handler.

Prerequisite: Introduction to SQL.

Technology: Microsoft SQL Server

Topics:

  • SQL Server Tables and Data Overview
  • Data Validations and Constraints
  • Introduction to Stored Procedure
  • Types of Stored Procedures
  • Defining Variables and Parameters
  • Input and output parameters
  • System level Stored Procedures
  • Building Dynamic SQL
  • Creating and calling Stored procedure
  • Renaming and dropping Stored procedure
  • Declaring, opening and closing a cursor
  • Introduction to User Defined Functions
  • System level functions
  • Date and Time functions
  • Introduction to Triggers
  • developing database and Server Triggers
  • Bulk operation Stored Procedures and Triggers
  • Cursor declaration
  • Cursor Life Cycle
  • Database Certification Overview: Microsoft
  • Lab 1: Supplier, Course, Student Database
  • Lab 2: Student Record Database
  • Lab 3: Books Database
  • Lab 4: Contacts Database
  • Lab 5: Warehouse
  • Lab 6: Inventory Database

MTA 98-364

MTA 98-364: Database Administration Fundamentals Certification Exam

NR Computer Learning Center (NRCLC) offers hands-on training to help students gain the fundamental knowledge and skills required to manage a Microsoft database. Students will learn the database design concepts, creating database objects, managing data, using SQL statement, using T-SQL, developing Stored Procedure and administrating a database.This course will help students prepare for MTA 98-364 exams. Click here for more information.