0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Learn SQL with Microsoft SQL Server

Learn SQL with Microsoft SQL Server: Understanding databases and SQL

John Elder

€137.99

Video May 2019 1hr 48mins 1st Edition

Renews at €18.99p/m

John Elder

€137.99

Video May 2019 1hr 48mins 1st Edition

Renews at €18.99p/m

Renews at €18.99p/m

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

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

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Product Details

Publication date : May 29, 2019

Length: 1hr 48mins

Edition : 1st

Language : English

ISBN-13 : 9781838981167

Vendor :

Microsoft

Category :

Data

Languages :

SQL

Concepts :

Tools :

Frequently bought together

C++ Standard Template Library in Practice

C++ Standard Template Library in Practice

Oct 2019 10hrs 24mins

Video

€103.99

Learn SQL with Microsoft SQL Server

Learn SQL with Microsoft SQL Server

May 2019 1hr 48mins

Video

€137.99

Machine Learning for Algorithmic Trading

Machine Learning for Algorithmic Trading

Jul 2020 820 pages

eBook

€23.99 ~~€34.99~~

Total € 285.97

C++ Standard Template Library in Practice

€103.99

Learn SQL with Microsoft SQL Server

€137.99

Machine Learning for Algorithmic Trading

€43.99

Total € 285.97

Table of Contents

3 Chapters

Introduction

Database Concepts

Installation and Setup

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

Select Statements

The Having Clause

Select Distinct

Insert Statement

Update Statement

Delete Statement

Creating A Table

Intro To Joining Tables

Left, Right, and Outer Join

Recommendations for you

Python Machine Learning By Example

Python Machine Learning By Example

Jul 2024 518 pages

eBook

€18.99 ~~€27.99~~

Building AI Applications with OpenAI APIs

Building AI Applications with OpenAI APIs

Oct 2024 252 pages

eBook

€15.99 ~~€23.99~~

Unlocking Data with Generative AI and RAG

Unlocking Data with Generative AI and RAG

Sep 2024 346 pages

eBook

€15.99 ~~€23.99~~

Building LLM Powered Applications

Building LLM Powered Applications

May 2024 342 pages

eBook

€20.98 ~~€29.99~~

RAG-Driven Generative AI

RAG-Driven Generative AI

Sep 2024 334 pages

eBook

€22.99 ~~€32.99~~

Machine Learning with PyTorch and Scikit-Learn

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

eBook

€22.99 ~~€32.99~~

Python for Algorithmic Trading Cookbook

Python for Algorithmic Trading Cookbook

Aug 2024 404 pages

eBook

€24.99 ~~€35.99~~

Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Microsoft Power BI - The Complete Masterclass [2023 EDITION]

Jan 2023 14hrs 31mins

Video

€82.99

Principles of Data Science

Principles of Data Science

Jan 2024 326 pages

eBook

€15.99 ~~€23.99~~

Mastering NLP from Foundations to LLMs

Mastering NLP from Foundations to LLMs

Apr 2024 340 pages

eBook

€21.99 ~~€31.99~~

People who bought this also bought

Machine Learning Engineering with Python

Machine Learning Engineering with Python

Aug 2023 462 pages

eBook

€20.98 ~~€29.99~~

Deep Learning with TensorFlow and Keras – 3rd edition

Deep Learning with TensorFlow and Keras – 3rd edition

Oct 2022 698 pages

eBook

€20.98 ~~€29.99~~

Modern Generative AI with ChatGPT and OpenAI Models

Modern Generative AI with ChatGPT and OpenAI Models

May 2023 286 pages

eBook

€20.98 ~~€29.99~~

Generative AI with LangChain

Generative AI with LangChain

Dec 2023 368 pages

eBook

€20.98 ~~€29.99~~

Causal Inference and Discovery in Python

Causal Inference and Discovery in Python

May 2023 456 pages

eBook

€15.99 ~~€23.99~~

About the author

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.

See other products by John Elder

FAQs

How can I download a video package for offline viewing?

Login to your account at Packtpub.com.
Click on "My Account" and then click on the "My Videos" tab to access your videos.
Click on the "Download Now" link to start your video download.

How can I extract my video file?

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?

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.

Video
Format watched (HTML, MP4, streaming)
Chapter or section that issue relates to (if relevant)
System being played on
Browser used (if relevant)
Details of support

Why can’t I download my video package?

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

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