monitor

SQL course for beginners

Bohl Anthony

SQL is a structured query language used to create, modify and manage data in relational databases.
“SQL Course for Beginners” consists of 7 lessons that allow beginner developers to learn all the basic concepts of programming with SQL Server 2012 R2, this course also covers SQL Server optimization, development tips, administration tasks that will be useful for experienced developers.

COURSE PROGRAM

Lesson 1. Introduction to SQL

  • Basic concepts of databases.
  • Objects of relational database.
  • Familiarization with Management Studio.
  • T-SQL data types.

Lesson 2. T-SQL Queries.

  • What is SQL, T-SQL.
  • What is DML.
  • Basic queries of the DML language: SELECT, INSERT, UPDATE, DELETE.
  • Further development of Management Studio tools.

Lesson 3. The basics of DDL.

  • What is DDL.
  • Basic queries of DDL language: CREATE, ALTER, DROP.
  • The concept of user constraints, primary and foreign key.

Lesson 4. Designing databases.

  • Database design, normalization.
  • Mastering visual database design tools.

Lesson 5. JOIN-s.

  • Consideration of types of unions.
  • Consideration of nested joins.
  • Consideration of external unions.
  • Consideration of joins.

Lesson 6. Nested queries.

  • Nested queries and linked nested queries.
  • Working with cursor

Presentation. Saved procedures. User functions.

  • Conditional constructs, loops, error message processing.
  • Stored procedures.
  • Functions.
  • Representation.