SQL Basics

SQL Basics

Duration : 10 Hours

This course will easy-to-understand SQL instruction. It also provide the hands on the SQL statement. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the trainer will support everything covered in this course.

Course Features

Certificate Trainer: 10+ Years of IT Exp
24/7 Support Live Class Video Recording

1. Sql Basics
1.1 Introduction
1.2 What is A Database
1.3 What Does Relational Mean
1.4 An Example
1.5 SQL Statement
1.6 Naming Things
 
2. The SELECT Statement
2.1 Introduction
2.2 The FROM clause
2.3 Limiting The Result Set
2.4 WHERE clause
2.5 AND and OR Demo: AND and OR
2.6 More OperatorsDemo: Between
2.7 LIKE
2.8 Demo: LIKE
2.9 IN Demo: IN
2.10 IS and IS NOT
2.11 Demo: IS and IS NOT
 
3. Joins
3.1 Introduction
3.2 OrderBY
3.3 Demo: OrderBY
3.4 Set Functions
3.5 Demo: Set Functions
3.6 Qualifiers and Set Functions
3.7 Demo: Qualifiers and Set Functions
3.8 GROUP BY
3.9 Demo: GROUP BY
3.10 HAVING
3.11 Demo: HAVING
3.12 JOINS
3.13 Demo: JOINS
3.14 Summary
 
4. Adding, Changing & Removing data
4.1 Inroduction
4.2 INSERT
4.3 Demo: INSERT
4.4 Inserting Multiple Rows
4.5 UPDATE
4.6 Demo: UPDATE
4.7 DELETE
4.8 Demo: DELETE
4.9 Summary
 
5. Creating Tables
5.1 Introduction
5.2 CREATE TABLE example
5.3 NULL & NOT NULL
5.4 PRIMARY KEY & CONSTRAINT
5.5 ALTER TABLE
5.6 DROP TABLE
5.7 Demo: CREATE TABLE Summary

Good to have basic undestanding about database.

  1. Understand the concept of relational database
  2. Understand various SQL instruction, and where to use.
  3. Able towrite efficent query for better data fecth.
  • Understand the concept of relational database
  • Understand various SQL instruction, and where to use.
  • Able towrite efficent query for better data fecth.
 
a) Understand the concept of relational database
b) Understand various SQL instruction, and where to use.
c) Able towrite efficent query for better data fecth.

Registered Office:

Impecabble Research Lab

C-102, Bloom Tower,My World
    Baner, Pune, 411045
 +1.404.828.0450 (US)
 +91-7798188384 (India)
contact@irlabs.io
Contact Us