.
115
LESSONS
ALL
SKILL LEVEL
9:17 hr
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
OVERVIEW
This course is the foundation for the ITS-201 Database Fundamentals certification, focusing on Microsoft SQL Server. In a few hours, learn to create tables, queries, views, procedures, and more. It offers an introductory knowledge of how databases work and how to construct your own SELECT statements.
There are regular quizzes to help support and consolidate learning.
.
WHO IS THE COURSE FOR?
This course is ideal for anybody wanting to make a start in the information technology field.
No prior knowledge of SQL Server is required. This course is designed for those without experience, as well as those who would like a refresher.
On completion, you may wish to take the ITS-201 exam.
.
LEARNING PATH
THE SELECT STATEMENT
- SELECT.
- FROM.
- WHERE.
- GROUP BY.
- HAVING.
- ORDER BY.
TABLES
- Data types.
- Creating own tables.
- JOINing tables.
- Normalisation.
- Primary and composite keys.
- Foreign keys and other constraints.
DATA MANIPULATION LANGUAGE (DML)
- INSERT.
- UPDATE.
- DELETE.
DATA DEFINITION LANGUAGE (DDL) & MORE
- Views, including WITH CHECK option and WITH SCHEMABINDING.
- Stored procedures.
- Functions.
- UNION, INTERSECT and EXCEPT.
- Indexes.
DATABASE SECURITY, BACKUPS & RESTORE
- User accounts and roles.
- Backups and restore.
.
REVIEWS
“As a result of completing this course, I decided to take the exam which I have successfully passed. I was a beginner at the time of starting this course, now I obtain knowledge about the fundamentals of SQL Server and T-SQL in general. Phillip is an excellent instructor, and I would highly recommend investing in this course.” Kamal
“The instructor really put a great effort into this course. I was able to score 98% on the exam! I’m really glad and grateful for this instructor.” Mousa
“Great course covering all the fundamentals of SQL… This course really explained in detail some of the things I use on a regular basis but never really knew why. Great job!” Mikko
“This course is definitely designed for the absolute beginner, just as it states. If you know absolutely nothing about SQL, T-SQL or databases as a whole, then start with this course. As a bonus, this is the only entry level course (that I have found so far) that actually touches on ‘database security’ and ‘database backup and restore’ that are required in daily work and for passing the certification exam.” Aubrey
.
