Change Location × Atlanta

    Recent Locations

      Querying Microsoft SQL Server (70-461) five 5 days Training in Lawrenceville

      • Querying Microsoft SQL Server (70-461) five 5 days Training Photo #1
      1 of 1
      November 23, 2019

      Saturday   9:30 AM

      2179 Lawrenceville Hwy, Suite 204
      Lawrenceville, Georgia

      • No Performers Listed
      Querying Microsoft SQL Server (70-461) five 5 days Training

      Exam 70-461 – This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014/2016. 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. At Course Completion After completing this course, students will be able to: Describe the basic architecture and concepts of Microsoft SQL Server 2014/2016. Understand the similarities and differences between Transact-SQL and other computer languages. Write SELECT queries Query multiple tables Sort and filter data Describe the use of data types in SQL Server Modify data using Transact-SQL Use built-in functions Group and aggregate data Use subqueries Use table expressions Use set operators Use window ranking, offset and aggregate functions Implement pivoting and grouping sets Execute stored procedures Program with T-SQL Implement error handling Implement transactions   Prerequisites This course requires that you meet the following prerequisites: Working knowledge of relational databases. Basic knowledge of the Microsoft Windows operating system and its core functionality. The class holds for 5 weekends.

      Categories: Science

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.