SQL Server Courses

  1. Home
  2. SQL Server Courses

    3. 1. 70-462: SQL Server Database Administration (DBA)

    70-462: SQL Server Database Administration (DBA)

    Beginner-Intermediate practical experience in Database Administration (DBA) SQL Server. Was for Microsoft exam 70-462.
    Content:
    - Create Backups and Restore Databases
    - understanding the different recovery models
    - Manage logins and server roles
    - and import and export data
    - Implement and maintain indexes
    - and manage and configure databases
    - including compression and concurrency problems

    2. Microsoft SQL Server 2012 Certification Training Exam 70-461

    Microsoft SQL Server 2012 Certification Training Exam 70-461

    To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE
    Content:
    - To Study And Pass The Microsoft 70-461 Exam and Gain Certification For MCSA or MCSE

    3. How To Begin Your Career As a SQL Server DBA

    How To Begin Your Career As a SQL Server DBA

    Your First Step In Becoming A Production SQL Server DBA
    Content:
    - A the end of this course you'll know what IT positions are starting roles for SQL Server DBAs
    - You'll learn how to sift through job descriptions specific to your level of expertise.
    - You learn what a day in the life of a DBA looks like.

    4. SQL Server Performance Tuning Part 1

    SQL Server Performance Tuning Part 1

    Detail building blocks of SQL performance tuning
    Content:
    - At the end of this course
    - the student will have extensive knowledge in the following areas: Types of indexes that can affect performance
    - ability to read and understand the execution plans
    - determine the causes of wait stats
    - views deeply into statistics
    - comprehend the cause of the fill factor and page splits
    - view various execution modes and much much more

    5. Learn T-SQL From Scratch For SQL Server Administrator

    Learn T-SQL From Scratch For SQL Server Administrator

    All the information needed within the courses to set yourself for a successful career as a SQL Production DBA
    Content:
    - Students will be able to create database
    - tables
    - view
    - stored procedures
    - filter data
    - update and delete information and be able to create complex joins of tables

    6. Implementing a Data Warehouse with SQL Server 2012

    Implementing a Data Warehouse with SQL Server 2012

    Implementing a Data Warehouse with SQL Server 2012 (Exam 70-463)
    Content:
    - Illuminate how to work with variables
    - Confer the concepts involved in Implementing a Data Warehouse with SQL Server 2012
    - Elucidate the importance of Fact Table

    7. A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

    A 18 Hour SQL/SQL Server 2014/Visual Studio 2017 Course

    Learn SQL, SQL Server, SSMS, ASP.NET, Visual Studio, C#, HTML and More!
    Content:
    - Learn SQL
    - Learn SQL Server
    - Learn the Basics of Microsoft Visual Studio 2017 Community

    8. SQL Server Analysis Services - SSAS, Data Mining & Analytics

    SQL Server Analysis Services - SSAS, Data Mining & Analytics

    Develop SSAS cubes from data warehouse on Multidimensional & Tabular modes with Dimensional & Data Mining Models
    Content:
    - Downloadable Course Content - FREE SQL Server 2016 EBook
    - 150+ Interview Questions
    - 100+ curated reference material links
    - 70+ MDX / DAX Queries
    - Links to 1 Sample OLTP Database and 1 Sample Data Warehouse with sample data - schema diagrams - documentation - dimensional modeling workbook
    - 1 Sample Multidimensional OLAP Database + 1 Sample Tabular OLAP Database containing fully functional cube with sample data
    - and Full project developed in the course.
    - By end of this course
    - you should be able to work with actual clients
    - technology architects
    - or team leads on a large scale SQL Server Analysis Services / MDX / Data Mining Project
    - Learn SQL Server Analysis Services ( SSAS ) Multi-dimensional as well as Tabular
    - Multidimensional Data Expressions ( MDX ) query language
    - Data Analysis Expressions (DAX) expression language and Data Mining on latest version of SQL Server - 2016 on a fast track with more practicals and limited theory necessary for fundamentals.

    9. SQL Server Essentials in an hour: The SELECT statement

    SQL Server Essentials in an hour: The SELECT statement

    Learn how to use SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER in SQL Server. Create views+procedures. Export in Excel
    Content:
    - Build your own SQL Server SELECT statements.
    - Use the SELECT
    - FROM
    - WHERE
    - GROUP BY
    - HAVING and ORDER BY clauses.
    - Encapsulate (save) your statements as views or procedures.

    10. Learn C# With Windows Forms and SQL Server

    Learn C# With Windows Forms and SQL Server

    With a real database project!
    Content:
    - Create and runs Windows Forms applications
    - Understand blocks of code
    - curly braces
    - comments
    - Understand how to use string interpolation
    - and add new line characters

    11. Microsoft SQL Server Development for Everyone

    Microsoft SQL Server Development for Everyone

    Learn the fundamentals of database design, development and querying using the latest Microsoft SQL Server
    Content:
    - Basic Database Design (Tables
    - Columns
    - Data Types
    - Primary Keys
    - Normalization)
    - Using Microsoft SQL Management Studio
    - SELECT Statements: Queries against single tables (Filtering
    - Ordering
    - Grouping)

    12. Mastering the Basics of SQL Server Query Optimization

    Mastering the Basics of SQL Server Query Optimization

    Learn to Create Optimal Execution Plans for Your Queries
    Content:
    - At the conclusion of this course you'll understand how the optimizer works at a very high level.
    - You will be able to read showplans. These are created when a query is executed.
    - You'll understand the caching mechanisms behind SQL Server optimizer.

    13. SQL Server Performance Tuning Part 2

    SQL Server Performance Tuning Part 2

    Resolving SQL Server performance tuning issues
    Content:
    - This is the second part of SQL Server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning
    - page splitting
    - tempb database sizing
    - recompilation of stored procedures
    - and much more with the use of tools and utilities such the performance monitor
    - DTA
    - DMVs
    - extended events
    - profiler and other tools.

    14. SQL Server High Availability and Disaster Recovery (HA/DR)

    SQL Server High Availability and Disaster Recovery (HA/DR)

    Dive deep into how SQL Server works to implement an effective high availability and disaster recovery solution.
    Content:
    - By the end of the course
    - attendees will be able to understand the different SQL Server high availability and disaster recovery technologies - how they work and properly implement the right solution to address recovery objectives and service level agreements

    15. SQL Server Essentials, from Scratch

    SQL Server Essentials, from Scratch

    Step-by-Step Beginner's Training Course in SQL Server. No prior database knowledge is needed.
    Content:
    - By the end of the course
    - you will have a foundation in SQL Server and the vocabulary and understanding to talk about and use SQL Server with confidence.
    - You will know how to navigate SQL Server Management Studio (SSMS) to find database objects and business data.
    - You will understand how to take advantage of Management Studio to make you work faster and more efficient.

    16. SQL Server Administration: (SQL Server Integration Services)

    SQL Server Administration: (SQL Server Integration Services)

    Learn how to create SSIS packages that allow migration of data from source to destination
    Content:
    - At the end of this course
    - the student will be able to design
    - configure
    - manage and deploy SSIS packages that migrate data from source to destination using many platforms