All Projects → elvanselvano → algorithm-bootcamp-sql

elvanselvano / algorithm-bootcamp-sql

Licence: other
Teaching materials for Algorithm Bootcamp: Database Systems.

Programming Languages

Jupyter Notebook
11667 projects
TSQL
950 projects

Projects that are alternatives of or similar to algorithm-bootcamp-sql

dbaTDPMon
dbaTDPMon - Troubleshoot Database Performance and Monitoring
Stars: ✭ 20 (+11.11%)
Mutual labels:  sql-server
mssql-restapi
A simple REST API for SQL Server, Azure SQL DB and Azure SQL DW using SMO on .NET Core 2.0
Stars: ✭ 33 (+83.33%)
Mutual labels:  sql-server
GeoJSON.Net.Contrib
Repository for all GeoJSON.Net *.Contrib projects
Stars: ✭ 31 (+72.22%)
Mutual labels:  sql-server
sql-source-control
Simple CLI for getting SQL into source control systems.
Stars: ✭ 49 (+172.22%)
Mutual labels:  sql-server
bcpandas
High-level wrapper around BCP for high performance data transfers between pandas and SQL Server. No knowledge of BCP required!!
Stars: ✭ 69 (+283.33%)
Mutual labels:  sql-server
SqlServer.Rules
SQL Server static code analysis rules for SSDT database projects
Stars: ✭ 20 (+11.11%)
Mutual labels:  sql-server
ngorm
Neo GORM: The modern fork of gorm The fantastic ORM( Object Relational Mapper ) for Go
Stars: ✭ 37 (+105.56%)
Mutual labels:  sql-server
N-Tier-Architecture
This is a n-layer architecture based on Common web application architectures.
Stars: ✭ 105 (+483.33%)
Mutual labels:  sql-server
myTickle
📅 A PowerShell and SQL Server-based reminder system
Stars: ✭ 20 (+11.11%)
Mutual labels:  sql-server
xelogstash
Send SQL Server Extended Events to Logstash, Elastic Search, or JSON
Stars: ✭ 22 (+22.22%)
Mutual labels:  sql-server
Rebus.SqlServer
🚌 Microsoft SQL Server transport and persistence for Rebus
Stars: ✭ 35 (+94.44%)
Mutual labels:  sql-server
GraphQL.RepoDB
A set of extensions for working with HotChocolate GraphQL and Database access with micro-orms such as RepoDb (or Dapper). This extension pack provides access to key elements such as Selections/Projections, Sort arguments, & Paging arguments in a significantly simplified facade so this logic can be leveraged in the Serivces/Repositories that enca…
Stars: ✭ 25 (+38.89%)
Mutual labels:  sql-server
SimpleSqlExec
Lightweight command-line utility to execute queries on SQL Server in place of SQLCMD
Stars: ✭ 20 (+11.11%)
Mutual labels:  sql-server
plant erd
ERD exporter with PlantUML and mermaid format
Stars: ✭ 126 (+600%)
Mutual labels:  erd
Peasy.NET-Samples
Showcases a middle tier built with peasy and consumed by multiple client consumers
Stars: ✭ 33 (+83.33%)
Mutual labels:  sql-server
uzbekistan-regions-data
Full Database of regions Uzbekistan available in JSON, SQL & CSV Format All Regions, Districts & Quarters with Latin, Cyrillic and Russian versions. (Районы (туманы) Республики Узбекистан и Города областного (республиканского) подчинения)
Stars: ✭ 46 (+155.56%)
Mutual labels:  sql-server
ksqlDB.RestApi.Client-DotNet
ksqlDb.RestApi.Client is a C# LINQ-enabled client API for issuing and consuming ksqlDB push queries and executing statements. SqlServer.Connector is a client API for consuming row-level table changes (CDC - Change Data Capture) from Sql Server databases with the Debezium connector streaming platform.
Stars: ✭ 44 (+144.44%)
Mutual labels:  sql-server
sql server
Development repository for the sql_server cookbook
Stars: ✭ 60 (+233.33%)
Mutual labels:  sql-server
StoreCleanArchitecture-NET
This is a basic project to demonstrate an introduction about the implementation of Clean Architecture on .NET
Stars: ✭ 19 (+5.56%)
Mutual labels:  sql-server
sync-client
SyncProxy javascript client with support for all major embedded databases (IndexedDB, SQLite, WebSQL, LokiJS...)
Stars: ✭ 30 (+66.67%)
Mutual labels:  sql-server

Database Systems

Header

Materials

Materials Topics Code
Database Environment ERD Referential Integrity SQL Server Environment 00_introduction.sql
Data Manipulation I CRUD Constraint Begin Tran Order By 01_data_manipulation_1.sql
Data Manipulation II Aggregate Functions Grouping String Date 02_data_manipulation_2.sql
Data Manipulation III Join Set Operator 03_data_manipulation_3.sql
Advanced SQL I Subquery In and Exists Any, Some, All 05_advanced_sql_1.sql
Advanced SQL II Views Stored Procedure Trigger Function 06_advanced_sql_2.sql
Normalization and ERD Modelling Normalization ER Modelling -

Databases

All of the Databases and ERD are taken from Software Laboratory Center: BINUS University.

Reading Materials

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].