Discover Classes. Earn Rewards.

SQL: Level 1

The Career Center

Price:
$325 7 seats left
Start Date:

Wed, Dec 20, 5:50pm - Dec 21, 9:20pm ( 2 sessions )

Next start dates (13)

Location:
Murray Hill, Manhattan
185 Madison Ave Ste 1104
Btwn E 34th & 35th Streets
New York, New York 10016
(Map)
Share:
No Booking Fees Book Online Save to WishList

223 people saved this class

Give as a Gift
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 8

What you'll learn in this sql class:

SQL: Level 1 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:

  • Connect to the SQL Server database and execute a simple query
  • Include a search condition in a simple query
  • Use various functions based on the data types to perform calculations on data
  • Organize the data obtained from the query before it is displayed on the screen
  • Retrieve data by combining information from multiple tables
  • Format the output, save the result, and generate a report

SQL Training Outline - Level 1

Lesson 1: Executing a Simple Query

  • Topic 1A: Connect to the Database
  • Topic 1B: Query the Database
  • Topic 1C: Modify a Query
  • Topic 1D: Save a Query
  • Topic 1E: Execute a Saved Query

Lesson 2: Performing a Conditional Search

  • Topic 2A: Search Using a Simple Condition
  • Topic 2B: Compare Column Values
  • Topic 2C: Search Using Multiple Conditions
  • Topic 2D: Search for a Range of Values and Null Values
  • Topic 2E: Retrieve Data Based on Patterns

Lesson 3: Working with Functions

  • Topic 3A: Perform Date Calculations
  • Topic 3B: Calculate Data
  • Topic 3C: Manipulate String Values

Lesson 4: Organizing Data

  • Topic 4A: Sort Data
  • Topic 4B: Group Data
  • Topic 4C: Filter Grouped Data
  • Topic 4D: Summarize Grouped Data

Lesson 5: Retrieving Data from Multiple Tables

  • Topic 5A: Combine Results of Two Queries
  • Topic 5B: Retrieve Data by Joining Tables
  • Topic 5C: Check for Unmatched Records
  • Topic 5D: Retrieve Information from a Table Using Joins

Lesson 6: Presenting Query Results

  • Topic 6A: Customize and Save the Query Result
  • Topic 6B: Generate an HTML Report
  • Appendix A: The Bindery Database
School Notes: All of our classes are offered on PCs, we do not have any Macs in our classrooms. Free Retakes
  • No charge for substituting students at any time.
  • Students are eligible for a free retake within 12 months, contingent on class running and available seating
  • No refund or rescheduling permitted within 2 business days of start of class.

Map

Google Map
The Career Center


All classes at this location
We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square.
Start Dates (14)
Start Date Time Teacher # Sessions Price
5:50pm - 9:20pm TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Thu, Dec 21 5:50pm - 9:20pm TBD
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
5:50pm - 9:20pm TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Tue, Jan 23 5:50pm - 9:20pm TBD
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
5:50pm - 9:20pm TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Tue, Feb 27 5:50pm - 9:20pm TBD
9:00am - 5:00pm TBD 1 $325
Start Date Time Teacher # Sessions Price
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
5:50pm - 9:20pm TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Thu, Mar 29 5:50pm - 9:20pm TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 3250 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!

Reviews of Classes at The Career Center

(416 Reviews)
11/12/2017
Karen O.

Attended: SQL: Level 1
Pace was ideal, not too fast that beginner couldn't keep up, but not too slow that it got boring.

9/7/2017
Anonymous

Attended: SQL: Level 1
Great class! This was a good overview of SQL. I am looking forward to practicing and attending Session 2. The only think i would improve is to have more independent work. I am a very hands on learner and I believe it would have been a good experience to try to create a lot of solutions on my own.

8/27/2017
Anonymous

Attended: SQL: Level 1
Coming in with a few years of database experience, I find this class to be a very good refresher course. The instructor, Peter, is a database elite; and he was great conducting the class -- the pace was just right, the topics were covered, and he encouraged us to think and engage in discussions. Unfortunately, he doesn't teach at night (I plan to attend the night session of SQL Level 2). The location was easily accessible from where I live (Jersey City). The classroom was clean, but a little too tiny. Good thing the class was small -- we were only five in the session, so room size didn't really matter at the time. The PC's were all working and ready, and we experienced no technical disruptions at all. We had a short morning break, a one hour lunch, and an afternoon break. Our group decided to shorten our lunch break so we could leave a little early. Keurig coffee machine is available at the lobby, and there's also a mini-fridge with water bottles and cans of soda for everyone. My only nitpick was the outside noise: the location was at the intersection of Madison and 34th, I could hear the constructions and ambulances. But the same can be said to other training schools I went to, so I am used to it. YMMV. Overall, I would recommend this class to anyone who wants to get his/her feet wet on SQL database. If you don't get it the first time, there's always a free retake (valid for a year I believe).

7/27/2017
Anonymous

Attended: SQL: Level 1
Ready to go computers. Small classroom size. Easy to find location

5/25/2017
Anonymous

Attended: SQL: Level 1
SQL level 1 was a great class to introduce SQL and to practice it. The instructor, Peter, was very informative and made sure we understood the concepts before moving on. He did a great job of testing our knowledge throughout the class.

School: The Career Center

The Career Center helps individuals and corporations advance their computer skills. We offer instructor-led classes, with very low student to teacher ratios. Students come to our facility on 34th Street & Madison Avenue in Manhattan and get a manual which is theirs to keep, they are then shown to...

Read more about The Career Center

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK ONLINE
Taking this class for work? Get exclusive perks & discounts for free. Learn More
Loading...