Master Sql: A Comprehensive Guide From Beginner To Advanced
Published 9/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 782.96 MB | Duration: 2h 53m

From Basics to Advanced, Learn by Doing with Practical Exercises, SQL for Data-Driven Decision Making

What you'll learn

Practical SQL skills: Apply SQL concepts to real-world scenarios and solve complex data problems.

Data analysis techniques: Extract meaningful information from large datasets using SQL

Database management: Efficiently create, manipulate, and query databases.

Problem-solving abilities: Develop logical thinking and problem-solving skills through hands-on exercises.

Industry-relevant knowledge: Gain insights into SQL best practices and common use cases.

Requirements

Basic Computer Skills : How to use a computer, navigate files and folders, and open applications.

Understanding of basic data types (numbers, text, dates) and how data is organized in tables.

Description

Master SQL: A Comprehensive Guide from Beginner to AdvancedAre you ready to unlock the power of SQL and transform data into valuable insights? This comprehensive course is designed to guide you from SQL basics to advanced concepts, equipping you with the skills needed to excel in data analysis and management.Key Topics Covered:Fundamentals of SQL:Basic SELECT statementsMathematical OperationsFiltering Data with WHEREGrouping and Sorting dataUsing HAVING and LIMIT clausesAliasesIntermediate SQL:Joins (INNER,LEFT, RIGHT, FULL OUTER,SELF Join)Unions and subqueriesString functionsCase statementsWindow functionsAdvanced SQLCommon Table Expressions (CTEs)Temporary tablesStored proceduresTriggers and eventsWhat You'll Learn:Practical SQL skills: Apply SQL concepts to real-world scenarios and solve complex data problems.Data analysis techniques: Extract meaningful information from large datasets using SQL.Database management: Efficiently create, manipulate, and query databases.Problem-solving abilities: Develop logical thinking and problem-solving skills through hands-on exercises.Who This Course Is For:Beginners: Individuals new to SQL looking for a solid foundation.Data analysts: Professionals seeking to enhance their SQL expertise.Database administrators: Those responsible for managing and maintaining Developers: Programmers who need to interact with databases in their work.Enroll Today and Start Your Journey to SQL Mastery!

Overview

Section 1: Basic SQL

Lecture 1 Introduction

Lecture 2 Installing MySQL Workbench

Lecture 3 Exploring MySQL Workbench & Creating a Database in MySQL

Lecture 4 Resources to use

Lecture 5 SELECT Statement : Display data from a SQL table

Lecture 6 SELECT Statement : Performing mathematical operations in SQL

Lecture 7 SELECT Statement : Retrieving Unique records from SQL table

Lecture 8 WHERE Clause : Filtering the data from a SQL table

Lecture 9 WHERE Clause : Filtering the data from SQL table with multiple conditions

Lecture 10 WHERE Clause : Filtering the data from SQL table with wildcards : LIKE Operator

Lecture 11 Group By Clause : Grouping data in SQL table

Lecture 12 Group By Clause : Grouping data in SQL table with Aggregate Functions

Lecture 13 Order By Clause : Sorting data in SQL table

Lecture 14 Having Vs Where Clause

Lecture 15 Limit and Alias in SQL

Section 2: Intermediate SQL

Lecture 16 Introduction

Lecture 17 Introduction to Joins in SQL

Lecture 18 Join Type : Inner join in SQL

Lecture 19 Join Type : Outer Join in SQL : Left Outer Join & Right Outer Join

Lecture 20 Join Type : Self Join

Lecture 21 Joining Data from Multiple Tables

Lecture 22 Unions in SQL : Union ALL, Union DISTINCT

Lecture 23 Unions in SQL : Applying multiple queries with Where Conditions

Lecture 24 String Functions in SQL : LENGTH, UPPER, TRIM(RTRIM/LTRIM)

Lecture 25 String Functions in SQL : Susbtring function

Lecture 26 String Functions in SQL : Locate & Concat Function

Lecture 27 Case Statement : Categorizing data on different conditions

Lecture 28 Case Statement : Performing Mathematical Operations with Case Statements

Lecture 29 Subqueries in SQL : Subquery in WHERE clause

Lecture 30 Subqueries in SQL : Subquery in SELECT clause

Lecture 31 Subqueries in SQL : Subquery in FROM Clause

Lecture 32 Window Functions in SQL : OVER() function

Lecture 33 Window Function in SQL : Calculate Rolling total

Lecture 34 Window Functions in SQL : ROW_NUMBER(), RANK(), DENSE_RANK()

Section 3: Advanced SQL

Lecture 35 Introduction

Lecture 36 Common Table Expressions (CTEs) in SQL : Why and How to create a CTE

Lecture 37 Common Table Expressions (CTEs) in SQL : Creating Muliple CTEs

Lecture 38 Temporary Table in SQL : Introduction

Lecture 39 Temporary Table in SQL : Creating a temporary table in mySQL Workbench

Lecture 40 Stored Procedure in SQL : Introduction

Lecture 41 Stored Procedure in SQL : Creating & Calling First Simple Stored Procedure

Lecture 42 Stored Procedures in SQL : Creating Stored Procedure from multiple queries

Lecture 43 Stored Procedures in SQL : Creating Stored Procedure with Parameters

Lecture 44 Triggers in SQL : Introduction

Lecture 45 Triggers in SQL : Creating and testing Triggers

Lecture 46 Events in SQL : Creating and testing Events

Lecture 47 Congratulations

Beginners: Individuals new to SQL looking for a solid foundation.,Data analysts: Professionals seeking to enhance their SQL expertise.,Database administrators: Those responsible for managing and maintaining databases.,Developers: Programmers who need to interact with databases in their work.