Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
The Complete SQL Bootcamp for Aspiring Data Scientists [Video]
The Complete SQL Bootcamp for Aspiring Data Scientists [Video]

The Complete SQL Bootcamp for Aspiring Data Scientists: The Ultimate SQL Bootcamp to Accelerate Your Data Science Journey

Arrow left icon
Profile Icon Vivek P.
Arrow right icon
€52.99
Video Aug 2023 8 hours 10 minutes 1st Edition
Video
€52.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Vivek P.
Arrow right icon
€52.99
Video Aug 2023 8 hours 10 minutes 1st Edition
Video
€52.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€52.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

Key benefits

  • Develop a solid understanding of SQL Server fundamentals, data types, querying, and database management
  • Learn advanced SQL querying techniques such as joins, subqueries, and CTE for complex data retrieval and analysis
  • Gain hands-on experience in creating and managing essential database objects, such as schemas, tables, and views to organize data

Description

Welcome to this SQL Server course designed to cater to aspiring data professionals and anyone looking to enhance their SQL skills. We will begin with the fundamentals, covering SQL syntax, data types, and essential querying techniques. You will learn how to write powerful SQL queries to retrieve, filter, and sort data, as well as perform calculations, and leverage aggregate functions. In the second part of the course, we will dive into advanced SQL for data science. Joining tables, using subqueries, and employing window functions are vital skills for complex data retrieval and analysis. You will learn how to combine data from multiple tables, create intricate queries, and extract valuable insights from large datasets. Lastly, we will focus on database management and optimization. You will gain the skills to efficiently manage SQL Server databases, including database design, indexing, and performance tuning. This knowledge is crucial for ensuring that your databases run smoothly and deliver optimal performance. By the end of this course, you will have gained the confidence and expertise to utilize SQL for data science tasks, ranging from data exploration and manipulation to advanced analytics and reporting.

What you will learn

  • Learn DDL commands for creating, altering, and deleting databases
  • Understand various data types and their significance in defining data structures
  • Explore constraints, including NOT NULL, Primary Key, Foreign Key, Check, and Default
  • Work with views to simplify complex queries and improve data security
  • Learn how to use aggregate functions for data summarization and analysis
  • Learn the order of execution in SQL queries and how it affects query performance

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 23, 2023
Length 8 hours 10 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781835461808
Category :

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

Product Details

Publication date : Aug 23, 2023
Length 8 hours 10 minutes
Edition : 1st Edition
Language : English
ISBN-13 : 9781835461808
Category :

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 75.98 85.98 10.00 saved
PostgreSQL Server Programming
€22.99 €32.99
The Complete SQL Bootcamp for Aspiring Data Scientists
€52.99
=
Book stack Total 75.98 85.98 10.00 saved Stars icon

Table of Contents

13 Chapters
1. Introduction Chevron down icon Chevron up icon
2. DDL and DML Statements Chevron down icon Chevron up icon
3. Data Integrity Chevron down icon Chevron up icon
4. Querying the Database Chevron down icon Chevron up icon
5. Sort, Aggregate, Group, and Filter the Data Chevron down icon Chevron up icon
6. Functions Chevron down icon Chevron up icon
7. Joins Chevron down icon Chevron up icon
8. SQL Query Order of Execution Chevron down icon Chevron up icon
9. CASE, IF ELSE Statement, and Set Operators Chevron down icon Chevron up icon
10. Views Chevron down icon Chevron up icon
11. Writing Subqueries and Common Table Expressions (CTE) Chevron down icon Chevron up icon
12. Stored Procedures Chevron down icon Chevron up icon
13. Window Functions for Advanced Querying Chevron down icon Chevron up icon
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.