"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Show your skillset in Query Writing!

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

 

2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Course offered at MasterGrade.

Why should you attend?

Take the first step in an exhilarating career of Data Management, where MasterGrade and Writing Queries Using Microsoft SQL Server 2008 Transact-SQL will set you up in the right path.

Who should attend?

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.

2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Lesson 1: Getting Started with Databases and Transact-SQL

  • 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

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 sets

Lesson 5: Working with Sub queries

  • Writing basic sub queries
  • Writing correlated sub queries
  • Comparing sub queries with joins and temporary tables
  • Using common table expressions

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 Techniques

  • Considerations for querying data
  • Working with data types
  • Cursors and set-based queries
  • Dynamic SQL
  • Maintaining query files

Duration:

Learning Materials:

Prerequisites:

What course next:

Course Content
Writing Queries Using Microsoft SQL server 2008

   • Getting Started with Databases and Transact-SQL
   • 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
   • Using Programming Objects for Data Retrieval
   • Using Advanced Querying Techniques

 

Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.

Name

Email

Phone

Location

Message


Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

Shaun2.jpg
- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

zaheer1.jpg
- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

rene1.jpg
- René Leandro Borges

I enjoyed doing the course in my own time!

sadia.jpg
- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup

Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.