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

Beginner SQL Course Outline

What You'll Learn in this Class:

  • 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

Basic Concepts

• Microsoft SQL Server
• What is SQL?
• What are Relational Databases?

The Graphic User Interface

• Object Explorer
• Query Window
• Results Grid
• Options

The Code

• Basic Clauses
• Field and Table Aliases
• Creative use of Aliases
• Inner and Outer Table Joins
• Self Joins
• Union Joins
• Cross Joins
• Aggregations
• Distinct Records
• Text Criteria & Operators
• Wildcard Filters
• Numeric Criteria & Operators

Student Labs