Introduction to Microsoft SQL Server Databases

Product type
Logo Udemy
Provider rating: starstarstarstarstar_half 8.5 Udemy has an average rating of 8.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Database Management, Microsoft SQL Server, PL/SQL, CompTIA A+ / Network+ / Security+, and Oracle.

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.

Category: Technology
  • Over 10 lectures and 1.5 hours of content!
  • 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 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.

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.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.