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.

Continue reading

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