Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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
• Data Definitions
• Relational Data
• Tools for working with SQL
• Data Normalization
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. 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.
Good to know:
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Joining Multiple Tables-Details|
|Section 2: Common SQL Functions|
|Section 3: Transactions|
|Section 4: Data Definitions|
|Section 5: Understanding Relational Data|
RELATIONAL DATA OVERVIEW
DEFAULT CONSTRAINTS-NOT NULL CONSTRAINTS
|Section 6: Indexes|
BENEFITS AND CAVEATS
|Section 7: Tools For Working With SQL|
MS SQL SERVER MANAGEMENT STUDIO
I am a young but experienced and highly passionate BI Reporting Specialist and Database Developer,writer and founder of EasyWaySQL and MyCar mobile app.
I also have a Bachelor's degree in Business Administration and a Master's degree in Economic Decision Support Systems.
Other than that I am dedicated to share my knowledge with others and learn new technologies on the way.