Ultimate SQL and DataBase Concepts
4.2 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,323 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ultimate SQL and DataBase Concepts to your Wishlist.

Add to Wishlist

Ultimate SQL and DataBase Concepts

Learn SQL and Database Core Concepts: This SQL Tutorial will cover all Major SQL concepts from Scratch.
4.2 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,323 students enrolled
Created by Jazeb Akram
Last updated 4/2017
English
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • SQL Fundamentals
  • Understand Complex SQL Concepts in Easy way using daily life examples
  • Construct SQL Statements
  • Use SQL to retrieve data from database
  • Selecting Data From Database
  • Restricting and Sorting Data from DB
  • Grouping Data From DB
  • Construct SQL statements that will let them work with more than two tables
  • Use SQL Functions
  • Work with SQL Operators and find out precedence
  • Nesting in SQL
  • Joins
View Curriculum
Requirements
  • No prior knowledge is required
  • PC or MAC
Description

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.


Who is the target audience?
  • Beginners
  • University or College students
  • Anyone who wants Solid SQL Concepts
Curriculum For This Course
Expand All 24 Lectures Collapse All 24 Lectures 02:12:23
+
Introduction
1 Lecture 03:57
+
Fundamentals
4 Lectures 24:43

This Lecture will focus on following things.

  1. What is SQL
  2. Need of SQL
  3. How it work


Why SQL
02:15

This Lecture will focus on following things.

  1. KeyWord
  2. Clause
  3. SQL Block
  4. Select Satements
  5. From Statements


Select
07:52

This Lecture will focus on following things.

  1. Arithmetic Operations
  2. Operators
Arithmmatic Expressions
06:14

This Lecture will focus on following things.

  1. Building Blocks
  2. Alias
  3. Literals
  4. Concatenation
  5. Duplicate Rows
  6. Table Structure
Building Blocks
08:22
+
Conditioning Sorting and Operators
4 Lectures 20:49

This Lecture will focus on following things.

  1. Conditioning
  2. WHERE Clause
  3. Character Strings 
  4. Dates
  5. All Comparison Operators


Writing Comparison Operators and Precedence
08:10

This Lecture will focus on following things.

  1. All Logical Operators
Logical Operators
05:04

This Lecture will focus on following things.

  1. Operators
  2. Precedence 
  3. Execution
Operator Precedence
02:45

This Lecture will focus on following things.

  1. Sorting
  2. Ascending 
  3. Descending 
  4. ORDER BY Clause
ORDER BY Clause
04:50
+
Functions
6 Lectures 31:11

This Lecture will focus on following things.

  1. Functions
  2. Character Functions
  3. Types
  4. Examples
Character Functions
11:44

This Lecture will focus on following things.

  1. Number Functions
  2. Types
  3. Examples
Numbers
03:36

This Lecture will focus on following things.

  1. Dates Functions
  2. Types
  3. Examples
Dates
06:28

This Lecture will focus on following things.

  1. Conversion Functions
  2. Types
  3. Examples
Conversion
03:39

This Lecture will focus on following things.

  1. General Functions
  2. Types
  3. Examples
General
04:11

Nesting Function
01:33
+
Groups
2 Lectures 14:13

This Lecture will focus on following things.

  1. Multi Row Functions
  2. Examples
Multiple Row Functions on Table
04:21

This Lecture will focus on following things.

  1. Multi Row Functions
  2. Examples
Multiple Row Functions on Different Tables
09:52
+
Joins
7 Lectures 37:30

This Lecture will focus on following things.

  1. Primary Key
  2. Foreign Key
  3. Examples


    Preview 09:11

    This Lecture will focus on following things.

    1. Joins
    2. Examples
    Joins
    03:41

    This Lecture will focus on following things.

    1. Cartesign Production
    2. Elimnation
    3. Examples
    Cartesian Product
    03:05

    This Lecture will focus on following things.

    1. Join Types
    2. Equie Join
    3. Simple Join
    4. Self Join
    5. Examples
    Equie Join Simple Join Self Join
    10:06

    This Lecture will focus on following things.

    1. Non Equi Join
    2. Examples
    Non Equie Join
    02:32

    This Lecture will focus on following things.

    1. Outer Join
    2. Examples
    Outer Join
    03:23

    This Lecture will focus on following things.

    1. Self Join
    2. Examples
    3. Regards
    Self Join
    05:32
    About the Instructor
    Jazeb Akram
    4.2 Average rating
    108 Reviews
    8,631 Students
    5 Courses
    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

    • Udemy
    • StackSkills
    • SkillShare
    • StackSocial

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

    Best,

    Jazeb Akram