This course is all about creating the tables, applying the constraints and establishing the relationship among the tables, it also covers basics related to keys, indexes, views along with other essential topics. Most critical of the lot includes designing queries for information retrieval and joins.
It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.
You can learn it at your own pace, if you are determined you can complete this in a Day as well.
This course is apt for you if you are an absolute beginner to SQL or you may want to fine tune your SQL foundations. It is structured in a step by step manner which will help you understand even the tough topics through simplified examples.
Step by step Installation guide for MySQL (Windows).
Explains the key terms like database, schema and key components of DBMS.
Demonstrates how to get started with MySQL workbench, database creation along with sample table creation, insertion and query.
Explains how to use the insert command to insert data into the table.
Explains how select command could be used in conjunction with insert to insert multiple records at one go.
Explains the usage of where clause in the query.
Explains how to use order by with the query.
Demonstrates query processing sequence from query designer perspective.
Explains about update command usage.
Explains how to use the delete command.
Explains what is a primary key, unique, not null and check constraints.
Explains foreign key constraint and its usage.
Explains how to set auto increment for an identity column.
Explains about designing tables for cardinality
Explains how to apply constraints over multiple columns. It distinguishes column constraints and table constraints.
Explains the terms
Explains about aggregate functions.
Explains how to use group by clause in query.
Explains how to filter groups with having clause in the query.
Fine tunes query oriented thinking.
Explains what is join.
Explains how to inner and outer joins.
Explains the usage of sub queries.
Explains how to use Alter command to add, modify and drop a column for an existing table.
Explains the significance of views and teaches how to create view using CREATE VIEW command and query the view.
Explains what is an Index and demonstrates the following,
Explains how to begin a transaction and perform commit and rollback operations along with save points concept.
Sagar an M.Tech graduate from ANU a passionate application developer and a trainer apart from being a good learner and a listener, started his career as a trainer and later he was part of design and development of several software projects and products. Earned his reputation as a hard core Java developer and Systems Integration Specialist and was instrumental in success of several projects with his technical, leadership and mentoring skills.