SQL Kursu : Sıfırdan Sektörün Yükseklerine | 2020

Whether you're a financial expert or risk manager in banking, or a senior software developer in a company, this course is designed for you! In today's business landscape, few organizations operate without a database. Databases are where we manage and store our valuable data. Therefore, robust data health relies on sound database design. Efficient data retrieval demands strong SQL skills. Gaps in either area can significantly hinder your ability to access and utilize information.

This course comprehensively addresses both of these critical needs, emphasizing sustainable practices. You've come to the right place to master SQL writing and/or database design.

This course assumes you have no prior database knowledge. Your destination is advanced, industry-leading techniques!

Course Content:

Fundamental Concepts

• Workshop 1 - Normalization-Focused Design: Learn the principles of database normalization for efficient data storage.

  • Demo: Translating Design to a Real Database: See how theoretical designs are implemented in a practical database environment.
  • Techniques for Examining Existing Databases: Develop skills to analyze and understand existing database structures.
  • Working with Computational Queries: Master complex query construction.
  • Working with OrderBy, And, Or, Not: Learn to refine query results with logical operators.
  • Working with Like, Between, In: Utilize pattern matching and range queries.
  • Working with Aggregate Functions: Extract meaningful insights from data using aggregation.
  • Working with String Functions: Manipulate and extract information from text data.
  • Working with GroupBy and Having: Perform data summarization and filtering.
  • Working with Join: Combine data from multiple tables.

• Workshop 2

• Workshop 3

• Workshop 4

• Workshop 5

Working with Queries That Modify Data

• Join-Focused Insert, Update, Delete: Learn to efficiently modify data within your database using joins.
• Reviewing Gaps with General Repetition: Reinforce key concepts and address any remaining knowledge gaps.
• Demo: Professional Design Example: Analyze a real-world database design.
• Demo: Translating Design into a Database: Witness the process of converting a design into a functional database.
• Working with Index Architecture: Optimize database performance with effective indexing strategies.

This course will equip you with the skills to become proficient in database management, SQL querying, and data design, regardless of your current role.