Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Querying MS SQL Server 2012 Training Course
Quick Look Course Summary:Querying MS SQL Server 2012 Training Course
-
Next Public Course Date:
-
Length: 3 day(s)
-
Price (at your venue): 1 Person R 17,953 EX VAT 3 Person R 12,518 EX VAT 10 Person R 8,424 EX VAT
-
Certification Type:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Querying MS SQL Server 2012
Training Course Course: Introduction
This course introduces the SQL Server platform and major tools. It discusses editions, versions, tools used to query, documentation sources, and the logical structure of databases.
Querying MS SQL Server 2012
Training Course Course :Course Outline
1. Introduction to Microsoft SQL Server 2014
The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
SQL Server 2014 Tools
Working with SQL Server Management Studio
Creating and Organizing T-SQL scripts
Using Books Online
2. Introduction to T-SQL Querying
Introducing T-SQL
Understanding Sets
Predicate Logic
Logical Order of Operations in SELECT statements
Introduction to Transact-SQL Querying
Basic SELECT Statements
Executing queries which filter data using predicates
Executing queries which sort data using ORDER BY
3. Writing SELECT Queries
Writing Basic SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
4. Querying Multiple Tables
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Querying Multiple Tables
5. Sorting and Filtering Data
Sorting Data
Filtering Data with a WHERE Clause
Filtering with the TOP and OFFSET-FETCH Options
Working with Unknown and Missing Values
Sorting and Filtering Data
Writing Queries That Filter Data Using an ORDER BY Clause
6. Working with SQL Server 2014 Data Types
Introducing SQL Server 2014 Data Types
Working with Character Data
Working with Date and Time Data
7. Using DML to Modify Data
Inserting Data
Modifying and Deleting Data
Using DML to Modify Data
8. Using Built-In Functions
Writing Queries with Built-In Functions
Conversion Functions
Logical Functions
Using Functions to Work with NULL
Built-In Functions
9. Grouping and Aggregating Data
Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
Grouping and Aggregating Data
Write queries which use distinct aggregate functions
Querying MS SQL Server 2012
Training Course Course: Course Duration
3 day/s
Who should attend: Querying MS SQL Server 2012
Training Course Course
This course is intended for programmers, SQL Server.
**Quote does not include Any Exam Fees (if applicable)
IMPORTANT ACTION: Do Not Wait To Improve Your Skills. Â
Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal
About this course
This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, please see our accredited qualifications and skills programmes, or read about BOTI accreditations.
Frequently Asked Questions
Is this course accredited?
No. This course is delivered as a practical, facilitator-led skills programme and delegates receive a BOTI certificate of attendance. If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, ask us about our accredited qualifications, skills programmes and unit standards.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Spend on this course still counts as skills development expenditure for B-BBEE purposes, but it does not count as accredited training spend, and the Codes limit how much non-accredited training can contribute. Please confirm the treatment with your skills development facilitator or B-BBEE verification agency.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.