Developing SQL Databases is unfortunately unavailable

Thankfully we have 11 other SQL Classes for you to choose from. Check our top choices below or see all classes for more options.

Developing SQL Databases

at Corporate Training Group - New Jersey

(27)
Course Details
Price:
$2,975
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
New Jersey
120 S Wood Ave 4th Fl, Ste 405
Btwn Thornall St & Garden State Pkwy
Iselin, New Jersey 08830
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this sql class:

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

Audience Profile

The primary audience for this course is IT Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database.

At Course Completion
After completing this course, students will be able to:
  • Design and Implement Tables.
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including Optimized and Columnstore indexes
  • Design and Implement Views.
  • Design and Implement Stored Procedures.
  • Design and Implement User Defined Functions.
  • Respond to data manipulation using triggers.
  • Design and Implement In-Memory Tables.
  • Implement Managed Code in SQL Server.
  • Store and Query XML Data.Work with Spatial Data.
  • Store and Query Blobs and Text Documents.

Still have questions? Ask the community.

Refund Policy
Cancellation acceptable prior to 10 days before class date.

Map

Google Map

Corporate Training Group

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 29750 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Corporate Training Group (4)

School: Corporate Training Group

Corporate Training Group

Corporate Training Group, Inc. is a Microsoft Gold Certified Partner for Learning Solutions and Information Worker Solutions. CTG provides authorized training delivered by Microsoft Certified Instructors (MCT) using Microsoft Certified Courseware. CTG provides technical training and consulting services....

Read more about Corporate Training Group

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

11 Top Choices

Introduction to SQL and Data Analysis

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

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

Wednesday Nov 6th, 6pm - 9pm

  (3 sessions)
$399

3 sessions

SQL Bootcamp: Learning the Language

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. Takeaways Understand...

Thursday Oct 31st, 10am - 5pm

Provisioning SQL Databases

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This three-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. Audience Profile The primary audience for this course is individuals...

Monday Oct 21st, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Developing SQL Data Models

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS. Audience Profile The primary audience for this...

Monday Oct 21st, 10am - 6pm

  (3 sessions)
$1,785

3 sessions

SQL Bootcamp Series

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence and begin to unleash...

Thursday Oct 24th, 10am - 5pm

  (2 sessions)
$479

2 sessions

Intermediate SQL Bootcamp

at General Assembly - Financial District 1 Liberty St 3rd Fl, New York, New York 10006

Enabling analysts to broaden their SQL skills to retrieve and manipulate data from multiple sources into timely, cohesive, informative analysis. Takeaways We will be going over the following: JOIN and UNION with Aliasing Primary and Foreign Keys Aggregation and Functions Complex JOINs with multiple tables NULL values and related SQL functions...

Saturday Oct 26th, 10am - 4pm

Administering a SQL Database Infrastructure

at NetCom Learning - Hell's Kitchen 519 8th Ave, New York, New York 10018

Administering a SQL Database Infrastructure (SQL Server 2017) course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.  This...

Monday Oct 28th, 9am - 5pm

  (5 sessions)
$2,995

5 sessions

Administering a SQL Database Infrastructure

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

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

Monday Nov 11th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

SQL Querying: Basic

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but...

Thursday Nov 14th, 10am - 5pm

  (2 sessions)
$990

2 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

SQL Querying: Advanced

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle...

Thursday Dec 12th, 10am - 5pm