Discover Classes. Earn Rewards.

Introduction to Structured Query Language (SQL) for Data Analytics is unfortunately unavailable

Thankfully we have 18 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

SQL Bootcamp

Noble Desktop - Virtually Online

Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.

(373) All levels 18 and older
$975

3 sessions

Gift it!

SQL Private Training

Noble Desktop - Virtually Online

Unlock the power of databases with personalized SQL training. Master the art of querying, filtering, and aggregating data using PostgreSQL, gaining essential skills applicable across various database platforms. Transform

(373) All levels 13 and older

Data Analytics Technologies Bootcamp

Noble Desktop - Virtually Online

In this course, students will master Excel, SQL, and Tableau, some of the top data analytics tools. Here, students will gain the skills to organize, analyze, summarize, and visualize data, presenting actionable insights for effective decision-making. Comprehensive classroom training in Midtown Manhattan.

(373) All levels 18 and older
$1,949

8 sessions

Gift it!

SQL Level 1

Noble Desktop - Virtually Online

Unlock the power of SQL and relational databases with this comprehensive course. Learn how to write SQL queries, filter results, and combine data from multiple tables, all while gaining a strong foundation in database architecture. Master the fundamentals of SQL at Noble Desktop.

(373) Beginner 18 and older
$350

2 sessions

Gift it!

SQL Level 3

Noble Desktop - Virtually Online

Take your SQL skills to the next level with this advanced course at Noble Desktop. Learn how to use subqueries, views, functions, stored procedures, and more to manipulate and analyze data in databases. Gain in-depth techniques that will prepare you for a job in data analysis or data science.

(373) Advanced 18 and older
$425

2 sessions

Gift it!
See all SQL classes Online

Introduction to Structured Query Language (SQL) for Data Analytics

Learn to query a relational database for information and analysis using Structured Query Language (SQL) in this comprehensive course at Borough of Manhattan Community College. Master the basics of SQL syntax, functions, and data types, and gain hands-on experience with real-world examples and exercises. Take your data analytics skills to the next level with this Introduction to SQL course.

  • Beginner
  • 18 and older
  • $714
  • Live Online
  • 30 hours over 10 sessions

Start Dates (0)

  • $714
  • 30 hours over 10 sessions
  • Price includes $15 registration fee
    Session for purchase is 10 sessions only
Showing 10 of 0

Class Description

Description

What you'll learn in this sql class:

Structured Query Language (SQL) is used to extract information from a relational database to address an array of business information needs. Thus, the goal of the course is to teach participates how to query a relational database for information and analysis.

Course Objectives:

  • Students will learn how to query a relational database for information and analysis using Transact-SQL.
  • Understand how data is retrieved prior to analyze it

Curriculum:

  • Installing Microsoft SQL Express and Management Studio
  • Learning history of SQL and basic concepts of the structure of a relational database
  • Understanding structured programming
  • Understanding naming convention
  • Understanding basic syntax to query one table
  • Using built-in functions for strings
  • Querying two or more datasets (tables or views) using INNER JOIN, OUTER LEFT JOIN and OUTER RIGHT JOIN
  • Using built-in functions for numeric values including aggregate functions and GROUP BY
  • Using clauses ORDER BY, CASE, WHERE and operators
  • Sub-queries
  • Understanding function FORMAT() for dates and currencies including culture codes
  • Understanding data types
  • Creating, dropping, and altering databases, schemata, tables and columns
  • Inserting values into tables and updating values
  • Differences between DROP, TRUNCATE and DELETE
  • Altering databases, schemata, tables and views
  • Understanding NULL and NOT NULL
  • Understanding functions CONVERT(), CAST(), DAY(), MONTH(), YEAR() and GETDATE()
  • Creating, dropping, and altering views

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

School Notes: Please don't forget to bring a valid ID. Students registering on or after the first day of class shall be assessed a non-refundable late registration fee of $10.00.

Refund Policy

