Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Germany
Country selected
country flag France
Country selected
country flag Canada
Country selected
country flag Russia
Country selected
country flag Spain
Country selected
country flag Brazil
Country selected
country flag Australia
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag South Korea
Country selected
country flag Turkey
Country selected
country flag Switzerland
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Chile
Country selected
country flag Norway
Country selected
country flag Ecuador
Country selected
country flag Indonesia
Country selected
country flag New Zealand
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag Austria
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag South Africa
Country selected
country flag Malaysia
Country selected
country flag Japan
Country selected
country flag Slovakia
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Home > Data > Databases > Learn SQL with Microsoft SQL Server
Learn SQL with Microsoft SQL Server
Learn SQL with Microsoft SQL Server

Learn SQL with Microsoft SQL Server: Understanding databases and SQL

Arrow left icon
Profile Icon John Elder
Arrow right icon
Mex$179.99 Mex$3753.99
Video May 2019 1hr 48mins 1st Edition
Video
Mex$179.99 Mex$3753.99
Subscription
Free Trial
Arrow left icon
Profile Icon John Elder
Arrow right icon
Mex$179.99 Mex$3753.99
Video May 2019 1hr 48mins 1st Edition
Video
Mex$179.99 Mex$3753.99
Subscription
Free Trial
Video
Mex$179.99 Mex$3753.99
Subscription
Free Trial

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Billing Address

Table of content icon View table of contents

Key benefits

  • Install and use Microsoft SQL Server
  • Gain a basic understanding of databases and their use
  • Explore SQL and use it with databases

Description

Databases are incredibly important in the modern world, and may seem quite complex to most people. But they're easy to use if you know the right techniques and concepts. With this course, you’ll get up to speed with the Structured Query Language (SQL) in an interactive, quick, and easy way. You’ll be able to download and use the free trial version of Microsoft SQL Server and understand how to use it confidently. You’ll start by learning fundamental database concepts, gradually understanding what databases, tables, rows and columns, and data types are. Next, you’ll explore how to set up and use Microsoft SQL Server. The course will then delve into SQL, focusing on basic concepts such as SELECT statements; Where, And, or Not; and How to Order and Group By. As you progress, you’ll gain insights into comprehensive topics such as Having and Top Clauses; Select Distinct; Union; and Functions. Finally, you’ll focus on advanced concepts including Insert and Update Statements; Deleting and Altering Tables; Joining Tables; Primary Keys; and Indexing. By the end of this course, you’ll have the skills you need to effectively use databases with SQL.

Who is this book for?

This course is for beginners who want to learn SQL, or anyone who wants to understand how to build databases using Microsoft SQL Server.

What you will learn

  • Discover the fundamentals of Microsoft SQL Server
  • Explore conditions
  • Understand how to experiment with tables
  • Work with functions

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : May 29, 2019
Length: 1hr 48mins
Edition : 1st
Language : English
ISBN-13 : 9781838981167
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Databases
Tools :
SQL Server

What do you get with a video?

Product feature icon Download this video in MP4 format
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : May 29, 2019
Length: 1hr 48mins
Edition : 1st
Language : English
ISBN-13 : 9781838981167
Vendor :
Microsoft
Category :
Data
Languages :
SQL
Concepts :
Databases
Tools :
SQL Server

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
START FREE TRIAL
BUY NOW
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just Mex$85 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just Mex$85 each
Feature tick icon Exclusive print discounts
START FREE TRIAL
BUY NOW

Frequently bought together

C++ Standard Template Library in Practice
C++ Standard Template Library in Practice
Read more
Oct 2019 10hrs 24mins
Full star icon 5 (1)
Video
Video
  • Video Video Mex$179.99
Mex$179.99 Mex$2830.99
Learn SQL with Microsoft SQL Server
Learn SQL with Microsoft SQL Server
Read more
May 2019 1hr 48mins
Video
Video
  • Video Video Mex$179.99
Mex$179.99 Mex$3753.99
Machine Learning for Algorithmic Trading
Machine Learning for Algorithmic Trading
Read more
Jul 2020 820 pages
Full star icon 4 (44)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1189.99
Mex$179.99 Mex$951.99
Mex$1189.99
Stars icon
Total Mex$ 1,549.97 7,774.97 6,225.00 saved
C++ Standard Template Library in Practice
Mex$179.99 Mex$2830.99
Learn SQL with Microsoft SQL Server
Mex$179.99 Mex$3753.99
Machine Learning for Algorithmic Trading
Mex$1189.99
Total Mex$ 1,549.97 7,774.97 6,225.00 saved Stars icon
Banner background image

Table of Contents

