Discover Classes. Earn Rewards.
Price:
$325 5 seats
Start Date:

Mon, Feb 26, 5:50pm - Feb 27, 9:20pm (2 sessions)

Next start dates (40)

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

233 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 server training:

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

Still have questions? Ask the community.

  • 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
Career Centers


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 (41)
Start Date Time Teacher # Sessions Price
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
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, Mar 27 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
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, May 03 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.
Thu, May 31 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
5:50pm - 9:20pm TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Thu, Jun 28 5:50pm - 9:20pm TBD
9:00am - 5:00pm TBD 1 $325
9:00am - 5:00pm TBD 1 $325
Start Date Time Teacher # Sessions Price
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, Jul 31 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
Start Date Time Teacher # Sessions Price
5:50pm - 9:20pm TBD 2 $325
This course consists of multiple sessions, view schedule for sessions.
Thu, Aug 30 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, Oct 02 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
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, Nov 06 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.
Thu, Dec 06 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

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!
Questions & Answers

Get quick answers from CourseHorse and past students.

Question from Chelsea C.
Can this class be taken on a Mac? And do we need any specific software?
Answer from Michael G. Verified Student
This class is given on a PC not a Mac. You don't need to bring your computer as they are provided for you. You also don't need to bring any software as it is provided for you.
Answer from Jenn C. CourseHorse Staff
Hi Chelsea! Unfortunately, Microsoft SQL server 2014 cannot be installed on the mac. The flavor of SQL for the Mac is Postgres which the school does not support in the class. However, they provide PCs in the classroom for your convenience. If you'd be interested in private tutoring on Postgres for the Mac please let us know through [email protected]ehorse.com and we'll be happy to connect you with them!
Show all 2 answers
Answer
Cancel
Question from Jenn S.
Hi guys, is this an appropriate course for me who doesn't have any database experience?
Answer from Angelica B. CourseHorse Staff
Hi, yes it is appropriate. This is a beginner SQL class that will introduce the fundamentals of databases. The only prerequisite is basic computer knowledge.
Answer
Cancel
Question from Kate K.
And is this price for one or two sessions? Because when I try to book this course drop-down menu with dates will come out to select one date. So I wonder wether this is start date or single date. Thanks Kate
Answer from Brenda L. CourseHorse Staff
Hi Kate! For the October 25 class, there will be two sessions. If you noticed, the class per day is only for 3.5 hours. The rest of the schedules are for one-day session only. You can check the number of sessions on the 4th column of the schedule. I hope this helps!
Answer
Cancel
Question from Kate K.
Hi! Do you provide any kind of certificate after taking the course? Thanks Kate
Answer from Brenda L. CourseHorse Staff
Hi Kate! Yes, you will receive a certificate of completion for this class. I hope this helps!
Answer from Elisabeth B. Verified Student
Yes, I received a certificate at the end of the course stating it was completed and signed by the instructor
Show all 2 answers
Answer
Cancel

Reviews of Classes at Career Centers

(433 Reviews)
2/11/2018
Anonymous

Attended: SQL Level I - Beginner
The class started an hour late, and ended before 5pm. The projector kept blacking out, equipment did not work well. The first part of the course moved smoothly, the second part was rushed, and glazed over. The instructor was somewhat helpful. At the end of the course there were no take home disk to take home to practise what was taught. There was an option to download a practice slide from the instructor's computer, and he was not too helpful showing the students how to do so. Additionally, they misspelled my name on the completion certification. I am very disappointed, especially as I was looking forward to take this class. It was not worth $325.00 I will not recommended anyone to take this class at that site.

1/26/2018
Michael G.

Attended: SQL Level I - Beginner
Could use more time for assessments and labs within the class

1/17/2018
Anonymous

Attended: SQL Level I - Beginner
The instructor was very knowledgeable and had a good course philosophy - hand-holding sometimes, letting us do things ourselves most of the time. I rated four instead of five stars because I was the only person that seemed to start from a true beginner's perspective in this course - everybody else seemed to have some knowledge about joins, aggregates, and other concepts. That's totally fine - I learned a lot from their conversation with the instructor. I will have to practice a bunch to learn some of the more complicated concepts.

11/12/2017
Karen O.

Attended: SQL Level I - Beginner
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 I - Beginner
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.

School: Career Centers

Career Centers
Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD. Our courses are instructor-led...

Read more about Career Centers

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...