Packt | Learn SQL with Microsoft SQL Server [FCO]

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size1.8 GB
  • Uploaded BySunRiseZone
  • Downloads247
  • Last checkedJul. 30th '19
  • Date uploadedJul. 29th '19
  • Seeders 33
  • Leechers15
Your ISP and Government can track your torrent activity! Hide your IP with a VPN!

Infohash : 257BFCCF456E1DED87C09A62DF84AD1AE4C9AF4A

For More Udemy Free Courses >>> https://ftuforum.com/
For more Lynda and other Courses >>> https://www.freecoursesonline.me/
Our Forum for discussion >>> https://discuss.ftuforum.com/



By : John Elder
Released : 28 May 2019 (New Release!)
Torrent Contains : 38 Files, 4 Folders
Course Source : https://www.packtpub.com/application-development/learn-sql-microsoft-sql-server-video

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.



Files:

[FreeCoursesOnline.Me] [Packt] Learn SQL with Microsoft SQL Server [FCO] 0. Websites you may like
  • 1. (FreeTutorials.Us) Download Udemy Paid Courses For Free.url (0.3 KB)
  • 2. (FreeCoursesOnline.Me) Download Udacity, Masterclass, Lynda, PHLearn, Pluralsight Free.url (0.3 KB)
  • 3. (NulledPremium.com) Download Cracked Website Themes, Plugins, Scripts And Stock Images.url (0.2 KB)
  • 4. (FTUApps.com) Download Cracked Developers Applications For Free.url (0.2 KB)
  • 5. (Discuss.FTUForum.com) FTU Discussion Forum.url (0.3 KB)
  • How you can help Team-FTU.txt (0.2 KB)
01.Introduction
  • 0101.Introduction.mp4 (30.9 MB)
  • 0102.Database Concepts.mp4 (61.5 MB)
  • 0103.Data Types.mp4 (91.1 MB)
02.Installation and Setup
  • 0201.Download and Install SQL Server.mp4 (61.8 MB)
  • 0202.Download and Install SSMS.mp4 (46.4 MB)
  • 0203.Connect To Server.mp4 (27.6 MB)
  • 0204.System Databases.mp4 (25.8 MB)
  • 0205.Creating a Database and Table.mp4 (60.4 MB)
  • 0206.Adding Data To A Table.mp4 (44.8 MB)
03.Structured Query Language - SQL
  • 0301.Intro To SQL.mp4 (57.6 MB)
  • 0302.Select Statements.mp4 (70.9 MB)
  • 0303.Where Clause.mp4 (65.5 MB)
  • 0304.And or Not.mp4 (68.8 MB)
  • 0305.Order By.mp4 (68.6 MB)
  • 0306.Group By.mp4 (58.4 MB)
  • 0307.The Having Clause.mp4 (35.6 MB)
  • 0308.The Top Clause.mp4 (44.8 MB)
  • 0309.Select Distinct.mp4 (53.7 MB)
  • 0310.Union.mp4 (73.1 MB)
  • 0311.Functions.mp4 (69.7 MB)
  • 0312.Insert Statement.mp4 (79.9 MB)
  • 0313.Update Statement.mp4 (60.6 MB)
  • 0314.Delete Statement.mp4 (52.5 MB)
  • 0315.Alter Table.mp4 (74.2 MB)
  • 0316.Null.mp4 (42.8 MB)
  • 0317.Creating A Table.mp4 (63.4 MB)
  • 0318.Drop Table.mp4 (56.3 MB)
  • 0319.Primary Key.mp4 (90.0 MB)
  • 0320.Intro To Joining Tables.mp4 (19.9 MB)
  • 0321.Inner Join.mp4 (70.3 MB)
  • 0322.Left, Right, and Outer Join.mp4 (84.9 MB)
  • 0323.Indexing.mp4 (73.2 MB)

Code:

  • udp://tracker.iamhansen.xyz:2000/announce
  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://tracker.leechers-paradise.org:6969/announce
  • udp://tracker.uw0.xyz:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://denis.stalker.upeer.me:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2710/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://tracker.coppersurfer.tk:6969/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://tracker.opentrackr.org:1337/announce