SQL Server for Beginners
4.3 (3,291 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.
66,151 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server for Beginners to your Wishlist.

Add to Wishlist

SQL Server for Beginners

A Tutorial to Setting up SQL Server and Writing Your First Query
4.3 (3,291 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.
66,151 students enrolled
Created by Rick A. Morelan
Last updated 10/2013
English
English [Auto-generated]
Price: Free
Includes:
  • 1 hour on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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.
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
11 Lectures
01:01:09
+
What is a database and what is SQL Server?
3 Lectures 06:33
Introductory lecture
1 page

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.

What is a Database
03:45

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.

What is SQL Server
02:48
+
Installing SQL Server and setting up your labs.
4 Lectures 22:31

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.

SQL Server Editions
02:52

Installing SQL Server 2012 Developer
09:30

Installing SQL Server 2012 Express
06:53

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.

Setting up your SQL Server labs
03:16
+
Writing SQL Queries
4 Lectures 17:05

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.

Writing your first SQL Queries
06:41

Single Table Queries and Database Context
10:24

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.

Writing Basic Queries
11 pages

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

3.1 - Critera
1 question

What comes right after the FROM clause?

3.1 - FROM
1 question

Conclusion Lecture
3 pages
About the Instructor
Rick A. Morelan
4.3 Average rating
3,321 Reviews
66,438 Students
2 Courses
Joes 2 Pros

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