The Complete SQL Bootcamp for Aspiring Data Scientists

The Complete SQL Bootcamp for Aspiring Data Scientists

by Vivek P.
Released August 2023
Publisher(s): Packt Publishing
ISBN: 9781835461808

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video 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 performanc

Audience

If you are an aspiring data professional, a Database Administrator (DBA), a developer, or anyone eager to level up your SQL skills, this all-inclusive SQL Server course is tailor-made for you. Whether you are a beginner or looking to advance your SQL expertise, this course will empower you to excel in managing and manipulating data using SQL Server, unlocking new opportunities in the world of data-driven decision-making. Join us and embark on a journey to master SQL and take your career to the next level.

About The Auhthor

Vivek P.: Vivek P. is a Tableau Certified Associate with more than 12 years of IT experience with different technologies. He is enthusiastic about working with technology and strongly believes in hands-on learning. His teaching methodology is also driven by this belief.

Table of contents

  1. Chapter 1 : Introduction
    1. What All Will Be Covered?
    2. What Is a Database?
    3. Understand SQL
    4. Installation of SQL Server
    5. Download and Restore Database
  2. Chapter 2 : DDL and DML Statements
    1. DDL: Create Database Graphically
    2. DDL: Create Database Using Query
    3. Add Comments
    4. DDL: Alter Database Command
    5. DDL: Delete a Database
    6. Data Types
    7. DDL: Create Table
    8. DML: Insert Data in Table
    9. DDL: Create Table with Identity Column
    10. DDL: Alter Table Command
    11. DDL: Drop the Table
    12. DML: Delete the Table
    13. DDL: Truncate the Table
    14. What Is Schema?
  3. Chapter 3 : Data Integrity
    1. What Is Data Integrity?
    2. Not Null Constraint
    3. Primary Key Constraint
    4. Unique Constraint
    5. Foreign Key Constraint
    6. Check Constraint
    7. Default Constraint
  4. Chapter 4 : Querying the Database
    1. Import Data from Excel
    2. SELECT Statement
    3. SELECT with DISTINCT and TOP Clause
    4. WHERE Clause with Comparison Operators
    5. WHERE Clause with Logical Operators
    6. WHERE Clause with Range Operators
    7. WHERE Clause with List Operators
    8. WHERE Clause with Wildcard Operators
    9. WHERE Clause with IS NULL / IS NOT NULL Operators
    10. WHERE Clause with Update Command
  5. Chapter 5 : Sort, Aggregate, Group, and Filter the Data
    1. Sort the Data
    2. Aggregate Functions 1
    3. Aggregate Functions 2
    4. Group By Clause
    5. Having Clause
  6. Chapter 6 : Functions
    1. String Functions
    2. Date Functions
    3. Mathematical Functions
    4. Data Conversion Functions
    5. COALESCE and ISNULL
    6. String Aggregation Function
  7. Chapter 7 : Joins
    1. Inner Join
    2. Left Join
    3. Right Join
    4. Full Outer Join
    5. Self Join
    6. Cross Join
  8. Chapter 8 : SQL Query Order of Execution
    1. Order of Execution 1
    2. Order of Execution 2
  9. Chapter 9 : CASE, IF ELSE Statement, and Set Operators
    1. Simple CASE Expression
    2. Searched CASE Expression
    3. Variable and Print Statement
    4. IF ELSE Statement
    5. Set Operators: Union and Union All
    6. Set Operators: Intersect and Except (Minus)
  10. Chapter 10 : Views
    1. Create a View
    2. Alter, Join, and Drop the Views
  11. Chapter 11 : Writing Subqueries and Common Table Expressions (CTE)
    1. Subqueries 1
    2. Subqueries 2
    3. Subqueries 3
    4. Subqueries 4
    5. Subqueries 5
    6. Common Table Expression 1
    7. Common Table Expression 2
    8. SQL Problem 1
    9. SQL Problem 2
  12. Chapter 12 : Stored Procedures
    1. Create, Alter, Execute, Drop a Stored Procedure
    2. Stored Procedure with Input Parameters
    3. Stored Procedure with Output Parameters
    4. Calling One Stored Procedure from Another Stored Procedure
  13. Chapter 13 : Window Functions for Advanced Querying
    1. Aggregate Window Function
    2. Ranking Window Function
    3. ROWS BETWEEN Clause
    4. LAG and LEAD
    5. FIRST_VALUE and LAST_VALUE

Product information

  • Title: The Complete SQL Bootcamp for Aspiring Data Scientists
  • Author(s): Vivek P.
  • Release date: August 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781835461808