Course ID: 314692
Querying Data with Microsoft Transact-SQL Training (DP-080)
<b>Important Course Information</b><ul class="accordion">
<li>
<h3>Who Should Attend This Course</h3>
<div>
<p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer....
# of Virtual Event(s)
10
# of Virtual Event(s)
10 EVENTS
Duration
2 days
Duration
2 days
Price: $1950
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)
3
# of Virtual Event(s)
3 EVENTS
Duration
n/a
Duration
n/a
Price: $1190
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)
1
# of Virtual Event(s)
1 EVENTS
Duration
2 days
Duration
2 days
Price: $1190
VIEW DETAILS
Course ID: 261317
Developing SQL Data Models (M20768)
<div><p>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.</p> <p>This course incorporates material from the Official Microsoft Learning Product 20768: Developing SQL Data Models</p> <p>�</p> <p><strong>Learn more about this topic. View the recorded webinar <a href="https://www.globalknowledge.com/us-en/resources/resource-library/recorded-webinar/overview-of-microsoft-sql-server-and-high-availability-options-3/">Overview of Microsoft SQL Server and High Availability Options</a></strong></p></div>...
# 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)
<div><p>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:</p> <ul> <li>Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session</li> <li>Redeem two SATVs for an individual GK Digital Learning course</li> </ul> <p>�</p> <p><em>*For more information on Microsoft SATVs, click<span>�</span><a href="https://www.globalknowledge.com/us-en/training/planning-logistics/payment-policies/payment-options/credits-vouchers/microsoft-satvs/">here</a>.</em></p></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2295
VIEW DETAILS
Course ID: 261314
Administering a SQL Database Infrastructure (M20764)
<div><p>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.</p></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 310559
Oracle 19c SQL Fundamentals
<div><p>Oracle 19C SQL Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently.</p> <p>�</p></div>...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $1945
VIEW DETAILS
Course ID: 312656
Model Based System Engineering with SysML Training
<b>Important Course Information</b><ul class="accordion">
<li>
<h3>Who Should Attend</h3>
<div>
<p>The course is intended as a comprehensive introduction to MBSE and SysML intended for practicing engineers, software developers or those with similar backgrounds. It is also useful an overview for managers who want to have an insightful talking understanding of the topic....
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 190322
SQL Server® Integration Services: Hands-On
<h3>Introduction to Integration Services</h3>
<ul><li>Defining SQL Server Integration Services (SSIS)
</li><li>Exploring the need for migrating diverse data
</li><li>The role of Business Intelligence (BI) </li></ul>
<h3>SSIS Architecture and Tools</h3>
<h4>Managing heterogeneous data</h4>
<ul><li>Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
</li><li>Running wizards for basic migrations
</li><li>Creating packages for complex tasks
</li><li>Explore other supported...
# of Virtual Event(s)
7
# of Virtual Event(s)
7 EVENTS
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 310558
Oracle 19c PL/SQL Fundamentals
<div><p>Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.</p></div>...
# of Virtual Event(s)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $2545
VIEW DETAILS
Course ID: 253717
SQL Server Introduction
You Will Learn How To:Create and administer SQL Server 2012 or 2014 databasesWrite Transact-SQL quer...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
4 days
Duration
4 days
Price: $2242
VIEW DETAILS
Course ID: 314568
Introduction to SQL Basics | Basic SQL Programming
A companyÆs success hinges on responsible, 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 valuable dat...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
3 days
Duration
3 days
Price: $2145
VIEW DETAILS
Course ID: 190172
Developing SQL Queries for Oracle® Databases: Hands-On
<h3>Introduction and Overview</h3>
<h4>The uses of SQL queries</h4>
<ul>
<li>Why SQL can be both easy and difficult</li>
<li>Recommendations for thorough testing</li>
</ul>
<h4>Enhancing query performance</h4>
<ul>
<li>Query optimization</li>
<li>Choosing the most efficient query method</li>
</ul>
<h3>Leveraging SQL Functions to Build Queries</h3>
<h4>Aggregate functions</h4>
<ul>
<li>Grouping in several levels</li>
<li>Grouping and NULLs</li>
<li>CUBE and ROLLUP</li>
<li>Building crosstab repor...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
4 days
Duration
4 days
Price: $2990
VIEW DETAILS
Course ID: 253668
Powerful SQL Queries for SQL Server
<b>You Will Learn How To</b><ul>
<li>Select the most efficient solution to complex SQL problems</li>
<li>Apply joins and subqueries</li>
<li>Identify and avoid common error situations</li>
<li>Ensure that correct queries continue to work correctly in the future</li>
<li>Produce test data for thorough and complete testing</li>
</ul><br/><b>Who Should Attend</b>Users and developers who want to learn how to use SQL to create powerful and complex queries to retrieve database content from SQL S...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
1 day
Duration
1 day
Price: $517
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)
6
# of Virtual Event(s)
6 EVENTS
Duration
3 days
Duration
3 days
Price: $2650
VIEW DETAILS
Course ID: 253738
Writing SQL Queries
<b>You Will Learn How To</b><ul>
<li>Write SQL SELECT statements based on ANSI/ISO standards to retrieve data from relational databases</li>
<li>Identify the fundamental database building blocks</li>
<li>Apply filter conditions to extract specific data</li>
<li>Combine multiple tables with different types of joins</li>
</ul><br/><b>Who Should Attend</b>This course is intended for users and developers interested in learning how to retrieve database content with SQL queries.<br/><b>Hands-On E...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
1 day
Duration
1 day
Price: $517
VIEW DETAILS
Course ID: 253739
Writing SQL Queries with SQL Server Management Studio
<b>You Will Learn How To</b><ul>
<li>Leverage SQL Server Management Studio to graphically design SQL queries</li>
<li>Write Transact-SQL statements to collect and analyze data</li>
<li>Target data retrieval with the WHERE clause</li>
<li>Manipulate data with INSERT, UPDATE, and DELETE statements</li>
</ul><br/><b>Who Should Attend</b>Anyone who is new to writing SQL statements for Microsoft SQL Server. Prior knowledge of SQL Server is not required....
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
1 day
Duration
1 day
Price: $517
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)
7
# of Virtual Event(s)
7 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)
8
# of Virtual Event(s)
8 EVENTS
Duration
3 days
Duration
3 days
Price: $1950
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)
6
# of Virtual Event(s)
6 EVENTS
Duration
5 days
Duration
5 days
Price: $3190
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.
