Learn more about our SQL classes
Database Management in Microsoft SQL Server
In our SQL classes, you will use SQL as a tool to implement logic, define instructions and compose queries. In our intermediate-level course, we will create advanced queries and manipulate and index tables. In the advanced course, you will learn techniques for writing decision-making code using advanced functions.
SQL Training Benefits
- Practical and hands-on training focused on real-world applications of SQL
- Engaging instructors teaching in-person in our state-of-the-art Manhattan facility
- Free Retake within six months of the class
- Proprietary SQL course manual
- Small class sizes for personalized attention
Basic to Advanced SQL Courses & SQL Bootcamps
Beginner SQL Course Outline
Intermediate SQL Course Outline
Advanced SQL Course Outline
Corporate & Private SQL Training
Flexible training solutions & customized course content
Over two decades, NYIM has served the most prestigious businesses and institutions across the United States with its industry-leading SQL corporate training program. For our corporate clients, we can offer custom SQL training to meet the needs of your team and conduct the classes at your location or ours. Each SQL class will come with a free consultation to ensure that the content meets your standards. After the consultation, our curriculum team will work to customize the course material at no additional charge.
Inquire about corporate SQL training
Overview of SQL and its Applications
SQL is a database language used to communicate with databases. A database is a collection of data stored in an organized fashion. Databases contain tables, which stores a specific type of data. Consider a computer training company. Its database would have several tables, including customer data, classes, invoices, etc.
SQL is the database language, and it can be used across multiple Database Management Systems (DBMS), including Microsoft SQL Server, Microsoft Access, MySQL, PostgreSQL and more. Our SQL courses use Microsoft SQL Server, but the concepts can be applied across the DBMSs, with some different conventions and syntaxes.
With SQL, you can
- Retrieve, sort, and filter data
- Create calculated fields (a new field calculated from existing fields)
- Apply functions
- Group and summarize data
- Retrieve data from multiple tables with inner and outer JOINs
- Create stored procedures to save and reuse SQL code
- Create views to create tables based on other tables
Learn the SQL Programming Language in Microsoft SQL Server
- SQL (Structured Querying Language): Programming language used to manage data in a relational database management system
- SQL Server: In our SQL classes, you'll learn Microsoft SQL Server, Microsoft's database management application.
- In summary, SQL is the programming language, and SQL Server is the application, or a database management system (DBMS)
What You'll Learn in our SQL Courses
- Fundamentals of Relational Databases
- Major clauses including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
- Extract data with basic to advanced queries
- Use inner and out joins to pull data from multiple tables
- Summarize data with aggregate functions: SUM, AVERAGE, MIN, MAX, COUNT
- Create tables, views, and indexes
- Write decision-making code using advanced functions
SQL Certification NYC
Take our three core SQL classes and study for the SQL Certification exam "Database Fundamentals" (Exam 98-364). Based on the outline provided on the Microsoft exam page, the Database Fundamentals exam covers:
- Understanding core database concepts: how data is stored in tables; relational database concepts; data manipulation language; data definition language
- Create database objects: Choose data types; tables and how to create them; create views; create stored procedures and functions
- Manipulate Data: Select, insert, update and delete data; utilize SELECT queries to extract data, and combine result sets by using UNION and INTERSECT
- Understand data storage: Normalization; Primary, foreign, and composite keys; understand indexes
- Administer a database: Database security concepts; database backups and restore
For more information on how to take the certification exam, and how our SQL classes prepare you for the exam, please call or email us.