Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 53 Minute(s)
Language
English
Taught by
How To Network
Rating
Course Overview
Beginner to Intermediate Level - Pass Your Microsoft Technology Associate Database Exam
If you have always wanted to learn about SQL databases but didn't know where to start this course is for you.
We start at the very basics and walk you through all the configurations step-by-step. You learn:
- How data is stored in tables
- Understand Relational Database Concepts
- Understand Tables and How to Create Them
- Insert, Delete and Update Data
- Database Security Concepts
- Database Backups and Restore
All examples are configured on Microsoft SQL Server 2008 which you can download via a free trial. This is the edition you will be tested on if you choose to take the Microsoft MTA Database Exam (98-364). You can follow along with the instructor and create your own database.
This is your first step to becoming a database engineer. It leads to the MCSA or MCSE Data Platform certifications.
The course is delivered by Microsoft Expert Toby Lawrence who has taught thousands of students from all over the world on Microsoft subjects.
Course Content
- 6 section(s)
- 19 lecture(s)
- Section 1 Introduction
- Section 2 Understanding Core Database Concepts
- Section 3 Creating Database Objects
- Section 4 Manipulating Data
- Section 5 Understanding Data Storage
- Section 6 Administering a Database
What You’ll Learn
- Understand how SQL data is stored
- Know how to create and manipulate tables
- Create Stored Procedures and Functions
- Understand Normalization
- Be able to backup and restore a database
Skills covered in this course
Reviews
-
OOzan H
Starts off pretty good, but feels rushed at the end. + The teacher knows his topic well. + After every lesson a quiz with 10 questions. - Almost no practical use cases for what you learned(mostly it's just theoretical) - The Q&A seems completely dead. All in all it's a average/good course where you get a basic understanding of MS SQL.
-
llex Subedi
Could have been better if there would be more practice questions.
-
RRicardo Rojas
Great detailed course. I enjoyed it very much, it added so much context for the SQL I had learned in a previous course.
-
BBrandon Fitts
Very good beginner level information about SQL and SSMS, quizzes were overall a good review of each lesson learned, but I thought that some could be a little more difficult or challenging.
