Skip to main content
SightSpectrum Learning
SQL
0%
Previous
Course data
General
Announcements
Week-1
Understanding the basics of databases and their role in information management.
Introduction to relational databases and their key components.
Overview of SQL and its relevance in database management.
Assessment-Overview of SQL and its relevance in database management.
Setting up a development environment for SQL.
Week-2
Retrieve data from a single table using SELECT statements
Assessment--Retrieve data from a single table using SELECT statements
-Filtering data using the WHERE clause and comparison operators
Assessment-(-Filtering data using the WHERE clause and comparison operators)
Sorting data using the ORDER BY clause
Assessment-(Sorting data using the ORDER BY clause)
"-Inserting new records into a table using the INSERT statement "
Assessment-("-Inserting new records into a table using the INSERT statement ")
Modifying existing data with the UPDATE statement
Assessment-(-Modifying existing data with the UPDATE statement)
Week-3
Creating tables with the CREATE TABLE statement.
Assessment--Creating tables with the CREATE TABLE statement
Specifying column data types, constraints, and primary keys.
Assessment-(-Specifying column data types, constraints, and primary keys)
Modifying table structure using the ALTER TABLE statement.
Assessment(-Modifying table structure using the ALTER TABLE statement)
Dropping tables from the database with the DROP TABLE statement.
Assessment(-Dropping tables from the database with the DROP TABLE statement)
Week-4
Understanding table relationships: one-to-one, one-to-many, and many-to-many.
Assessment(-Understanding table relationships: one-to-one, one-to-many, and many-to-many)
Establishing relationships using primary and foreign keys.
Writing JOIN statements to retrieve data from multiple tables.
Performing inner, outer, and cross joins.
Assessment(-Establishing relationships using primary and foreign keys)
Assessment("-Writing JOIN statements to retrieve data from multiple tables ")
Week-5
Aggregating data using functions such as COUNT, SUM, AVG, MIN, and MAX.
Grouping data with the GROUP BY clause.
Filtering grouped data using the HAVING clause.
Subqueries: using queries within queries.
Working with SQL functions and expressions.
Week-6
Database normalization: reducing redundancy and improving data integrity.
Applying best practices in SQL coding.
Database security considerations.
Introduction to database administration tasks.
Reviewing and summarizing the key concepts covered throughout the course.
Next
SightSpectrum Learning
Side panel
Categories
All categories
Technical Courses
Online Assessment
Mandatory
Soft Skill
Feedback
Corporate Security Policy
Student Enhancement
Home
Log in
Username
Username
Password
Password
Forgot your password?
Log in
SightSpectrum Learning
Categories
Collapse
Expand
All categories
Technical Courses
Online Assessment
Mandatory
Soft Skill
Feedback
Corporate Security Policy
Student Enhancement
Home
Course info
SQL
Teacher:
admin admin
Skill Level
:
Beginner