SQL Course Overview
This SQL certification course gives you all of the information you need to successfully start working with SQL databases and make use of the database in your applications. Learn how to correctly structure your database, author efficient SQL statements, and clauses, and manage your SQL database for scalable growth.
Skills Covered
Database and relationships
Query tools and SQL commands
Aggregate functions
Group by clause
Tables and joins
Subqueries
Data manipulation
Transaction control
Views and procedures
SQL Course Curriculum
Elgibility
This online SQL certification course is ideal for freshers, programmers, software developers, and testing professionals who want to learn SQL. It’s also ideal for marketing professionals and salespeople who want to better understand their company’s data.
- 1.1 Course Overview
- 2.1 Installation
- 3.1 Case study part one
- 3.2 Case study part two
-
4.1 CREATE
-
4.2 Exercise one Create DB and Table
-
4.3 INSERT
-
4.4 Import data from File
-
4.5 Exercise two Inserting and Importing
-
4.6 SELECT statement
-
4.7 SELECT DISTINCT
-
4.8 WHERE
-
4.9 Logical Operators
-
4.10 Exercise three SELECT and WHERE
-
4.11 UPDATE
-
4.12 DELETE
-
4.13 ALTER
-
4.14 Exercise four Updating Table
-
1 What is Ethical Hacking?
-
2 Why Ethical Hacking is Necessary
-
3 Scope and Limitations of Ethical Hacking
-
4 Skills of an Ethical Hacker
- 5.1 Restore and Back-up
- 5.2 Exercise five Restore and Back up
-
6.1 IN
-
6.2 BETWEEN
-
6.3 LIKE
-
6.4 Exercise six In Like and Between
-
7.1 Side Lecture Commenting in SQL
-
7.2 ORDER BY
-
7.3 LIMIT
-
7.4 Exercise 7 Sorting
- 8.1 AS
-
9.1 COUNT
-
9.2 SUM
-
9.3 AVERAGE
-
9.4 MIN and MAX
-
9.5 Exercise eight Aggregate functions
-
10.1 GROUP BY
-
10.2 HAVING
-
10.3 Exercise nine Group By
- 11.1 CASE WHEN
-
12.1 Introduction to Joins
-
12.2 Inner Join
-
12.3 Left Join
-
12.4 Right Join
-
12.5 Full Outer Join
-
12.6 Cross Join
-
12.7 Except
-
12.8 Union
-
12.9 Exercise ten Joins
-
13.1 Subqueries
-
13.2 Exercise eleven Subqueries
-
14.1 VIEWS
-
14.2 INDEX
-
14.3 Exercise tweleve Views
-
15.1 LENGTH
-
15.2 UPPER LOWER
-
15.3 REPLACE
-
15.4 TRIM, LTRIM, RTRIM
-
15.5 CONCATENATION
-
15.6 SUBSTRING
-
15.7 LIST AGGREGATION
-
15.8 Exercise thirteen String Functions
-
16.1 CEIL and FLOOR
-
16.2 RANDOM
-
16.3 SETSEED
-
16.4 ROUND
-
16.5 POWER
-
16.6 Exercise fourteen Mathematical Functions
-
17.1 CURRENT DATE and TIME
-
17.2 AGE
-
17.3 EXTRACT
-
17.4 Exercise fifteen Date-time functions
-
18.1 PATTERN MATCHING BASICS
-
18.2 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS)
-
18.3 Exercise sixteen Pattern Matching
-
19.1 Converting Numbers Date to String
-
19.2 Converting String to Numbers Date
- 20.1 User Access Control
-
21.1 Tablespace
-
21.2 PRIMARY KEY and FOREIGN KEY
-
22.1 EXPLAIN
-
22.2 Soft Delete vs Hard Delete
-
22.3 Update vs Case
-
22.4 VACCUM
-
22.5 Truncate vs Delete
-
22.6 STRING FUNCTIONS
-
22.7 JOINS
-
22.8 SCHEMAS
-
23.1 What is SQL
-
23.2 Tables and DBMS
-
23.3 Types of SQL commands
-
23.4 PostgreSQL