Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 33 Minute(s)
Language
English
Taught by
Rwynn Christian
Rating
1 views
Course Overview
Start your Database Developer journey by learning the Basics of SQL Server Databases
Are you looking for a course to jumpstart your database developer or database administration career, then look no further!
In this database course, I'll be taking you from the basic understanding of database concepts to writing your own T-SQL queries, to select, and modify data, as well as creating and altering database structures. Along the way, I'll explain the key concepts such as database normalization, database keys, and constraints, demonstrate the syntax, and give you an opportunity to test out the skills you have acquired during this course.
The course is designed to be completed at your own pace and consists of video presentations, video demonstrations, resources, and external links to text-based resources.
The first three sections include video presentations that cover the theory needed to understand how databases work in a nutshell, while the other sections mostly include demonstrations that cover the practical part of this course.
Once you have finished this course, you'll receive a certificate you can show to your employer and colleagues that you have the fundamental skills to develop and administer SQL Server databases.
This course can also be used as a reference for the Microsoft Technology Associate (MTA) 98-364 Database Fundamentals Exam and covers all exam objectives.
Course Content
- 7 section(s)
- 31 lecture(s)
- Section 1 Introduction
- Section 2 Core Database Concepts
- Section 3 Relational Database Concepts
- Section 4 Querying and Manipulating Data
- Section 5 Creating Database Objects
- Section 6 Database Administration Fundamentals
- Section 7 Assessment
What You’ll Learn
- Fundamentals of Relational Databases such as the different types of databases, database management systems, and how data is stored., Core Database Concepts such as normalization, constraints, and keys., Query Relational Databases and manipulate Data using T-SQL., Fundamentals of Creating Database Objects such as Tables, Views, Functions, Stored Procedures and Indexes., Database Administration Fundamentals such as securing a SQL Server Database and Database Recovery.
Skills covered in this course
Reviews
-
NNicholas Mavundlha
This is a good course
-
NNkambenhle
Great intorduction to SQL
-
FFrancis Ebekamere Ibioro
Hi, Francis from calabar Nigeria. I enjoy the course and the presentation of each model. I could not follow up with the practical aspect which is very important in this course because my Management studio refuse to install after trying all options.
-
PPieter-Jan Gouws
Was a great course there are a few errors here and there but nothing major, there is a few things in the coding that are inserted without knowing what they do like the 'go' statement and also I wish the presentations are uploaded that you can easily revise them. The coding assessment also did work so I could not have tested my solutions.
