Library

Course: Learn to Build SQL Query| Ultimate SQL and DataBase Concepts

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

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 

  • Fundamentals
  • Building Blocks
  • Selecting Records from DB
  • Working with Arithmetic Expressions

Chapter 2 Conditioning Sorting and Operators 

  • Logical Operators
  • Comparison Operators
  • Operator Precedence 
  • Sorting Results

Chapter 3 Functions 

  • Character Functions
  • Number Functions
  • Date Functions
  • Conversions
  • General Purpose Functions
  • Nesting Functions

Chapter 4 Grouping

  • Multiple Row Functions on a single Table
  • Multiple Row Functions on Many Table

Chapter 5 Joins

  • Understanding Primary Key 
  • Understanding Foreign Key 
  • Understanding Need of Joins
  • Cartesian Product
  • Equie Join Simple Join Self Join
  • Non Equie Join
  • Outer Join
  • 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 this course is for:

  • Beginners
  • University or College students
  • Anyone who wants Solid SQL Concepts
Basic knowledge
  • No prior knowledge is required
  • PC or MAC
What you will 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
Curriculum
Number of Lectures: 24
Total Duration: 02:12:33
Course Introduction
  • Road map | Course Introduction  
Fundamentals
  • Why SQL  

    This Lecture will focus on following things.

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

    This Lecture will focus on following things.

    1. Keyword
    2. Clause
    3. SQL Block
    4. Select Statements
    5. From Statements
  • Arithmetic Expressions  

    This Lecture will focus on following things.

    1. Arithmetic Operations
    2. Operators
  • Building Blocks  

    This Lecture will focus on following things.

    1. Building Blocks
    2. Alias
    3. Literals
    4. Concatenation
    5. Duplicate Rows
    6. Table Structure
Conditioning Sorting and Operators
  • Writing Comparison Operators and Precedence  

    This Lecture will focus on following things.

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

    This Lecture will focus on following things.

    1. All Logical Operators
  • Operator Precedence  

    This Lecture will focus on following things.

    1. Operators
    2. Precedence 
    3. Execution
  • ORDER BY Clause  

    This Lecture will focus on following things.

    1. Sorting
    2. Ascending 
    3. Descending 
    4. ORDER BY Clause
Functions
  • Character Functions  

    This Lecture will focus on following things.

    1. Functions
    2. Character Functions
    3. Types
    4. Examples
  • Numbers  

    This Lecture will focus on following things.

    1. Number Functions
    2. Types
    3. Examples
  • Dates  

    This Lecture will focus on following things.

    1. Dates Functions
    2. Types
    3. Examples


  • Conversion  

    This Lecture will focus on following things.

    1. Conversion Functions
    2. Types
    3. Examples
  • General  

    This Lecture will focus on following things.

    1. General Functions
    2. Types
    3. Examples


  • Nesting Function  
Groups
  • Multiple Row Functions on Table  

    This Lecture will focus on following things.

    1. Multi Row Functions
    2. Examples


  • Multiple Row Functions on Different Tables  

    This Lecture will focus on following things.

    1. Multi Row Functions
    2. Examples


Joins
  • Primary Key and Foreign Key  

    This Lecture will focus on following things.

    1. Primary Key
    2. Foreign Key
    3. Examples


  • Joins  

    This Lecture will focus on following things.

    1. Joins
    2. Examples


  • Cartesian Product  

    This Lecture will focus on following things.

    1. Cartesign Production
    2. Elimnation
    3. Examples


  • Equi Join Simple Join Self Join  

    This Lecture will focus on following things.

    1. Join Types
    2. Equi Join
    3. Simple Join
    4. Self Join
    5. Examples
  • Non Equi Join  

    This Lecture will focus on following things.

    1. Non Equi Join
    2. Examples


  • Outer Join  

    This Lecture will focus on following things.

    1. Outer Join
    2. Examples


  • Self Join  

    This Lecture will focus on following things.

    1. Self Join
    2. Examples
    3. Regards


Reviews (0)