Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories

55315 Introduction to SQL Databases

$595 - $1,895

Upgrade your tech skills with this , training course. Launch your career to the stars with AstraTech IT Certification Training!

Please select a Learning Method below to get started:

There are currently no upcoming course dates scheduled. Please complete the form to request a date/receive schedule update notifications:

    • Microsoft Technical
    • SQL Server

    Course Highlights
    ILT DURATION: 3 Day(s)
    SKILL LEVEL: 
    • Intermediate
    BRAND/TECHNOLOGY: 
    TOPICS: 

    55315 Introduction to SQL Databases Course Outline

    This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs. This course updates and replaces course 10985C previously published under the same title.

    The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.

    This is a foundation level course and therefore only requires general computer literacy.

    • Describe key database concepts in the context of SQL Server
    • Describe database languages used in SQL Server
    • Describe data modeling techniques
    • Describe normalization and denormalization techniques
    • Describe relationship types and effects in database design
    • Describe the effects of database design on performance
    • Describe commonly used database objects

    1 – Introduction to databases

    • Introduction to Relational Databases
    • Other Databases and Storage
    • Data Analysis
    • SQL Server Database Languages

    2 – Data Modeling

    • Data Modelling
    • Designing a Database
    • Relationship Modeling

    3 – Normalization

    • Fundamentals of Normalization
    • Normal Form
    • Denormalization

    4 – Relationships

    • Introduction to Relationships
    • Planning Referential Integrity

    5 – Performance

    • Indexing
    • Query Performance
    • Concurrency

    6 – Database Objects

    • Tables
    • Views
    • Stored Procedures, Triggers and Functions

    Related Training Courses

    Related products

    • Data & Analytics

      Power BI for Data-driven Decision Makers
      Microsoft Technical
      Intermediate
      As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and…
      1 Day(s)
      $395.00
      Virtual Classroom
      Live, Instructor-Led (ILT)
    • Data & Analytics

      SQL Querying Fundamentals – Part 1
      Microsoft Technical
      Intermediate
      In this course, students will compose SQL queries to retrieve desired information from a database.
      1 Day(s)
      $695.00
      Virtual Classroom
      Live, Instructor-Led (ILT)
    • Data & Analytics

      SQL Querying Fundamentals – Part 2
      Microsoft Technical
      Intermediate
      In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry…
      1 Day(s)
      $695.00
      Virtual Classroom
      Live, Instructor-Led (ILT)

    Contact Info

    Email address
    info@ittrainingclasses.com
    Phone number
    (813) 425-3300

    Our Company

    AstraTech was established out of a passion for education and the core belief that knowledge is the ultimate super power. Our mission is to revolutionalize the IT education industry with our wide range of innovative & cost-effective IT certification training courses.