What you'll learn
- The primary objective is to make the individual utilizing this tutorial an expert in writing data retrieval statements.
Course content
- Preview03:44
- 01:15Tables
- 03:20Set of Tables
- 02:10Primary and Foreign Key
- 03:11Data Types
- 08:01Schema
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 this course is 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.
Instructor
![John Anthony](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.0 Instructor Rating
- 309 Reviews
- 2,532 Students
- 2 Courses
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.