SQL Server Database Fundamentals

Start your Database Developer journey by learning the Basics of SQL Server Databases

Ratings: 4.49 / 5.00




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.

What You Will 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.

Who Should Attend!

  • 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