SQL Certification Course
Structured query language (SQL) is a programming language for storing and processing information in a relational database. A relational database stores information in tabular form, with rows and columns representing different data attributes and the various relationships between the data values. You can use SQL statements to store, update, remove, search, and retrieve information from the database
FREE
/CourseBundles(41907)/2867258-Untitled_design.png)
Course Overview
Schedule of Classes
Course Curriculum
1 Subject
SQL Certification Course
1 Exercises • 28 Learning Materials
Module 1
SQL Intoduction
History and Architecture of SQL
SQL commands
RDBMS
Constraints and Normal Forms
Module 2
MY SQL
MS SQL Server
Oracle
Ms Access
Various Syntaxes in SQL
Module 3
SQL Datatypes
Operators in SQL
SQL Expression
Creating and Dropping Databases
Creating Tables Using SQL Commands
Populating One Table Using Another Table
Module 4
SQL AND, OR Operators
Like Clause
Top Clause
Order By and Group By Clause
SQL Distinct Keyword
Activity 1 : Joining two datasets together, and merging columns together to get rid of nulls.
Joining two datasets together and merging columns together to get rid of nulls
Activity 2: Replacing NULL and blank values in Microsoft SQL Server
Replacing NULL and blank values in Microsoft SQL Server
Activity 3: Retrieving the last row for each group in a table in SQL
Retrieving the last row for each group in a table in SQL
Activity 4: Creating a rolling total over the last 3 months in SQL
Creating a rolling total over the last 3 months in SQL
Activity 5: Remove duplicate rows in SQL Server (three different ways)
Remove duplicate rows in SQL Server (three different ways)
Activity 6: Combine Date and Time fields in SQL Server into one column
Combine Date and Time fields in SQL Server into one column
Activity Submissions
SQL Certification Submission
Wallmart Project
Project - Wallmart
Course Instructor
/1767938-32_-_32_PNG.png)
EDUREPUBLIC
249 Courses • 347950 Students
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy