Details
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’s 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.
Upon successful completion of this course, students will be able to:
- Utilize 'Case When Then' statements and create and use variables
- Format and/or convert numeric data
- Extract, replace and concatenate text data
- Use Stored Procedures for the creation of parameterized queries and automation of workflow processes
- Create local and global Temporary Tables
Prerequisites:
Students are recommended to take the following course or possess equivalent knowledge:
- SQL: Level 1
- SQL: Level 2
Outline
Lesson 1: Letting a Query Make a Decision
- Topic 1A: Simple 'Case When Then'
- Topic 1B: Create Variables
- Topic 1C: Create a Custom Function
Lesson 2: Convert and Format Output
- Topic 2A: Str Function
- Topic 2B: Cast Function
- Topic 2C: Convert Function
- Topic 2D: Parsename Function
- Topic 2E: Replace Function
Lesson 3: Text Functions
- Topic 3A: Left, Right and Len Functions
- Topic 3B: Rtrim, Ltrim and Substring Functions
- Topic 3C: Upper and Lower Functions
- Topic 3D: Patindex and Replicate Functions
- Topic 3E: Reverse Function
Lesson 4: Stored Procedures
- Topic 4A: Create, Execute, Alter and Drop Stored Procedures
- Topic 4B: Create a Simple Parameter
- Topic 4C: Use a Wild Card with a Parameter
Lesson 5: Temporary Tables
- Topic 5A: Local Temp Tables
- Topic 5B: Global Temp Tables
Lesson 6: Automating Processes
- Topic 6A: Create a Simple Temp Table Process
- Topic 6B: Create an Archive Process
- Topic 6C: Create a Synonym
The Career Center is a full-service training provider that offers training services in a wide array of courses, including applications such as Microsoft Office, the Adobe Creative Suite, SQL, QuickBooks and AutoCAD.
As a Microsoft Silver Learning Partner we also offer all of the Microsoft Official Courses (MOC) and proudly accept Microsoft Software Assurance Training Vouchers.
The Career Center offers computer courses and hands-on training that helps people of all levels, from beginners to advanced users, increase their computer knowledge & efficiency. Conveniently located on the corner of 34th Street & Madison Avenue, The Career Center offers over 100 public classes in popular softwares.
The Career Center also offers other training solutions including:
- Onsite Training
- Private Corporate Classes
- Private Computer Tutoring
- Lab Rentals
For more information about individual or corporate training, please contact us at your convenience at (212) 684-5151 or [email protected]