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
Data Management with SQL
Data Management with SQL

Data Management with SQL: Mastering MySQL: From Fundamentals to Advanced SQL Techniques

Arrow left icon
Profile Icon SkillSprints Inc., Mark Lassoff
Arrow right icon
NZ$73.99
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2 (1 Ratings)
Video Mar 2024 2hrs 4mins 1st Edition
Video
NZ$73.99
Subscription
Free Trial
Arrow left icon
Profile Icon SkillSprints Inc., Mark Lassoff
Arrow right icon
NZ$73.99
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2 (1 Ratings)
Video Mar 2024 2hrs 4mins 1st Edition
Video
NZ$73.99
Subscription
Free Trial
Video
NZ$73.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
Modal Close icon
Payment Processing...
tick Completed

Billing Address

Key benefits

  • Comprehensive introduction to databases and SQL with a focus on MySQL
  • Covers a broad range of topics from basic operations to advanced SQL techniques
  • Designed for immediate application and skill enhancement in the tech industry

Description

This SQL mastery course offers a solid foundation in databases, emphasizing MySQL, a popular database management system. Starting with the essentials, learners are introduced to the pivotal role of databases in data management and given a primer on SQL, laying the groundwork for subsequent, more detailed study. The course is meticulously structured to guide you through setting up a MySQL environment, enabling practical engagement from the onset. As the course unfolds, you'll delve into designing databases and tables, learn to manage data through insertion, updating, and deletion, and explore the construction of basic to complex SQL queries for effective data retrieval. The course further advances into sophisticated SQL features like filtering with WHERE clause and operators, sorting and grouping data, and utilizing functions and aggregates for enhanced data analysis. A pivotal section on JOINs elucidates the intricacies of linking data across tables, while the final modules on indexes and optimization offer crucial insights into improving database performance. Each SkillSprint is designed to be both informative and hands-on, ensuring that by the end of the course, you'll possess a comprehensive understanding of SQL and MySQL, equipped with the skills to tackle real-world data management challenges.

Who is this book for?

Ideal for students, business analysts, project managers, software developers, data analysts, and career changers aiming to build or enhance their database management and SQL skills, particularly in MySQL.

What you will learn

  • Understand the fundamental concepts and roles of databases and SQL.
  • Perform data manipulation tasks including inserting, updating, and deleting data.
  • Construct basic and complex SQL queries for effective data retrieval.
  • Apply sorting, grouping, and filtering techniques for data analysis.
  • Utilize built-in functions and aggregates for advanced data operations.
  • Implement various types of JOINs to link data across multiple tables.

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Last updated date : Mar 28, 2024
Publication date : Mar 28, 2024
Length: 2hrs 4mins
Edition : 1st
Language : English
ISBN-13 : 9781835881064
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

Last updated date : Mar 28, 2024
Publication date : Mar 28, 2024
Length: 2hrs 4mins
Edition : 1st
Language : English
ISBN-13 : 9781835881064
Category :
Languages :
Tools :

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
$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 NZ$7 each
Feature tick icon Exclusive print discounts
$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 NZ$7 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total NZ$ 219.97
Practical Game Design
NZ$73.99
Data Management with SQL
NZ$73.99
Swift Game Development
NZ$71.99
Total NZ$ 219.97 Stars icon
Banner background image

Table of Contents

1 Chapters
SQL Fundamentals and Advanced Data Management Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
(1 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 100%
1 star 0%
Cinandi Aug 13, 2024
Full star icon Full star icon Empty star icon Empty star icon Empty star icon 2
The steps on how to intitially get into the mysql command-line application are missing at timestamp 6:22
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.