Book Image

SQL Masterclass: SQL for Data Analytics [Video]

By : Abhishek Bansal, Pukhraj Parikh
Book Image

SQL Masterclass: SQL for Data Analytics [Video]

By: Abhishek Bansal, Pukhraj Parikh

Overview of this book

<p>This complete tutorial on SQL can be completed within a weekend. SQL is the most sought-after skill for data analysis roles in all companies. So, whether you want to start a career as a data scientist or just grow your data analysis skills, this course will cover everything you need to know. </p><p> </p><p>The course is taught by Abhishek and Pukhraj, who have been teaching Data Science and Machine Learning for over a decade. They are also the creators of some of the most popular online courses—with over 150,000 enrollments. </p><p> </p><p>SQL is the most universal and commonly used database language. It powers the most commonly used database engines such as PostgreSQL, SQL Server, SQLite, and MySQL. Simply put, If you want to access databases then yes, you need to know SQL. It is not difficult to learn SQL. SQL is not a programming language; it’s a query language. The primary objective for which SQL was created was to enable normal people get the data they need from databases. The language resembles English, so anyone who can use the latter at a basic level can write SQL queries easily. SQL is one of the most sought-after skills by employers who are hiring. </p><p> </p><p>SQL is easy but no one can determine how long it takes to learn it; it totally depends on you. The method we have adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same timetable but remember: you can learn nothing without practicing it. Practice is the only way to learn SQL quickly. </p><p>Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message. With each lecture, there is a practice sheet attached for you to follow along. Each section contains a practice assignment for you to implement what you've learned practically. We have created a set of concise and comprehensive videos to teach you all the SQL-related skills you will need in your professional career. We also provide exercises to complement the videos. These exercises are carefully designed to further clarify the concepts and help you implement them on practical problems you'll face at work. </p><p> </p><p>All the code and supporting files for this course are available at - https://github.com/PacktPublishing/SQL-Masterclass-SQL-for-Data-Analytics</p>
Table of Contents (23 chapters)
Free Chapter
1
Introduction
2
Installation and getting started
6
Selection commands: Filtering
8
Alias
AS
10
Group by Commands
11
Conditional Statement
14
Views and Indexes
20
User Access Control Functions
21
Bonus Section: Nail that Interview!
23
Bonus Section: Database Basics
Chapter 15
String Functions
Content Locked
Section 5
CONCATENATION
String Functions: CONCATENATION