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! 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
Free Learning
Arrow right icon
From 0 To 1:SQL And Databases - Heavy Lifting
From 0 To 1:SQL And Databases - Heavy Lifting

From 0 To 1:SQL And Databases - Heavy Lifting: Your bodyguard for when data gets too big, this course is strong but friendly, funny yet deep, animated yet thoughtful.

Arrow left icon
Profile Icon Loonycorn
Arrow right icon
€8.99 €38.99
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1 (1 Ratings)
Video Jan 2018 14hrs 24mins 1st Edition
Video
€8.99 €38.99
Subscription
Free Trial
Renews at €18.99p/m
Arrow left icon
Profile Icon Loonycorn
Arrow right icon
€8.99 €38.99
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1 (1 Ratings)
Video Jan 2018 14hrs 24mins 1st Edition
Video
€8.99 €38.99
Subscription
Free Trial
Renews at €18.99p/m
Video
€8.99 €38.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

  • SQL In Great Depth
  • Database Fundamentals and Just Enough Theory
  • Practical Examples - Queries in MySQL and SQLite, and code in Python

Description

Your bodyguard for when data gets too big, this course is strong but friendly, funny yet deep, animated yet thoughtful. Let’s parse that. Your bodyguard for when data gets too big: Most business folks (and quite a few engineers) use Excel as a basic tool of decision making and modeling, but when you can't fit the data you'd like into an Excel spreadsheet that you can easily open, its time to move to a database. The course is strong but friendly: This course will help you move to a database without being intimidated by the new environment. Don't let anyone tell you that any dataset is too large or too complicated for you to understand. The course is funny yet deep: It goes really deep into the topics that folks often find hard to understand, such as joins, aggregate operators and interfacing with databases from a programming language. But it never takes itself too seriously. The course is very visual: most of the techniques are explained with the help of animations to help you understand better. This course is practical as well: Queries are explained in excruciating detail, indices are demystified, and potentially career-limiting traps (Drop, Alter) are marked with bright yellow tape markers so you can steer clear. The course is also quirky. The examples are irreverent. Lots of little touches: repetition, zooming out so we remember the big picture, active learning with plenty of quizzes. There’s also a peppy soundtrack, and art - all shown by studies to improve cognition and recall.

Who is this book for?

Data analysts who would like to really get down and dirty with the data. Business folks and executives looking to make their decision making more data-driven, and seeking the technical knowledge to do so.Students of Computer Science and Computer Engineering looking to understand database concepts for the first time. Software engineers who need to understand and interface with databases from programming languages in their work.

What you will learn

  • Explore large datasets and uncover insights - going far beyond the Excel, deep into the data
  • Model and create a database for day-to-day use
  • Interface with databases from a programming language such as Python
  • Have the comfort and confidence needed to load data and use both GUI and a command line interface for database operations
  • Fully understand and leverage joins, sub queries, aggregates, indices, triggers, stored procedures and other major database concepts

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Jan 29, 2018
Length: 14hrs 24mins
Edition : 1st
Language : English
ISBN-13 : 9781789134285
Vendor :
Apache
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 : Jan 29, 2018
Length: 14hrs 24mins
Edition : 1st
Language : English
ISBN-13 : 9781789134285
Vendor :
Apache
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 59.97 195.97 136.00 saved
From 0 To 1:SQL And Databases - Heavy Lifting
€8.99 €38.99
Advanced Applied SQL for Business Intelligence and Analytics
€8.99 €114.99
MySQL 8 Cookbook
€41.99
Total 59.97 195.97 136.00 saved Stars icon
Banner background image

Table of Contents

11 Chapters
Introduction To Databases Chevron down icon Chevron up icon
Going From Relations To Database Tables Chevron down icon Chevron up icon
Creating Tables And Inserting Data Into Them Chevron down icon Chevron up icon
Back To Retrieving Data - More Advanced Queries Using Group By Chevron down icon Chevron up icon
Joins - Don't Let Them Intimidate You! They're All Fuzzy And Nice Chevron down icon Chevron up icon
Subqueries: Layering The Cake Chevron down icon Chevron up icon
Constraints Chevron down icon Chevron up icon
Somewhat More Advanced Concepts Chevron down icon Chevron up icon
Table Design: Theory And Practice Chevron down icon Chevron up icon
Putting It Together: Database Programming In Python Chevron down icon Chevron up icon
Appendix Chevron down icon Chevron up icon

Customer reviews

Rating distribution
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
(1 Ratings)
5 star 0%
4 star 0%
3 star 0%
2 star 0%
1 star 100%
Pawel Sep 30, 2023
Full star icon Empty star icon Empty star icon Empty star icon Empty star icon 1
I hardly understand this thick accent.
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.