SQL for Beginners - Level 1 is unfortunately unavailable

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

Special School Offer!
10% Off Extensive Business Solutions Corp. Gift Cards! Learn More >

SQL for Beginners - Level 1

at Extensive Business Solutions Corp. - Midtown East

(16)
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)
Purchase Options
Save to WishList

6 people saved this class

Book Private Class
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. (16)

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

School: Extensive Business Solutions Corp.

Extensive Business Solutions Corp.
Special School Offer!
10% Off Extensive Business Solutions Corp. Gift Cards! Learn More >

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

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

42 Top Choices

SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Sep 22nd, 11am - 5pm Eastern Time

Introduction to SQL for Data Analytics

This class is temporarily being offered remotely.

at Borough of Manhattan Community College - Online BMCC Virtual Learning, New York, New York 00000

Dear prospective student, as you are aware New York State has been dealing with a declared state of emergency due to the novel coronavirus-19 outbreak. Please be aware that our future course dates may be delivered in either a traditional classroom face-to-face format or an on-line format or a hybrid model that mixes both live and online course delivery....

Saturday Nov 14th, 9:30am - 4:30pm Eastern Time

  (5 sessions)
$714

5 sessions

Databases and SQL Queries with Oracle

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

Learn the Structured Query Language, the industry-standard syntax for interacting with relational databases, using Oracle, the industry-leading database software.  This course will cover database diagramming, design, and creation, entity relationship (ER) modeling, querying, data warehousing, reporting, and more. This one course introduces you...

Tuesday Sep 22nd, 6:15pm - 8:45pm Eastern Time

  (10 sessions)
$675

10 sessions

SQL Bootcamp Remote

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Sep 22nd, 8am - 2pm Pacific Time

SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Sep 22nd, 8am - 2pm Pacific Time

SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy. SQL provides...

Tuesday Sep 22nd, 10am - 4pm Central Time

SQL Bootcamp Series

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

The wellbeing of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the Coronavirus situation very carefully and will be adjusting delivery of our programs. Due to the current health concerns in the greater San Francisco area, all GA short-form (one day) classes, workshops...

Saturday Oct 10th, 9am - 4pm Pacific Time

  (2 sessions)
$375

2 sessions

SQL Bootcamp Series

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

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

Saturday Oct 10th, 12pm - 7pm Eastern Time

  (2 sessions)
$375

2 sessions

SQL Bootcamp Series

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

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

Saturday Oct 10th, 12pm - 7pm Eastern Time

  (2 sessions)
$375

2 sessions

Querying Data with Transact-SQL

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

The main purpose of this 5-day, instructor-led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database...

Monday Sep 28th, 10am - 4:45pm Eastern Time

  (5 sessions)
$2,795

5 sessions

SQL Querying Fundamentals: Part 1

This class is temporarily being offered remotely.

at New Horizons Learning Group LA - Online Virtual Class, Online, California 00000

This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases. Who should attend This course is intended for individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Course Objectives...

Thursday Oct 1st, 6am - 2pm Pacific Time

Next Level SQL Programming

This class is temporarily being offered remotely.

at Out of Bounds Technology - Virtual Learning

This course explores how to identify and use advanced querying techniques to manipulate and index tables. All hands-on work is ANSI SQL compliant and should work with SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. Course Overview A company’s success hinges on responsible...

Thursday Oct 1st, 7am - 3pm Pacific Time

  (2 sessions)
$1,495

2 sessions

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

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 3rd, 8am - 2pm Pacific Time

Intermediate SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Seattle, Washington 00000

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 3rd, 8am - 2pm Pacific Time

Intermediate SQL Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online, Online, California 00000

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 3rd, 8am - 2pm Pacific Time

Intermediate SQL Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

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 3rd, 9am - 3pm Mountain Time

Intermediate SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

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 3rd, 10am - 4pm Central Time

Intermediate SQL Bootcamp Remote (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

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 3rd, 10am - 4pm Central Time

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

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 3rd, 11am - 5pm Eastern Time

Intermediate SQL Bootcamp (Online)

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

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 3rd, 11am - 5pm Eastern Time