This course offers end-users a sound background on the concepts of a Relational Database Management System. It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database
This course will be conducted using a Microsoft SQL Server.
Introduction to databases
Selecting data
Grouping data
Multiple table queries
Working with joins
Course Overview
This course offers end-users a sound background on the concepts of a Relational Database Management System.
It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database either directly or through third-party Query and Reporting Tools.
Audience:
Users who will be querying the corporate database either directly or through third-party Query and Reporting Tools.
Prerequisites:
There are no particular requirements for this course.
Inclusions
Training Manual with step by step instructions
Practice files with relevant to the training material
Training Completed files you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
Course Content
Learning Outcomes
At the end of the course students will be able to:
Understand the basics of what a database is
Formulate simple SELECT statements
Qualify queries using the WHERE clause
Summarise data using the GROUP BY and HAVING clauses
Formulate complex queries which span multiple tables
Gain an appreciation for performance when developing queries
Gain confidence in developing accurate and efficient SQL queries
Introduction To Databases
Defining a Databases Management System
Defining a Relational Database Management System
Defining Normalisation
What Does SQL Do?
Basic SELECT Statement
The SELECT Statement
Restricting Columns
Performing Arithmetic Computing
SQL Functions
Eliminating Duplicate Rows
Sorting Data
Qualifying Data
The WHERE Clause
Comparison Operators
Logical Operators
Selecting NULL Values
Subqueries
ANY and ALL Predicates
String Components
Combining Tables
What is a Join?
Why We Join Tables?
How to Get a Good Join
Formulation of a Join
Summarising Information
Aggregate Functions
Grouping Data
Qualifying Groups of Data
The Having Clause
More Complex SQL
Exists Predicate
Outer Joins
Pattern Matching and String Manipulations
Handling Date Comparisons and Manipulation
Corporate Training Solutions Australia is an independent, Australian owned training provider, highly respected for the delivery of corporate training in desktop software and soft skills development. We have more than 20 years' experience helping businesses train their teams on Microsoft business software.
Hundreds of businesses rely on CTSA to provide software training for their employees. Our comprehensive range of learning solutions help organisations manage the changing needs of business by developing the skills of their people to empower teams and individuals.
T-SQL Create Select Queries course is offered by IFA Australia - Institute for Financial Analysts Australia. Our program structure and content has been researched by consultation with industry CFO’s. The courses are written and delivered by experts in their field.
This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.
On completion of this course, attendees will be able to use SQL to develop complete computer reporting systems without writing a line of programming code. You should come to this course if your work involves the storage and retrieval of lists of information capable of being queried.
This course draws content from both Microsoft 10985 – Introduction to SQL Databases and Microsoft 20761 – Querying Data with Transact-SQL 2016
The Oracle Database Administration I certification training course focuses on Oracle Database Architecture, Managing Users, Roles and Privileges, Moving Data, Managing Tablespaces and Datafiles, Restricting and Sorting Data and more.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy