This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports.
Overview
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn:
how to write SQL queries
what relational databases are and how we can use them
what are relations and how to create them
the structure of data
differences between T-SQL and other dialects
practical skills for writing queries
This SQL course deals with Microsoft T-SQL dialect. If you are interested in generic SQL, please see SQL Fundamentals course.
Course Outline
DQL (Data Query Language) in Detail
SELECT clause
Column aliases
Table aliases
Date types and Date functions
Group function
Table joins
JOIN clause
UNION operator
Nested queries
Correlated subqueries
DML (DataManipulationLanguage) Overview
Inserting rows (INSERT)
Inserting rows using subquery
Updating rows (UPDATE)
Deleting rows (DELETE)
DDL (Data Definition Language) Overview
Creating, altering and dropping objects (CREATE, ALTER, DROP)
Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
NULL i NOT NULL
CONSTRAINT clause
ENUM type
SET type
PRIMARY KEY
UNIQUE
FOREIGN KEY
DEFAULT clause
Transactions Overview
COMMIT
ROLLBACK
SAVEPOINT
Implicit and explicit rollbacks and commits
T-SQL Dialects Overview
What is Transact-SQL
T-SQL and portability with other dialects (what to avoid)
Handling Date
NobleProg is an international training and consultancy group, delivering high quality courses to every sector, covering: Cyber Security, Artificial Intelligence, IT, Management, Applied Statistics.
Over the last 17 years, we have trained more than 50,000 people from over 6000 companies and organisations.
Our courses include classroom (both public and closed) and instructor-led online giving you choice and flexibility to suit your time, budget and level of expertise.
We practice what we preach – we use a great deal of the technologies and methods that we teach, and continuously upgrade and improve our courses, keeping up to date with all the latest developments.
Our trainers are hand picked and have been through rigorous checks and interviews, and all courses are evaluated by delegates ensuring continuous feedback and improvement.
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
Introduction to SQL Databases course is offered by Wardy IT Solutions. As a Microsoft Partner we’ve been awarded with the Silver Learning competency. Every training session we run is taught by a Microsoft Certified Trainer.
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.
Our CISLAB hands-on-Lab Training Programs and Job Oriented Training programs are very popular among individual customers.
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy