What is the focus of this course?

This course gives you all the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn to correctly structure your database, author efficient SQL statements and clauses, and manage your SQL database for scalable growth.

What are the course objectives?

• Understand Databases & Relationships
• Use Common Query Tools and work with SQL commands
• Understanding Transactions, create Tables and Views
• Comprehend and Execute Stored Procedures

Who should take this course?

• Freshers, Programmers, Software Developers, Testing professionals who want to learn SQL
• Marketing, Sales people who want to understand their company data better

What is the prerequisite for this course?

There are no prerequisite for the course. This course can be taken up by anyone who wants to learn SQL.

Course Preview 

Lesson 1 - Relational Databases

• 1.1 What are Databases?
• 1.2 What's the Role of Databases in Application Programming?
• 1.3 Tables and Relations
• 1.4 Primary and Foreign Keys and Other Constraints

Lesson 2 - SQL Querying

• 2.1 What is Querying?
• 2.2 The ANSI SQL Standard
• 2.3 DML, DDL and More
• 2.4 Common Query Tools

Lesson 3 - Your First Queries

• 3.1 The SELECT Statement
• 3.2 Limiting Output Columns
• 3.3 Formatting and Sorting Output
• 3.4 Column Aliases

Lesson 4 - Filtering Your Results

• 4.1 The WHERE Clause
• 4.2 Creating a Filter Condition
• 4.3 Applying Multiple Filter Conditions
• 4.4 More Filter Options

Lesson 5 - Consolidating Your Data

• 5.1 Counting Records
• 5.2 Common Aggregate Functions: SUM, AVG, MIN, MAX
• 5.3 Do's and Dont's When Consolidating
• 5.4 Unions and Other Multiset Consolidations

Lesson 6 - Grouping Your Data2

• 6.1 The GROUP BY Clause
• 6.2 The HAVING Clause
• 6.3 Do's and Dont's When Grouping

Lesson 7 - Joining Tables

• 7.1 Table Aliases
• 7.2 Inner Joins
• 7.3 Outer Joins
• 7.4 Self Joins
• 7.5 Complex Multi Table Joins

Lesson 8 - Subqueries

• 8.1 Filtering Using Subqueries
• 8.2 The EXISTS Clause
• 8.3 Subqueries as Alternative to Joins
• 8.4 Derived Tables

Lesson 9 - Manipulating Your Data

• 9.1 The INSERT Statement
• 9.2 The UPDATE Statement
• 9.3 The DELETE Statement

Lesson 10 - Transaction Control

• 10.1 What are Transactions
• 10.2 Initiating a Transaction
• 10.3 The COMMIT and ROLLBACK Commands

Lesson 11 - Creating Database Objects And Adding Business Logic

• 11.1 Creating Tables
• 11.2 Creating and Using Views
• 11.3 Developing and Calling Stored Procedures
• 11.4 Implementing Triggers