My SQL Course

My SQL Syallbus

Introduction to SQL

What is SQL?
Purpose of SQL
What are the subsets of SQL? Data Definition Language
Data Manipulation Language
Data Control Language
SQL vs. NoSQL

Introduction to Databases and RDMBS

What is a Database?
Database Objects
Database Tables
Table Records
Types of Database Management Systems
Relational Database Management Systems
SQL/Relational Databases vs. No SQL Databases

Install a Database Engine

Download MS SQL Server or Oracle or MySQL Database Engine
Install. Launch SQL Server Management Studio
Select New Query
launch SQL Query
Type SQL Commands and Execute.

SQL Syntax

Focus on SQL Syntax
SQL keywords
SQL is not case sensitive
SQL Comments
SQL Commands
writing SQL Statements.

SQL Data Types

SQL Numeric data types
Date and Time data types
Character and String data types
Unicode character string data types
Binary data types
Miscellaneous data types.

SQL Operators

SQL Arithmetic Operators
Comparison Operators
Logical Operators
and Bitwise Operators

SQL Clauses

Clauses in SQL are similar to conditionals in high-level languages. We have a large variety in the SQL clauses like the Where clause, Union Clase, Order By clause, etc.

SQL Joins

The SQL Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.

SQL Views

Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database.

SQL Expressions

SQL Boolean Expression
SQL Numeric Expression
SQL Date Expression

SQL Comments

SQL Comments, Comments are used to explain sections of SQL statements
to prevent the execution of SQL statements. Single-Line Comments
Multi-line Comments

Data Definition Language Commands and Operations.

SQL Data Definition Language Commands
Create Alter
Drop Truncate and Rename Data Definition Language Operations
Create a Database Use Database
Rename a Database
Drop Database
Create a Table Rename Table
Add a Column to exiting Table
Add multiple columns to existing Table
Modify an existing column, Rename a Column
Drop a Column
Truncate a Table
Drop a Table

Data Manipulation Language Commands and Operations

Data Manipulation Language Operations
Retrieving data from a table
Inserting data into a table
Updating existing data into a table
Deleting all records from a table.

Data Control Language Commands

- DCL includes commands such as GRANT and REVOKE which mainly deal with the rights
- permissions
- other controls of the database system.

SQL Functions

- SQL has many built-in functions for performing calculations on data
- SQL Aggregate Functions
- SQL String Functions
- SQL Date Functions SQL Scalar functions.

SQL Queries and Sub Queries

- A Query is used to traverse over some data that may be of small or large quantity to find the needed information.
  A Subquery is a type of query which is written inside another query. A subquery becomes a part of a larger query. A subquery is also called INNER QUERY OR NESTED QUERY.

SQL Indexes

- An index is a schema object. It is used by the server to speed up the retrieval of rows by using a pointer. It can reduce disk I/O(input/output) by using a rapid path access method to locate data quickly.

SQL Injection

- SQL injection, also known as SQLI, is a common attack vector that uses malicious SQL code for backend database manipulation to access information that was not intended to be displayed. This information may include any number of items, including sensitive company data, user lists, or private customer details.

In the last 12 hours, 10 learners have onboarded with us

C Programming Course Schedule

Day Range	Topic
Day 1-4	Introduction and Basics Control Flow and Loops Functions Arrays Pointers and Strings
Day 5-8	Structures and Unions File Handling Preprocessor Directives
Day 9-12	Dynamic Memory Allocation Linked Lists Stacks Queues
Day 13-16	Trees Graphs Hashing Sorting Algorithms
Day 17-20	Searching Algorithms Advanced Topics in C Review and Practice
Day 21-24	Comprehensive Review Real-world Applications
Day 25-28	Project Planning and Execution
Day 29-30	Final Assessment and Certification

Investigate MySQL Database Administration courses to find out more about how database administrators and developers can master complex features and operations.