Database Training NYC

All Locations NYC Los Angeles Chicago Online Boston Nashville Houston Washington, D.C. San Diego San Francisco Seattle Atlanta Denver San Jose Charlotte New Jersey Brooklyn

Querying Microsoft SQL Server

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...

Querying Data with Transact-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...

MongoDB Intensive Workshop

General Assembly

MongoDB is only four years old and it has already become the most popular NoSQL database solution in the world. It combines powerful querying capabilities with unparalleled flexibility, yet also manages to be very approachable. Ideal for data scientists, people with some programming experience in any language, or those familiar with SQL and looking to learn about NoSQL options, this class will introduce you to the world of MongoDB and leave you with...

Oracle Database 12c Introduction

Learning Tree International

To efficiently handle today's business-critical information, organizations need database systems that are reliable and scalable, as well as experienced professionals to manage them. In this training course, you gain the skills to unleash the power and flexibility of Oracle Database 12c, while gaining a solid foundation of database concepts, SQL, and PL/SQL, so you can develop robust databases. You Will Learn How To: Build robust and scalable Oracle...

Developing Microsoft SQL Server 2014 Databases

Learning Tree International

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...

Intro to SQL & Databases

NYC Career Centers @ 185 Madison Ave, New York, NY

Administering a SQL Database Infrastructure

Corporate Training Group @ 120 S Wood Ave, Iselin, NJ

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases. Audience Profile The primary audience for this course is individuals who administer and maintain SQL Server databases.These individuals perform database...

Hadoop and NoSQL for Terrified Absolute Beginners

General Assembly @ 902 Broadway, New York, NY

You’ve probably heard about “big data,” but chances are you haven’t been told what it means. In this class, you’ll receive a comprehensive overview of the technologies powering big data — including the history of databases and storage, the difference between relational and “document” databases, the challenges of big data and the tools it necessitates, and demystifying “map reduce” and Hadoop. Whether you’re a product manager,...

Oracle Database 11g: Administration Workshop I R 2

NetCom Learning

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner...

Oracle Database 12c: RAC Administration

ExitCertified

This Oracle Database 12c: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. Learn To: Install Oracle RAC software. Create cluster databases. Administer both administrator and policy-managed Oracle RAC databases. Monitor and address performance issues. Learn about services in a RAC environment as well as highly available...

Oracle Database 12c: Backup and Recovery Workshop Ed2

ExitCertified

This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. Learn To: Develop appropriate backup and recovery procedures to address your business needs. Implement backup and recovery settings and perform backup operations to disk and tape. Employ Oracle Database recovery procedures...

Website Development Professional Combo

NetCom Learning @ 519 8th Ave, New York, NY

The class begins with HTML, the mark-up language that is the basis of the entire web, then continues to teach JavaScript, which is the most common client side language on the web. A hands-on exploration of PHP and MySQL follows. The combination of the PHP programming language and MySQL database technology allows participants to develop increasingly complex web applications. Finally the class introduces AJAX; a red hot technology that many believe...

DB2 for z/OS Application Data Recovery (CV891G)

Global Knowledge

Learn how data and index recovery is supported by DB2 for z/OS in order to develop the knowledge and skills you need to design and implement backup and recovery procedures for your installations. Practice using the utility functions and techniques included in the lecture material during extensive interactive machine lab exercises on a z/OS system. Course Materials The course materials cover DB2 for z/OS V9. The content is also appropriate for...

Oracle Database 12c: New Features for Admin Ed 2

ExitCertified

In the Oracle Database 12c: New Features for Administrators Ed2 course, you’ll learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability and performance Learn To: Manage the Oracle multitenant container databases and pluggable databases. Configure Heat Map and use Automatic Data Optimization. Benefit from Online Datafile Move....

Oracle Database 12c: Introduction to SQL Ed 1.1

ExitCertified

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Learn To: Understand the basic concepts of relational databases ensure refined code by developers. Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database...

MCSA: SQL Server 2012 Boot Camp

ExitCertified

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....

Updating Your SQL Server Skills to Microsoft SQL Server

Corporate Training Group @ 330 West 38th St, New York, NY

This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008. The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.   The primary audience for this course is database and business intelligence (BI) professionals who are familiar...

Oracle Database 12c: Performance Management and Tuning

ExitCertified

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. Learn To: Use the Oracle tuning methodology. Use Oracle-supplied tools for monitoring and diagnosing...

Querying Microsoft SQL Server (M20461)

ExitCertified

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,...

Querying Microsoft SQL Server

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...