Tuition refunds are calculated in accordance with the Tuition Refund Policy for those students who officially drop a class or classes during the first three weeks of the semester. Fees are not refundable.

  • Drops prior to the first day of the semester: 95% Tuition Refund
  • Drops during the first calendar week of the semester: 75% Tuition Refund
  • Drops during the second calendar week of the semester: 50% Tuition Refund
  • Drops during the third calendar week of the semester: 25% Tuition Refund
  • No refund after the third calendar week of the semester.

Tuition will be refunded 100 percent for those courses which, at any time, are cancelled by the College. Failure to attend class, merely giving notice to the instructor, or stopping payment on a check is not considered an official drop or withdrawal.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Borough of Manhattan Community College (178)

(3.8-star rating across 178 reviews)
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Anonymous review on 8/7/2015
    The material covered in this course is great for beginners. It's the basics that all need to know. But my favorite part was the instructor/professor. He is a very nice guy who knows how to make every student feel comfortable participating in discussions and answering example questions. The quizzes and business problems are great for you to know if you understand the topics or not. I would recommend this course and instructor/professor for anyone who needs a start with SQL.
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Anonymous review on 8/7/2015
    Excellent instructor. Very thorough in going over all the course material that was included for the class. Answered any questions on problems if you didn't understand something.
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Reviewed by David H. on 10/1/2018
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Anonymous review on 10/9/2017
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Reviewed by Oluwatobi A. on 6/28/2016
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Reviewed by Jamie L. on 6/28/2016
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Anonymous review on 12/18/2015
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Anonymous review on 3/15/2015
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Reviewed by Jessica R. on 3/11/2015
  • Introduction to Structured Query Language (SQL) for Data Analytics

    Reviewed by Amaury F. on 3/5/2015
See reviews for other classes at Borough of Manhattan Community College
loading...
Hide Reviews

Similar Classes

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 7140 points. Points give you money off your next class!

Questions & Answers (4)

Get quick answers from CourseHorse and past students.

Question from Anonymous
Will I receive a certification?
Answer from Brenda L. CourseHorse StaffCourseHorse Staff
Hi there! This Intro course will only lead towards a certificate of completion. Hope this helps!
Answer Show answer
Cancel
Question from Tseyi T.
Will this class cover how to use SQL in Looker? or other BI tools?
Answer from Linda W. Verified Student
Hi Tseyi. When I took the class about a year ago, we just covered the various SQL statements. We used the PostGre database.
Answer from Jenn C. CourseHorse StaffCourseHorse Staff
Hi Tseyi! Furthermore, the following topics will be discussed (with practical and hands-on examples): - Careers in Data Management - Client/Server Computing - An Introduction to SQL Server - The essential SQL Skills
Answer Show all 2 answers
Cancel
Question from Julie C.
Is there a syllabus available for the course? From the CUNY website, this class is $699 and I understand the difference is $15 registration fee. What exactly is this registration fee?
Answer from Chermalyn P. CourseHorse StaffCourseHorse Staff
Hi Julie! The class details page has been updated and now includes an overview of what will be discussed. The syllabus is sent to students after they've enrolled in the class. As for the registration fee, this is collected by the school. They call it a Consolidated Service Fee (all students per semester).
Answer Show answer
Cancel
Question from Matthew B.
I believe September 4th is a holiday, but a class is scheduled for that day. Is that right?
Answer from Ciarra O. CourseHorse StaffCourseHorse Staff
Hi Matthew! You're correct! BMCC is closed on Sept 4th, thanks for catching that! You can view the additional dates by scrolling down to the "Start Dates" section, selecting the date, and clicking the "view schedule for sessions" dropdown"
Answer Show answer
Cancel

Borough of Manhattan Community College

Over the past three decades, the Borough of Manhattan Community College’s Center for Continuing Education and Workforce Development has had a strong tradition of offering extraordinary programs to New Yorkers.

Whether you want to expand your credentials, move into a new career field, or simply learn...

Read more about Borough of Manhattan Community College

CourseHorse Approved

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

Borough of Manhattan Community College

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...