Help

Querying Data with Transact SQL

This course is a piece of the MS Professional Program Certificate in Big Data and the MS Professional Program Certificate in Data Science.

$1,000.00

This course is a piece of the MS Professional Program Certificate in Big Data and the MS Professional Program Certificate in Data Science.

More Information:

  • Learning Style: Self-Paced
  • Provider: Microsoft
  • Difficulty: Intermediate
  • Course Duration: 30 Hours
  • Course Info: Download PDF
  • Certificate: See Sample

Need Training for 5 or More People?

Customized to your team's need:

  • Annual Subscriptions
  • Private Training
  • Flexible Pricing
  • Enterprise LMS
  • Dedicated Customer Success Manager

Course Information

About This Course:

This course is a piece of the MS Professional Program Certificate in Big Data and the MS Professional Program Certificate in Data Science.

Transact-SQL is an important expertise for data developers and professionals functioning with the databases of SQL. With this arrangement of master demonstrations, instruction, and practical labs, start from your first statement of SELECT through to executing the logic of the transactional program.

Function through numerous modules, every one of which investigates a key zone of the language of Transact-SQL, with attention on modifying and querying information in Azure SQL Database or Microsoft SQL Server. In this course, the labs utilize a modest database that can be deployed effectively in the Database of Azure SQL, so you get hands-on involvement in Transact-SQL without configuring or installing a server of the database.

Course Objective:

  • Make the queries for Transact-SQL SELECT
  • Perform with subqueries and APPLY
  • With the use of JOIN, query multiple tables
  • Function with NULL and data types
  • Sets group and pivot data
  • Explore set operators
  • Use aggregate data and functions
  • Program with Transact-SQL
  • Utilize table expressions
  • Investigate set administrators
  • Modify data
  • Execute error handling and transactions

Audience:

  • Developers
  • Programmers

Prerequisite:

A fundamental comprehension of databases and IT frameworks.

Outline

Credly Badge

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Customer Reviews
  1. Querying Data with Transact SQL
    Course Quality
    100%
    Overall Satisfaction
    100%
    Quality of Instructor
    100%
    Course Value
    100%
    Overall course was very useful and informative regarding manipulation of data with SQL Queries.

    Review by

    Posted on

  2. Great
    Course Quality
    100%
    Overall Satisfaction
    100%
    Quality of Instructor
    100%
    Course Value
    100%
    Excellent course

    Review by

    Posted on

  3. Challenging!
    Course Quality
    100%
    Overall Satisfaction
    100%
    Quality of Instructor
    100%
    Course Value
    100%
    I consider this course as ADVANCED! Even though the first sections are basic stuff, the more you go - the more challenging it is including programming, stored procedures, etc.

    Review by

    Posted on

  4. Challenging!
    Course Quality
    100%
    Overall Satisfaction
    100%
    Quality of Instructor
    100%
    Course Value
    100%
    I consider this course as ADVANCED! Even though the first sections are basic stuff, the more you go - the more challenging it is including programming, stored procedures, etc.

    Review by

    Posted on

  5. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  6. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Mahesh was a great instructor. The course overall felt a little fast there is so much to cover I have worked 7-10 years in the IT industry when taking this training.

    Review by

    Posted on

  7. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked 7-10 years in the IT industry when taking this training.

    Review by

    Posted on

  8. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    60%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    instructor was outstanding and patient because instructor was able to solve many of the outdated materials within the course that simply did not work I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  9. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    Good flow of course. Polite and respectful. Very Knowledgeable. Demo's were presented very well. Was able to resolve everyone's issues nicely. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  10. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    some time when the instructor provide real life experience it takes a while for the story to be finished. the instructor add new slide or make changes a long the way which is good but the book does not have the changes and it would be nice to have the changes to review on after class is over I have worked 1-3 years in the IT industry when taking this training.

    Review by

    Posted on

  11. Querying With Transact SQL
    Course Quality
    60%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    60%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  12. Querying With Transact SQL
    Course Quality
    60%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Very knowledgeable and patient. I have worked over 10 years in the IT industry when taking this training. I have rated this class as outstanding in terms of the knowledge and skills gained from taking it.

    Review by

    Posted on

  13. Querying With Transact SQL
    Course Quality
    60%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  14. Querying With Transact SQL
    Course Quality
    80%
    Course Value
    60%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  15. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    The instructor seemed very knowledgeable. He moved a little fast for ME. Jumped around a bit so following along was challenging however I am not sure that is HIS issue or the way the syllabus is layed out. Again he is very knowledgeable. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  16. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  17. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  18. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  19. Querying With Transact SQL
    Course Quality
    80%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    He was an excellent instructor and a very nice person. I have worked 5-7 years in the IT industry when taking this training.

    Review by

    Posted on

  20. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  21. Querying With Transact SQL
    Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    Paul was great! I have worked over 10 years in the IT industry when taking this training

    Review by

    Posted on

  22. Querying With Transact SQL
    Course Quality
    80%
    Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%
    I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  23. Querying With Transact SQL
    Course Quality
    100%
    Course Value
    60%
    Quality of Instructor
    60%
    Overall Satisfaction
    60%
    I have worked 5-7 years in the IT industry when taking this training.

    Review by

    Posted on

click here