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

Duration

Career Options

Financing Options

Admission Requirements

Important Notes

<ul>
	<li>
	<div>Students are to be at the training venue by 08h00 in preparation for a 08h30 start time.</div>
	</li>
	<li>
	<div>Learnfast retains the right to change this calendar without any notification.</div>
	</li>
	<li>
	<div>Bookings are only confirmed upon receipt of the proof of payment or an official company purchase order for the full amount of the training.</div>
	</li>
	<li>
	<div>For full day courses Learnfast will supply you with the relevant training material. A desktop computer to use for the training (where applicable), tea/coffee and a full lunch for full day InClass training hosted at Learnfast only. Catering is not included for OnSite training and laptop is available for hire at an additional cost if required.</div>
	</li>
	<li>
	<div>Cancellation or rescheduling requests must be in writing and reach us via fax or email at least 5 (five) working days prior to the course commencement date. Full course fees may be retained for no shows or requests within 5 working days prior to commencement.</div>
	</li>
	<li>
	<div>Although we go to great lengths to ensure that all training proceeds as scheduled, 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.</div>
	</li>
	<li>
	<div>Learnfast suggests clients wait until a week prior to course commencement that a course has been confirmed to go ahead as scheduled before booking flight and accommodation. Learnfast is NOT responsible for cost associated with cancellation of classes such as flight and accommodation for clients.</div>
	</li>
</ul>

CourseOutline

<div class="quicktabs-tabpage" id="quicktabs-tabpage-course_tabbed_content-1">
<div class="view view-course-outline view-id-course_outline view-display-id-default view-dom-id-2">
<div class="view-content">
<div class="views-row views-row-1 views-row-odd views-row-first views-row-last">
<div class="ds-1col node node-course-outline view-mode-full clearfix course">
<div class="field field-name-body field-type-text-with-summary field-label-hidden">
<div class="field-items">
<div class="field-item even">
Module 1: Introduction to Microsoft SQL Server 2014 
This module introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases. 
Lessons

<ul>
	<li>The Basic Architecture of SQL Server</li>
	<li>SQL Server Editions and Versions</li>
	<li>Getting Started with SQL Server Management Studio</li>
</ul>

<hr />
Module 2: Introduction to T-SQL Querying 
This module introduces Transact SQL as the primary querying language of SQL Server. It discusses the basic structure of T-SQL queries, the logical flow of a SELECT statement, and introduces concepts such as predicates and set-based operations. 
Lessons

<ul>
	<li>Introducing T-SQL</li>
	<li>Understanding Sets</li>
	<li>Understanding Predicate Logic</li>
	<li>Understanding the Logical Order of Operations in SELECT statements</li>
</ul>

<hr />
Module 3: Writing SELECT Queries 
This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table. 
Lessons

<ul>
	<li>Writing Simple SELECT Statements</li>
	<li>Eliminating Duplicates with DISTINCT</li>
	<li>Using Column and Table Aliases</li>
	<li>Writing Simple CASE Expressions</li>
</ul>

<hr />
Module 4: Querying Multiple Tables 
This module explains how to write queries that combine data from multiple sources in SQL Server. The module introduces the use of JOINs in T-SQL queries as a mechanism for retrieving data from multiple tables. 
Lessons

<ul>
	<li>Understanding Joins</li>
	<li>Querying with Inner Joins</li>
	<li>Querying with Outer Joins</li>
	<li>Querying with Cross Joins and Self Joins</li>
</ul>

<hr />
Module 5: Sorting and Filtering Data 
This module explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. The module also discusses how to resolve missing and unknown results. 
Lessons

<ul>
	<li>Sorting Data</li>
	<li>Filtering Data with a WHERE Clause</li>
	<li>Filtering with the TOP and OFFSET-FETCH Options</li>
	<li>Working with Unknown and Missing Values</li>
</ul>

<hr />
Module 6: Working with SQL Server 2014 Data Types 
This module explains the data types SQL Server uses to store data. It introduces the many types of numeric and special-use data types. It also explains conversions between data types and the importance of type precedence. 
Lessons

<ul>
	<li>Introducing SQL Server 2014 Data Types</li>
	<li>Working with Character Data</li>
	<li>Working with Date and Time Data</li>
</ul>

<hr />
Module 7: Using DML to Modify Data 
This module describes the use of Transact-SQL Data Manipulation Language to perform inserts, updates and deletes to your data. 
Lessons

<ul>
	<li>Inserting Data</li>
	<li>Modifying and Deleting Data</li>
</ul>

<hr />
Module 8: Using Built-In Functions 
This module introduces the use of functions that are built into SQL Server Denali and will discuss some common usages including data type conversion, testing for logical results and nullability. 
Lessons

<ul>
	<li>Writing Queries with Built-In Functions</li>
	<li>Using Conversion Functions</li>
	<li>Using Logical Functions</li>
	<li>Using Functions to Work with NULL </li>
</ul>

<hr />
Module 9: Grouping and Aggregating Data 
This module introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. The module is designed to help the student grasp why a SELECT clause has restrictions placed upon column naming in the GROUP BY clause as well as which columns may be listed in the SELECT clause. 
Lessons

<ul>
	<li>Using Aggregate Functions</li>
	<li>Using the GROUP BY Clause</li>
	<li>Filtering Groups with HAVING</li>
</ul>

<hr />
Module 10: Using Subqueries 
This module will introduce the use of subqueries in various parts of a SELECT statement. It will include the use of scalar and multi-result subqueries, and the use of the IN and EXISTS operators. 
Lessons

