Course ID: 261317
Developing SQL Data Models (M20768)
The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768. This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models á Learn more about this topic. View the recorded webinar Overview of Microsoft SQL Server and High ...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 261311
Introduction to SQL Databases (M10985)
This course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. Note: Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session Redeem two SATVs for an individual GK Digital Learning course á *For more information on Microsoft SATVs, clickáhere....
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 318783
DP-080T00 Querying Data with Microsoft Transact-SQL
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics....
# of Virtual Event(s)
5
# of Virtual Event(s)
5 EVENTS
Duration
n/a
Duration
n/a
Price: $1190
VIEW DETAILS
Course ID: 261314
Administering a SQL Database Infrastructure (M20764)
In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain 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.áAdditionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases....
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 257537
55123 Writing Reports with Report Builder and SSRS Level 1
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS....
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 190261
Oracle® PL/SQL Programming: Hands-On
<h3>Introduction and Overview</h3>
<h4>PL/SQL fundamentals</h4>
<ul>
<li>Declaring and anchoring variables to database definitions</li>
<li>Flow control constructs</li>
</ul>
<h4>Oracle 11<i>g</i> and 12<i>c</i> PL/SQL features</h4>
<ul>
<li>PL/Scope in Oracle 11<i>g</i></li>
<li>Returning implicit cursor results from stored procedures in Oracle 12<i>c</i></li>
<li>Declaring local functions within SELECT statements in Oracle 12<i>c</i></li>
</ul>
<h3>Data Manipulation Techniques</h3>
<h4>Maintai...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
5 days
Duration
5 days
Price: $3190
VIEW DETAILS
Course ID: 270135
Writing Advanced SQL Queries
<h3>Introduction and Overview</h3>
<h4>SQL fundamentals</h4>
<ul><li>Why SQL can be both easy and difficult
</li><li>Recommendations for thorough testing</li></ul>
<h4>Retrieving data with SELECT</h4>
<ul><li>Expressions
</li><li>Literals
</li><li>Handling NULLs properly</li></ul>
<h4>Executing queries</h4>
<ul><li>Analyzing query plans
</li><li>Enhancing query performance
</li><li>Retrieving partly results with FETCH and OFFSET
</li><li>Selecting the best altern...
# of Virtual Event(s)
5
# of Virtual Event(s)
5 EVENTS
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 190312
SQL Programming Language: A Comprehensive Hands-On Introduction
<h3>SQL Overview</h3>
<ul>
<li>Outlining SQL as the cornerstone of database activity</li>
<li>Applying the ANSI/ISO standards</li>
<li>Describing the fundamental building blocks: tables, columns, primary keys and foreign keys</li>
</ul>
<h3>Building the Database Schema</h3>
<h4>Creating tables and columns</h4>
<ul>
<li>Building tables with CREATE TABLE</li>
<li>Modifying table structure with ALTER TABLE</li>
<li>Adding columns to an existing table</li>
<li>Removing tables with DROP T...
# of Virtual Event(s)
5
# of Virtual Event(s)
5 EVENTS
Duration
3 days
Duration
3 days
Price: $1950
VIEW DETAILS
Course ID: 310057
Next Level SQL Programming
A companyÆs success hinges on responsible and accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers, to setting financial goals. Data professionals like analysts, developers, and architects are tasked with creating, optimizing, managing, and analyzing data from databases, with little room for error. When databases arenÆt built or maintained correctly, itÆs easy to mishandle or lose valuabl...
# of Virtual Event(s)
9
# of Virtual Event(s)
9 EVENTS
Duration
2 days
Duration
2 days
Price: $1595
VIEW DETAILS
Course ID: 309337
Migrate NoSQL workloads to Azure Cosmos DB (DP-060T00)
This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB....
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
1 day
Duration
1 day
Price: $795
VIEW DETAILS
Course ID: 233569
SQL Server® 2012: A Comprehensive Hands-On Introduction
<h3>Introducing SQL Server</h3>
<h4>Overview of the SQL Server suite of products</h4>
<ul><li>Fundamentals of the relational database engine
</li><li>Benefits of the Business Intelligence stack</li></ul>
<h4>SQL Server components and tools</h4>
<ul><li>SQL Server Agent and Management Studio
</li><li>Integration Services
</li><li>Analysis Services
</li><li>Reporting Services
</li><li>Data Quality Services
</li><li>Master Data Services</li></ul>
<h3>Building the Database</h3>
<h4>Const...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 293285
Migrate SQL Workloads to Azure Training (DP-050)
<b>Important Course Information</b><ul class="accordion">
<li>
<h3>Prerequisites</h3>
<div>
<p>Successful students start this role with a fundamental knowledge of cloud computing concepts and professional experience in implementing SQL solutions. {course:8529} or {course:8566} will help with that knowledge....
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
2 days
Duration
2 days
Price: $1950
VIEW DETAILS
Course ID: 310075
Writing SQL Queries
SQL is the cornerstone of all relational database operations. In this hands-on course, youÆll learn how to employ the full potential of the SELECT statement to write robust queries using the best query method for your application. YouÆll also test your queries and learn to avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to select the most efficient solution in each situation. The course describes the ANSI/ISO SQL standard, but also identifi...
# of Virtual Event(s)
9
# of Virtual Event(s)
9 EVENTS
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 314620
DP-080T00 Querying Data with Microsoft Transact-SQL
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microso...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 261316
Implementing a SQL Data Warehouse (M20767)
In this course, provides students with the knowledge and skills to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse. á Learn more about this topic. View the recorded webinar Overview of M...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 268385
Introduction to Hadoop Administration (TTCHADADM3)
Apache Hadoop is an open source framework for creating reliable and distributable compute clusters. Hadoop provides an excellent platform to process large unstructured or semi-structured data sets from multiple sources to dissect, classify, learn, and make suggestions for business analytics, decision support, and other advanced forms of machine intelligence. This course will teach you how to install, maintain, monitor, troubleshoot, optimize, and secure Hadoop. Previous Hadoop experience is not ...
# of Virtual Event(s)
7
# of Virtual Event(s)
7 EVENTS
Duration
3 days
Duration
3 days
Price: $2195
VIEW DETAILS
Course ID: 251940
55069 PowerShell for SQL Server Administrators
This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks....
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 292727
Db2 12 for z/OS SQL Performance and Tuning
Learn how to prevent SQL performance problems and how to improve the performance of existing SQL.
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
3 days
Duration
3 days
Price: $2610
VIEW DETAILS
Course ID: 246248
DB2 SQL Workshop
This course provides an introduction to the SQL language. Note: This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment. á...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
2 days
Duration
2 days
Price: $1590
VIEW DETAILS
Course ID: 260665
Tableau: Presenting Analytic Visualizations
<h3>Getting Started with Tableau</h3>
<h4>Employing visual analysis and analytics</h4>
<ul>
<li>Appreciating the impact of Big Data on visualization
</li><li>Handling large volumes of data
</li><li>Presenting visualizations to analysts and business users
</li></ul>
<h4>Exploring Tableau</h4>
<ul>
<li>Utilizing the Tableau interface components
</li><li>Distinguishing measures and dimensions
</li><li>Generating basic visualizations
</li></ul>
<h3>Data Visualizations for Business Intel...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
TrainUp.com is your one-stop source for the best virtual sql server training and live courses nationwide. Start your search now and browse among 47 live instructor-led sql server training classes near you, from the industry's best sql server training companies such as SkillSoft, BizLibrary, and New Horizons TrainUp.com also lists more than 275 self-paced online sql server training courses, micro-learning videos, and eLearning bundles. If you have a team to train, we can conduct a course just for you. Check out our onsite on-site sql server training page to request a custom virtual or in-person training quote today.
Request SQL Server On-Site Training. We bring the best instructors to you.
