Course Course Summary Section 1 Content Section 1 Content Left Section 1 Content Right Credit Type: Course ACE ID: SKIL-0201 Organization: SkillSoft Corporation Location: Online Length: Self-paced, 18 hours Dates Offered: 6/1/2023 - 5/31/2026 10/1/2019 - 5/31/2023 Credit Recommendation & Competencies Section 2 Content Section 2 Content Left Section 2 Content Right Level Credits (SH) Subject Lower-Division Baccalaureate 1 Relational Databases or Sql Description Section 3 Content Section 3 Content Left Section 3 Content Right Objective: The course objective is to help prepare learners for the Microsoft SQL Server 2016: Querying (70-761) certification exam. Learning Outcomes: Configure T-SQL statements in SQL Server 2016 Create T-SQL variables Work with T-SQL control of flow, errors, and transactions Use T-SQL comments and batch separators Use SELECT statements in SQL Server 2016 to query tables and views and manipulate data Work with various clauses with SELECT statements including ORDER BY, TOP, OFFSET, and FETCH Write queries using various SQL Server built-in functions Use aggregate functions such as SUM, MIN, MAX, AVG, and COUNT, as well as the GROUP BY clause Use and create stored procedures Use database programmability objects Change a table-valued expression into another table using the PIVOT and UNPIVOT operators Write subqueries and correlated subqueries Use set operators including UNION, INTERSECT, EXCEPT and APPLY Demonstrate how to input and output parameters in SQL 2016 General Topics: T-SQL querying Querying and manipulating data Filter and modify data in SQL Server 2016 Using functions in SQL Server 2016 Aggregating data in SQL Server 2016 Subqueries and predicate Operators and expressions in SQL Server 2016 Database programmability objects and non-relational data Instruction & Assessment Section 4 Content Section 4 Content Left Section 4 Content Right Instructional Strategies: Computer Based Training Practical Exercises Methods of Assessment: Examinations Quizzes Minimum Passing Score: 70% Supplemental Materials Section 5 Content Section 5 Content Left Section 5 Content Right Section 6 Content Section 6 Content Left Section 6 Content Right Button Content Rail Content 1 Other offerings from SkillSoft Corporation Agile for Software Development (SKIL-0216) AI Apprentice to AI Architect (SKIL-0210) Application Developer to Blockchain Solutions Architect (SKIL-0209) Apprentice Java Developer to Senior Java Developer (SKIL-0229) Apprentice Programmer Journey - Novice and Apprentice Programmer (SKIL-0214) Apprentice Programmer Journey - Web Programmer and Web Apps Developer (SKIL-0213) Business Analyst to Data Analyst (SKIL-0227) Certified Business Analysis Professional (CBAP) (SKIL-0172) Certified Information Systems Security Professional (CISSP) 2021 (SKIL-0241) Cisco Certified Network Associate (SKIL-0211) View All Courses Page Content