SQL language in MSSQL Training Course

Description

• Type

  Course

Description

The course answers questions
How to build a query?
What opportunities have SQL?
What is a relational database?
What is the structure and SQL commands?

About this course

Requirements

Computer literacy
Knowledge of any operating system

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• Database
• SQL
• Database training

Course programme

Relational database models

• The structure of a relational database
• Relational operators

Download the data

• Rules for writing SQL queries
• The syntax for the SELECT
• Selecting all columns
• Inquiries from arithmetic operations
• Aliases columns
• Literals
• Concatenation

Restrict results

• The WHERE clause
• The comparison operators.
• LIKE Condition
• Prerequisite BETWEEN ... AND
• IS NULL condition
• IN condition.
• Logical operators
• Many of the conditions in the WHERE clause
• The order of operators
• DISTINCT clause

Sorting Data

• The ORDER BY clause
• Sorting by multiple columns or expressions

SQL Functions

• The differences between the functions of single and multi-rows
• Functions text, numeric, date,
• Conversion functions
• Nesting functions
• Handling of NULL values

Aggregating data using the grouping function

• Grouping functions
• How grouping functions treat NULL values
• Create groups of data - the GROUP BY clause
• Grouping multiple columns
• Reducing the function result grouping - the HAVING clause

Retrieving data from multiple tables

• Types of joins
• Aliases tables
• Joins in the WHERE clause
• INNER JOIN Inner join
• External Merge LEFT, RIGHT
• Cartesian product

Subqueries

• Place subqueries in the SELECT command
• Subqueries single and multi-lineage
• Operators Subqueries single-line
• Operators Subqueries multi-IN, ALL, ANY

Collective operators

• UNION operator
• INTERSECT operator
• EXCEPT operator

Insert, update, and delete data

• INSERT command
• UPDATE command
• DELETE command

Transactions

Additional information

14 hours (usually 2 days including breaks)

See related categories

• SQL courses
• Distance learning SQL courses
• Courses in England
• Oracle sql courses
• Data analysis sql courses
• Sql intermediate courses
• Transact sql courses
• Database leeds courses
• SQL Server courses
• Distance learning SQL Server courses
• Distance learning Course
• Courses in Leicestershire
• Courses in Leicester
• Nobleprog Limited courses