3 Chapters
Introduction Chevron down icon Chevron up icon
Introduction
Database Concepts
Data Types
Installation and Setup Chevron down icon Chevron up icon
Download and Install SQL Server
Download and Install SSMS
Connect To Server
System Databases
Creating a Database and Table
Adding Data To A Table
Structured Query Language - SQL Chevron down icon Chevron up icon
Intro To SQL
Select Statements
Where Clause
And or Not
Order By
Group By
The Having Clause
The Top Clause
Select Distinct
Union
Functions
Insert Statement
Update Statement
Delete Statement
Alter Table
Null
Creating A Table
Drop Table
Primary Key
Intro To Joining Tables
Inner Join
Left, Right, and Outer Join
Indexing

Recommendations for you

Left arrow icon
Python Machine Learning By Example
Python Machine Learning By Example
Read more
Jul 2024 518 pages
Full star icon 4.9 (8)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$943.99
Mex$179.99 Mex$754.99
Mex$943.99
Unlocking Data with Generative AI and RAG
Unlocking Data with Generative AI and RAG
Read more
Sep 2024 346 pages
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$820.99
Mex$179.99 Mex$656.99
Mex$820.99
Building LLM Powered Applications
Building LLM Powered Applications
Read more
May 2024 342 pages
Full star icon 4.2 (22)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1025.99
Mex$179.99 Mex$820.99
Mex$1025.99
Python for Algorithmic Trading Cookbook
Python for Algorithmic Trading Cookbook
Read more
Aug 2024 404 pages
Full star icon 4.6 (15)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1230.99
Mex$179.99 Mex$984.99
Mex$1230.99
Machine Learning with PyTorch and Scikit-Learn
Machine Learning with PyTorch and Scikit-Learn
Read more
Feb 2022 774 pages
Full star icon 4.4 (95)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1128.99
Mex$179.99 Mex$902.99
Mex$1128.99
Artificial Intelligence Engines
Artificial Intelligence Engines
Read more
Nov 2024 217 pages
eBook
eBook
  • eBook eBook Mex$136.99
Mex$136.99 Mex$196.99
AI Product Manager's Handbook
AI Product Manager's Handbook
Read more
Nov 2024 484 pages
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1025.99
Mex$179.99 Mex$820.99
Mex$1025.99
RAG-Driven Generative AI
RAG-Driven Generative AI
Read more
Sep 2024 334 pages
Full star icon 4.5 (13)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$902.99
Mex$179.99 Mex$721.99
Mex$902.99
Hands-On Reinforcement Learning with Python
Hands-On Reinforcement Learning with Python
Read more
Jun 2018 318 pages
Full star icon 2.6 (18)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$799.99
Mex$179.99 Mex$639.99
Mex$799.99
LLM Engineer's Handbook
LLM Engineer's Handbook
Read more
Oct 2024 522 pages
Full star icon 4.8 (16)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1230.99
Mex$179.99 Mex$984.99
Mex$1230.99
Right arrow icon

People who bought this also bought

Left arrow icon
Machine Learning Engineering with Python
Machine Learning Engineering with Python
Read more
Aug 2023 462 pages
Full star icon 4.6 (36)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1025.99
Mex$179.99 Mex$820.99
Mex$1025.99
Deep Learning with TensorFlow and Keras – 3rd edition
Deep Learning with TensorFlow and Keras – 3rd edition
Read more
Oct 2022 698 pages
Full star icon 4.6 (45)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1025.99
Mex$179.99 Mex$820.99
Mex$1025.99
Modern Generative AI with ChatGPT and OpenAI Models
Modern Generative AI with ChatGPT and OpenAI Models
Read more
May 2023 286 pages
Full star icon 4.2 (34)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1025.99
Mex$179.99 Mex$820.99
Mex$1025.99
Generative AI with LangChain
Generative AI with LangChain
Read more
Dec 2023 368 pages
Full star icon 4 (34)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$1025.99
Mex$179.99 Mex$820.99
Mex$1025.99
Causal Inference and Discovery in Python
Causal Inference and Discovery in Python
Read more
May 2023 456 pages
Full star icon 4.5 (49)
eBook
eBook
  • eBook eBook Mex$179.99
  • Paperback Paperback Mex$820.99
Mex$179.99 Mex$656.99
Mex$820.99
Right arrow icon

About the author

Profile icon John Elder
John Elder
John Elder is a pioneer in Web Development who 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 that's been used by over 3 million individuals and small businesses in over 45 countries. John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.
Read more
See other products by John Elder
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How can I download a video package for offline viewing? Chevron down icon Chevron up icon
  1. Login to your account at Packtpub.com.
  2. Click on "My Account" and then click on the "My Videos" tab to access your videos.
  3. Click on the "Download Now" link to start your video download.
How can I extract my video file? Chevron down icon Chevron up icon

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package? Chevron down icon Chevron up icon

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

  1. Video
  2. Format watched (HTML, MP4, streaming)
  3. Chapter or section that issue relates to (if relevant)
  4. System being played on
  5. Browser used (if relevant)
  6. Details of support
Why can’t I download my video package? Chevron down icon Chevron up icon

In the even that you are having issues downloading your video package then please follow these instructions:

  1. Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
  2. Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.