Course Details
Price:
$325 7 seats left
Start Date:

Wed, Oct 16, 5:50pm - Oct 17, 9:20pm (2 sessions)

Next start dates (11)

Location:
Midtown, Manhattan
185 Madison Ave Ste 1104
At E 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 8

What you'll learn in this sql server training:

Beginner SQL Class Overview

SQL is a powerful and popular database program that is widely used for data analysis and manipulation. Learn to use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database in our beginner SQL training class.

Our SQL courses are taught in our state-of-the-art training facility in Manhattan in small class sizes. The course includes our proprietary, step-by-step training manual customized by a top SQL instructor in New York.

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
  • Beginner SQL Class Outline

    Basic Concepts

    • Microsoft SQL Server
    • What is SQL?
    • What are Relational Databases?

    The Graphic User Interface

    • Object Explorer
    • Query Window
    • Results Grid
    • Options

    The Code

    • Basic Clauses
    • Field and Table Aliases
    • Creative use of Aliases
    • Inner Table Joins
    • Aggregations
    • Distinct Records
    • Text Criteria & Operators
    • Wildcard Filters
    • Numeric Criteria & Operators

    Student Labs


    Note: Students will receive a Certificate of Completion at the end of this course and may retake the same course for free. 

    Still have questions? Ask the community.

    Refund Policy
    • Registration Fee: All courses include a non-refundable registration fee of 10%.
    • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
    • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

    Map

    Google Map

    NYC 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 (12)
    Start Date Time Teacher # Sessions Price
    5:50pm - 9:20pm TBD 2 $325
    This course consists of multiple sessions, view schedule for sessions.
    Thu, Oct 17 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, Nov 12 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 12 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

    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 (13)

    Get quick answers from CourseHorse and past students.

    Question from Anonymous
    What’s the duration of the course? Thank you
    Answer from Brenda L. CourseHorse StaffCourseHorse Staff
    Hi there! We have two option for this class. We have one session that is from 9am to 5pm, and we have 2 sessions that are from 5:50pm to 9:20pm. You may choose which time works for you. Hope this helps!
    Answer
    Cancel
    Question from anonymous
    How many sessions?
    Answer from Helen L. Verified Student
    2
    Answer
    Cancel
    Question from Anonymous
    Is a computer provided?
    Answer from Brenda L. CourseHorse StaffCourseHorse Staff
    Hi there! Yes, computers are provided for students taking this course. Hope this helps!
    Answer
    Cancel
    Question from anonymous
    Is there are prerequisite training or experience expected?
    Answer from Georgia C. CourseHorse StaffCourseHorse Staff
    Hi there! This is a beginner SQL class that will introduce the fundamentals of databases. The only prerequisite is basic computer knowledge.
    Answer
    Cancel
    Question from NanA
    Are computers supplied or do students need to bring their own laptops? Thanks
    Answer from Georgia C. CourseHorse StaffCourseHorse Staff
    Hi Nana! Computers are provided by the school.
    Answer
    Cancel
    Question from Anonymous
    Hello, what're the length and schedule of the course? Thank you
    Answer from Brenda L. CourseHorse StaffCourseHorse Staff
    Hello there! The class is for 8 hours and the schedule is posted on this class page. You may click on the link "Next Class Dates" just above this page to see the full class schedule that will fit your need. Hope this helps!
    Answer
    Cancel
    Question from Angelica B.
    What is the background of the trainer?
    Answer from Angelica B. CourseHorse StaffCourseHorse Staff
    All of our Instructors are BPSS approved with more than 20 years of Experience.
    Answer
    Cancel
    Question from Angelica B.
    Will the users be using ssms and doing actual queries?
    Answer from Angelica B. CourseHorse StaffCourseHorse Staff
    Students will be using SQL Server Management Studio 2014, and yes, they are doing actual queries.
    Answer
    Cancel
    Question from Angelica B.
    Are the classes definite? They may have someone travel to NY for one of these classes.
    Answer from Angelica B. CourseHorse StaffCourseHorse Staff
    We only reschedule or cancel classes in case of emergency and will try to notify students in advance of any potential schedule changes.
    Answer
    Cancel
    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 StaffCourseHorse 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] 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 StaffCourseHorse 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 StaffCourseHorse 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 StaffCourseHorse 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
    View all 13 questions

    Reviews of Classes at NYC Career Centers (630)

    (630 Reviews)
    Beginner SQL
    Reviewed by Anonymous on 5/19/2019
    The class size was small, The instructor was knowledgeable and thorough, and very kind. However we didn't get a chance to do any labs/practice on our own - I believe that the best way of learning is practicing with the instructor, then independently, and then going over the labs together.
    Beginner SQL
    Reviewed by Rosanna M. on 2/7/2019
    Great instructor. Made the class interesting and fun
    Beginner SQL
    Reviewed by shariq m. on 11/8/2018
    Instructor was great!!! Learned a lot
    Beginner SQL
    Reviewed by Colleen M. on 10/24/2018
    This class was a great introduction. The instructor made the material relevant and fun. He did a great jab reinforcing the basics and laying the groundwork to continue advancing with next course levels.
    Beginner SQL
    Reviewed by Anonymous on 9/4/2018
    Wish we had more time to write our own queries
    loading...
    loading...
    Similar Classes

    School: NYC Career Centers

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

    CourseHorse Approved

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

    Ready to take this class?
    BOOK NOW
    Booking this class for a group? Find great private group events here