17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Complete Beginners Introduction To SQL
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Learn the basics of SQL in practical hands -on steps
What you'll 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
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
Download More Latest Courses Visit -->> Course Drive
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
Complete beginners introduction to SQL/01 Introduction and Database Setup/001 Introduction.mp4
4 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/002 What is SQL.mp4
4.1 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/003 What is T-SQL.mp4
4.4 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/004 Database concepts.mp4
7.2 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/005 Hardware and software requirements.mp4
8.6 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/006 SQL Server Download.mp4
9.4 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/007 installing SQL Server 2014.mp4
12 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/008 Introduction to SSMS.mp4
13.2 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/009 Download Adventureworks Database.mp4
10.3 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/010 Attaching Adventureworks Database.mp4
9.5 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/011 What is Query.mp4
16.8 MB
Complete beginners introduction to SQL/01 Introduction and Database Setup/Must Read.txt
428 B
Complete beginners introduction to SQL/02 Performing A CRUD Operation/012 Introduction to CRUD.mp4
2.2 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/013 Creating a view.mp4
20.1 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/014 Retrieving and Reading data with SELECT.mp4
28.2 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/015 Adding Records to a table.mp4
26.6 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/016 ORDER BY Clause.mp4
7.9 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/017 Updating existing database records.mp4
19.1 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/018 Deleting Records from a table.mp4
16.2 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/019 Using Aliases.mp4
14.2 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/020 Removing Duplicates.mp4
17.2 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/021 Sorting Data in ascending order.mp4
10.6 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/022 Sorting data by multiple columns.mp4
13.2 MB
Complete beginners introduction to SQL/02 Performing A CRUD Operation/023 Using Comments in your queries.mp4
16.4 MB
Complete beginners introduction to SQL/03 Introduction to Joining Tables/024 Why do we Join Tables.mp4
1.4 MB
Complete beginners introduction to SQL/03 Introduction to Joining Tables/025 INNER JOIN.mp4
26.7 MB
Complete beginners introduction to SQL/03 Introduction to Joining Tables/026 Left Outer Join.mp4
28.6 MB
Complete beginners introduction to SQL/03 Introduction to Joining Tables/027 Right Outer Join.mp4
20.1 MB
Complete beginners introduction to SQL/04 Aggregate Functions/028 What are aggregate functions.mp4
4.2 MB
Complete beginners introduction to SQL/04 Aggregate Functions/029 COUNT.mp4
20.3 MB
Complete beginners introduction to SQL/04 Aggregate Functions/030 SUM.mp4
15.4 MB
Complete beginners introduction to SQL/04 Aggregate Functions/031 AVG.mp4
18.5 MB
Complete beginners introduction to SQL/04 Aggregate Functions/032 MIN.mp4
14.3 MB
Complete beginners introduction to SQL/04 Aggregate Functions/033 MAX.mp4
13.7 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/034 CASE Expressions.mp4
29 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/035 Filtering data with NULL.mp4
12.3 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/036 Filtering data with logical operators.mp4
47.3 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/037 Filtering data with string comparison.mp4
29.7 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/038 Filtering Records with Comparison filters.mp4
15.6 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/039 Filtering Records with equality filter.mp4
39.3 MB
Complete beginners introduction to SQL/05 Filtering Records and Case expressions/040 Grouping Data.mp4
