Menu Icon

Available Training Rooms

  • PRIVATE BATCH
  • PUBLIC PROGRAM
  • ON DEMAND
  • BLENDED

Course Details

  • Course Overview
  • Skills Gained
  • Who Can Benefit
  • Prerequisites
  • Syllabus

In this course, you will develop the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for the all SQL Server-related disciplines, including database administration, database development, and business intelligence. Many of the labs are SQL Azure enabled, allowing you to perform the lab while connected to your own Windows Azure database in the cloud. This requires a Microsoft Windows Azure account.

Write SELECT Queries
Query Multiple Tables
Use Built-In Functions and Subqueries
Execute Stored Procedures
Use Set Operators
Implement Error-Handling and Transactions
Use Table Expressions, Windows Ranking, Offset, and Aggregate Functions
Sort and Filter Data
Query SQL Server Metadata and Improve Query Performance
Program with T-SQL
line11
Database administrators
Database developers
BI professionals
SQL power-users such as report writers
Business analysts
Client application developers
Working knowledge of relational databases
Basic knowledge of Microsoft Windows operation system and its core functionality

1. Microsoft SQL Server 2012

  • SQL Server 2012 Architecture
  • Working with SQL Server 2012 Tools
  • Working with SQL Server Databases

2. SQL Azure

  • Working with SQL Azure

3. Transact-SQL Querying

  • Transact-SQL
  • Sets
  • Predicate Logic
  • Logical Order of Operations in SELECT Statements

4. Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions

5. Querying Multiple Tables

  • Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying Using Self and Cross Joins

6. Sorting and Filtering Data

  • Sorting Data
  • Filtering Data
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown Values

7. Working with SQL Server 2012 Data Types

  • SQL Server 2012 Data Types
  • Working with Character Data
  • Working with Date and Time Data

8. Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Conversion Functions
  • Logical Functions
  • Using Functions to Test for Nullability

9. Grouping and Aggregating Data

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with the HAVING Clause

10. Using Subqueries

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries

11. Using Table Expressions

  • Views
  • Table Expressions

12. Use Set Operators

13. Using Window Ranking, Offset, and Aggregate Functions

14. Pivoting and Grouping Sets

15. Querying SQL Server Metadata

16. Executing Stored Procedures

17. Programming with T-SQL

18. Implementing Error Handling

19. Implementing Transactions

20. Improving Query Performance

Lab 1: SQL Server 2012 Tools

Lab 2: Transact-SQL Querying

Lab 3: Write Basic SELECT statements

Lab 4: Query Multiple Tables

Lab 5: Filter and Sort Data

Lab 6: Work with SQL Server 2012 Data Types

Lab 7: Use Built-In Functions

Lab 8: Group and Aggregate Data

Lab 9: Use Subqueries

Lab 10: Use Table Expressions

Lab 11: Use Set Operators

Lab 12: Use Window Ranking, Offset, and Aggregate Functions

Lab 13: Pivot and Group Sets

Lab 14: Query SQL Server Metadata

Lab 15: Execute Stored Procedures

Lab 16: Program with T-SQL

Lab 17: Implement Error Handling

Lab 18: Implement Transactions

Lab 19: Improve Query Performance

Audience

  • Business Intelligence
  • Database Developer
  • Database Administrator

Public Program Schedule

Course Name Duration Brochure Location Schedule Enroll
There is no upcoming Public Batch Schedule, you can ask for Private Batch or for On-Demand Learning

Download the syllabus

Download

The highest standard, The happiest learners

Our Enterprise Clients

FAQ

  • Why should I choose RPS?
  • I am working, is it possible to arrange the classes on weekends?
  • Please confirm if your office is open on weekends?
  • Can I get the courseware in advance before start of training?
  • What are the timings (class hours)?
  • How can I make the payment?
  • What is the mode of payment?
  • Candidate authorized RPS to charge $200. But the bank has charged $208. Why is this?
  • If we need training on one of the modules only how does that work?
  • How long before do we need to book the exams?
  • Where are your training centers available?
  • Can I pay the fee in installments?
  • What are the refund policies? Can i get my money back in case i am unable to attend the training?
  • Do you provide a bank loan facility?
  • 10+ years of Training Expertise
  • Gold Learning Partner for Microsoft
  • Certified instructors with industry standard experience
  • Tailor made training available
  • 6+ training Locations
  • 100000 + professional trained
  • Customer Satisfaction
  • Reliable and Most cost effective Training

Yes, we do offer weekend classes for professionals in group or 1-to-1 Training depending upon the technology.

The administrative and sales staff works on weekdays (Monday - Friday). System Admins and Operation team are available on all days.

Yes, after you have paid the booking amount (which will be non–refundable in this case). Booking amount depends on the technology selected.

Training timings are from 9 am to 5 pm.

You can send the deposit by any of the following methods:-

  • PayPal
  • Credit Card
  • Bank Transfer
  • Demand Draft
  • Cash
  • Purchase Order (in case of Corporates / Government).
  • If you are an International student, the registration amount of USD 200 can be paid by Bank Transfer or PayPal/PayUMoney . The balance amount has to be paid by traveler's cheque or cash after arrival in India. You can also pay the balance by PayPal. There is a surcharge of 4% in this case.
  • For Indian Resident students, the course fees including registration can be paid by Cash, Cheque, Demand Draft or Bank transfer.To Know more Please call +919883305050 or Email us at info@rpsconsulting.in for any of your queries.

Overseas credit card payments through PayPal involve a mark-up of up to 4% as surcharge.

We can provide customized 1-to-1 training for a technology as per your requirement.

Most exams can be booked once you are on the course (e.g. Microsoft, ITIL, VEEAM, EC-Council). Red Hat and some other exams have to be booked in advance.

Our training centers are available in Bangalore, Chennai, Hyderabad, Pune and Delhi.

We do not have facility to pay in installments

If the course fee has been paid for and RPS cancels the Course, a refund will be provided, else the courses are non-refundable.

We do not provide loan facility.

Other Related Courses

Related courses will be updated soon...
123movies