(212) 684-5151

Beginner SQL
Beginner SQL

Price: $325.00

Course Code: SC | Hours: 8

SQL Training Classes NYC

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.

For more of the top SQL classes in New York City, see our intermediate and advanced SQL courses. Our intermediate SQL training covers advanced querying using subqueries, manipulating table data and table structure, and indexing data. Our advanced SQL class reviews text functions, stored procedures, and automating processes.

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

Prerequisites:

In this introductory SQL training, all required resources will be provided to the students.

Next Classes:

Related Classes:

See Also:

Prerequisites:

In this introductory SQL training, all required resources will be provided to the students.

Next Classes:

Related Classes:

See Also:

Beginner SQL Course Overview

Lesson 1: Executing a Simple Query

• Topic 1A: Connect to the Database
• Topic 1B: Query the Database
• Topic 1C: Modify a Query
• Topic 1D: Save a Query
• Topic 1E: Execute a Saved Query

Lesson 2: Performing a Conditional Search

• Topic 2A: Search Using a Simple Condition
• Topic 2B: Compare Column Values
• Topic 2C: Search Using Multiple Conditions
• Topic 2D: Search for a Range of Values and Null Values
• Topic 2E: Retrieve Data Based on Patterns

Lesson 3: Working with Functions

• Topic 3A: Perform Date Calculations
• Topic 3B: Calculate Data
• Topic 3C: Manipulate String Values

Lesson 4: Organizing Data

• Topic 4A: Sort Data
• Topic 4B: Group Data
• Topic 4C: Filter Grouped Data
• Topic 4D: Summarize Grouped Data

Lesson 5: Retrieving Data from Multiple Tables

• Topic 5A: Combine Results of Two Queries
• Topic 5B: Retrieve Data by Joining Tables
• Topic 5C: Check for Unmatched Records
• Topic 5D: Retrieve Information from a Table Using Joins

Lesson 6: Presenting Query Results

• Topic 6A: Customize and Save the Query Result
• Topic 6B: Generate an HTML Report

Appendix A: The FullerAckerman Database