Linux, HTML, CSS, JS, Python, SQL, PHP, GO, Git, Algorithm and much more ...

数据库是一切数据存储的基础。SQL是操作数据库的基础语言。

第四期：Brentwood Coding SQL 数据库课程 王宁博士（Kevin）主讲

欢迎广大对编程，数据库，IT感兴趣的爱好者参加。未注册过的新学员，请访问 brentwoodcoding.ddns.net，点击右上角的register尽早注册。位置有限。

SQL课程。共6次课。3月25日开课。每周日下午2：15--3：15。每人$30的费用。

教室：BRENTWOOD Baptist Church 2004 B 教室。

谢谢大家！希望大家都将有所收获。Remember, coding is fun! And it can help you in your life and work.

Introduction to SQL

Course Requirements

There are no pre requisites. Anyone over the age of 13 is welcome to join this course. It is recommended though that individuals have some basic computer programming knowledge.

Course Description

Structured query language (SQL) is the language of databases. Whether you run reports or provide a dynamic website, you need to know SQL to add, delete, edit and view records. Databases organize and collect your data, and the SQL language is the liaison between you and the data. The role of database administrator includes several functions that you should know. You should know how to create and design tables, manipulate your data and run reports, create small programs and use more advanced concepts.

Whether you're new to database administration or want to create customized, personal reports for your online business, this course shows you how to get started and helps you understand the SQL language from the ground up.

Course Topics

  1. Relational Database(RDBMS)

    • Logical Table model
    • SQL statement
    • Access database
    • Basic Data Types
    • Normalization
    • Understanding Indexes
    • Database Schemas

  2. Writing Simple SELECT Queries

    • Using the SELECT Statement
    • Selecting a Literal Value
    • Retrieving from a Table
    • Filtering Data
    • Working with NULL
    • Sorting Data

  3. Using Built-In Functions and Expressions

    • Expressions Using Operators
    • Using Mathematical Operators
    • Using String Functions
    • Using Date and Time Functions
    • Using Mathematical Functions
    • Logical Functions and Expressions

  4. Joining Tables

    • Using INNER JOIN
    • Joining Two Tables

  5. Grouping and Summarizing Data

    • Aggregate Functions
    • The GROUP BY Clause
    • DISTINCT Keyword
    • Using DISTINCT vs. GROUP BY
    • Aggregate Queries with More Than One Table

  6. Building on Subqueries and Unions

    • Writing Subqueries
    • Using a Subquery in an IN List
    • Using a Subquery and NOT IN
    • Using a Subquery Containing NULL with NOT IN
    • Using EXISTS
    • Using CROSS APPLY and OUTER APPLY
    • Writing UNION Queries
    • Using EXCEPT and INTERSECT

  7. SQL Database manipulation

    • DDL vs DML
    • DML
    • Constrains
    • Index
    • Views
    • Stored procedures

Copyright © 2017 Brentwood Coding
All Rights Reserved