The main purpose of this course (workshop) is for students to learn how to design and develop SQL databases by listening lectures and practicing them in the tasks given by the trainer. The course is going to be monitored from Microsoft certified experts.
Database design & development using MS SQL Server 2008
Audience:
Curriculum:
Students will learn by doing for:
- Getting Started with Databases and Transact-SQL in SQL Server 2008
- Working with Data Types
- Designing and Implementing Tables
- Designing and Implementing Views
- Designing and Implementing Stored Procedures
- Designing and Implementing User-Defined Functions
- Ensuring Data Integrity through Constraints
- Responding to Data Manipulation via Triggers
- Querying and Filtering Data
- Grouping and Summarizing Data
- Joining Data from Multiple Tables
- Working with Subqueries
- Modifying Data in Tables
- Querying Metadata, XML, and Full-Text Indexes
Duration and Price:
Duration: 3 months, three hrs twice weekly
Price: 80 EUR per month
Registration:
Interested students can contact us by filling up the form below or via telephone.