Discover Classes. Earn Rewards.
SQL for Beginners - Level 1 is unfortunately unavailable

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

SQL for Beginners - Level 1

at Extensive Business Solutions Corp. - Midtown East

(5)
Course Details
Price:
$270
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Midtown East, Manhattan
845 3rd Ave 6th Fl
Btwn E 51st & 52nd Streets
New York, New York 10022
(Map)
Share:
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 1
Teacher: Shivgan Joshi

What you'll learn in this sql class:

Duration: 6 Hours total (3 HOURS ONSITE TRAINING + 3 HOURS OF ONLINE ZOOM TRAINING)

This training program is designed to address all the major topics required to get started with Analytics in SQL with no prior experience necessary.

The program helps in critical thinking and implementation:

  • Create a DB design for your day to day work data that you use in Excel
  • Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.Understand Data Wrangling using Group, Joins, and UNION to get data in the format you need
  • For any data that comes through new tools get new insights
  • Get Excel equivalent functions for SQL commands
  • Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)

OTHER AREAS COVERED 

  • Understand why SQL is needed as a solution to the limitation of excel
  • Connect to the SQL Server database and execute a simple query.
  • Includes search condition in a simple query.Use various functions to perform calculations on data.
  • Organize data obtained from a query before it is displayed on-screen.
  • Use New York City data for running on SQL

Why will this workshop help you?

The 3-hour on-site workshop will get you started with data analytics using SQL, which is one of the most commonly used tools for data analytics. A wide range of organizations and businesses in all industries use SQL for data analytics. SQL can serve as the solution for Microsoft Excel’s limitations. This training workshop will get you acquainted with how you can use SQL in your everyday work. No prior experience is necessary.

You will be trained on:

  • The fundamentals of SQL, databases, and data analytics
  • How to think like a SQL developer
  • How to execute a simple queries to be used in your day to day work
  • Filtering, sorting, grouping, and joining data
  • Data wrangling terms used in data analytics that are also common in other languages such (Python & R)
  • SQL commands for equivalent Microsoft Excel function
  • How to perform calculations on data 

What you’ll take away from this course:

  • Knowledge on how to create a database and querying
  • Knowledge on how to sort, group, join, and filter your data
  • Preparation to move on to the Level 2 Intermediate SQL for Data Analytics Executive Training
  • Lines of SQL code to add to your portfolio

What to Bring:

  • Laptop with minimum 8GB ram and Chrome installed on it.
  • Notebook for writing down notes

Still have questions? Ask the community.

Refund Policy

  • If you enroll for a course that is scheduled to begin in under 7 days, you must request cancellation via email within the first 24 hours after enrollment in order to receive a full refund - less $50 processing fee.
  • For cancellations, we must receive a cancellation request or notice via email at least 10 days prior to the first scheduled session in order to issue a full refund – less a $50 processing fee.
  • You may also cancel 3 to 10 days prior to the first scheduled session and receive a 50% refund. 
  • If you cancel less than 3 days prior to the first scheduled session you will be required to pay the full amount for the course. 
  • All refunds will be processed within 30 business days. 

Map

Google Map

Extensive Business Solutions Corp.

All classes at this location

Easy access from E, M, 6 train at Lexington 53rd Street, take 3rd Avenue 53rd Street Exit, then 1 min walk towards downtown.

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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 2700 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Extensive Business Solutions Corp. (5)

(5 Reviews)
SQL for Beginners - Level 1
Reviewed by Amber K. on 7/20/2019
loading...

School: Extensive Business Solutions Corp.

Extensive Business Solutions Corp.

EBS Corp aims to empower executive-level, business, and working professionals with our technical
skills development programs. Our programs focus...

Read more about Extensive Business Solutions Corp.

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

9 Top Choices

Introduction to SQL and Data Analysis

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. Also, this workshop will teach you advanced concepts of databases as well as how to write...

Wednesday Nov 6th, 6pm - 9pm

  (3 sessions)
$399

3 sessions

SQL Bootcamp: Learning the Language

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand...

Thursday Oct 31st, 10am - 5pm

SQL Bootcamp Series

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence and begin to unleash...

Thursday Oct 24th, 10am - 5pm

  (2 sessions)
$479

2 sessions

Intermediate SQL Bootcamp

at General Assembly - Financial District 1 Liberty St 3rd Fl, New York, New York 10006

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions...

Saturday Oct 26th, 10am - 4pm

Administering a SQL Database Infrastructure

at NetCom Learning - Hell's Kitchen 519 8th Ave, New York, New York 10018

Administering a SQL Database Infrastructure (SQL Server 2017) course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.  This...

Monday Oct 28th, 9am - 5pm

  (5 sessions)
$2,995

5 sessions

Administering a SQL Database Infrastructure

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases. Audience Profile The primary audience for this...

Monday Nov 11th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

SQL Querying: Basic

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but...

Thursday Nov 14th, 10am - 5pm

  (2 sessions)
$990

2 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

SQL Querying: Advanced

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle...

Thursday Dec 12th, 10am - 5pm

Loading...