search close
search
0
cart
close
You have no products in your basket yet
left
Tech Categories
Best Sellers
New Releases
Books
Videos
Audiobooks
Articles
Newsletters
Free Learning
right
Learn SQL with Microsoft SQL Server [Video]

Learn SQL with Microsoft SQL Server: Understanding databases and SQL [Video]

By John Elder
$182.99
Video May 2019 1 hours 48 minutes 1st Edition
Video
$182.99
Subscription
$15.99 Monthly
Video
$182.99
Subscription
$15.99 Monthly

What do you get with a video?

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

Product Details

Publication date : May 29, 2019
Length 1 hours 48 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781838981167
Vendor :
Microsoft
Category :
Data
Languages :
SQL (Beginner)
Concepts :
Databases
Tools :
SQL Server (Beginner)
toc 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.

What you will learn

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

What do you get with a video?

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

Product Details

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

Table of Contents

3 Chapters
Introduction Packt Packt
Introduction
Database Concepts
Data Types
Installation and Setup Packt Packt
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 Packt Packt
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
Causal Inference and Discovery in Python: Unlock the secrets of modern causal machine learning with DoWhy, EconML, PyTorch and more
Causal Inference and Discovery in Python: Unlock the secrets of modern causal machine learning with DoWhy, EconML, PyTorch and more
May 2023 456
Ebook
€22.99 €32.99
€41.99
Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
Machine Learning with PyTorch and Scikit-Learn: Develop machine learning and deep learning models with Python
Feb 2022 774
Ebook
€21.99 €31.99
€38.99
Machine Learning for Algorithmic Trading: Predictive models to extract signals from market and alternative data for systematic trading strategies with Python, Second Edition
Machine Learning for Algorithmic Trading: Predictive models to extract signals from market and alternative data for systematic trading strategies with Python, Second Edition
Jul 2020 822
Ebook
€23.99 €34.99
€43.99
Mastering Microsoft Power BI – Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence, Second Edition
Mastering Microsoft Power BI – Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence, Second Edition
Jun 2022 712
Ebook
€20.98 €29.99
€37.99
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, Third Edition
Microsoft Power BI Quick Start Guide: The ultimate beginner's guide to data modeling, visualization, digital storytelling, and more, Third Edition
Nov 2022 330
Ebook
€19.99 €28.99
€35.99
Machine Learning Engineering with Python: Manage the lifecycle of machine learning models using MLOps with practical examples, Second Edition
Machine Learning Engineering with Python: Manage the lifecycle of machine learning models using MLOps with practical examples, Second Edition
Aug 2023 462
Ebook
€20.98 €29.99
€37.99
The AI Product Manager's Handbook: Develop a product that takes advantage of machine learning to solve AI problems
The AI Product Manager's Handbook: Develop a product that takes advantage of machine learning to solve AI problems
Feb 2023 250
Ebook
€32.99 €47.99
€59.99
€35.99
Et al.: Because not all research deserves a Nobel Prize
Et al.: Because not all research deserves a Nobel Prize
Aug 2023 230
Ebook
€7.99 €11.99
€14.99
Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2, Third Edition
Python Machine Learning: Machine Learning and Deep Learning with Python, scikit-learn, and TensorFlow 2, Third Edition
Dec 2019 772
Ebook
€21.99 €31.99
€38.99
Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques
Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal data modeling techniques
May 2023 324
Ebook
€20.98 €29.99
€37.99
right arrow

Customer reviews

filter Filter
Top Reviews
Rating distribution
star-icon star-icon star-icon star-icon star-icon 0
(0 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 0%
1 star 0%

Filter reviews by

No reviews found

People who bought this also bought

left arrow
Mastering Ubuntu Server: Explore the versatile, powerful Linux Server distribution Ubuntu 22.04 with this comprehensive guide, Fourth Edition
Mastering Ubuntu Server: Explore the versatile, powerful Linux Server distribution Ubuntu 22.04 with this comprehensive guide, Fourth Edition
Sep 2022 584
Ebook
€22.99 €32.99
€41.99
Mastering Ansible, 4th Edition: Automate configuration management and overcome deployment challenges with Ansible, Fourth Edition
Mastering Ansible, 4th Edition: Automate configuration management and overcome deployment challenges with Ansible, Fourth Edition
Dec 2021 540
Ebook
€17.99 €25.99
€32.99
Enterprise DevOps for Architects: Leverage AIOps and DevSecOps for secure digital transformation
Enterprise DevOps for Architects: Leverage AIOps and DevSecOps for secure digital transformation
Nov 2021 288
Ebook
€22.99 €32.99
€41.99
Ansible for Real-Life Automation: A complete Ansible handbook filled with practical IT automation use cases
Ansible for Real-Life Automation: A complete Ansible handbook filled with practical IT automation use cases
Sep 2022 480
Ebook
€17.99 €25.99
€31.99
Kubernetes – An Enterprise Guide: Effectively containerize applications, integrate enterprise systems, and scale applications in your enterprise, Second Edition
Kubernetes – An Enterprise Guide: Effectively containerize applications, integrate enterprise systems, and scale applications in your enterprise, Second Edition
Dec 2021 578
Ebook
€19.99 €28.99
€37.99
right arrow

Authors (1)

Profile John Elder
Linkedin
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? Packt Packt
  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? Packt Packt

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? Packt Packt

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? Packt Packt

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.