Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add SQL Queries 101 to your Wishlist.

Add to Wishlist

SQL Queries 101

A Beginning SQL Server Guide
4.7 (40 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.
419 students enrolled
Last updated 2/2014
English
$10 $30 67% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
To get proficient at SQL code for writing queries, manipulating data, basic Security, and common workplace tips.
View Curriculum
Requirements
  • SQL Server will be needed to follow along but we will show you how to install it.
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.

Who is the target audience?
  • Beginners wanting to know the core coding concepts of SQL Server 2012 and 2014.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 31 Lectures Collapse All 31 Lectures 03:26:37
+
Getting Started
2 Lectures 03:16
+
SQL Queries
8 Lectures 01:12:15

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
+
Design Definitions
3 Lectures 22:16
LabTips
03:35

CreatingDatabases
12:44

CreatingTables
05:57
+
Data Manipulation (DML)
9 Lectures 56:14
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
+
Transactions
2 Lectures 12:40
Explicit Transactions
04:43

Table Hints
07:57
+
Security
3 Lectures 20:13
SQL Logins
06:29

Granting Permissions
04:55

Revoking & Denying Permissions
08:49
+
Workplace Tips
3 Lectures 13:43
Code Comments
05:31

Automatic Script Generation
03:47

Import Export Wizard
04:25
+
Conclusion
1 Lecture 00:00
Conclusion
4 pages
About the Instructor
4.2 Average rating
2,603 Reviews
59,211 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

More from Rick A. Morelan
Report Abuse