Course details

Learn SQL language from scratch, the easy way, is designed to give a detailed introduction to using and understanding structured query language (SQL) for manipulating business data. This is the second part of a 2 parts course which covers the following topics:

- More ways of getting data from multiple tables

- Common SQL Functions

- Transactions

- Data Definitions

- Relational Data

- Indexes

- Tools for working with SQL

- Pointers

- Data Normalization

3 Remaining chapters will be uploaded in the following couple of days.

For the most part, the SQL learned in the course is applicable to all major databases. In the few cases in which there are differences between the databases, these differences will be pointed out. There are 2 sample databases provided with this course. SQLMain is used throughout the demonstrations. The second one is a Microsoft developed sample database that you can have fun with after you finish the course. Besides the video tutorials and sample databases, this course includes a 186 pages pdf book about SQL that I have written. Some of the concepts covered in the book will be demonstrated in this course, leaving the remaining ones to be presented in part 2 of the course which is still under development. I myself started learning on my own with no mentor and no place where to get the exact information that I needed. This is one of the reasons this course is structured in such a way that you can start writing SQL code in hours with ease. I recommend taking one lecture once every 2 or 3 days. This way you will have time to get used with the terminology and also have time to practice what you learned on your own. This course is not going to make you a SQL guru overnight. It takes practice and patience to get there. Let's get started and learn SQL language together. The easy way.

Updated on 30 December, 2017
Courses you can instantly connect with... Do an online course on Database Management starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or