Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: What is a database and what is SQL Server?|
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.
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.|
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
Installing SQL Server 2012 Express
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|
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
|Lecture 10||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.
|Quiz 1||1 question|
Which SQL clause helps limit the number of records seen in a query from a single table?
|Quiz 2||1 question|
What comes right after the FROM clause?
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