SQL
Structured Query Language, abbreviated SQL , sometimes “continuation” for historical reasons), is a domain-specific language used in programming and designed to manage data stored in a management system relational databases (RDBMS) or for flow processing in a relational data flow management system (RDSMS).
It is particularly useful when working with structured data, i.e. data involving relationships between entities and variables. SQL offers two main advantages over older read/write APIs such as ISAM or VSAM.
Firstly, it introduced the concept of accessing many records with a single command. Second, it eliminates the need to specify how to reach the record, e.g. with or without an index. Originally based on relational algebra and tuple relational calculus.
Types of SQL
SQL consists of many types of statements, which can be informally classified as sub-languages, commonly: Data Query Language (DQL) and Data Definition Language (DDL), data control language (DCL) and data manipulation language (DML). The scope of SQL includes data queries, data manipulation (inserts, updates, and deletes), data definition (schema creation, and modification), and data access control. Although SQL is essentially a declarative language (4GL), it also contains procedural elements.
- Overview of SQL Server
- Row Ordering – ORDER BY
- WHERE Clause – Comparison Operators
- Pattern Matching – Part 2
- Introduction to Aggregate Functions
- Outer Joins
- Set Operator Precedence
- Introduction to Window Functions
- CREATE TABLE Challenges
- Introduction to Indexes
- CREATE VIEW Statement
- Mac OS – How to set up SQL Server Database on a Mac Computer using Docker
- Solutions to the SELECT Challenges
- SELECT DISTINCT Statement
- SELECT DISTINCT Challenges
- Solutions to the SELECT DISTINCT Challenges
- Filtering Data with TOP
- ORDER BY Challenges
- Solutions to the ORDER BY Challenges
- WHERE Clause – Three-valued Logic
- Replacing Nulls in Queries
- WHERE Clause Challenges
- Solutions to the WHERE Clause Challenges
- Introduction to Collations and Pattern Matching
- Introduction to Character Data Types
- Pattern Matching Challenges
- Solutions to the Pattern Matching Challenges
- GROUP BY and Aggregate Functions
- HAVING Clause
- Logical Query Processing Order
- GROUP BY Challenges
- Solutions to the GROUP BY Challenges
- AND operator
- OR operator
- Operator Precedence
- IN Operator
- Logical Operator Challenges
- Solutions to the Logical Operator Challenges
- LEFT OUTER JOIN and RIGHT OUTER JOIN
- FULL OUTER JOIN
- Integrity Constraints
- Many-to-many Relationships
- Join Challenges
- Solutions to the Join Challenges
- Composite Joins – Joining on multiple columns
- Joining more than two tables
- Predicate placement – ON clause vs WHERE clause
- Self-referencing Joins
- Cross Joins
- Advanced Join Challenges
- Solutions to the Advanced Join Challenges
- UNION and UNION ALL
- INTERSECT
- EXCEPT
- SET Operator Challenges
- Solutions to the Set Operator Challenges
- Self-contained Subqueries
- EXISTS
- Common Table Expressions
- Avoiding the NOT IN trap
- Subquery Challenges
- Solutions to the Subquery Challenges
- Concatenation in SQL Server
- String Manipulation Functions
- Date and Time Functions
- Function Challenges
- Solutions to the Function Challenges
- CASE Expression
- CASE Expression Challenges
- Solutions to the CASE Expression Challenges
- Overview of Data Types
- DECIMAL Data Type
- FLOAT Data Type
- CREATE TABLE Statement
- INSERT Statement
- Solutions to the CREATE TABLE Challenges
- UNIQUEIDENTIFIER (GUID) Data Type
- UPDATE Statement
- DELETE Statement
- TRUNCATE TABLE statement
- DROP TABLE Statement
- Stored Procedures
- Stored Procedures Demo
- Stored Procedure Challenges
- Solutions to the Stored Procedure Challenges
- ALTER TABLE Statement and sp_rename
- ALTER TABLE Challenges
- Solutions to the ALTER TABLE Challenges
- UNIQUE Constraints
- CHECK Constraints
- Index Types and Indexing Guidelines
- Index Types Part 2 – Composite vs Included Columns
- Indexing and Sargable Query Challenges
- Solutions to the Indexing and Sargable Query Challenges
- Functional Dependencies
- Functional Dependencies Exercise
- Candidate Keys and Super Keys
- First Normal Form
- Restructuring Multi-valued and Multi-type fields
- Second Normal Form
- Third Normal Form
- Boyce Codd Normal Form
SQL Course Details
SQL Course
- Rs 15,000/-
- Course Duration 1 Month
- Online Session
- On Campus Lecture + Practical
- Video Lecture Available
- Urdu & English
- 24/7 Support
Fee: 15,000
Duration: 1 Month
Timing: 9AM-11AM, 11AM-1PM, 1PM-3PM, 3PM-5PM, 5PM-7PM, 7PM-9PM
