Complete beginners introduction to SQL
2.5 (1 rating)
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.
1,858 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Complete beginners introduction to SQL to your Wishlist.

Add to Wishlist

Complete beginners introduction to SQL

Learn the basics of SQL in practical hands -on steps
New
2.5 (1 rating)
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.
1,858 students enrolled
Last updated 9/2017
English
English [Auto-generated]
Current price: $12 Original price: $105 Discount: 89% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Download SQL Server
  • Install SQL Server
  • Download sample database
  • Attach sample database to SQL Server
  • Create a database table
  • Create a view
  • Update Records
  • Delete records
  • Retrieve and read data from database
  • Use SSMS Tool
  • Join tables
View Curriculum
Requirements
  • Basic knowledge of using a pc
Description

SQL -Structural Query language is the language used to interrogate and manipulate Microsoft SQL Server Databases.

SQL is one of the most in demand IT Skills and has been that way for quite a long time.  Data  growth is increasing and so also is the demand for professionals with SQL skills.

This course is a complete beginners course for those who have had no exposure to SQL.
It is a very basic and practical hands on course to introduce you to SQL.
We will be using SQL Server as our database engine for this course.
Microsoft SQL Server is robust relational database management system used by so many 
organizations of various sizes including top fortune 100 companies.

In this course we will cover

Download  and Install SQL Server
Database concepts
Download  sample database
Attach sample database
Create a view
Create a table
Retrieve and reading data from a database using SELECT Statement
Updating existing data in the database
Deleting records from a database

Use Aliases 
Use order by clause
Sort data by ascending order 
Sort data by multiple columns  
Add new records 
Update existing records 
Delete records
Joining Tables
Inner joins  
Left outer joins 
Right Outer joins

SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases.

Who is the target audience?
  • Basic knowledge of navigating the internet
Compare to Other SQL Courses
Curriculum For This Course
40 Lectures
04:41:27
+
Introduction and Database Setup
11 Lectures 53:22




Hardware and software requirements
02:49

SQL Server Download
04:07

installing SQL Server 2014
06:47

Introduction to SSMS
08:21

Download Adventureworks Database
05:06

Attaching Adventureworks Database
04:14

What is Query
09:41
+
Performing A CRUD Operation
12 Lectures 01:24:05
Introduction to CRUD
01:31

Creating a view
09:10

Retrieving and Reading data with SELECT
12:53

Adding Records to a table
10:34

ORDER BY Clause
03:02

Updating existing database records
09:18

Deleting Records from a table
07:53

Using Aliases
07:12

Removing Duplicates
06:42

Sorting Data in ascending order
04:34

Sorting data by multiple columns
05:09

Using Comments in your queries
06:07
+
Introduction to Joining Tables
4 Lectures 33:21
Why do we Join Tables?
00:49

INNER JOIN
10:36

Left Outer Join
12:26

Right Outer Join
09:30
+
Aggregate Functions
6 Lectures 40:25
What are aggregate functions
02:12

COUNT
09:24

SUM
07:17

AVG
07:52

MIN
06:51

MAX
06:49
+
Filtering Records and Case expressions
7 Lectures 01:10:14
CASE Expressions
12:15

Filtering data with NULL
04:36

Filtering data with logical operators
14:08

Filtering data with string comparison
11:22

Filtering Records with Comparison filters
06:07

Filtering Records with equality filter
13:36

Grouping Data
08:10
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,781 Reviews
39,071 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.