(212) 684-5151

Intermediate SQL
Intermediate SQL

Price: $325.00

Course Code: SD | Hours: 8

SQL: Level 2 Training Overview

SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and then shown to your seat with a computer that is fully equipped with SQL. The instructor computer is attached to an overhead projector so you can easily follow their instructions. The class is taught in a very hands-on way, with the instructor teaching a concept and then the class doing exercises to enforce it. The maximum class size is 10 so you don't have to worry about getting lost in the crowd!

Intermediate SQL Course Outline

What You'll Learn in this Class:

  • Code subqueries to generate query output
  • Create views, manipulate data through views, modify the view structure, and drop views
  • Use date functions, text parsing, concatenation and formatting functions
  • Create logic statements, variables and user functions
  • Use conversion functions to make outputs more user friendly

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Prerequisites:

Students are recommended to take the following course or possess equivalent knowledge:

Next Classes:

Related Classes:

See Also:

Intermediate SQL Course Overview

Saving Queries Programmatically

• Benefits versus Shortcomings
• Views
• Functions
• Stored Procedures
• Layered Views
• Protect Views with Schema binding
• Create Top Value Views

Sub Queries

• 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

Student Labs

• Creating Views
• Sub Queries
• Advanced Functions
• Logic and Date Functions
• Conversion Functions