Querying Microsoft SQL Server

IT & Business Consulting Group

Add to wishlist

Price: USD 65

Duration: 5 Days

Course details

Overview:

This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

Audience Profile:

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Outline

Module 1: Introduction to Microsoft SQL Server 2012
Module 2: Getting Started with SQL Azure
Module 3: Introduction to T-SQL Querying
Module 4: Writing SELECT Queries
Module 5: Querying Multiple Tables
Module 6: Sorting and Filtering Data
Module 7: Working with SQL Server 2012 Data Types
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying SQL Server Metadata
Module 16: Executing Stored Procedures
Module 17: Programming with T-SQL
Module 18: Implementing Error Handling
Module 19: Implementing Transactions
Module 20: Improving Query Performance

Updated on 08 November, 2015

About IT & Business Consulting Group

Whether you need a one-day onsite training course, full-service consulting, or if you are not really sure which solution will work, we can help.

ITBCG is a leading and innovative learning provider with over twenty years’ experience of providing best in-class learning solutions. We work in partnership with our customers to deliver flexibility, value and service. We develop innovative programs to ensure that every aspect of the learning development, delivery and administration of courses work to our clients’ benefit.

We provide IT and business skills learning to both the private and public sector companies and organizations. Our core training is focused on Cisco, Microsoft, CompTIA Citrix, EC-Council, Oracle, and ISC2 and best practice. This includes ITIL® Service Management and ISO, and PMI which is tied into business process improvement, project management, and business analysis and leadership development.

See all IT & Business Consulting Group courses

Ask Laimoon

View more similar courses

Are you from IT & Business Consulting Group ? Claim your course!

Courses you can instantly connect with... Do an online course on SQL Server starting now.