Learn the essentials of SQL and database management in NYC with classes that cover topics such as data modeling, query optimization, and database security.
18 classes have spots left
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...
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™
Explore private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Coding Private Group EventsThis 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...
This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content. What You'll Learn Design better indexes Determine...
Global Knowledge @ 1 State Street Plaza, New York, NY
Learn to design and monitor high performance and high available data solutions with Microsoft SQL Server 2012 and 2014. In this course, you will learn to plan and implement enterprise database infrastructure solutions using Microsoft SQL Server 2012 and 2014. You will be introduced to Enterprise Data Architecture along with multi-server configuration management. You'll then delve into database solutions including: consolidating database workloads,...
Learn to build analysis and reporting solutions with SQL Server 2012 or 2014. 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...
This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components. What You'll Learn Describe...
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,...
This official Microsoft 4-day instructor-led Provisioning SQL Databases training course (20765) is designed to teach students how to provision SQL Server databases both on-premise and in SQL Azure. Plus, get prepped for Microsoft exam 70-765, a requirement for MCSA: SQL 2016 Database Administration. You Will Learn How To: Provision a Database Server Upgrade SQL Server Configure SQL Server Manage Databases and Files (shared) Provision, migrate...
Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY
Duration: 6 Hours total (3 HOURS ONSITE TRAINING + 3 HOURS OF ONLINE ZOOM TRAINING) This training program is designed to address all the major topics required to get started with Analytics in SQL with no prior experience necessary. The program helps in critical thinking and implementation: Create a DB design for your day to day work data that you use in Excel Understand what you can do and what you cannot do. Or rather how hard or simple it...
Practical Programming @ 185 Madison Ave, New York, NY
This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. Also, this workshop will teach you advanced concepts of databases as well as how to write effective SQL queries you can use in your everyday work. Going over the major topics a data scientist...
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 course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic...
Borough of Manhattan Community College @ BMCC Virtual Learning, New York, NY
This course is intended for students who want to learn about the Linux operating system and prepare to pass the Linux+ certification exam from CompTIA (Powered by LPI). The course provides comprehensive coverage of topics related to Linux certification, including Linux distributions, installation, administration, X-Windows, cloud technologies, networking, and security. Prerequisites: CompTIA Network+ certification or course equivalent recommended....
Borough of Manhattan Community College @ BMCC Virtual Learning, New York, NY
Database professionals in the labor economy are on the rise and are creating a surge for individuals who possess the right skills to store and query large data sets. This introductory course is designed for those who have some or no knowledge of databases. The goal is to teach participants how to query a relational database for information and analysis. Jumpstart your career today! Note: This class is delivered virtually via Zoom
Borough of Manhattan Community College @ BMCC Virtual Learning, New York, NY
Expand your database knowledge to learn more advance techniques to manage and query data. A greater understanding of the SQL language will enable you to read or create more than the most basic queries. This series discusses the concept of SQL Queries from Basics to Advanced techniques. By taking this course students will also be prepared for the Microsoft Certified Professional (MCP) Exam 98-364. It will show employers that you understand and have...
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....
Try removing some filters.
Database Training in NYC are rated 4.3 stars based on 618 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 Coding
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.