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: 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 2 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 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 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 Use set operators including UNION, INTERSECT, EXCEPT and APPLY Create T-SQL variables Work with various clauses with SELECT statements including ORDER BY, TOP, OFFSET, and FETCH Write queries using various SQL Server built-in functions Change a table-valued expression into another table using the PIVOT and UNPIVOT operators Write subqueries and correlated subqueries 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 Apprentice Java Developer to Senior Java Developer (SKIL-0229) AWS Certified Solutions Architect - Associate (SKIL-0252) AWS Certified Solutions Architect - Professional (SKIL-0253) C Programming Proficiency (SKIL-0262) Certified Business Analysis Professional (CBAP) (SKIL-0172) Certified Information Systems Security Professional (CISSP) 2021 Training (SKIL-0241) Cloud Computing for Decision-makers and Leaders (SKIL-0269) CloudOps Apprentice to CloudOps Engineer (SKIL-0237) CompTIA Linux+ (SKIL-0257) CompTIA Network+ (SKIL-0256) View All Courses Page Content