SQL Server Database Fundamentals
SQL Server Database Fundamentals
Duration: 4h 33m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.79 GB
Genre: eLearning | Language: English
Duration: 4h 33m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.79 GB
Genre: eLearning | Language: English
Start your Database Developer journey by learning the Basics of SQL Server Databases
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.
Requirements:
SQL Server 2016+
SQLServer Management Studio
Description:
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
Who this course is for:
Individuals seeking to learn the fundamentals of relational databases, database management systems, database components and querying databases
Anyone who wants to get started with database development
Beginners seeking to pass the MTA 98-364 Database Fundamentals Exam
More Info