SQL Server for Beginners

A Tutorial to Setting up SQL Server and Writing Your First Query
4.1 (1,954 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.
53,702 students enrolled
Free
Start Learning Now
  • Lectures 11
  • Contents Video: 1 hour
    Other: 15 mins
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course Description

This short course helps a beginner to understand how SQL Server works and to write basic SQL queries. You will learn about the different editions of SQL server and how to install your own licensed copy for free or at a very low cost. Partway through the course, there will be downloadable labs to follow with the lessons so you gain confidence with your new skill. When you do the steps along with the lessons you can expect this course to take between 2 and 5 hours.

What are the requirements?

  • To start the course you will not need anything other than your computer. Partway into the course we choose an install option to follow along. The last section of the course will show you how to use the SQL Server software to write queries.

What am I going to get from this course?

  • By end of this course you will know how to install SQL server, set up SQL practice labs. The last section of the course will show you how to use the SQL Server software to write queries.

What is the target audience?

  • This is for anyone who is starting out new with SQL server and wants a step by step understanding of what it is and how it works.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: What is a database and what is SQL Server?
Introductory lecture
1 page
03:45

At first when you hear the question of “Why Databases” you might think why should I learn about databases? If this is your question then you have likely answered it already. The answer is it pays very well and leads to a great career. Going deeper into the question is why do companies need databases so much they offer you such a career? The simple answer is there is a high business need for databases and SQL is a very powerful and affordable enterprise database management system. What does that mean exactly? In this lecture we will talk about the business needs for databases and how SQL Server is a complete system used to manage these databases.

02:48

Databases have been around since cavemen were drawing stick figures of their family’s on the rock walls. A database is a collection of related information. In the last 20 years what has improved greatly is we can get the information we need instantly from databases.

Section 2: Installing SQL Server and setting up your labs.
02:52

There are different version of SQL Server (like SQL 2005, 2008, and 2012). So what is SQL Developer, SQL Enterprise, or SQL Express? These are the different Edition of SQL Server. For example in the 2012 version you might have SQL Developer 2012 or SQL 2008 2012. This lecture will talk about the different editions.

Installing SQL Server 2012 Developer
09:30
Installing SQL Server 2012 Express
06:53
03:16

This video will show you how to take a system with SQL Server on it and how to set up the sample databases to do the tutorial lessons in the next Section. you will need to download the zip file as part of this lesson.

Section 3: Writing SQL Queries
06:41

The way you retrieve data to get what our manager wants is to write a query starting with the word SELECT. This chapter will show the core elements for the most commonly used keywords we use to retrieve data from SQL Server.

Single Table Queries and Database Context
10:24
11 pages

Here are a few pages from my book “SQL Basics Joes 2 Pros”. Please read this as a review to the lecture we have just covered then answer the quiz.

1 question

Which SQL clause helps limit the number of records seen in a query from a single table?

1 question

What comes right after the FROM clause?

Conclusion Lecture
3 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rick Morelan is the author of the “Joes 2 Pros” book SQL series. He also co-wrote a book T-SQL 2008 Joes 2 Pros which was one of the featured books at SQL PASS 2009. Rick has previously worked at Microsoft for more than 10 years. Rick has presented at SQL Saturdays in the USA, Canada, and India. Currently Ricks Joes2Pros YouTube channel has 3,500 subscribers, gets about 1000 views per day, with over 850,000 total video views since 2010

Ready to start learning?
Start Learning Now