Ultimate SQL and DataBase Concepts

Jazeb Akram, Freelancer, Web Developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
25 Videos (2h 15m)
    • Promo

      2:56
    • Introduction

      3:57
    • Lecture 1 Why SQL

      2:15
    • Lecture 2 Select

      7:52
    • Lecture 3 Arithmmatic Expressions

      6:14
    • Lecture 4 Building Blocks

      8:22
    • Lecture 5 Writing Comparison Operators In SQL

      8:10
    • Lecture 6 Logical Operators

      5:04
    • Lecture 7 Operator Precedence

      2:45
    • Lecture 8 ORDER BY Clause

      4:50
    • Lecture 9 Character Functions

      11:44
    • Lecture 10 Numbers

      3:36
    • Lecture 11 Dates

      6:28
    • Lecture 12 Conversion

      3:39
    • Lecture 13 General

      4:11
    • Lecture 14 Nesting Function

      1:33
    • Lecture 15 Multiple Row Functions on Table

      4:21
    • Lecture 16 Multiple Row Functions on Different Table sets of Data

      9:52
    • Lecture 17 Primary Key and Foreign Key

      9:11
    • Lecture 18 Joins

      3:41
    • Lecture 19 Cartesian Product

      3:05
    • Lecture 20 Equie Join Simple Join Self Join

      10:06
    • Lecture 21 Non Equie Join

      2:32
    • Lecture 22 Outer Join

      3:23
    • Lecture 23 Self Join

      5:32

About This Class

SQL developers are earning higher salary in IT industry, but, its not about writing queries its about understanding and applying the right query at right time and this course will let you understand complex SQL Statements in an easy way .

Moreover, This Course will teach you how to extract Data from Database and write complex queries to a database This course will focus on a wider scale by Covering Structure Query Language SQL concepts as a whole, whether Students work with MySQL, Microsoft SQL Server, Oracle Server, etc.

This course have 5 Chapters in which you will learn

  • Chapter 1  Fundamentals
  1. Fundamentals
  2. Building Blocks
  3. Selecting Records from DB
  4. Working with Arithmetic Expressions
  • Chapter 2 Conditioning Sorting and Operators 
  1. Logical Operators
  2. Comparison Operators
  3. Operator Precedence 
  4. Sorting Results
  • Chapter 3 Functions 
  1. Character Functions
  2. Number Functions
  3. Date Functions
  4. Conversions
  5. General Purpose Functions
  6. Nesting Functions
  • Chapter 4 Grouping
  1. Multiple Row Functions on a single Table
  2. Multiple Row Functions on Many Table
  • Chapter 5 Joins
  1. Understanding Primary Key 
  2. Understanding Foreign Key 
  3. Understanding Need of Joins
  4. Cartesian Product
  5. Equie Join Simple Join Self Join
  6. Non Equie Join
  7. Outer Join
  8. Self Join

Course is Designed for College and University Students who want Solid SQL and Data Base Concepts in a short period of time.

2

Students

--

Projects

0

Reviews (0)

Jazeb Akram

Freelancer, Web Developer

Hi,

its Jazeb. let me tell you about myself . i am 24, living in Lahore, Pakistan. I've been working as a Freelancer since 2011. Recently i have joined world best learning platforms as an online instructor. Eventually People ask me why you are in online teaching business. The reason i came into teaching from my successful freelance experience because i always love to teach and get very passionate about development and assisting others to achieve success in the field of programming. when i was in my college, one thing that always made me wonder that why people are learning without skills? why students are paying enough but what they are gaining? Nothing. why? so i came into this solution that i have to jump in for all the stragglers who want to achieve skills for their career. that's why at the end of my courses students are finding unique skills that they can really use in their life and boost up their career.

i am a developer and web designer with the great passion for building beautiful new Desktop/Web Applications from scratch. I also have a University Degree in Computer Science (Hons). and a Research Paper in Software Quality Assurance.

i am helping many students online by teaching Online Courses on different Platforms

  • StackSkills
  • StackSocial
  • Udemy
  • SkillShare

in Computer sciences, web development.Contact me on my web or here, if you need any assistance online.

Best,

Jazeb Akram