SQL for Beginners - Level 1 is unfortunately unavailable

Thankfully we have 15 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

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

Wednesday Nov 6th, 6pm - 9pm

  (3 sessions)
$399

3 sessions

Introduction to SQL for Data Analytics

at Borough of Manhattan Community College - Financial District 25 Broadway, 8th Floor, New York, New York 10004

Database professionals in the labor economy is on the rise. Over the next 10 years the Department of Labor has projected an 11% job increase creating a surge for individuals who possess the right skills to store and query large data sets.  This course is designed for those who have some or no knowledge of databases and would like to jumpstart...

Saturday Sep 28th, 9:30am - 4:30pm

  (5 sessions)
$714

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

Friday Sep 20th, 10am - 5pm

Querying Data with Transact-SQL (SQL Server 2017)

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

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. This course is based on the objectives of the course...

Monday Sep 23rd, 9am - 5pm

  (5 sessions)
$2,995

5 sessions

Databases and SQL Queries with Oracle

at Baruch College - CAPS - Murray Hill 10010

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

Thursday Oct 3rd, 6:15pm - 9:15pm

  (8 sessions)
$675

8 sessions

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

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 Sep 30th, 9am - 5pm

  (5 sessions)
$2,995

5 sessions

Intermediate SQL Bootcamp

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

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

Friday Oct 4th, 10am - 4pm

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

Monday Oct 7th, 10am - 5pm

  (2 sessions)
$990

2 sessions

Developing SQL Databases

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

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database. Audience Profile The primary audience for this course is IT Professionals who want to...

Monday Oct 14th, 10am - 6pm

  (5 sessions)
$2,975

5 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 Oct 14th, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

Provisioning SQL Databases

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

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. Audience Profile The primary audience for this course is individuals...

Monday Oct 21st, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Developing SQL Data Models

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

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS. Audience Profile The primary audience for this...

Monday Oct 21st, 10am - 6pm

  (3 sessions)
$1,785

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

Monday Nov 4th, 10am - 5pm

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