Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 17 Minute(s)
Language
English
Taught by
Phillip Burton • over one million students so far, I Do Data Limited
Rating
Course Overview
For Microsoft SQL Server T-SQL. SELECT queries, views, procedures, indexes, backups. ITF-201. Helps with DP-600
This course is the foundation for the Pearson IT Specialist Certification ITF-201 "Databases Fundamentals", which is also known as ITS-201 and ITN-201, and focuses on Microsoft SQL Server's T-SQL. Learn in just a few hours how to create tables, queries, views, procedures and more.
Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.
What do people like you say about it?
Seme says "Thank you very much for your valuable course . I really enjoyed this course . Packed a lot of information , I found it very interesting and useful . Thank you ."
Gasper says "Phillip always does a great job, this is my third course from him. Passionate and informed, I will take as many courses as I can from him."
Jonas says "Explaining SQL on a very easyway! Takes you though everything you need to know nice and calm."
We start off by installing for free on your Windows desktop or laptop SQL Server, and learning how the six clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
We'll examine how data is stored in tables, and see why normalisation is important for the proper building of tables.
We'll then look at constraints, which allows you to set up rules for your data. Following this, how can we insert, update and delete data? We'll also create views, procedures and functions.
Finally, we'll investigate how to speed up your queries using indexes, add security, and back up your data.
No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!
There are regular quizzes to help you remember the information, so you can be sure that you are learning.
Once finished, you will have a good introductory knowledge of how databases work and be able to construct your own SELECT statements. And with a bit of practice, you could also go for the official IT Specialist exam - wouldn’t that certificate look good on your CV or resume?
Course Content
- 10 section(s)
- 115 lecture(s)
- Section 1 Introduction
- Section 2 Installing SQL Server and SQL Server Management Studio (SSMS)
- Section 3 3.2. Select data - Utilize SELECT queries to extract data from one table
- Section 4 [3.2]. Select data - Utilize SELECT queries to extract data - WHERE and GROUP BY
- Section 5 [3.2]. Select data - Utilize SELECT queries to extract data -HAVING and ORDER BY
- Section 6 Let's explore tables
- Section 7 Creating our own tables
- Section 8 Joining tables
- Section 9 13. Understand normalization
- Section 10 14. Understand primary and composite keys
What You’ll Learn
- create tables in a database, normalize the tables, and ALTER columns in the table.
- Know what data type to use in various situations.
- retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
- JOIN two tables together, finding missing data.
- INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
- Create constraints, views, procedures and triggers
- Create backups and restore data, and investigate security
Skills covered in this course
Reviews
-
AAna Busila
This is a quite comprehensive journey that the instructor, Phillip, takes you through in order to teach you a lot of what is needed to know regarding SQL. I really enjoyed and found very helpful to have lots of quizzes and practice activities. Despite this not being my first SQL course, I definitely had difficulties with some of the concepts and needed to watch some parts more than once (or twice) so I would not let not understanding at first deter you from continuing this course. If I had one advice to give would be to move the last 'extra videos' part back to their initial place, with the same mention that this is not absolutely necessary and can be skipped - I think that it would be easier to follow in order rather than having to go back and find the section 12 practice activity in order to do the triggers practice activity at the end. But this is just me being a bit too nitpicky. I recommend this course!
-
AAlan Ritchie
Knowledgeable and well presented.
-
BBhavnish Mohla
I CAME TO THIS COURSE FROM 70-461 AND 70-462, I WAS ABLE TO DO THE QUIZZES AND PRACTICE TESTS WITHOUT GOING THROUGH THE LECTURES. WILL BE GIVING THE EXAM IN ABOUT 2 WEEKS FROM NOW. THESE CERTIFICATIONS HAVE NOT HELPED ME IN GETTING A JOB.
-
AArfan Rahman
I passed the exam and found this course as incredibly helpful ! Thank you Phillip for all your work in this space.
