Course Outline

Module 1: Understanding Relational Databases
This module explains how use relational databases. It explains entities and attributes, and describes relationships.
 

Lessons

•  SQL Server and Transact-SQL
•  Relational Database Concepts
•  Accessing Relational Data

Lab : Understanding Relational Databases

•  Identifying Entities, Attributes, and Relationships

After completing this module, students will be able to:

•  Identify relational database concepts
•  Explain the first 3 normal forms
•  Use tools to access SQL Server Data

 

Module 2: Retrieving Simple Data
This module explains how query SQL Server data using SELECT statements. It also discusses how to format results sets.
 

Lessons

•  Simple SELECT Statements
•  Restricting Rows
•  Formatting Output

Lab : Writing Simple Queries

•  Writing SELECT Statements.
•  Using the WHERE Clause
•  Formatting Results

After completing this module, students will be able to:

•  Write basic SELECT statements
•  Restrict results with the WHERE clause
•  Use column aliases
•  Sort results with the ORDER BY clause

 

Module 3: Complex Data Retrieval
This module explains how to create results sets using joins.
 

Lessons

•  Using INNER JOINS
•  Using OUTER JOINS
•  Other Methods of Combining Data

Lab : Using Joins

•  Inner Joins
•  Outer Joins
•  Other Types of Joins

After completing this module, students will be able to:

•  Combine related data using INNER and OUTER JOINS
•  Use CROSS JOINS and self-joins
•  Use the UNION operator

 

Module 4: Summarizing Data
This module explains how summarizes data using GROUP BY. It also discusses aggregate functions and the PIVOT and UNPIVOT operator.
 

Lessons

•  Using Aggregates
•  Summarizing Results Sets

Lab : Summarizing Data

•  Using simple aggregate functions
•  Using GROUP BY
•  Using COMPUTE BY

After completing this module, students will be able to:

•  Understand how to summarize data
•  Use aggregate functions
•  Use GROUP BY
•  Use COMPUTE BY

 

Module 5: Modifying Data
This module explains how to modify data using INSERT, UPDATE, and DELETE.
 

Lessons

•  Inserting Data
•  Deleting Data
•  Updating Data

Lab : Data Modification

•  Using the INSERT Statement
•  Using the DELETE Statement
•  Using the UPDATE Statement

After completing this module, students will be able to:

•  How data modification works
•  How to modify data with INSERT, UPDATE, and DELETE

 

Module 6: Using Database Objects
This module explains how to use views, stored procedures, and functions. It also describes their purpose and how to handle parameters and return values.
 

Lessons

•  Introduction to Database Objects
•  Using Views
•  Calling Stored Procedures
•  Using Functions

Lab : Using Database Objects

•  Using Views
•  Using Stored Procedures
•  Using Functions

After completing this module, students will be able to:

•  Create and use views
•  Call stored procedures
•  Pass parameters into stored procedures and use output parameters
•  Return data from functions

 

Module 7: Advanced Queries
This module explains how to use conditional logic, transactions, and error handling.
 

Lessons

•  Using Conditional Logic
•  Handling Errors
•  Using Transactions

Lab : Creating Advanced Queries

•  Use Conditional Logic
•  Create Transactions

After completing this module, students will be able to:

•  Use CASE and IF logic
•  Use TRY/CATCH logic to handle errors
•  Use transaction to maintain data integrity

 

Module 8: Accessing Data with Microsoft Office 2007
This module explains how to work with SQL Server Data in Excel. Word, and Access.
 

Lessons

•  Using Data with Microsoft Excel 2007
•  Using Data with Microsoft Access 2007
•  Using Data with Microsoft Word 2007 (Optional)

Lab : Accessing Data with Microsoft Office

•  Import SQL Server Data into Excel 2007
•  Link to SQL Server Tables from Access 2007
•  Do a Mail Merge Using Word 2007 (Optional)

After completing this module, students will be able to:

•  Import data into Microsoft Excel 2007
•  Use Microsoft Access 2007 to create reports from SQL Server data
•   Perform a Mail Merge from Microsoft Word 2007 using SQL Server data

 

Trajanje: 2 dni

Lokacija: Housing Co., d.o.o., Vodovodna 100, SI-1000 Ljubljana

Cena: 690,00 + DDV

ZA NLT ČLANE BREZPLAČNO

 

Termini

• 15.09.2011 -> 19.09.2011

Prijava na tečaje je možna samo za registrirane uporabnike.