Learn SQL in 6 days

Learn SQL in 6 days, available at $69.99, has an average rating of 4.05, with 57 lectures, 8 quizzes, based on 658 reviews, and has 3153 subscribers.

You will learn about The primary objective is to make the individual utilizing this tutorial an expert in writing data retrieval statements. This course is ideal for individuals who are "Learn SQL in 6 days" can be used by any and every technology professional as well as individuals pursuing their graduation / post-graduation in the Computer Science or Information Technology sector. It is particularly useful for "Learn SQL in 6 days" can be used by any and every technology professional as well as individuals pursuing their graduation / post-graduation in the Computer Science or Information Technology sector.

Enroll now: Learn SQL in 6 days

Summary

Title: Learn SQL in 6 days

Price: $69.99

Average Rating: 4.05

Number of Lectures: 57

Number of Quizzes: 8

Number of Published Lectures: 56

Number of Published Quizzes: 8

Number of Curriculum Items: 65

Number of Published Curriculum Objects: 64

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

The primary objective is to make the individual utilizing this tutorial an expert in writing data retrieval statements.

Who Should Attend

"Learn SQL in 6 days" can be used by any and every technology professional as well as individuals pursuing their graduation / post-graduation in the Computer Science or Information Technology sector.

Target Audiences

"Learn SQL in 6 days" can be used by any and every technology professional as well as individuals pursuing their graduation / post-graduation in the Computer Science or Information Technology sector.

“Learn SQL in 6 days” Video Course provides a basic understanding of databases, tables, as well as how to manipulate data with functions like add, edit or delete data from tables and databases. Data retrieval concepts, which includes sorting, filtering, multi-table join, sub-queries and using functions in retrieval statements are discussed in detail.

This course covers the following topics:

· Database Basics

· Schema

· Managing Database and Tables

· Populating Data

· Retrieving Data

· Functions

· Creating Sub-totals

· Sub-queries

· Bonus exercises (on Simple Select)

This course requires approximately 4.5 hours to complete. But we would recommend you to split it into 6 days to have a complete understanding of the concepts.

Each section is well structured and is designed in such a way that the concept is explained first, then I have taken example and explained how to write the SQL for the problem statement. This might help you to understand the concepts better. To make it easier for the learner, all the examples are based on the schema explained in the Schema section.

This course is structured in such a way that one can start writing SQL in hours with confidence.

The bonus exercises section is an add-on, where I made some simple and lighter exercises to give some more input on Simple Select statements. The bonus section has around 10 exercises only on simple select statement.

Course Curriculum

Chapter 1: DAY 1: Database Basics and Schema

Lecture 1: Database

Lecture 2: Tables

Lecture 3: Set of Tables

Lecture 4: Primary and Foreign Key

Lecture 5: Data Types

Lecture 6: Schema

Chapter 2: DAY 2 : Managing Database and Tables

Lecture 1: Database Creation

Lecture 2: Show Database

Lecture 3: Drop Database

Lecture 4: Data Types

Lecture 5: Create Table

Lecture 6: Describe Table

Lecture 7: Alter Table

Lecture 8: Delete Table

Lecture 9: Create Foreign Key

Lecture 10: Create Primary Key

Chapter 3: DAY 3: Populating Data

Lecture 1: Setting up Database and Tables

Lecture 2: Add Data to table

Lecture 3: WHERE Clause

Lecture 4: WHERE Clause examples

Lecture 5: Arithmetic Operators and Expressions

Lecture 6: Comparison Operators and Simple Condition

Lecture 7: Logical Operators and Operator Precedence

Lecture 8: Update Table Data

Lecture 9: Delete Data from Table

Chapter 4: DAY 4: Retrieving Data

Lecture 1: Simple Select

Lecture 2: Change Column Header

Lecture 3: Select Specific Columns

Lecture 4: Select Distinct Columns

Lecture 5: Sorting the Data

Lecture 6: Retrieve Data from Multiple Tables

Chapter 5: DAY 5: Functions and Creating Sub-totals

Lecture 1: String Functions

Lecture 2: Mathematical Functions

Lecture 3: Date Functions

Lecture 4: Logical Operators

Lecture 5: NULL Data

Lecture 6: GROUP BY clause

Lecture 7: GROUP Functions

Lecture 8: HAVING clause

Chapter 6: DAY 6: Sub-Queries

Lecture 1: Sub-Queries in SELECT

Lecture 2: Sub-Queries in WHERE

Lecture 3: Sub-Queries in WHERE – ANY Operator

Lecture 4: Sub-Queries in WHERE – ALL Operator

Lecture 5: Sub-Queries using EXISTS Operator

Lecture 6: Sub-Queries in INSERT

Chapter 7: Conclusion

Lecture 1: Conclusion

Chapter 8: Bonus Exercises

Lecture 1: Exercise 1

Lecture 2: Exercise 2

Lecture 3: Exercise 3

Lecture 4: Exercise 4

Lecture 5: Exercise 5

Lecture 6: Exercise 6

Lecture 7: Exercise 7

Lecture 8: Exercise 8

Lecture 9: Exercise 9

Lecture 10: Exercise 10

Instructors

John Anthony
Architect, Analyst and Trainer

Rating Distribution

1 stars: 12 votes
2 stars: 19 votes
3 stars: 94 votes
4 stars: 228 votes
5 stars: 305 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!

Menu