Learn SQL in 6 days
4.0 (69 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.
1,288 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL in 6 days to your Wishlist.

Add to Wishlist

Learn SQL in 6 days

Learn SQL and handle databases confidently
4.0 (69 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.
1,288 students enrolled
Created by John Anthony
Last updated 8/2015
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • The primary objective is to make the individual utilizing this tutorial an expert in writing data retrieval statements.
View Curriculum
Requirements
  • No prior SQL knowledge is required
Description

"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

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

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

Who is the target audience?
  • "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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
46 Lectures
03:27:57
+
DAY 1: Database Basics and Schema
6 Lectures 21:41

This lecture will give a basic understanding of database concepts.

Preview 03:44

Tables are taught with a real time example in this lecture

Tables
01:15

This lecture talks about how real time data can be split in multiple tables.

Set of Tables
03:20

In relational database world, tables are connected and data is referred by using primary keys and foreign keys. This lecture explains these concepts with examples

Primary and Foreign Key
02:10

This lecture talks about the basic data types which are commonly used in real-time databases.

Data Types
03:11

Defines how data can be represented in database with an example.

Schema
08:01
+
DAY 2 : Managing Database and Tables
10 Lectures 20:56

Database creation is explained in this lecture with examples.

Database Creation
01:35

This lecture explains the participant on how to find all the databases that exists in the RDMS,

Show Database
00:40

This lecture explains the user on how to delete a database which already exists.

Drop Database
01:53

This lecture talks about the data types that are commonly used in MySQL.

Data Types
03:15

This lectures explains how to create a table.

Create Table
04:23

This lecture explains how to see the structure of a table.

Describe Table
01:35

This lecture explains how to modify the table structure and its fields.

Preview 02:14

This lecture explains how to delete a table which already exists.

Delete Table
01:35

This lecture explains how to create a primary key with an example.

Create Foreign Key
02:53

This lecture explains how to create a foreign key with examples.

Create Primary Key
00:53
+
DAY 3: Populating Data
9 Lectures 38:20

This lecture explains how to create a database and tables in it with the help of MySQL

Setting up Database and Tables
06:30

This lecture explains how to insert data into a table.

Add Data to table
10:50

This lecture explains the purpose and how to include WHERE clause in an SQL statement.

WHERE Clause
01:49

This lecture gives examples of WHERE clause statements to make the user understand how to write conditional statements.

WHERE Clause examples
01:21

This lecture explains arithmatic operators and expressions using MySQL

Arithmetic Operators and Expressions
02:08

This lecture explains the user on how to write simple conditional statements.

Comparison Operators and Simple Condition
01:24

This lecture talks about Logical Operators and operator preceidence.

Logical Operators and Operator Precedence
01:22

This lecture explains how to update table data using SQL Statements.

Update Table Data
08:17

This lecture explains how to delete data from a table.

Delete Data from Table
04:39
+
DAY 4: Retrieving Data
6 Lectures 18:14

This lecture explains how to write a simple SQL retrival query.

Simple Select
02:41

This lecture explains how to change the column header in the output created by an SQL statement.

Change Column Header
02:21

This lecture explains how to retrieve only selected fields from table and display the result using SQL.

Select Specific Columns
01:19

This lecture explains how to select unique rows from the table data.

Select Distinct Columns
03:09

This lecture explains how to sort the output of an SQL query as per the user requirement.

Sorting the Data
03:38

This lecture explains how to retrieve data from multiple tables as per the user requirement.

Retrieve Data from Multiple Tables
05:06
+
DAY 5: Functions and Creating Sub-totals
8 Lectures 01:10:48

This lecture explains the application of string functions with the help of MySQL functions.

String Functions
22:54

This lecture explains some of the mathematical functions which are commonly used in writting SQL statements.

Mathematical Functions
13:02

This lecture explains some of the commonly used date functions using MySQL Date Functions.

Date Functions
08:01

This lecture explains some commonly used logical operators and how those operators can be used in SQL statements.

Logical Operators
07:09

NULL is a special data type and it works in a specified manner. The concept of NULL and its usage is explained in this lecture.

NULL Data
02:07

This lecture explains how to group the output data retrieved by an SQL query.

GROUP BY clause
04:12

This lecture explains the functions that are used in SQLs with GROUP BY Cluase.

GROUP Functions
08:48

Data retreived by GROUP BY Clause can further be filtered using the HAVING Clause. The HAVING clause is explained in this lecture.

HAVING clause
04:35
+
DAY 6: Sub-Queries
6 Lectures 37:21

Some times the data retrieved by an SQL statement can be filtered using one more query. Query within a query is a sub-query. The Sub-queries are usually used in WHERE clauses, This lecture aims at explaining the concept of Sub-queries.

Sub-Queries in SELECT
11:09

This lecture aims at explaining how to use a sub-queries within WHERE clause.

Sub-Queries in WHERE
10:07

This lecture aims at explaining the usage of ANY operator in Sub-queries.

Sub-Queries in WHERE - ANY Operator
04:31

This lecture aims at explaining the usage of ALL operator in Sub-queries.

Preview 04:53

EXISTS is a special operator. This lecture aims at explaining the user on how to use the EXISTS operator in Sub-queries.

Sub-Queries using EXISTS Operator
04:42

This lecture aims at explaining the user on how to used Sub-queries in INSERT statements.

Sub-Queries in INSERT
01:59
+
Conclusion
1 Lecture 00:37

This lecture gives the concluding remarks for this course.

Conclusion
00:37
Frequently Bought Together
About the Instructor
John Anthony
4.0 Average rating
76 Reviews
1,822 Students
2 Courses
Architect, Analyst and Trainer

John Anthony has a Masters in Computer Application with around 20 years of experience in the industry. The instructor has worked on real time projects in India and USA and has successfully designed, developed projects for clients in India as well as Abroad. Also, he has life-time experience on small, medium as well as large size projects.

As an entrepreneur John Anthony has managed IT businesses for around two decades. During his tenure as an entrepreneur, he has worked with highly qualified finance professionals and made important financial decisions to foster business growth.