LEARNFAST CMS

Course Name

CRM Qualification Value

Netsuite Product

Course Level

None Beginner Intermediate Advanced

Show Page Title

Yes, Show the page title No, Hide the page title

Header Block

Information Block Contact Form Block

Background Fill

Yes No

Publish

Learning Methods

Instructor-Led Classes Mentored Learning Distance Learning

Instructor-Led Classes

Online learning

Title

Title Background color

Block Colour

Dashboard Image

Category

External link

Accreditation

Promo

Accredited by
Credit Details

Full Time Fee Part Time Fee Online Cost Cost Terms

Registration Fee Laptop Cost Laptop Registration Fees

Core Spec Med Spec High Spec

Laptop Terms

Terms

Installments

2M 3M 6M 9M 12M 18M 24M Early Bird Discount 10%

Page Title

Price Description

Payment Terms

Overview

<p><span style="font-size:14px;"><span style="font-family:segoe ui;">This course will teach the basics of Microsoft's dialect of the standard SQL language:<strong> Transact-SQL</strong>. 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. No formal exam is available.</span></span></p>

<p><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Features & Benefits</strong></span></span></p>

<ul>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;"> This is an authorised<strong> Microsoft Official Course (MOC). </strong></span></span></li>
</ul>

<ul>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;">Attendees will learn <strong>practical skills</strong> which can be applied in the work environment. </span></span></li>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;">Even though Microsoft retired the certification exams for MCSA/E/D certifications, we will still provide you with a Microsoft Certificate of Completion of your course.</span></span></li>
	<li><span style="font-size:14px;"><span style="font-family:segoe ui;">Take full advantage of our new <strong>Hybrid Learning</strong> by attending <strong>on campus</strong> or <strong>virtually.</strong> Have all your classes ready to be <strong>downloaded</strong> and <strong>watched</strong>, anytime, anywhere. <a href="http://learnfast.co.za/pgs-153-hybrid-learning.html">(Read More) </a></span></span></li>
</ul>

Duration

Career Options

Financing Options

Admission Requirements

Important Notes

<ul>
	<li>
	<div><span style="font-family:segoe ui"><span style="font-size:14px"></span></span><span style="font-size:14px;"><span style="font-family:segoe ui;">Learners to arrive at the training venue from 08:00 in preparation for 08:30 starting time </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="1" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{21}" paraid="1182152953"><span style="font-size:14px;"><span style="font-family:segoe ui;">Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order. </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="2" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{28}" paraid="1081372771"><span style="font-size:14px;"><span style="font-family:segoe ui;">For full day, on campus courses, Learnfast will supply you with a computer to use for training (if applicable),& tea/coffee and a full lunch. Catering is not included for On-Site training and laptops are available for hire at an additional cost if required. </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="3" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{59}" paraid="1309175345"><span style="font-size:14px;"><span style="font-family:segoe ui;">Cancellation or rescheduling requests must be in writing and reach us via email at least 5-10 working days prior to the course commencement date. Full course fees will be retained for no shows. </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="4" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{66}" paraid="880286382"><span style="font-size:14px;"><span style="font-family:segoe ui;">Virtual learners are required to have a stable internet connection & a working headset available for sound purposes.  </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="5" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{73}" paraid="2124695199"><span style="font-size:14px;"><span style="font-family:segoe ui;">Learners who use their own laptops are fully responsible to ensure that administration rights, software installations, etc. are working sufficiently prior to training. </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="1" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{88}" paraid="2134258061"><span style="font-size:14px;"><span style="font-family:segoe ui;"> Learnfast reserves the right to cancel or postpone dates if we require to do so and undertake to inform clients in writing and telephonically of these changes. </span></span></div>
	</li>
	<li aria-setsize="-1" data-aria-level="1" data-aria-posinset="2" data-font="Symbol" data-leveltext="" data-listid="23" role="listitem">
	<div paraeid="{c690573b-a2d4-4b96-996a-25b4ad77b2af}{97}" paraid="1561849529"><span style="font-size:14px;"><span style="font-family:segoe ui;">Learnfast is not responsible for costs associated with cancellation of classes such as flight and accommodation for clients. </span></span></div>
	</li>
</ul>

