Introduction to Microsoft SQL Server Databases
3.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
125 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Microsoft SQL Server Databases to your Wishlist.

Add to Wishlist

Introduction to Microsoft SQL Server Databases

Learn how to build a simple SQL Server database to collect and analyze your data in this Microsoft SQL server training
3.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
125 students enrolled
Created by Baya Dewald
Published 10/2011
English
Current price: $10 Original price: $45 Discount: 78% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Description

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 Microsoft's 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>
Who is the target audience?
  • 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 Microsoft's 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 10 Lectures Collapse All 10 Lectures 01:42:23
+
My First Section
10 Lectures 01:42:23

Each 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 Microsoft's SQL Server is the most popular one used by top enterprises as well as small and medium sized businesses. This course introduces you to database concepts and the process of building a database from ground up. Instead of dwelling on theory the course focuses on a case study of defining a data logical model, creating SQL Server objects and code modules. The first lecture introduces the course agenda and discusses basic database concepts.

Preview 04:20

Each business application requires a database - we must have a way of collecting data so we can analyze it to make informed decisions. Although you could store all your data in a single table your application needs proper design if you want to serve multiple users and store / retrieve data efficiently. This video teaches the process of identifying business entities and coresponding attributes, normalizing data so that attributes aren't duplicated in multiple entities, and adding unique identifiers to each entity.

Preview 19:15

In this video we discuss major components of SQL Server product suite. Although this course focuses on the relational database management system, it is essential to know that SQL Server product suite offers much more than just a relational database. SQL Server suite also includes enterprise class tools for data extraction, transformation, loading, analysis, mining and reporting.

SQL Server product suite components
03:46

This video discusses the steps for creating a SQL Server database including defining data and transaction log files, configuring automatic growth, adding file-groups and setting the default file-group.

Creating a SQL Server database
07:26

In this video we discuss creating database tables, column data types and nullability as well as check and default constraints.

Create database tables
19:24

This lecture teaches what primary and foreign keys are and how to create them. The video also discusses the concept of an index, clustered and non-clustered indexes.

Creating primary keys, foreign keys, clustered and non clustered indexes.
10:06

Learn how to review entity relationships using database diagrams. Also learn about database schemas and views.

Database diagrams, schemas, views
09:03

Each SQL Server instance includes system databases essential for its operation. Additionally each database includes system objects for performing administrative tasks and for storing metadata. In this lecture you'll learn about the purpose of each system database.

System databases and objects
04:43

This lecture teaches how to create SQL Server logins, database users and roles. Learn how to secure objects all the way down to individual column level.  

SQL Server database security
12:45

Learn basics of creating user-defined functions and stored procedures. The video also includes the course summary and links for additional information.

Transact-SQL code modules and course summary
11:35
About the Instructor
Baya Dewald
3.6 Average rating
4 Reviews
125 Students
1 Course
Database Consultant

Baya Dewald is a senior database administrator for a leading global financial services firm. He administers numerous installations of SQL Server and Analysis Services, consulting on design, development, administration and performance tuning of large data warehouses and business intelligence applications. In the past Mr. Dewald has also been a successful SQL Server consultant, DBA manager and a contributor to several technical books. Mr. Dewald can be reached at baya_baya@hotmail.com.