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.
• In-depth coverage of SQL fundamentals
• Covers all of the important query tools and SQL commands
• Industry-recognized course completion certificate
• Lifetime access to self-paced learning
Share on:
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
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 twelve 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
From: $14.99 / month
You Will Get Certification After Completetion This Course.
-
-
-
-