Intermediate SQL Custom 3-Day Private Class Outline

3 Days

18 CPD hours

In this 3 day customized Intermediate SQL course students will learn additional commands and functions using labs/activities/content that correlates with this content. By understanding SQL, you get the knowledge of fundamental queries associated with data management so that you can verify, monitor, and control all the activities operating in the database.

Lesson 1

• Substring
• Instr / CharIndex
• Convert (data types and with Formatting)
• Replace
• RowCount / RowNum / Top )n) ÿ(Oracle/SQL Server functions)
• Case / If Then Else statements
• Exists Clause
• Find Duplicates using Group by and have clause (and other tips for analyzing data)

Lesson 2

• Set operations (UNION, UNION ALL, INTERSECT, MINUS)
• GROUP BY extensions (ROLLUP, CUBE, and GROUPING SETS)
• Loops / Cursors
• Common Table Expressions (CTEs)

Lesson 3

• Temp Tables / Views
• Advanced Subqueries
• Regular Expressions (RegEx)
• Linked Server Queries
• Qualified subquery predicates
• Aggregate functions
• Optimizing queries
• SQL Injection

Lesson 4

• JSON Parsing
• With
• Partition By With Over
• Fuzzy Logic - MDS.mdq.[Similarity]ÿ

Additional course details:

Nexus Humans Intermediate SQL Custom 3-Day Private Class Outline training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.