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
[FreeCoursesOnline.Me] [Packt] Learn SQL With Microsoft SQL Server [FCO]
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
Use Node.js to build websites and host them live on Heroku Webhosting
Video Details
ISBN 9781838981167
Course Length 1 hour 48 minutes
Table of Contents
• Introduction
• Installation and Setup
• Structured Query Language - SQL
Learn
• Introduction to Microsoft SQL Server
• Understanding conditions
• Playing around with tables.
• Working with functions
About
In this course, I'll teach you the Structured Query Language—SQL for short—the fast and easy way. We'll download and use the free trial version of Microsoft SQL Server and I'll teach you exactly how to use it like a pro. Databases are incredibly important in our modern world, and they remain a mystery to most people. But they're easy to use if you know just a few things...and I'll teach you those things in this course.
We'll start out by learning fundamental database concepts, such as: What is a database, What is a table, What are rows and columns, and What are data types? After that, I'll show you how to set up and use Microsoft SQL Server. Then we'll dive right into SQL itself. I'll teach you basic concepts such as:
• Select statements
• Where, And, or Not
• How to Order and Group By
• And cool things like that.
Then we'll move into slightly more difficult concepts such as:
• Having and Top Clauses
• Select Distinct
• Union
• And functions
Then we'll jump into more advanced concepts such as:
• Insert and Update statements
• Deleting and altering tables
• Joining tables
• Primary keys
• Indexing
• And more!
When you get right down to it, using databases with SQL is pretty easy, and actually a lot of fun!
Style and Approach
This course will show you how to build databases with Microsoft SQL Server from scratch. It covers the theory and implementation with real-life examples.
Features:
• Install and use Microsoft SQL Server
• Gain a basic Understanding about databases and their use
• Understand and use SQL with databases
Author
John Elder - Founder of Codemy
John Elder is a pioneer in Web Development and created one of the first internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot.com boom and then went on to create the best-selling Submission-Spider search engine submission software, which has been used by over 3 million individuals and small businesses in over 45 countries. Today, he teaches Web Development courses at Codemy, the online code school he founded. John graduated with Honors with a Degree in Economics from Washington University in St. Louis, where he was an artsci scholar.
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
0. Websites you may like/How you can help Team-FTU.txt
237 B
01.Introduction/0101.Introduction.mp4
30.9 MB
01.Introduction/0102.Database Concepts.mp4
61.5 MB
01.Introduction/0103.Data Types.mp4
91.1 MB
02.Installation and Setup/0201.Download and Install SQL Server.mp4
61.8 MB
02.Installation and Setup/0202.Download and Install SSMS.mp4
46.4 MB
02.Installation and Setup/0203.Connect To Server.mp4
27.6 MB
02.Installation and Setup/0204.System Databases.mp4
25.8 MB
02.Installation and Setup/0205.Creating a Database and Table.mp4
60.4 MB
02.Installation and Setup/0206.Adding Data To A Table.mp4
44.8 MB
03.Structured Query Language - SQL/0301.Intro To SQL.mp4
57.6 MB
03.Structured Query Language - SQL/0302.Select Statements.mp4
70.9 MB
03.Structured Query Language - SQL/0303.Where Clause.mp4
65.5 MB
03.Structured Query Language - SQL/0304.And or Not.mp4
68.8 MB
03.Structured Query Language - SQL/0305.Order By.mp4
68.6 MB
03.Structured Query Language - SQL/0306.Group By.mp4
58.4 MB
03.Structured Query Language - SQL/0307.The Having Clause.mp4
35.6 MB
03.Structured Query Language - SQL/0308.The Top Clause.mp4
44.8 MB
03.Structured Query Language - SQL/0309.Select Distinct.mp4
53.7 MB
03.Structured Query Language - SQL/0310.Union.mp4
73.1 MB
03.Structured Query Language - SQL/0311.Functions.mp4
69.7 MB
03.Structured Query Language - SQL/0312.Insert Statement.mp4
79.9 MB
03.Structured Query Language - SQL/0313.Update Statement.mp4
60.6 MB
03.Structured Query Language - SQL/0314.Delete Statement.mp4
52.5 MB
03.Structured Query Language - SQL/0315.Alter Table.mp4
74.2 MB
03.Structured Query Language - SQL/0316.Null.mp4
42.8 MB
03.Structured Query Language - SQL/0317.Creating A Table.mp4
63.4 MB
03.Structured Query Language - SQL/0318.Drop Table.mp4
56.3 MB
03.Structured Query Language - SQL/0319.Primary Key.mp4
90 MB
03.Structured Query Language - SQL/0320.Intro To Joining Tables.mp4
19.9 MB
03.Structured Query Language - SQL/0321.Inner Join.mp4
70.3 MB
03.Structured Query Language - SQL/0322.Left, Right, and Outer Join.mp4
84.9 MB
03.Structured Query Language - SQL/0323.Indexing.mp4