Database Systems Using SQL Server

This course will enable IT professionals not only to learn how to come up with good database design on theory but also to implement their design in practice and code T-SQL to retrieve and/or update data stored in SQL Server tables.

Course Outline

After participating in this course, you will be able to:

• Implement basic database design principles in SQL Server
• Differentiate between view, stored procedures and user-defined functions
• Develop database applications for SQL Server databases with Transact-SQL
• Write Transact-SQL queries that retrieve or modify data by using fundamentals learnt in the course
• Manage concurrency using transactions and locking options

Description

Database Design is the database structure that will be used as plan to store and manage data. The database management system (DBMS) is the software used to implement a database design. Microsoft SQL Server is a computer application used to create desktop, enterprise, and web-based database applications. It is used at different levels and with various goals.

Good application programs can't overcome bad database designs. The existence of a DBMS does not guarantee good data management, nor does it ensure that the database will be able to generate correct and timely information. Ultimately, the end user and the designer decide what data will be stored in the database. Good database design avoids redundant data (unnecessarily duplicated data) since poorly designed database generates inconsistent data  (inaccurate data) that leads to bad decisions  which can lead to failure of organization.

The first day will focus on database design, normalization, using Management Studio, creating tables, indexes and Queries.  Second day will focus on joins, sub queries, views, data manipulation, stored procedures and user-defined functions. There will be two workshops in the two days incorporates significant learn-by-doing exercises including but not limited to ERD Design, Queries, Joins, Subqueries, data modifications, stored procedure and user-defined function.

This course will enable IT professionals not only to learn how to come up with good database design on theory but also to implement their design in practice and code T-SQL to retrieve and/or update data stored in SQL Server tables. This course provides the technical skills required to implement a database solution with Microsoft® SQL Server"¢ client/server database management system.

Course Objective
1. Database Design
2. Create databases
3. Create tables/indexes
4. Implement data integrity in Microsoft SQL Server 2005 databases by using constraints
5. Implement views
6. Implement stored procedures
7. Implement functions
8. Manage transactions and locks

Who should attend

This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.  Attendees include but not limited to  developers: SQL and Transact-SQL, database administrators, analysts and report authors.

Program Outline

• Welcome, Introduction, Workshop Preview, Learning Outcomes and the Assessment Method
• Database Systems
• Data Models
• Entity Relationship (ER) Modeling
• Normalization
• SQL Server Overview
• Using Management Studio
• Introduction to Structured Query Language (SQL)
• Tables, Indexes (Primary Key, Foreign Key, ..)
• Queries
• Merging Data with Joins & Unions
• Introducing Sub-Queries
• Aggregating Data
• Data Views
• Data Manipulation
• T-SQL and Stored Procedure
• User-Defined Functions
• Introduction to Locking and Concurrency
• Questions and Answers and Feedback to Participants on Achievement of Learning Outcomes

Daily Schedule
8:00    Registration and Coffee (1st Day only)
8:30    Session begins
12:00  Lunch
4:30    Adjournment

There will be a one hour lunch break in addition to a refreshments and networking break during each morning and afternoon session.

Faculty

Shady Shehata PhD in Computer Engineering , is a  Senior Software Developer  in Desire2Learn Inc. He has over 11 years in experience in Java Technologies  and Database Systems. He is also a present member of   IEEE, ACM, AIS and has served on Chairing of Software Conferences.        

Additional Details

Pre-Requisites

Certificates offered

1.2 CEU / 12 PDH

Cancellation Policy

To withdraw from a course, you must send a request, in writing, with the official receipt to our office. Fifteen or more business days in advance: full refund less $50.00 administration charge. Five to fifteen business days in advance: non-refundable credit of equal value for any future EPIC seminar within one year. Credits are transferable within your organization. In case of an unexpected event occurring after this time, you may send someone else to take your place without any additional cost.

Map & Reviews

EPIC Educational Program Innovations Center
[ View Provider's Profile ]

Reviews

 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.

   

Would have liked more interactive problem solving.

Reviewed by Allen A. 2011