Yelp Facebook LinkedIn YouTube Twitter Instagram

SQL Level I

Introduction to SQL Classes in NYC

The SQL Level I course will provide you with strong foundational skills within three core topics: Relational Database Management Systems (RDBMSs), SQL code, and Microsoft SQL Server. Using practical, hands-on exercises, our expert instructor will guide you through understanding database architecture and will develop your skills in writing real SQL code. Queries covered in SQL Level I include wildcard filters and multi-table queries with inner and outer joins.

By the end of this course, you'll be able to write SQL queries in Microsoft SQL server. You'll also be able to apply what you've learned to other Database Management Systems (DBMSs) that are compatible with SQL, such as MySQL, MariaDB, PostgreSQL, and Microsoft Access.

SQL Level I is taught at our affiliate school, NYIM Training, in Midtown Manhattan.

  • 8 Hours
  • Small classes
  • PC only
  • Free retake

Register for this class

$325

185 Madison Ave, NYC

This course is offered at our affiliate business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on our affiliate's website.

What You’ll Learn

  • Fundamentals of Relational Databases
  • What is SQL and SQL Server?
  • Major clauses including SELECT and FROM
  • Sort data with ORDER BY clauses
  • Filter and group data with WHERE, GROUP BY, HAVING
  • Simplify queries with aliases
  • Extract data with queries
  • Use inner and out joins to pull data from multiple tables
  • Summarize data with aggregate functions: SUM, AVERAGE, MIN, MAX, COUNT
View full syllabus

SQL Level I Class Syllabus

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
  • Complete a hands-on project to retain and refine skills

Build SQL Skills to Dive Deep into your Data!

Learn the skills that industry professionals use to store and manage intricate data. Our expert instructors help you maximize your organization's decision-making capabilities through hands-on activities and real-world examples that you'll be able to apply to your own professional context right away! 

Industry Professional Instructors

Our instructors are industry professionals who draw on their experience to teach real-world applications and time-saving techniques for database management. Learn tips, tricks, and keyboard shortcuts that you can use right away.

Students learning SQL

Practical, Hands-on Examples and Activities

Throughout this course, you will explore SQL techniques by practicing with real-world examples. You’ll gain extensive exposure to each new skill during class exercises, as well as apply the concepts you learned in a relevant culminating project.

Customized SQL training manual

Register for this class

$325

185 Madison Ave, NYC

This course is offered at our affiliate business training school, NYIM Training, in Midtown Manhattan. Register for this course directly on our affiliate's website.