Real World SQL Server From The Ground Up

There are two types of instances in SQL Server. A default instance and a named instance. Let's learn about them in this lesson.

Each release of SQL Server may have different editions.

When we build out a box we need to be cognizant of the editions for each version.

Most of the time we will be installing Enterprise or Standard but there are outliers.

Depending on the components that you decide to install, SQL Server Setup installs up to ten different services.

SQL Server 2008 collation settings depend on the type of installation. Typically, you should choose a SQL Server collation that supports the Windows system locale most commonly used at your organization.

Let's learn how to install the express edition in SQL Server.

SQL Server Configuration Manager is a tool to configure the network protocols used by the SQL Server, and to manage network connectivity.

Let's learn about the key terms in Section 2.

Let's wrap up what we've covered in this section.

SQL Server has to have two files to be a database. Let's learn what they are.

Why do we need a log file? Why isn't the data file enough. Le's learn why the log file is so critical to a database.

In this lesson let's learn how to create file groups for our database files.

Let's cover the terminology of Section 3.

Let's summarize what we've convered in this section.

The easiest way to move a database is to detach, move and then attach it. Let's learn how to do this.

Databases live in a different states. Let's cover them in this lecture.

In his lecture let's lean how to modify our existing databases.

The cover some new vernacular on working with database files.

Let's wrap up what we've learned in this section.

The table object is the most important one in SQL Server. Let's learn the basics on creating them.

Let's continue to learn how to define the basics of our tables.

A table can be a heap or a table with a clustered index.

Let's learn the differences.

Let's learn the key terms for this section.

Let's wrap up what we've covered in this course.

There are two branches within transact-sql. Let's learn the difference between DML and DDL.

In his lecture let's learn the very basics of the most commonly used statement in all database systems.

There are 4 core things we do to manipulate data.

Let's learn what they are in this lesson.

Let's learn the vernacular of creating out tables.

Let's wrap up what we've covered in Section 6.

Let's learn how to create our first stored procedure.

Let's take our stored procedure statement one more step.

Every time we execute a query SQL Serve stores the plan in cache.

Let's learn what a plan cache is.

Let's learn the key terms for Section 7.

Let's wrap up what we've learned in Section 7.

Thanks for taking my course. You've reached the end of this course.