🚨 Time is Running Out: Reserve Your Spot in the Lucky Draw & Claim Rewards! START NOW
watching now
4 Students

Description

What Will You Learn?

  • You'll get solid SQL basics
  • You'll build a proper understand of complex SQL concepts
  • You'll be able to write robust SQL queries
  • You'll know how to use SQL to extract data from a database

Requirements

  • No prior knowledge is necessary
  • MAC or PC
  • NFT Certificate
  • 26 Lessons
  • Beginner
  • English
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 2h 17min of content, in total.

Section 1: Introduction
08:23
Section 2: Fundamentals
24:45
Arithmmatic Expressions
06:14
Building Blocks
08:22
Section 3: Conditioning Sorting and Operators
20:51
Writing Comparison Operators In SQL
08:10
Logical Operators
05:04
Operator Precedence
02:46
ORDER BY Clause
04:51
Section 4: Functions
31:13
Character Functions
11:44
Numbers
03:36
Dates
06:28
Conversion
03:40
General
04:11
Nesting Function
01:34
Section 5: Groups
14:15
Multiple Row Functions on Table
04:22
Multiple Row Functions on Different Table sets of Data
09:53
Section 6: Joins
37:34
Primary Key and Foreign Key
09:12
Joins
03:42
Cartesian Product
03:05
Equie Join Simple Join Self Join
10:07
Non Equie Join
02:33
Outer Join
03:23
Self Join
05:32

About the Instructor

Jazeb Akram is a Data Scientist and has been working as a Developer consultant. He has been working as a Freelancer since 2011. He designed various Applications for many companies and also training individuals on development tools and languages. Jazeb Also has a university degree in computer science from the University of the Punjab, Pakistan, and a master's degree in Data Science from Western Sydney University, Australia.

You can read his full portfolio on his website jazebakram.com



Another Jazeb’s passion is teaching. He has joined the world's best learning platforms as an online instructor. Jazeb Akram says that the reason he came into teaching is his successful freelance experience because he loves to teach and gets very passionate and assisting others to achieve success in programming. That’s why at the end of his courses, students develop unique skill sets that they can use in a real-life and improve their career.

Jazeb loves to travel and explore new places.

On BitDegree, you have an opportunity to be guided by this amazing instructor to learn programming, complete projects and build apps. Jazeb Akram will teach you JavaScript, PHP, CSS, SQL and more. Choose the best course for you and dive into learning today!

See All Instructor Courses

BitDegree platform reviews