SQL Server Level I (Live Online)

Learn the fundamentals of SQL (Structured Query Language) and relational databases, so you can start writing SQL queries to extract and understand the information stored in databases.This SQL starter course will provide you with strong foundational skills to explore the tables, columns, and rows stored in a database and write/code SQL queries to extract and start analyzing that data. Using practical, hands-on exercises, our expert instructor will guide you through understanding the basics of database architecture and will develop your skills in writing real SQL code.You’ll learn how to write SELECT statements to choose the specific columns you want from tables, start filtering the results using WHERE, AND/OR, IN, and NOT. You’ll learn how to use wildcard filters as well as mathematical comparisons like equals, greater than, less than, etc. to retrieve only the data you want. Finally, you’ll combine data from multiple tables with inner JOINs.By the end of this introductory hands-on course, you’ll be able to write basic SQL queries for Microsoft SQL Server. You’ll learn how to use the free SQL Server Management Studio app to explore the database and execute your SQL queries. The concepts you’ll learn on SQL Server can be applied to other flavors of SQL (such as Microsoft Access, PostgreSQL, MySQL, etc.) with minor syntax differences.What You’ll Learn at a GlanceExplore information stored in a database (tables, columns, rows, etc.) using the graphical interface of SQL Server Management Studio (Microsoft’s free database app)Write SQL queries to retrieve data from tables in a databasePrimary SQL clauses including SELECT and FROMFiltering the results using WHERE, AND/OR, IN, and NOTWildcard filters as well as mathematical comparisons like equals, greater than, less than, etc.Combine information from multiple tables with inner JOINsCourse SyllabusFoundations of SQL & DatabasesSQL Fundamental ConceptsExploring Databases & Writing SQL Statements (with the free SQL Server Management Studio app)Writing SQL QueriesWriting SELECT StatementsFiltering ResultsUsing Joins to Combine Data from Multiple TablesUnderstanding Table RelationshipsCombining Tables with JOINLearn database fundamentals—Write Database Queries with SQLSQL is the most commonly used coding language in databases around the world. SQL Level I covers the fundamentals of relational databases, Microsoft SQL Server, and the SQL database language. Learn how databases store data within tables and how to write queries to understand data.Our experienced instructor will guide you through a variety of queries, including wildcard filters and multi-table queries with inner and outer joins. At the end of the class, apply the skills you’ve learned in a series of practice tasks. Our course workbook includes step-by-step instructions for each activity so you can brush up on the tasks at work or home.At the end of this course, you’ll be able to do the following:Explore information stored in a database using SQL Server Management StudioWrite simple SQL queries to retrieve data from tables in a databaseUse primary SQL clauses and filter your dataPlease Note:Students must be comfortable using a computer. No other prior knowledge is required.Click HERE for the SyllabusLearn more about SQL Level 1 at NYIM Training