Course ID: 256656
SQL Server Performance Tuning and Optimization (M55144)
<div><ul> <li>SQL 2014 Architecture including the new Cardinality Estimator</li> <li>Memory-optimized tables</li> <li>Startup stored procedures</li> <li>Database structures</li> <li>Instant File Allocation</li> <li>Table internals and valued parameters</li> <li>Concurrency, transactions, and isolation levels</li> <li>SQL Server locking architecture</li> <li>Partitioned tables and indexes</li> <li>Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)</li>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 328623
Administering a SQL Database (55316)
<div><ul> <li>Authenticate and authorize users</li> <li>Assign server and database roles</li> <li>Authorize users to access resources</li> <li>Use encryption and auditing features to protect data</li> <li>Describe recovery models and backup strategies</li> <li>Backup and Restore SQL Server databases</li> <li>Automate database management</li> <li>Configure security for the SQL Server agent</li> <li>Manage alerts and notifications</li> <li>Managing SQL Server using PowerShell</li> <li>Trace access...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
5 days
Duration
5 days
Price: $2995
VIEW DETAILS
Course ID: 314771
Transact-SQL Querying (DP-080T00)
<div><p>Students will learn to,</p> <ul> <li>Use SQL Server query tools</li> <li>Write SELECT statements to retrieve columns from one or more tables</li> <li>Sort and filter selected data</li> <li>Use built-in functions to returned data values</li> <li>Create groups of data and aggregate the results</li> <li>Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE</li> </ul></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
2 days
Duration
2 days
Price: $1545
VIEW DETAILS
Course ID: 314568
Introduction to SQL Basics | Basic SQL Programming
<div><p>Working in a hands-on learning environment led by our expert practitioner, attendees will explore:</p> <ul> <li>Basic RDBMS Principles</li> <li>The SQL Language and Tools</li> <li>Using SQL Developer</li> <li>SQL Query Basics</li> <li>WHERE and ORDER BY</li> <li>Functions</li> <li>ANSI 92 Joins</li> <li>ANSI 99 Joins</li> <li>GROUP BY and HAVING</li> <li>Subqueries</li> <li>Regular Expressions</li> <li>Analytics</li> </ul></div>...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $1995
VIEW DETAILS
Course ID: 310057
Next Level SQL | Intermediate to Advanced SQL Programming (TTSQL005)
<div><p>Join an engaging hands-on learning environment, where youll learn:</p> <ul> <li>Advanced Query Techniques</li> <li>Manipulating Table Data Using SQL's Data Manipulation Language (DML)</li> <li>User-Defined Functions</li> <li>Stored Procedures</li> <li>Triggers</li> </ul> <p>This course has a 50% hands-on labs to 50% lecture ratio with engaging instruction, demos, group discussions, labs, and project work.</p></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
2 days
Duration
2 days
Price: $1595
VIEW DETAILS
Course ID: 310075
Introduction to Writing SQL Queries (TTSQL003)
<div><p>Join an engaging hands-on learning environment, where youll learn:</p> <ul> <li>Maximize the potential of SQL to build powerful, complex and robust SQL queries</li> <li>Query multiple tables with inner joins, outer joins and self joins</li> <li>Construct recursive common table expressions</li> <li>Summarize data using aggregation and grouping</li> <li>Execute analytic functions to calculate ranks</li> <li>Build simple and correlated subqueries</li> <li>Thoroughly test SQL queries to avo...
# of Virtual Event(s)
3
# of Virtual Event(s)
3 EVENTS
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 331340
Writing Powerful SQL Queries for SQL Server
Gain the skills to maximize the potential of SQL, formulate powerful, complex queries, and avoid common errors and pitfalls...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
1 Day
Duration
1 Day
Price: $690
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)
3
# of Virtual Event(s)
3 EVENTS
Duration
4 days
Duration
4 days
Price: $2242
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)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $2395
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)
2
# of Virtual Event(s)
2 EVENTS
Duration
4 days
Duration
4 days
Price: $2242
VIEW DETAILS
Course ID: 310559
Oracle 19c SQL Fundamentals
<div><p>Initially, you will learn about all the key elements of a database and the way Oracle systems facilitate their induction in the system. Then you will discover the tools you can use and the strategies you can implement to store, retrieve, compare and organize data according to your requirements.</p> <p>You will also learn the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required t...
# of Virtual Event(s)
1
# of Virtual Event(s)
1 EVENTS
Duration
3 days
Duration
3 days
Price: $1795
VIEW DETAILS
Course ID: 331296
Writing SQL Queries Training
Attend this Writing SQL Queries course and learn the essentials of the SQL language used by all relational database products...
# of Virtual Event(s)
4
# of Virtual Event(s)
4 EVENTS
Duration
1 Day
Duration
1 Day
Price: $690
VIEW DETAILS
Course ID: 292727
Db2 12 for z/OS SQL Performance and Tuning
<div><p>After completing this course, you will be able to:</p> <ul> <li>Understand and design better indexes</li> <li>Determine how to work with the optimizer (avoid pitfalls, provide guidance)</li> <li>Optimize multi-table access</li> <li>Work with subqueries</li> <li>Avoid locking problems</li> <li>Use accounting traces and other tools to locate performance problems in existing SQL</li> </ul></div>...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2610
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)
3
# of Virtual Event(s)
3 EVENTS
Duration
3 days
Duration
3 days
Price: $1987
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)
2
# of Virtual Event(s)
2 EVENTS
Duration
4 days
Duration
4 days
Price: $2242
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)
2
# of Virtual Event(s)
2 EVENTS
Duration
1 day
Duration
1 day
Price: $517
VIEW DETAILS
Course ID: 237392
DB2 SQL Workshop for Experienced Users
<div><ul><li>Discuss basic relational database concepts </li><li>Use some of the OLAP features of DB2, such as GROUPing and RANKing functions </li><li>Create tables, views and indexes </li><li>Use referential integrity, check constraints and triggers </li><li>Use outer joins, and join tables to themselves </li><li>Use CASE expressions, and the CAST function </li><li>Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables </li><li>Use complex subqueries </li><li>Use...
# of Virtual Event(s)
2
# of Virtual Event(s)
2 EVENTS
Duration
3 days
Duration
3 days
Price: $2385
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)
2
# of Virtual Event(s)
2 EVENTS
Duration
1 day
Duration
1 day
Price: $517
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)
4
# of Virtual Event(s)
4 EVENTS
Duration
3 days
Duration
3 days
Price: $1462
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: $2392
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.
