SQL: From Zero to Hero - Unleash the Data Superpowers Within

SDE Arts | Octavo

Certificate of completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• 1.Introduction 11:42

  • 1: Course Intro 02:43
  • 2: Database Overview 02:02
  • 3: Work Environment 01:25
  • 4: Work Environment hands-on 02:29
  • 5: DBMS & RDBMS Overview 03:03

• The Basics of SQL 1:39:44

  • 6: SQL Queries 02:18
  • 7: Select Statement 02:29
  • 8: Hands-On Select an existing table 02:44
  • 9: Hands-On Select a particular column 02:53
  • 10: Hands-On Select number of columns 03:42
  • 11: Select Distinct 01:19
  • 12: Hands-On Select Distinct and count unique rec 02:50
  • 13: Where Statement 02:01
  • 14: Hands-On Where and filtering records 03:56
  • 15: Add Some Logic for conditions 02:40
  • 16: Hands-On Logics for conditions 05:01
  • 17: Aliases 01:54
  • 18: Hands-On Aliases and renaming columns 05:21
  • 19: Limitations 02:21
  • 20: Hands-On Limitations by examples 03:13
  • 21: Inserting Data 01:54
  • 22: Hands-On Inserting records with column names 03:13
  • 23: Hands-On Inserting values for all columns 02:45
  • 24: Hands-On Inserting data for specified columns 02:51
  • 25: Hands-On Inserting many records 04:20
  • 26: Updating data 02:16
  • 27: Hands-On Updating data by examples 04:40
  • 28: Hands-On Updating all records 01:59
  • 29: Deleting Data 02:46
  • 30: Hands-On Deleting records by examples 04:07
  • 31: Comments 03:27
  • 32: Hands-On Types of Comments 03:30
  • 33: SQL Operators 03:36
  • 34: Hands-On SQL Arithmetic Operators 04:42
  • 35: Hands-On SQL Comparators 04:25
  • 36: Hands-On SQL BETWEEN and IN Operators 04:31

• SQL Constraints & Data Types 12:49

  • 37: Data Types 02:21
  • 38: Hands-On Data Types by example 03:17
  • 39: Adding Constraints 03:11
  • 40: Hands-On Constraints by examples 04:00

• Creating DB Tables 32:29

  • 41: Creating DB and Tables 02:31
  • 42: Hands-On Creating Tables by examples 08:15
  • 43: Hands-On Creating Tables from tables 02:53
  • 44: Dropping DB and Tables 02:53
  • 45: Hands-On Dropping Tables 02:00
  • 46: Alter tables 03:12
  • 47: Hands-On Alter table by examples 10:45

• Data Sorting and Conditions 53:37

  • 48: Orders 01:55
  • 49: Hands-On Order by 03:52
  • 50: Union 04:32
  • 51: Hands-On Union and Union All 04:49
  • 52: Any and All 01:47
  • 53: Using Any Operator Hands-On 01:40
  • 54: SELECT ALL example 1 Hands-On 03:09
  • 55: ALL with two tables example 2 Hands-On 03:55
  • 56: Group By 01:28
  • 57: Hands-On Group By 05:12
  • 58: Having clause 02:59
  • 59: Use Having clause to filter data Hands-On 05:44
  • 60: Wildcards 01:30
  • 61: Hands-On Like and Wildcards 04:17
  • 62: Case Statement 03:05
  • 63: Performing tasks with Case Clause Hands-On 03:43

• SQL Functional Programming 20:48

  • 64: The concept of function 01:21
  • 65: Aggregate functions 02:31
  • 66: Scalar functions 02:23
  • 67: SQL Functions examples hands-on 14:33

• SQL Joins 29:31

  • 68: Joins overview 01:51
  • 69: Inner Join 02:01
  • 70: Inner Join hands-on 05:25
  • 71: Left Join 02:03
  • 72: Left Join hands-on 07:04
  • 73: Right Join 02:20
  • 74: Right Join hands-on 02:41
  • 75: Full Outer Join 03:03
  • 76: Full Outer Join hands-on 03:03

• More Learning and applying 14:05

  • 77: Views in detail hands-on 07:30
  • 78: SQL Project 02:49
  • 79: SQL Project Solution Hints 03:46

Unleash Your Data Superpowers: SQL From Zero to Hero Bootcamp

Ready to crack the code of data and unlock your inner data whiz? Welcome to the SQL: From Zero to Hero – Unleash the Data Superpowers Within Bootcamp, your passport to mastering this essential skill and transforming your career trajectory.

Whether you're a tech newbie or a seasoned programmer, SQL is the key that unlocks the most valuable treasure of the 21st century – information. It's the language of databases, the magic wand that turns raw numbers into compelling stories, and the fuel that powers countless industries.

This comprehensive bootcamp is your launchpad to data mastery. We'll take you from absolute beginner to confident SQL warrior, equipped to develop, manipulate, and manage relational databases like a pro.

No need for prior coding experience! We'll break down the complexities of SQL into bite-sized, easy-to-understand chunks, ensuring you grasp each concept before moving on.

Here's what awaits you on this epic data quest:

• Foundations Laid: Dive into the world of SQL, understanding its role in databases and the power it holds.

• CRUD Your Way to Mastery: Master the art of Creating, Reading, Updating, and Deleting data – the essential dance of any database maestro.

• Data Types Deciphered: Unravel the mystery of data types and operations, ensuring your queries speak the language of information.

• Constraints & Rules: Build sturdy databases with constraints and rules, keeping your data organized and reliable.

• Sorting & Filtering Magic: Learn to sift through mountains of data like a ninja, extracting the nuggets of gold you seek.

• Unite the Tables: Combine and connect tables like an architect, weaving intricate webs of information to reveal hidden insights.

• Multiple Table Mastery: Juggle multiple tables with ease, mastering joins and manipulations to unlock the full potential of your data.

• Condition Champions: Set conditions and filter fields like a pro, carving your desired information from the raw data.

• Build Your Data Kingdom: Construct your own databases and tables, crafting structures that house information like a well-oiled machine.

• Views & Cloning Secrets: Learn to copy tables and create views, expanding your data manipulation toolkit.

• Functional Programming Prowess: Level up your skills with advanced techniques like functional programming in SQL.

• Professional Polish: Put it all together in a capstone project, applying your newfound powers to real-world scenarios.

Your guide on this data odyssey? Me, Ahmed, your friendly neighborhood Lead Software Engineer and Data Science Professional! I'll be with you every step of the way, demystifying complex concepts, keeping you motivated, and celebrating your victories.

This bootcamp is for you if:

• You're a beginner eager to unlock the world of data and boost your career potential.

• You're a developer seeking to expand your skillset and tackle data-driven projects.

• You're a non-programmer curious about the language of information and its power.

• You're an engineer dreaming of becoming a data-powered hero.

• You simply want to speak the language of the future – the language of data!

Don't wait – embark on your data destiny today! Enroll now and let's unleash your inner data superhero together.

Remember, with this bootcamp, you'll:

• Gain in-demand skills sought after by countless industries.

• Boost your career prospects and open doors to exciting opportunities.

• Unlock the power of data and gain insights that drive informed decisions.

• Empower yourself with a valuable skill that shapes the future.

So, what are you waiting for? Enroll now and unlock your data superpowers!

• SQL Beginners
• Developers and Programmers
• Non-Programmers
• Software Engineers
• Anyone who wants to become a Professional Database Engineer in the future
• Data Engineers and Scientists

• No requirements to take this course. You will learn everything you need to know.

The average salary for SQL is $90,668 per year in United States

Currently there are no Q&As for this course. Be the first to ask a question.