writing queries using microsoft sql server 2008 transact-sql (Certificate)

New Horizons Learning Center Philippines
Alabang, Makati City, Marikina City, Philippines

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' this course provides students with the technical skills required to write basic transact-sql queries for microsoft sql server 2008.

who should attend:
this course is intended for sql server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

at course completion:
after completing this course, students will be able to: - describe the uses of and ways to execute the transact-sql language. - use querying tool. - write select queries to retrieve data. - group and summarize data by using transact-sql. - join data from multiple tables. - write queries that retrieve and modify data by using subqueries. - modify data in tables. - query text fields with full-text search. - describe how to create programming objects. - use various techniques when working with complex queries.

prerequisite comments:
relational database design skills
programming skills
knowledge of data integrity concepts.
core windows server skills


outline: top
lesson 1: getting started with databases and transact-sql in sql server 2008
overview of sql server 2008
overview of sql server databases
overview and syntax elements of t-sql
working with t-sql scripts
using t-sql querying tools
top
lesson 2: querying and filtering data
using the select statement
filtering data
working with null values
formatting result sets
performance considerations for writing queries

lesson 3: grouping and summarizing data
summarizing data by using aggregate functions
summarizing grouped data
ranking grouped data
creating crosstab queries

lesson 4: joining data from multiple tables
querying multiple tables by using joins
applying joins for typical reporting needs
combining and limiting result set

lesson 5: working with subqueries
writing basic subqueries
writing correlated subqueries
comparing subqueries with joins and temporary tables
using commonexpressions
top
lesson 6: modifying data in tables
inserting data into tables
deleting data from tables
updating data in tables
overview of transactions

lesson 7: querying metadata, xml, and full-text indexes
querying metadata
overview of xml
querying xml data
overview of full-text indexes
querying full-text indexes

lesson 8: using programming objects for data retrieval
overview of views
overview of user-defined functions
overview of stored procedures
overview of triggers
writing distributed queries

lesson 9: using advanced querying techniques
considerations for querying data
working with data types
cursors and set-based queries
dynamic sql
maintaining query files
...''

Elements of this syllabus are subject to change.

Phone:(63)2-859-2801

School Address:

CEO Suite, Level 37
LKG Tower
Ayala Avenue, Makati 1226
Philippines


Jobs & Resumes: Alabang, Makati City, Marikina City
Houses & Roommates: Alabang, Makati City, Marikina City
Travel Agencies:

Search other schools for writing queries using microsoft sql server 2008 transact-sql training resources.

Microsoft .NET Development
Foundations of Microsoft .NET 2.0 Development
Advanced Foundations of Microsoft .NET 2.0 Development
Developing Microsoft ASP.NET 2.0 Web Applications
Programming Microsoft .NET Applications with Microsoft Visual Studio 2005
Programming with the Microsoft .NET Framework using Microsoft Visual Studio 2005
Complete .NET Security
C# 3.0 Programming in the .NET Framework
SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.