Complete beginners introduction to SQL

Learn the basics of SQL in practical hands -on steps

4.50 (51 reviews)
Udemy
platform
English
language
Databases
category
Complete beginners introduction to SQL
1,997
students
4.5 hours
content
Jun 2021
last update
$49.99
regular price

What you will 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

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.

Content

Introduction and Database Setup

Introduction
What is SQL
What is T-SQL
Database concepts
Hardware and software requirements
SQL Server Download
installing SQL Server 2014
Introduction to SSMS
Download Adventureworks Database
Attaching Adventureworks Database
What is Query

Performing A CRUD Operation

Introduction to CRUD
Creating a view
Retrieving and Reading data with SELECT
Adding Records to a table
ORDER BY Clause
Updating existing database records
Deleting Records from a table
Using Aliases
Removing Duplicates
Sorting Data in ascending order
Sorting data by multiple columns
Using Comments in your queries

Introduction to Joining Tables

Why do we Join Tables?
INNER JOIN
Left Outer Join
Right Outer Join

Aggregate Functions

What are aggregate functions
COUNT
SUM
AVG
MIN
MAX

Filtering Records and Case expressions

CASE Expressions
Filtering data with NULL
Filtering data with logical operators
Filtering data with string comparison
Filtering Records with Comparison filters
Filtering Records with equality filter
Grouping Data
Thank You

Reviews

Heather
January 17, 2020
so far so good Had an issue downloading the software required as website was no longer there. Fortunately I found another website with a download that appears to have given the same result.
K.
January 6, 2020
I feel this course to be helpful for someone like myself who is new to Sql. The pace of the modules were not overwhelming like other modules I have viewed and I like that the modules are more demonstrative than straight lecture/talk. I also like the timing of the modules were not to long.
Murali
May 1, 2019
Basically i dont have a knowledge on SQL and its related topics .This course provide me the good understanding and knowledge on SQL and its processes .Thanking you for this wonderful duration

Charts

Price

Complete beginners introduction to SQL - Price chart

Rating

Complete beginners introduction to SQL - Ratings chart

Enrollment distribution

Complete beginners introduction to SQL - Distribution chart
1349492
udemy ID
9/13/2017
course created date
4/30/2022
course indexed date
Bot
course submited by