Xossip

Go Back Xossip > Technology> E-books > Complete beginners introduction to SQL

Reply
 
Thread Tools Search this Thread
  #1  
Old 20th February 2018
TheCornor TheCornor is offline
Custom title
 
Join Date: 4th February 2012
Posts: 3,730
Rep Power: 18 Points: 91
TheCornor is beginning to get noticed
Complete beginners introduction to SQL


Complete beginners introduction to SQL
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 4.5 Hours | Lec: 40 | 653 MB
Genre: eLearning | Language: English

Learn the basics of SQL in practical hands -on steps

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.

Learn the basics of SQL in practical hands -on steps
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
and Install SQL Server
Database concepts
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.

DOWNLOAD


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +5.5. The time now is 02:53 AM.
Page generated in 0.01414 seconds