Techcareer.net SQL Bootcamp Training Applications

This repository contains the ms sql applications that I have made in the Techcareer.net SQL Bootcamp training program that I have joined.

First Week

What I learned in the first week of training?

What is data, What is SQL, Why is querying, Relational and non-relational databases, DDL, DML, DCL concepts, Creating a database on SQL Server Management Studio, Database design, Loading database, Transferring the data in the tables in the database to excel, Excel Transferring data from the database to the empty tables in the database, SQL SELECT clause and sample applications in the northwind database, SQL LIKE operator and example applications in the northwind database, the use of wildcards with the LIKE operator, SQL is null and is not null usage, Normalization rules in SQL, Table relationships in the Northwind Database

Second Week

What I learned in the second week of training?

Implementations of One-to-Many - Many-to-Many and One-to-One relationships on MSSQL Server, Defining Constraints on the data in the table and editing the data entries, Defining Check Constraint, Defining Unique Constraints, Primary Key and Foreign Key concepts, Application of different conditions and priority with AND-OR terms, What is Alias and how to use it, SQL TOP Command, SQL Order By Command and sorting, What is Functions, Function types such as Built-In Functions, String Functions, Aggregate Functions, Math Functions, Convert Functions and Date Functions, IIF, Case-When Structure, Case-When types such as Simple Case-When and Searched Case-When

Third Week

What I learned in the third week of training?

DML commands (create, update, delete), T-SQL Programming Basic, Relational data query - Join concept, Example join applications in SQL, Answering homework questions, Join sample apps, SQL Group By and sample applications, SQL Having clause, Subquery concept and applications, Union and Union All concepts and applications, SQL View object, DDL commands (View creation, View update and View deletion)

Fourth Week

What I learned in the fourth week of training?

View applications, What is Stored Procedure? Why do we use Stored Procedure? AD-HOC Query, Stored Procedure applications, Week 3 Homework Question Solutions, What are Functions, Basic Structure of Functions, Cursor structure-functions and usage, Some query techniques, Sorting functions, Trigger structure-use and sample applications

12.12.2022 Lecture

What did I learn on the last day of training?

Index Concept, Transactions