SQL Queries 101

A Beginning SQL Server Guide
4.9 (21 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.
314 students enrolled
$30
Take This Course
  • Lectures 31
  • Contents Video: 3.5 hours
    Other: 6 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 2/2014 English

Course Description

This short course helps a beginner to understand how to write basic SQL queries and other code statement to develop and administer SQL Server. 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 20 and 40 hours.

What are the requirements?

  • SQL Server will be needed to follow along but we will show you how to install it.

What am I going to get from this course?

  • To get proficient at SQL code for writing queries, manipulating data, basic Security, and common workplace tips.

What is the target audience?

  • Beginners wanting to know the core coding concepts of SQL Server 2012 and 2014.

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: Getting Started
Course Intro
Preview
2 pages
Setting up Your Labs
Preview
03:16
Section 2: SQL Queries
Single Table Queries
Preview
13:32
Using Criteria
07:05
Finding Patterns in Data
17:47
Joining Table
09:04
Outer Joins
05:40
Table Aliases
10:24
Unmatched Records Queries
04:51
Cross Joins
03:52
Section 3: Design Definitions
LabTips
03:35
CreatingDatabases
12:44
CreatingTables
05:57
Section 4: Data Manipulation (DML)
Inserting Data
06:25
Updating Data
06:51
Deleting Data
02:56
Using Scripts
06:00
Altering Tables
08:37
Using BCP
07:23
Stored Procedures
06:26
Using Variables
05:05
Stored Procedure Parameters
06:31
Section 5: Transactions
Explicit Transactions
04:43
Table Hints
07:57
Section 6: Security
SQL Logins
06:29
Granting Permissions
04:55
Revoking & Denying Permissions
08:49
Section 7: Workplace Tips
Code Comments
05:31
Automatic Script Generation
03:47
Import Export Wizard
04:25
Section 8: Conclusion
Conclusion
4 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?
Take This Course