SQL Angeles는 SQL PASS의 공식 회원이며, LA Chapter 그룹으로 활동하는 데이터베이스(SQL Server) 스터디로 SQL 기초부터 DB 운영, 튜닝까지 학습하는 것을 목표로 운영되고있는 스터디 그룹입니다.

스터디 일정 및 장소 : https://www.facebook.com/groups/SQLAngeles/events/

회비 : $30 (Monthly) (Venmo : @SQLAngeles)

참여 조건 : 없음

참여 방법 : 운영진(카톡ID : sqlmvp)에게 참여 의사를 밝힌 후 회비 납부 및 참여

회칙 :

  • 회비는 스터디 운영에 사용 됩니다. (장소 사용료, 비품 구입 등)

 

Study Leader : Sungwook Kang

Facilitator : Sungwook Kang

 

Introducing SQL Server

  • Overview of the SQL Server suite of products
    • Fundamentals of the relational database engine
    • Benefits of the Business Intelligence stack
  • SQL Server components and tools
    • SQL Server Agent and Management Studio
    • Integration Services
    • Analysis Services
    • Reporting Services
    • Data Quality Services
    • Master Data Services

 

Query Basic

  • Exploring Database Concepts
  • Writing Simple SELECT Queries
  • Using Built-In Functions and Expressions
  • Joining Tables
  • Grouping and Summarizing Data
  • Building on Subqueries and Unions
  • Advanced WHERE Clauses

 

Query Advance

  • Building on Subqueries, Common Table Expressions, and Unions
  • Advanced Joining Tables
  • Advanced WHERE Clauses
  • Writing Advanced Queries

 

Administrator Database

  • Planning and Installing SQL Server
  • Configuring and Managing SQL Server Instances
  • Configuring SQL Server
  • Migrating, Importing, and Exporting
  • SQL Server Logins, Roles, and Users
  • Securing SQL Server
  • Mirroring and Replication
  • Clustering and AlwaysOn
  • Troubleshooting SQL Server
  • Indexes and Concurrency
  • SQL Server Agent, Backup, and Restore

 

Data Warehouse

  • Designing and Implementing a Data Warehouse
  • Designing and Implementing a Data Warehouse
  • Designing and Implementing a Data Warehouse
  • Managing and Maintaining SSIS Packages
  • Building Data Quality Solutions

 

Data Reporting

  • Installing Reporting Services
  • Building Basic Reports
  • Using Charts, Images, and Gauges
  • Using Maps and Spatial Data Types
  • Advanced Reporting
  • Integrating Reporting Services

 

Data Analysis

  • Business Intelligence
  • Server Integration Services
  • Data Quality Services
  • Master Data Services
  • Reporting Services
  • Creating Tabular Data Models with PowerPivot
  • Implementing an Analysis Services Tabular Data Model
  • Creating Data Visualizations with Power View
  • Using Cloud Technologies in a BI Solution

 

 

DB Modeling

  • Data Modeling Concepts
  • Creating and Managing Tables and Relations
  • Reverse Engineering
  • Managing SQL Scripts