Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
SQL Server Course for Beginners with 100+ examples
SQL Server Course for Beginners with 100+ examples

SQL Server Course for Beginners with 100+ examples: Learn Microsoft SQL Server in 2022 with 100+ live running queries and examples

Arrow left icon
Profile Icon Amit Diwan
Arrow right icon
€41.99
Full star icon Full star icon Half star icon Empty star icon Empty star icon 2.1 (10 Ratings)
Video Nov 2022 1hr 58mins 1st Edition
Video
€41.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Amit Diwan
Arrow right icon
€41.99
Full star icon Full star icon Half star icon Empty star icon Empty star icon 2.1 (10 Ratings)
Video Nov 2022 1hr 58mins 1st Edition
Video
€41.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€41.99
Subscription
Free Trial
Renews at €18.99p/m

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
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • Understand the SQL query process and the role of databases in real-world applications
  • Create new databases and tables and perform operations to manipulate records using SQL queries
  • Master SQL querying and write complex query statements to enhance your understanding of MySQL

Description

SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server also allows user-defined composite types (UDTs) to be used. The SQL Server services operate within SQL server instances, allowing people to do machine learning and data analytics. In this course, you will understand the difference between SQL and NoSQL. You will query SQL and learn about built-in SQL functions. You will create and modify databases and tables using the CREATE DATABASE and CREATE TABLE statements. You will create, select, and modify records and create constraints in SQL. You will advance to create indexes, drop tables, and databases in SQL. You will learn about operators (AND, OR, NOT, LIKE, BETWEEN, IN, LIKE), functions, statements, and constraints in SQL. You will look at stored procedures and aliases, and learn to back up databases in SQL. You will use the WHERE clause to query and learn about the SELECT and DISTINCT functions. You will arrange data using the ORDER BY keyword and ASC and DESC keywords. After completing the course, you will thoroughly understand SQL’s features and components. You will create complex databases and maintain existing databases. Finally, you will acquire complex SQL query capabilities and write complex queries. All resources are available at: https://github.com/PacktPublishing/SQL-Server-Course-for-Beginners-with-100-examples

Who is this book for?

This course delivers a substantial learning experience for database creators, web developers, application developers, and programmers who must operate with SQL and database structures. Database analysts and administrators who are looking to advance/refresh their knowledge skillsets can benefit from this course. The course has no additional prerequisites besides basic computer use knowledge.

What you will learn

  • Create databases and tables from the start
  • Learn to handle MySQL queries
  • Learn to query SQL to manipulate records in tables
  • Explore functions, statements, and constraints in SQL
  • Create and maintain complex databases and table structures
  • Write complex query statements for maximum data optimization

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Nov 22, 2022
Length: 1hr 58mins
Edition : 1st
Language : English
ISBN-13 : 9781837630226
Category :
Languages :
Tools :

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
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Product Details

Publication date : Nov 22, 2022
Length: 1hr 58mins
Edition : 1st
Language : English
ISBN-13 : 9781837630226
Category :
Languages :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.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
€189.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 €5 each
Feature tick icon Exclusive print discounts
€264.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 €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 121.97
Mastering Windows Security and Hardening
€41.99
Mastering Microsoft Power BI – Second Edition
€37.99
SQL Server Course for Beginners with 100+ examples
€41.99
Total 121.97 Stars icon
Banner background image

Table of Contents

10 Chapters
SQL Introduction Chevron down icon Chevron up icon
SQL Installation and Setup Chevron down icon Chevron up icon
Create and Insert Chevron down icon Chevron up icon
Select Records in SQL Chevron down icon Chevron up icon
Order Records in SQL Chevron down icon Chevron up icon
Operators in SQL Chevron down icon Chevron up icon
Built-In Functions in SQL Chevron down icon Chevron up icon
Constraints in SQL Chevron down icon Chevron up icon
Alter and Update in SQL Chevron down icon Chevron up icon
Advanced SQL Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Half star icon Empty star icon Empty star icon 2.1
(10 Ratings)
5 star 0%
4 star 30%
3 star 0%
2 star 20%
1 star 50%
Filter icon Filter
Top Reviews

Filter reviews by




Alejandro Sep 27, 2024
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
error in the name of each topic and the last video doestn work
Subscriber review Packt
Salvador Aug 09, 2024
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Some of the videos are not in correct order. It seems to be all over the place. Very informational though.
Subscriber review Packt
Ramon Oct 31, 2023
Full star icon Full star icon Full star icon Full star icon Empty star icon 4
Nice quick overview of SQL, but the videos does not match the Table Content, hopefully it gets fixed.
Subscriber review Packt
David Aug 12, 2024
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
I am only in section 6, but the videos are starting to no t match the table of contents. The video about the IN operator is teaching how to backup a database. I hope this can be fixed so you don't confuse SQL novices like me.
Subscriber review Packt
Lee Sep 12, 2024
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
Content is good, but videos are mixed up and dont match what it says on table of contents. So they are unorganised and out of order.
Subscriber review Packt
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 [email protected] 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.