Introduction to Microsoft SQL Server Databases

Introduction to Microsoft SQL Server Databases, available at $34.99, has an average rating of 3.69, with 10 lectures, based on 8 reviews, and has 179 subscribers.

You will learn about Discussion of database concepts – definition of a database management system, logical and physical data models, structured query language. Building a sample data model – start with a list of business entities and attributes, normalize the data, define key attributes. Overview of SQL Server product suite. Creating a database – data and transaction log files, file groups. Implementing a physical model: creating tables – defining column data types, null-ability, and constraints. Enhancing the physical model with primary and foreign key constraints, indexes, views. Discussion of system databases and objects. Implementing database security through server logins and database roles, defining object permissions. Introduction to Transact-SQL code modules: user-defined functions and stored procedures. This course is ideal for individuals who are This course assumes no background in databases; it is useful for people who have heard of databases but never built one, as well as for those who have worked with databases before but are trying to learn about Microsofts flagship database system. If you are a front-end programmer and would like to know what database administrators do to build databases, this course is for you. If you have a liberal arts degree and are now trying to get a real job, this course could be helpful for you as well. It is particularly useful for This course assumes no background in databases; it is useful for people who have heard of databases but never built one, as well as for those who have worked with databases before but are trying to learn about Microsofts flagship database system. If you are a front-end programmer and would like to know what database administrators do to build databases, this course is for you. If you have a liberal arts degree and are now trying to get a real job, this course could be helpful for you as well.

Enroll now: Introduction to Microsoft SQL Server Databases

Summary

Title: Introduction to Microsoft SQL Server Databases

Price: $34.99

Average Rating: 3.69

Number of Lectures: 10

Number of Published Lectures: 10

Number of Curriculum Items: 10

Number of Published Curriculum Objects: 10

Original Price: $34.99

Quality Status: approved

Status: Live

What You Will Learn

Discussion of database concepts – definition of a database management system, logical and physical data models, structured query language.

Building a sample data model – start with a list of business entities and attributes, normalize the data, define key attributes.

Overview of SQL Server product suite.

Creating a database – data and transaction log files, file groups.

Implementing a physical model: creating tables – defining column data types, null-ability, and constraints.

Enhancing the physical model with primary and foreign key constraints, indexes, views.

Discussion of system databases and objects.

Implementing database security through server logins and database roles, defining object permissions.

Introduction to Transact-SQL code modules: user-defined functions and stored procedures.

Who Should Attend

This course assumes no background in databases; it is useful for people who have heard of databases but never built one, as well as for those who have worked with databases before but are trying to learn about Microsofts flagship database system. If you are a front-end programmer and would like to know what database administrators do to build databases, this course is for you. If you have a liberal arts degree and are now trying to get a real job, this course could be helpful for you as well.

Target Audiences

This course assumes no background in databases; it is useful for people who have heard of databases but never built one, as well as for those who have worked with databases before but are trying to learn about Microsofts flagship database system. If you are a front-end programmer and would like to know what database administrators do to build databases, this course is for you. If you have a liberal arts degree and are now trying to get a real job, this course could be helpful for you as well.

Each modern business needs to have a way of collecting and analyzing large amounts of data. There are many Relational Database Management Systems (RDBMS) you could choose from, but Microsofts SQL Server is the most popular one used by top enterprises as well as small to medium-sized businesses. This SQL training course introduces you to database concepts and the process of building a database from the ground up. The Introductory Microsoft SQL Server Training course provides a brief overview of all major components of SQL Server product suite, but focuses on relational DBMS. Instead of forever dwelling on theory, this SQL training course provides a case study of defining a logical data model, implementing a physical model through SQL Server objects and also introduces Transact-SQL code modules.

Take this ultimate Introductory Microsoft SQL Server Training course now and learn how to build a simple SQL Server database.

</p>

Course Curriculum

Chapter 1: My First Section

Lecture 1: Database concepts

Lecture 2: Data normalization – building a data model.

Lecture 3: SQL Server product suite components

Lecture 4: Creating a SQL Server database

Lecture 5: Create database tables

Lecture 6: Creating primary keys, foreign keys, clustered and non clustered indexes.

Lecture 7: Database diagrams, schemas, views

Lecture 8: System databases and objects

Lecture 9: SQL Server database security

Lecture 10: Transact-SQL code modules and course summary

Instructors

Baya Dewald
Database Consultant

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 5 votes

4 stars: 2 votes

5 stars: 1 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!