Database Development (SQL Server)

Database Development (SQL Server)

Database Development (SQL Server)

1. Database Foundations:

  • Core Concepts
  • Installing SQL Server 2012/2014
  • Creating your first database and tables
  • Creating and editing database objects
  • Writing commands in DML
  • Selecting and inserting data
  • Updating and deleting data
  • Establishing relationships and file naming

2. Programming Foundations: Databases

  • Normalization and de-normalization
  • Writing queries
  • Sorting results
  • Joining tables
  • Modifying data
  • Course description

3. SQL Essential Training

  • How databases are organized
  • Selecting rows and columns
  • Creating new tables
  • Inserting and updating data
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Understanding numeric types
  • Using aggregate functions and transactions
  • Automating data with triggers
  • Creating views

Classes start from Feb 10, 2020

 

February 10FREE SEMINAR AT 06:00 PM
Monday06:00 PM To 07:30 PM
Tuesday12:00 PM To 01:30 PM
Wednesday01:30 PM To 03:00 PM

Post Inquiry