<ul>
	<li>Writing Self-Contained Subqueries</li>
	<li>Writing Correlated Subqueries</li>
	<li>Using the EXISTS Predicate with Subqueries</li>
</ul>

<hr />
Module 11: Using Table Expressions 
This module introduces T-SQL expressions which return a valid relational table, typically for further use in the query. The module discusses views, derived tables, common table expressions and inline table-valued functions. 
Lessons

<ul>
	<li>Using Derived Tables</li>
	<li>Using Common Table Expressions</li>
	<li>Using Views</li>
	<li>Using Inline Table-Valued Functions</li>
</ul>

<hr />
Module 12: Using Set Operators 
This module introduces Microsoft SharePoint Server as a platform for BI and then focuses on building BI dashboards and scorecards with PerformancePoint Services. 
Lessons

<ul>
	<li>Writing Queries with the UNION Operator</li>
	<li>Using EXCEPT and INTERSECT</li>
	<li>Using APPLY</li>
</ul>

<hr />
Module 13: Using Window Ranking, Offset, and Aggregate Functions 
This module introduces window functions including ranking, aggregate and offsets functions. Much of this functionality is new to SQL Server 2012. It will cover the use of T-SQL functions such as ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE and LAST_VALUE to perform calculations against a set, or window, of rows. 
Lessons

<ul>
	<li>Creating Windows with OVER</li>
	<li>Exploring Window Functions</li>
</ul>

<hr />
Module 14: Pivoting and Grouping Sets 
This module discusses techniques for pivoting data in T-SQL as well to introduce the fundamentals of the GROUPING SETS clause. It will also cover the use of GROUP BY ROLLUP and GROUP BY CUBE syntax in SQL Server. 
Lessons

<ul>
	<li>Writing Queries with PIVOT and UNPIVOT</li>
	<li>Working with Grouping Sets</li>
</ul>

<hr />
Module 15: Executing Stored Procedures 
This module introduces the use of existing stored procedures in a T-SQL querying environment. It discusses the use of EXECUTE, how to pass input and output parameters to a procedure, and how to invoke system stored procedures. 
Lessons

<ul>
	<li>Querying Data with Stored Procedures</li>
	<li>Passing Parameters to Stored Procedures</li>
	<li>Creating Simple Stored Procedures</li>
	<li>Working with Dynamic SQL</li>
</ul>

<hr />
Module 16: Programming with T-SQL 
This module provides a basic introduction to T-SQL programming concepts and objects. It discusses batches, variables, control of flow elements such as loops and conditionals, how to create and execute dynamic SQL statements, and how to use synonyms. 
Lessons

<ul>
	<li>T-SQL Programming Elements</li>
	<li>Controlling Program Flow</li>
</ul>

<hr />
Module 17: Implementing Error Handling 
This module introduces the use of error handlers in T-SQL code. It will introduce the difference between compile errors and run-time errors and will cover how errors affect batches. The module will also cover how to control error handling using TRY/CATCH blocks, the use of the ERROR class of functions, and the use of the new THROW statement. 
Lessons

<ul>
	<li>Using TRY / CATCH Blocks</li>
	<li>Working with Error Information</li>
</ul>

<hr />
Module 18: Implementing Transactions 
This module introduces the concepts of transaction management in SQL Server. It will provide a high-level overview of transaction properties, cover the basics of marking transactions with BEGIN, COMMIT and ROLLBACK. 
Lessons

<ul>
	<li>Transactions and the Database Engine</li>
	<li>Controlling Transactions</li>
	<li>Isolation Levels</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

Available Exams and Certifications

Articulation Options

Outcomes

Who Should Attend

Learning Methods & Delivery

At Learnfast we understand that that each person prefers different learning styles and techniques influenced by circumstances, location, field of study and learning preference. We have therefore developed learning methods to suit all learners to ensure everyone has all the opportunity to achieve learning success. We deliver our qualifications via three modern and flexible methods.

Full Time (myWay Learning Method) 
			Students will spend a minimum of 6 hours per day at our campus based on pre-scheduled dates with the mentors. This is done via our myWay learning method.

<hr />
			<a href="http://www.learnfast.co.za/pgs-96-myway-mentored-learning.html">LEARN MORE></a>
			</td>
			<td style="border-color:rgb(255, 255, 255)">
			<img alt="" src="/Library/part-time.png" style="border-style:solid; border-width:0px; height:154px; width:150px" />

Part Time (myWay Learning Method) 
			Part Time class times are from 18:00 – 21:00 during weekdays, Monday to Thursday on pre-scheduled dates. This is done via our myWay learning method.

<hr />
			<a href="http://www.learnfast.co.za/pgs-96-myway-mentored-learning.html">LEARN MORE></a>
			</td>
			<td style="border-color:rgb(255, 255, 255)">
			<img alt="" src="/Library/correspondence.png" style="border-style:solid; border-width:0px; height:150px; width:150px" />

Distance/Online Learning

Correspondence studies is based on self-study combined with Video Tutorials, student support and a dedicated tutor. Everything is managed online via the student portal.

<hr />
			<a href="http://www.learnfast.co.za/pgs-105-correspondence.html">LEARN MORE></a>
			</td>
		</tr>
	</tbody>
</table>

Study Kit

Assessment

Career Video

Hardware Requirements

PDF Link URL

Header

Form Email

LEARNFAST CMS

Course Info

Control Panel