Discover Classes. Earn 10% Rewards.
Database Training
NYC
Learn the essentials of SQL and database management in NYC with classes that cover topics such as data modeling, query optimization, and database security.
Follow
64 following
18 classes have spots left
SQL Server 2008 R2 for Administration (M6231)
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*...
Oracle Database 11g: Admin Workshop II Release 2
This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Learn To: Diagnose and repair data failures with Flashback technology. Manage space to optimize database storage so you can respond to growing space requirements....
Oracle Database 12c: Clusterware Administration
This Oracle Database 12c: Clusterware Administration training will explore general cluster concepts and Oracle Clusterware architecture. Work with expert Oracle University instructors through interactive instruction and hands-on exercises to reinforce your learning. Learn To: Perform Grid Infrastructure pre-installation tasks. Install both Standard and Flex clusters. Add and remove nodes from a cluster in addition to upgrading and patching existing...
Database Classes Gift Card
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 Coding Private Group Events
Explore private group events and team building activities ranging from cooking to art, escape rooms, trivia, and more
Explore Coding Private Group Events
Implementing a Data Warehouse with Microsoft SQL Server
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...
DB2 10 for LUW: Basic Administration for Linux & Window
This course teaches you to perform basic database administrative tasks using DB2 10.1 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented including using the db2diag.log file messages to direct your investigation...
Implementing Data Models and Reports with MS SQL Server
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...
Oracle Database 11g: Admin Workshop I Release 2
This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. Learn To: Install Oracle Grid Infrastructure. Create and manage users. Install and configure an Oracle Database. Create and manage storage structures....
Managing HP 3PAR StoreServ II (HK904)
In this course, you will cover remote copy, system reporter, adaptive optimization, and peer motion. You will also cover performance, cost, high availability, and the new EVA to HP 3PAR Online Migration feature. You will spend 50 percent of class in hands-on labs using HP 3PAR arrays. What You'll Learn Understand the difference between synchronous, periodic asynchronous, and synchronous long distance (SLD) modes Perform a failover of a remote...
Managing HP 3PAR StoreServ II
This course covers Remote Copy, System Reporter (External and On-node), HP 3PAR Priority Optimization and QoS (Quality of Service), Peer Motion, and EVA to HP 3PAR Online Migration. Best Practices and Performance Monitoring are also addressed. Hands-on lab exercises help illustrate the concepts learned. The two-day course is 60 percent lecture and 40 percent hands-on labs using HP 3PAR arrays. In some cases students will partner with other students...
Oracle Database 12c: Admin, Install and Upgrade
This Oracle Database 12c: Admin, Install and Upgrade Accelerated course covers 7 days worth of content in only 5 days. It consists of the Oracle Database 12c: Administration Workshop Ed 1 course (5 days) and the Oracle Database 12c: Install and Upgrade Workshop Ed 1 course (2 days). This course will will teach you about the Oracle Database architecture and you will discover how to effectively manage an Oracle Database instance. You will also be provided...
Developing Microsoft SQL Server Databases (M20464)
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...
SQL Server 2014 BI: Integration and Analysis Services
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....
SQL Server 2016 BI: Integration and Analysis Services
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)...
SQL Server 2017 BI: Integration and Analysis Services
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 2017 Business Intelligence: Integration Services and Analysis Services provides a rich environment for business intelligence development. The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data...
Microsoft SQL Server 2014 Administration
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...
Microsoft SQL Server 2017 Administration
Hands On Technology Transfer, Inc.
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2017. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data,...
Microsoft Transact-SQL Programming
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 Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs,...
SQL Server 2017 BI: Application Devt (SSRS, 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. 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...
SQL Server 2016 Reporting Services
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...
SQL Server 2017 Reporting Services
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 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing...
Database Training in NYC are rated 4.5 stars based on 21 verified reviews from actual CourseHorse.com purchasers.
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Coding
Made in NYC
© CourseHorse, Inc. 2024 Loading...
