Complete beginners introduction to SQL

Complete beginners introduction to SQL

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.

Learn the basics of SQL in practical hands -on steps

Url: View Details

What you will learn

• Download SQL Server
• Install SQL Server
• Download sample database

Rating: 4.55

Level: Beginner Level

Duration: 4.5 hours

Instructor: Bluelime Learning Solutions