In this intermediate level course, you'll build on your knowledge of SQL fundamentals to enhance your skills in using SQL to analyze data.
You'll learn how to find data that meets your specific search criteria using views, subqueries, math functions, and logic statements. You'll also learn how to use data conversion functions to manipulate data and increase report readability.
Ultimately, the functions and features taught in this course make SQL easier to use; by the end of SQL II, you'll have a strong command of how to use SQL to meet your specific data analysis needs.
SQL Level II is taught at our affiliate school, NYIM Training, in Midtown Manhattan.
Register for this class
185 Madison Ave, NYC
This course is offered at our affiliate business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on our affiliate's website.
What You’ll Learn
- Write and save queries to the server
- Create and edit views
- Use subqueries as an alternative to inner and outer joins
- Calculate new data field using math functions
- Format data for reporting with data conversion techniques
SQL Level II Class Syllabus
Saving Queries Programmatically
- Benefits versus Shortcomings
- Stored Procedures
- Layered Views
- Protect Views with Schema binding
- Create Top Value Views
- What is a Sub Query?
- Clarity and Transparency
- Single Table Sub Query
- Multiple Table Sub Query
- Exists versus In Operators
- Any versus All Operator
Math, Advanced Functions and Logic Statements
- Basic Math
- Advanced Date and Time Functions
- Advanced Text Functions
- Case When Then Logic Statements
- Variables and User Functions
Data Conversion Functions
- String Functions
- Cast Function
- Convert Function
- Rounding Functions
- Creating Views
- Sub Queries
- Advanced Functions
- Logic and Date Functions
- Conversion Functions