Learn how to design and manage databases with SQL Server through hands-on training in NYC, covering topics such as data manipulation, querying, and optimization techniques.
6 classes have spots left
Technical Institute of America @ 545 8th Ave, New York, NY
Microsoft Certified Solutions Associate (MCSA): SQL Server tests and validates your skills to manage a large SQL Sever environments. This course will prepare students to take the 3 Microsoft exams needed to acquire the certification. Students will learn real world skills through a range of hands on labs. . This is a great course for students looking to acquire the MCSA certification. The course includes many hands on labs to ensure that...
This instructor-led course provides you with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. You will learn to use SQL Server 2008 R2 product features and tools to install and configure a database, manage database files, and create and tune indexes. This course incorporates materials from the Official Microsoft Learning Product 6231: Maintaining a Microsoft SQL Server 2008 R2 Database. Skills Gained Plan, install,...
This accelerated learning environment helps you build your skills and techniques to design, build, and deploy solutions that deliver more data to more people across your organization as well as prepare you for the MCSE: Business Intelligence certification exams. This extended-hours boot camp, led by senior instructors, includes targeted lectures using Microsoft Learning recommended content and six-month access to over 20 hands-on remote labs. This...
Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™
In this instructor-led course, you will learn to implement a Reporting Services solution in an organization. You will learn how to use the Reporting Services development tools to create reports and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. This course incorporates material form the Official Microsoft Learning Product 6236: Implementing and Maintaining Microsoft SQL Server 2008...
In this course, you will learn the skills required to maintain a Microsoft SQL Server 2012 or 2014 database by focusing on data storage, backup and restoration, importing and exporting data, security, database maintenance and the SQL Server Agent. This course incorporates material from the Official Microsoft Learning Product 20462: Administering Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-462 and along with on-the-job...
Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material from the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Skills Gained Uses of and ways to execute the Transact-SQL language Use querying tools Write SELECT queries to retrieve data Group and summarize data by using Transact-SQL Join data...
General Assembly @ 10 E 21st St, New York, NY
Do you keep hearing the word ‘SQL’ buzzing around and want to find out more about it? This 3 hour workshop will provide an introduction to fundamental concepts in relational databases and using the query language SQL. Participants will learn to how to work with data that is stored in a relational database. By the end of the workshop, you will be able to use basic SQL commands to pull data to answer business questions. This workshop is...
In this course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters, and functions. You will also learn procedure coding, such as indexes, concurrency, error handling, triggers, and SQL Common Language Runtime (CLR). This course incorporates material from the Official Microsoft Learning Product...
This instructor-led course provides you with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. You will learn to use SQL Server 2008 R2 product features and tools to install and configure a database, manage database files, and create and tune indexes. This course incorporates materials from the Official Microsoft Learning Product 6231: Maintaining a Microsoft SQL Server 2008 R2 Database. Our Microsoft Training Exclusives*...
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services. This course incorporates material from the Official Microsoft Learning Product...
In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions. You will learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services, and Data Analysis Expressions (DAX). You will then learn how to create and publish reports using reporting services, report execution and delivery, SharePoint PerformancePoint...
Learn to design and develop SQL Server 2012 or 2014 databases. In this course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters, and functions. You will also learn procedure coding, such as indexes, concurrency, error handling, triggers, and SQL Common Language Runtime (CLR). This course incorporates...
Hands On Technology Transfer, Inc. @ (Exact location to be announced), New York, NY
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2014. Students will install and configure SQL Server 2014 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/SSAS....
Hands On Technology Transfer, Inc.
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. SQL Server 2016 Business Intelligence: Integration Services and Analysis Services SQL Server 2016 provides a rich environment for business intelligence development. The focus of this five day course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS)...
Hands On Technology Transfer, Inc.
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2014. The course focuses on performing common administrative tasks, understanding how SQL...
Hands On Technology Transfer, Inc.
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. Full Course Name: SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS) This hands-on course introduces the SQL Server 2017 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students will complete hands-on exercises creating a number of reports...
Hands On Technology Transfer, Inc. @ (Exact location to be announced), New York, NY
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. The three day course includes an overview of the SQL Server business...
The data explosion is happening at every level of the business - across devices, applications, and individual roles. Become certified on Microsoft SQL Server and prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions. Demonstrate to potential hiring managers your essential skills and breakthrough insights in developing and maintaining the next wave of mission critical...
ONLC Training Centers @ 33 Wood Avenue S, Iselin, NJ
Prepare for MCSA SQL Server or MCSA Windows Server certification outside of traditional office hours with ONLC's MCSA After Hours Certification Program. Our MCSA After Hours Certification Program is designed to help you attain a MCSA certification every step of the way—from training, to exam prep, to taking your test—we’ve got it covered. The program takes place over a three month period. It gives you time to learn the material so that you...
This 3-day course is designed to give the right amount of Internals knowledge and wealth of practical tuning & optimization techniques that they can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create...
Try removing some filters.
SQL Server Training in NYC are rated 4.3 stars based on 3,313 verified reviews from actual CourseHorse.com purchasers.
More in Microsoft Servers
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.