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

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

Contact information not available.

Courses you can instantly connect with...
Querying Microsoft SQL Server New Horizons Egypt Mastering PHP & MySQL Helper Learning MCTS: SQL Server 2008, Database Development Helper Learning

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?

or