HOT
blank

Comprehensive SQL Course:Hands-on Project & Coding Exercises

Business

Comprehensive SQL Course:Hands-on Project & Coding Exercises, available at $44.99, has an average rating of 4.65, with 130 lectures, 125 quizzes, based on 202 reviews, and has 1458 subscribers.

Rating4.7
Enroll Now

You will learn about You will learn how to create database tables, alter an existing table and drop a table that's not required using SQL You will learn how to query data from a table, apply transformations using functions, filter and sort the data returned using SQL You will learn how to join multiple tables, summarise the data as required to produce summaries using SQL You will learn how to use sub queries and common table expressions to implement complex logic using SQL You will learn how to create and work with views to simplify complex solutions using SQL Using SQL, you will learn how to use window functions to carry out complex data analysis with ease Using SQL, you will learn how to design and implement a database for a real world project You will learn how to write SQL queries required to satisfy the requirements for a real world project This course is ideal for individuals who are University students looking for a career in Information Technology or Software Engineers working with data, i.e, Web Developers, App Developers etc or Anyone interested in Data Engineering, Data Analysis, Data Science, Business Intelligence etc It is particularly useful for University students looking for a career in Information Technology or Software Engineers working with data, i.e, Web Developers, App Developers etc or Anyone interested in Data Engineering, Data Analysis, Data Science, Business Intelligence etc.

Enroll now: Comprehensive SQL Course:Hands-on Project & Coding Exercises

Summary

Title: Comprehensive SQL Course:Hands-on Project & Coding Exercises

Price: $44.99

Average Rating: 4.65

Number of Lectures: 130

Number of Quizzes: 125

Number of Published Lectures: 130

Number of Published Quizzes: 125

Number of Curriculum Items: 255

Number of Published Curriculum Objects: 255

Original Price: $27.99

Quality Status: approved

Status: Live

What You Will Learn

  • You will learn how to create database tables, alter an existing table and drop a table that's not required using SQL
  • You will learn how to query data from a table, apply transformations using functions, filter and sort the data returned using SQL
  • You will learn how to join multiple tables, summarise the data as required to produce summaries using SQL
  • You will learn how to use sub queries and common table expressions to implement complex logic using SQL
  • You will learn how to create and work with views to simplify complex solutions using SQL
  • Using SQL, you will learn how to use window functions to carry out complex data analysis with ease
  • Using SQL, you will learn how to design and implement a database for a real world project
  • You will learn how to write SQL queries required to satisfy the requirements for a real world project

Who Should Attend

  • University students looking for a career in Information Technology
  • Software Engineers working with data, i.e, Web Developers, App Developers etc
  • Anyone interested in Data Engineering, Data Analysis, Data Science, Business Intelligence etc

Target Audiences

  • University students looking for a career in Information Technology
  • Software Engineers working with data, i.e, Web Developers, App Developers etc
  • Anyone interested in Data Engineering, Data Analysis, Data Science, Business Intelligence etc

Welcome!

I am looking forward to helping you with learning SQL, one of the fundamental skills required to become a data professional. SQL is one of the important skill required to become data engineers, data analysts, data scientists, web developers, application developer etc.

This is a hand-on course with 120+ SQL coding exercises and a real world project of building a database for one of the popular sporting tournaments, Indian Premier League and writing all the SQL statements required for the scorecard of the tournament website.

No downloads or database installations required.I teach this SQL course using the Udemy’s coding exercises platform which comes with a database installed for you! You just need a web browser with any device (i.e., iPad,  tablet, laptop) to practice SQL!

Once you have completed the course including all the SQL coding exercises and the project, I strongly believe that you will be in a position to start working in a real world data project using SQL.

I value your time as much as I do mine. So, I have designed this SQL course to be fast-paced and to the point. Also, the course has been taught with simple English and no jargons. I start the course from basics and by the end of the course you will be proficient in SQL.

Currently this course teaches you the following

  • Basics of SQL statements

  • Querying Data

  • Filtering Data

  • Simple SQL functions

  • Date Functions

  • Conditional Expressions & Functions

  • Aggregate Functions

  • Grouping Data

  • SQL Joins

  • SQL Constraints

  • Primary & Foreign Keys and Relationships

  • Database Design & Entity Relationship Diagrams

  • Subqueries

  • Common Table Expressions (CTEs)

  • Views

  • Window/ Analytical Functions

  • Working with a Real World Project

This course assumes no prior knowledge of SQL or any programming language. Once you complete the course, I genuinely believe that you will be in a position to confidently work in a real time project using SQL!

Course Curriculum

Chapter 1: Beginner – Comprehensive SQL Course Introduction

Lecture 1: SQL Course Introduction

Lecture 2: SQL Course Structure

Lecture 3: Course Slides Download

Chapter 2: Beginner – Overviews

Lecture 1: Introduction to SQL

Lecture 2: Udemy Coding Exercises Overview

Lecture 3: SQLite Documentation (Optional)

Chapter 3: Beginner – Introduction to SQL Statements

Lecture 1: Section Overview

Lecture 2: Creating Tables

Lecture 3: Writing SQL Statement – Best Practices

Lecture 4: Inserting Single Record

Lecture 5: Inserting Multiple Records

Lecture 6: Selecting Data

Lecture 7: Filtering Data

Lecture 8: Updating Data

Lecture 9: Deleting Data

Lecture 10: Dropping Tables

Lecture 11: Code Used During Demonstration

Chapter 4: Beginner – Querying Data

Lecture 1: Querying Data – Overview

Lecture 2: Select Clause Overview

Lecture 3: Renaming Columns – Column Alias

Lecture 4: Removing Duplicates – DISTINCT

Lecture 5: FROM Clause Overview

Lecture 6: Sorting Outputs by Single Column – ORDER BY

Lecture 7: Sorting Outputs by Multiple Columns and Positions – ORDER BY

Lecture 8: Restricting number of records – LIMIT

Lecture 9: Code Used During Demonstration

Chapter 5: Beginner – Filtering Data

Lecture 1: Introduction to Filtering Data

Lecture 2: Filtering Using Mathematical Operators

Lecture 3: Filter Data Using BETWEEN Operator

Lecture 4: Filter Data Using Like Operator and Percentage Wildcard

Lecture 5: Filter Data Using Like Operator and Underscore Wildcard

Lecture 6: Filter Data Using Like Operator – Bringing It All Together

Lecture 7: Filter Data Using IN Operator

Lecture 8: Filter Data Using Multiple Conditions – AND Operator

Lecture 9: Filter Data Using Multiple Conditions – OR Operator

Lecture 10: Filter Data Using Multiple Conditions – Bringing It All Together

Lecture 11: Filter Data Using Negative Conditions

Lecture 12: Filters in UPDATE and DELETE Statements

Lecture 13: Code Used During Demonstration

Chapter 6: Intermediate – Simple SQL Functions

Lecture 1: SQL Functions – Overview

Lecture 2: String Functions – UPPER, LOWER, CONCAT

Lecture 3: String Functions – REPLACE, TRIM

Lecture 4: String Functions – SUBSTR, INSTR, LENGTH

Lecture 5: Math Functions

Lecture 6: Nested Function Calls

Lecture 7: Code Used During Demonstration

Chapter 7: Intermediate – Conditional Functions & Expressions

Lecture 1: Conditional Functions – IIF

Lecture 2: Simple CASE Expression

Lecture 3: Searched CASE Expression

Lecture 4: Introduction to NULLs

Instructors

Rating Distribution

  • 1 stars: 2 votes
  • 2 stars: 1 votes
  • 3 stars: 12 votes
  • 4 stars: 56 votes
  • 5 stars: 131 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024