Sql Essentials - Thinking In Sql For Beginners
Published 10/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 14.70 GB | Duration: 20h 39m
Learn SQL for beginners with hands-on and practice exercise
What you'll learn
Writing simple to complex SQL queries and answer business questions
Learn joins, group by, aggregates, and many other SQL clauses
Handling date, time, strings, and working with SQL functions
Master your skills with 50+ practice questions
Requirements
No prior knowledge of database and SQL is required
A Recent 64-bit Windows/Mac Machine with 8 GB RAM & Internet Connection
Description
SQL Essentials is a beginner's course that will help you learn SQL programming from the basics and become proficient in writing medium to complex SQL queries and answering business questions.This course is designed using ANSI SQL standard and uses one of the most in-demand skills - Spark SQL. These skills also apply to other major SQL databases, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and more.This course will help you learn the following topics.Writing simple to complex SQL queries and answering business questionsLearn joins, group by, aggregates, and many other SQL clausesHandling date, time, strings, and working with SQL functionsMaster your skills with 50+ practice questionsThis course specialises in the following complex aggregation and advanced SQL problems.Selecting and FilteringDifferent types of JoinSubqueriesCTE in SQLString functionsDate and Time ArithmeticSimple aggregationGrouping AggregationMulti-level aggregationWindowing AggregationThis course also includes practice questions and hands-on exercises.This course is ANSI SQL compliant and big data enabled - You will learn and practice SQL using Apache Spark SQL and be prepared to work as a Big Data Engineer using Apache Spark.This is the best course for you if you are looking forward to growing as a Data Engineer.
Overview
Section 1: Before you start
Lecture 1 About the course
Lecture 2 How to download your resources
Section 2: Introduction to Database and SQL
Lecture 3 What is Database and SQL
Lecture 4 What can you do with Databases and SQL
Lecture 5 How to set up your SQL learning environment
Lecture 6 How to test your SQL environment
Section 3: Getting started with SQL
Lecture 7 SQL Classification
Lecture 8 Microproject - Requirement
Lecture 9 Design your data model
Lecture 10 Implement your data model
Lecture 11 Working with databases
Lecture 12 Working with tables
Lecture 13 Inserting data into a table
Lecture 14 Inserting from source, updating and deleting
Lecture 15 Selecting data from tables
Lecture 16 Microproject - Solution
Section 4: The power of the SELECT clause
Lecture 17 Selecting columns
Lecture 18 Using mathematical expressions
Lecture 19 Creating logical expressions
Lecture 20 Designing conditional expressions
Section 5: The power of the WHERE clause
Lecture 21 Filter Expressions
Lecture 22 CASE and CTE in Filters
Lecture 23 Subquery Filters
Lecture 24 Correlated Query Filter
Section 6: Joining Tables, Subqueries and CTE
Lecture 25 Introduction to join
Lecture 26 Inner Join queries
Lecture 27 Outer joins
Lecture 28 Other types of joins
Section 7: The power of SQL functions
Lecture 29 Using SQL Functions
Lecture 30 Mathematical Functions
Lecture 31 String Functions
Lecture 32 Date Time Functions
Section 8: Grouping and aggregation
Lecture 33 Simple Aggregation
Lecture 34 Grouping Aggregation - Part 1
Lecture 35 Grouping Aggregation - Part 2
Lecture 36 Grouping Aggregation Filters
Lecture 37 Multilevel Aggregation - Part 1
Lecture 38 Multilevel Aggregation - Part 2
Lecture 39 Introduction to Window Aggregation
Lecture 40 Window Aggregates Part 1
Lecture 41 Window Aggregates Part 2
Lecture 42 Window Aggregates Part 3
Section 9: Other SQL Statements
Lecture 43 Set Operations
Lecture 44 Pivoting Data Sets
Lecture 45 Unpivot Data Sets
Lecture 46 Data Views
Lecture 47 Auxiliary Statements
This course is designed for everyone who wants to learn and develop the skills of writing SQL queries and solving business problems using SQL language.,This course is also designed for students who are absolute beginners in SQL programming.
Screenshot
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!