The Sql Bootcamp: Go From Clueless To Expert
Published 9/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.11 GB | Duration: 3h 39m
Published 9/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.11 GB | Duration: 3h 39m
Become a master at SQL!
What you'll learn
Use SQL to query a database
Use SQL to perform data analysis
Use real-world company database and query reports
Learn to perform GROUP BY statements
Requirements
No programming experience needed. You will learn everything you need to know
Description
You'll learn how to perform complex queries to a database using one of the most in demand skills - MYSQL. These skills are also applicable to any other major SQL database, such as PostgreSQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.Learning SQL is one of the greatest ways to increase your values in the job marketplace as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenge excercises along the way to improve your understanding!In this course you will learn everything you need to become a SQL Pro! Including:Get started with MYSQL , the world's most popular SQL toolsLearn he basics of SQL syntaxAnalyzing data using aggregate functions with GROUP BY commandsRunning advanced queries with string operations and comparison operationsLearn to use logical operators to add logic flow to your SQL queriesLearn common SQL JOIN commandsLearn to create tables and databases with constraints on data entriesand much, much more!This is course that builds you up to become a master, having you create simple table and further progress to set up complex databases throughout the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.As an efficient Data Analyst, I've combined all my skills to bring you this awesome course with real world examples. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!I'll see you inside the course!Check out the free preview videos for more information!
Overview
Section 1: Introduction
Lecture 1 SQL Basics
Lecture 2 Defining Data Types
Lecture 3 Tables & Keys
Lecture 4 What is SQL
Lecture 5 MySQL Installation
Section 2: Student Database
Lecture 6 Create Student Table
Lecture 7 Insert Data Into Table
Lecture 8 Constraints
Lecture 9 Constraints Part 2
Lecture 10 Update Table
Lecture 11 Delete Command
Lecture 12 The Select Command
Lecture 13 ORDER BY
Lecture 14 LIMIT
Lecture 15 The WHERE Statement
Section 3: Company Database
Lecture 16 Company Database Overview
Lecture 17 Create Company Database
Lecture 18 Inserting Data Into Company Database
Lecture 19 SQL Queries
Lecture 20 SQL Queries Part 2
Lecture 21 Functions
Lecture 22 Wildcard
Lecture 23 UNION
Lecture 24 The Join Operator
Lecture 25 Left & Right Join
Lecture 26 Nested Queries Part 1
Lecture 27 Nested Queries Part 2
Anyone interested in learning more about SQL, MYSQL, or basic data analysis!