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
Elements of this syllabus are subject to change.This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses 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. After completing this course, students will be able to: Describe SQL Server...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This 5-day instructor-led course teaches IT professionals how to administer and support Exchange Server 2016. Students will learn how to install Exchange Server 2016, and how to configure and manage an Exchange Server environment. The course covers how to manage mail recipients and public folders, including how to perform bulk operations using Exchange Management Shell. Students also will learn how to manage client connectivity, message transport...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This course provides experienced Exchange Server administrators with the knowledge to design and implement an Exchange Server 2016 messaging environment. Students will learn how to design and configure advanced components in an Exchange Server 2016 deployment such as site resiliency, advanced security, compliance, archiving, and discovery solutions. In addition, students will learn about coexistence with otherExchange organizations or Exchange...
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™
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. Audience profile: The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related...
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464. Note: This...
ONLC Training Centers @ 33 Wood Avenue S, Iselin, NJ
This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses 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. Audience This course is intended for information technology (IT) professionals and developers who need to implement reporting...
ONLC Training Centers @ 33 Wood Avenue S, Iselin, NJ
This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution. Audience The primary audience for this course is individuals who design and maintain...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
Prerequisites: Before attending this course, students must have: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of database administration and maintenance. Working knowledge of Transact-SQL Course Objectives: This course is designed to give the right amount of Internals knowledge, and wealth of practical tuning and optimization techniques, that you can put into production. The course...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability....
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting...
Corporate Training Group @ 120 S Wood Ave, Iselin, NJ
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases. Audience Profile The primary audience for this course is individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure...
In this accelerated learning environment, you will build your skills and prepare for the MCSA: SQL Server 2012 certification exams. This extended-hours boot camp led by senior instructors includes targeted lectures using Microsoft Learning recommended content as well as six months of access to more than 40 hands-on remote labs. This boot camp includes all the exam vouchers required for certification, along with one free retake voucher if needed....
In this course, you will learn the technical skills required to write basic Transact-SQL (T-SQL) queries for Microsoft SQL Server 2012 and 2014. This is the foundational course for all SQL server related disciplines: database administration, database development and business intelligence. Tools and skills you will learn include: SQL Server Management Studio, T-SQL, SELECT statements in querying multiple tables, data types, data sorting and filtering,...
ONLC Training Centers @ 33 Wood Avenue S, Iselin, NJ
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Audience Profile This course is intended for Database Administrators, Database Developers, and...
ONLC Training Centers @ 33 Wood Avenue S, Iselin, NJ
This three-day instructor-led is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2012 Reporting Services. During this course, attendees will learn how to Report Designer in SSDT and Report Builder, work with solutions and projects, design basic reports, enhance reports with formatting and images, effectively group and summarize data, work with parameterized reports, incorporate...
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. What You'll Learn Uses of and ways to execute the Transact-SQL language Use querying tools Write SELECT queries to retrieve data ...
NetCom Learning @ 519 8th Ave, New York, NY
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server...
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the...
Try removing some filters.
SQL Server Training in NYC are rated 4.2 stars based on 41 verified reviews from actual CourseHorse.com purchasers.
Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!
Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!
Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!
Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!
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.