CourseOutline

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 1: Introduction to Microsoft SQL Server 2016/2017/2019.</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">The Basic Architecture of SQL Server</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">SQL Server Editions and Versions</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Getting Started with SQL Server Management Studio</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 2: Introduction to T-SQL Querying</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes the elements of T-SQL and their role in writing queries. Describe the use of sets in SQL Server. Describe the use of predicate logic in SQL Server. Describe the logical order of operations in SELECT statements.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Introducing T-SQL</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Understanding Sets</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Understanding Predicate Logic</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Understanding the Logical Order of Operations in SELECT statements</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 3: Writing SELECT Queries</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Simple SELECT Statements</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Eliminating Duplicates with DISTINCT</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Column and Table Aliases</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Simple CASE Expressions</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 4: Querying Multiple Tables</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to write queries that combine data from multiple sources in Microsoft SQL Server 2016.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Understanding Joins</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Querying with Inner Joins</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Querying with Outer Joins</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Querying with Cross Joins and Self Joins</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 5: Sorting and Filtering Data</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to implement sorting and filtering.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Sorting Data</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Filtering Data with Predicates</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Filtering Data with TOP and OFFSET-FETCH</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Working with Unknown Values</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 6: Working with SQL Server 2016/2017/2019</strong><strong> Data Types</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces the data types SQL Server uses to store data.</span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Lessons</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Introducing SQL Server 2016/2017/2019 Data Types</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Working with Character Data</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Working with Date and Time Data</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 7: Using DML to Modify Data</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to create DML queries, and why you would want to.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Inserting Data</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Modifying and Deleting Data</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 8: Using Built-In Functions</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces some of the many built-in functions in SQL Server 2016.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Queries with Built-In Functions</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Conversion Functions</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Logical Functions</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Functions to Work with NULL</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 9: Grouping and Aggregating Data</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to use aggregate functions.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Aggregate Functions</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using the GROUP BY Clause</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Filtering Groups with HAVING</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 10: Using Subqueries</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes several types of subquery and how and when to use them.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Self-Contained Subqueries</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Correlated Subqueries</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using the EXISTS Predicate with Subqueries</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 11: Using Table Expressions</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Previously in this course, you learned about using subqueries as an expression that returned results to an outer calling query. Like subqueries, table expressions are query expressions, but table expressions extend this idea by allowing you to name them and to work with their results as you would work with data in any valid relational table. Microsoft SQL Server 2016 supports four types of table expressions: derived tables, common table expression (CTEs), views, and inline table-valued functions (TVFs). In this module, you will learn to work with these forms of table expressions and learn how to use them to help create a modular approach to writing queries.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Views</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Inline Table-Valued Functions</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Derived Tables</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using Common Table Expressions</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 12: Using Set Operators</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces how to use the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Queries with the UNION operator</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using EXCEPT and INTERSECT</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Using APPLY</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 13: Using Windows Ranking, Offset, and Aggregate Functions</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes the benefits of using window functions. Restrict window functions to rows defined in an OVER clause, including partitions and frames. Write queries that use window functions to operate on a window of rows and return ranking, aggregation, and offset comparison results.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Creating Windows with OVER</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Exploring Window Functions</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 14: Pivoting and Grouping Sets</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes writing queries that pivot and unpivot result sets. Write queries that specify multiple groupings with grouping sets.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Writing Queries with PIVOT and UNPIVOT</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Working with Grouping Sets</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 15: Executing Stored Procedures</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to return results by executing stored procedures. Pass parameters to procedures. Create simple stored procedures that encapsulate a SELECT statement. Construct and execute dynamic SQL with EXEC and sp_executesql.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Querying Data with Stored Procedures</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Passing Parameters to Stored procedures</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Creating Simple Stored Procedures</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Working with Dynamic SQL</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 16: Programming with T-SQL</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to enhance your T-SQL code with programming elements.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">T-SQL Programming Elements</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Controlling Program Flow</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 17: Implementing Error Handling</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module introduces error handling for T-SQL.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Implementing T-SQL error handling</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Implementing structured exception handling</span></span></div>
	</li>
</ul>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;"><strong>Module 18: Implementing Transactions</strong></span></span></div>

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">This module describes how to implement transactions.</span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Transactions and the database engines</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Controlling transactions</span></span></div>
	</li>
</ul>

Available Exams and Certifications

Articulation Options

Outcomes

<div><span style="font-size:14px;"><span style="font-family:segoe ui;">After completing this course, learners will be able to: </span></span></div>

<ul>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;"></span></span>Use SQL Server query tools</div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;"></span></span>Write SELECT statements to retrieve columns from one or more tables</div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;"></span></span>Sort and filter selected data</div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;"></span></span>Use built-in functions to returned data values</div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;"></span></span>Create groups of data and aggregate the results</div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE</span></span></div>
	</li>
	<li>
	<div><span style="font-size:14px;"><span style="font-family:segoe ui;">A Certificate of Completion will be awarded to the learner.</span></span></div>
	</li>
</ul>

Who Should Attend

Learning Methods & Delivery

Study Kit

Assessment

Career Video

Hardware Requirements

PDF Link URL

Header

Form Email

LEARNFAST CMS

Course Info

Control Panel