You are here

SQL: Level 2

SQL: Level 2

Overview

The Career Center
185 Madison Ave
Ste 1104
New York, NY 10016
Register for Course
Saturday, December 8, 2018 -
9:00am to 5:00pm
$325

Details

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 instructors 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: Code subqueries to generate query output Manipulate table data by inserting, updating, and deleting records in a table Create a simple table, create tables with constraints, modify the table structure, and delete tables Create views, manipulate data through views, modify the view structure, and drop views Create indexes on table columns and drop inefficient indexes SQL Training Outline - Level 2 Lesson 1: Advanced Querying Using Subqueries Topic 1A: Search Based on an Unknown Value Topic 1B: Search Based on Multiple Unknown Values Topic 1C: Compare a Value with Unknown Values Topic 1D: Search Based on the Existence of Records Topic 1E: Generate Output Using Correlated Subqueries Topic 1F: Filter Grouped Data Within Subqueries Topic 1G: Perform Multiple-level Subqueries Lesson 2: Manipulating Table Data Topic 2A: Insert Data Topic 2B: Modify Data Topic 2C: Delete Data Lesson 3: Manipulating the Table Structure Topic 3A: Create a Simple Table Topic 3B: Create a Table with Constraints Topic 3C: Add or Drop Table Columns Topic 3D: Add or Drop Constraints Topic 3E: Modify the Column Definition Topic 3F: Delete Tables Lesson 4: Working with Views Topic 4A: Create a View Topic 4B: Manipulate Data in Views Topic 4C: Modify and Drop Views Lesson 5: Indexing Data Topic 5A: Create Indexes Topic 5B: Drop Indexes Appendix A: Structure of the Bookstore Database Appendix B: Working with Transactions Supplemental Lesson Working with Transactions Topic 1A: Rollback Transactions Topic 1B: Commit Transactions

Register for Course

Additional Sessions