Complete beginners introduction to SQL

Complete beginners introduction to SQL, available at $49.99, has an average rating of 4.2, with 41 lectures, based on 53 reviews, and has 2002 subscribers.

You will learn about 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 This course is ideal for individuals who are Basic knowledge of navigating the internet It is particularly useful for Basic knowledge of navigating the internet.

Enroll now: Complete beginners introduction to SQL

Summary

Title: Complete beginners introduction to SQL

Price: $49.99

Average Rating: 4.2

Number of Lectures: 41

Number of Published Lectures: 41

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 41

Original Price: $89.99

Quality Status: approved

Status: Live

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

Who Should Attend

Basic knowledge of navigating the internet

Target Audiences

Basic knowledge of navigating the internet

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.

Course Curriculum

Chapter 1: Introduction and Database Setup

Lecture 1: Introduction

Lecture 2: What is SQL

Lecture 3: What is T-SQL

Lecture 4: Database concepts

Lecture 5: Hardware and software requirements

Lecture 6: SQL Server Download

Lecture 7: installing SQL Server 2014

Lecture 8: Introduction to SSMS

Lecture 9: Download Adventureworks Database

Lecture 10: Attaching Adventureworks Database

Lecture 11: What is Query

Chapter 2: Performing A CRUD Operation

Lecture 1: Introduction to CRUD

Lecture 2: Creating a view

Lecture 3: Retrieving and Reading data with SELECT

Lecture 4: Adding Records to a table

Lecture 5: ORDER BY Clause

Lecture 6: Updating existing database records

Lecture 7: Deleting Records from a table

Lecture 8: Using Aliases

Lecture 9: Removing Duplicates

Lecture 10: Sorting Data in ascending order

Lecture 11: Sorting data by multiple columns

Lecture 12: Using Comments in your queries

Chapter 3: Introduction to Joining Tables

Lecture 1: Why do we Join Tables?

Lecture 2: INNER JOIN

Lecture 3: Left Outer Join

Lecture 4: Right Outer Join

Chapter 4: Aggregate Functions

Lecture 1: What are aggregate functions

Lecture 2: COUNT

Lecture 3: SUM

Lecture 4: AVG

Lecture 5: MIN

Lecture 6: MAX

Chapter 5: Filtering Records and Case expressions

Lecture 1: CASE Expressions

Lecture 2: Filtering data with NULL

Lecture 3: Filtering data with logical operators

Lecture 4: Filtering data with string comparison

Lecture 5: Filtering Records with Comparison filters

Lecture 6: Filtering Records with equality filter

Lecture 7: Grouping Data

Lecture 8: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes

2 stars: 7 votes

3 stars: 6 votes

4 stars: 24 votes

5 stars: 16 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!