Learn SQL in 6 days

Learn SQL and handle databases confidently
4.0 (55 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,254 students enrolled
Instructed by John Anthony Development / Databases
$30
Take This Course
  • Lectures 47
  • Contents Video: 3.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • No prior SQL knowledge is required

What am I going to get from this course?

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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
00:59

This lecture gives an overview of the course.

Section 2: DAY 1: Database Basics and Schema
03:44

This lecture will give a basic understanding of database concepts.

01:15

Tables are taught with a real time example in this lecture

03:20

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

02:10

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

03:11

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

08:01

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

Section 3: DAY 2 : Managing Database and Tables
01:35

Database creation is explained in this lecture with examples.

00:40

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

01:53

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

03:15

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

04:23

This lectures explains how to create a table.

01:35

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

02:14

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

01:35

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

02:53

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

00:53

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

Section 4: DAY 3: Populating Data
06:30

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

10:50

This lecture explains how to insert data into a table.

01:49

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

01:21

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

02:08

This lecture explains arithmatic operators and expressions using MySQL

01:24

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

01:22

This lecture talks about Logical Operators and operator preceidence.

08:17

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

04:39

This lecture explains how to delete data from a table.

Section 5: DAY 4: Retrieving Data
02:41

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

02:21

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

01:19

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

03:09

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

03:38

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

05:06

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

Section 6: DAY 5: Functions and Creating Sub-totals
22:54

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

13:02

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

08:01

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

07:09

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

02:07

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.

04:12

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

08:48

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

04:35

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

Section 7: DAY 6: Sub-Queries
11:09

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.

10:07

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

04:31

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

04:53

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

04:42

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

01:59

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

Section 8: Conclusion
00:37

This lecture gives the concluding remarks for this course.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

John Anthony, 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.

Ready to start learning?
Take This Course