Looking for Global training? Go to https://firebrand.training/en or stay on the current site (Danmark)
På dette intense 6-dages MCSA: Database Development kursus lærer du at bruge Transact-SQL language, som er relevant for alle SQL Server discipliner. Dette er vigtigt i forbindelse med databaseadministration, business intelligence og databaseudvikling.
Du får kompetencer inden for databaseudvikling såsom advanced table designs, columnstore indexes og brug af in-memory tables. Disse kompetencer er eminente til at udvide dine SQL evner. Få din MCSA SQL Server 2016 – Database Development uddannelse og certificering på kun 6 dage og lær mere end du kan forestille dig.
Hos Firebrand ved vi, at din tid er værdifuld. Det er derfor, vi giver dig mulighed for at tage din MCSA-uddannelse og certificering på kun 6 dage. Vi giver dig de bedste muligheder for at lære.
Dette intense kursus ledes af Microsofts Certified Trainers (MCT) og er baseret på Microsofts Official Curriculum (MOC) og øvelsessæt. Du vil også benytte Firebrands unikke Lecture | Lab | Review teknik og vil komme til at dække emner såsom:
Med os på din side, mens vi opmuntrer og guider dig på rette vej, kan du glæde dig til 6 intense, fokuserede dage med kvalitets træning i et distraktionsfrit miljø. Din ekspert instruktør vil arbejde med Firebrands unikke accelererede indlæringsmetoder, som stiller dig bedst muligt i forhold til at lære, fastholde viden og bestå eksamen.
Når du tager MCSA: SQL Server 2016 Database Development uddannelses- og certificeringsprogram, betyder det, at:
Microsoft MCSA SQL Server 2016 – Database Development
We have designed our course material in the way that best prepares you to learn and pass your exams.
Course 20761A: Querying Data with Transact-SQL
Module 1: Introduction to Microsoft SQL Server 2016
This module introduces SQL Server, the versions of SQL Server, including cloud versions, and how to connect to SQL Server using SQL Server Management Studio.
Lessons
Lab : Working with SQL Server 2016 Tools
After completing this module, you will be able to:
Module 2: Introduction to T-SQL Querying
This module introduces the elements of T-SQL and their role in writing queries, describes the use of sets in SQL Server, describes the use of predicate logic in SQL Server, and describes the logical order of operations in SELECT statements.
Lessons
Lab : Introduction to Transact-SQL Querying
After completing this module, you will be able to:
Module 3: Writing SELECT Queries
This module introduces the fundamentals of the SELECT statement, focusing on queries against a single table.
Lessons
Lab : Writing Basic SELECT Statements
After completing this module, you will be able to:
Module 4: Querying Multiple Tables
This module explains how to write queries which combine data from multiple sources in SQL Server. The module introduces the use of JOINs in T-SQL queries as a mechanism for retrieving data from multiple tables.
Lessons
Lab : Querying Multiple Tables
After completing this module, you will be able to:
Module 5: Sorting and Filtering Data
This module explains how to enhance queries to limit the rows they return, and to control the order in which the rows are displayed. The module also discusses how to resolve missing and unknown results.
Lessons
Lab : Sorting and Filtering Data
After completing this module, you will be able to:
Module 6: Working with SQL Server 2016 Data Types
This module explains the data types SQL Server uses to store data. It introduces the many types of numeric and special-use data types. It also explains conversions between data types, and the importance of type precedence.
Lessons
Lab : Working with SQL Server 2016 Data Types
After completing this module, you will be able to:
Module 7: Using DML to Modify DataThis module describes the use of Transact-SQL Data Manipulation Language to perform inserts, updates, and deletes to your data.
Lessons
Lab : Using DML to Modify Data
After completing this module, you will be able to:
Module 8: Using Built-In Functions
This module introduces the use of functions that are built in to SQL Server Denali, and will discuss some common usages including data type conversion, testing for logical results and nullability.
Lessons
Lab : Using Built-In Functions
After completing this module, you will be able to:
Module 9: Grouping and Aggregating Data
This module introduces methods for grouping data within a query, aggregating the grouped data and filtering groups with HAVING. The module is designed to help the student grasp why a SELECT clause has restrictions placed upon column naming in the GROUP BY clause as well as which columns may be listed in the SELECT clause.
Lessons
Lab : Grouping and Aggregating Data
After completing this module, you will be able to:
Module 10: Using Subqueries
This module will introduce the use of subqueries in various parts of a SELECT statement. It will include the use of scalar and multi-result subqueries, and the use of the IN and EXISTS operators.
Lessons
Lab : Using Subqueries
After completing this module, you will be able to:
Module 11: Using Set Operators
This module introduces the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets.
Lessons
Lab : Using SET Operators
After completing this module, you will be able to:
Course 20762A: Developing SQL Databases
Module 1: Introduction to Database Development
This module is used to introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services and service accounts.
Lessons
Lab : SQL Server Database Development Tasks
After completing this module, you will be able to:
Module 2: Designing and Implementing Tables
This modules describes the design and implementation of tables. (Note: partitioned tables are not covered).
Lessons
Lab : Designing and Implementing Tables
After completing this module, you will be able to:
Module 3: Advanced Table Designs
This module describes more advanced table designs.
Lessons
Lab : Using Advanced Table Designs
After completing this module, you will be able to:
Module 4: Ensuring Data Integrity through Constraints
This module describes the design and implementation of constraints.
Lessons
Lab : Ensuring Data Integrity through Constraints
After completing this module, you will be able to:
Module 5: Introduction to Indexes
This module describes the concept of an index and discusses selectivity, density and statistics. It covers appropriate data type choices and choices around composite index structures.
Lessons
Lab : Implementing Indexes
After completing this module, you will be able to:
Module 6: Designing Optimised Index Strategies
This module includes covering indexes and the INCLUDE clause, hints, padding / fillfactor, statistics. It also execution plans and the DTE Lessons.
Lessons
Lab : Designing Optimised Index Strategies
After completing this module, you will be able to:
Module 7: Columnstore Indexes
This module introduces Columnstore indexes.
Lessons
Lab : Using Columnstore indexes
After completing this module, you will be able to:
Module 8: Designing and Implementing Views
This module describes the design and implementation of views.
Lessons
Lab : Designing and Implementing Views
After completing this module, you will be able to:
Module 9: Designing and Implementing Stored Procedures
This module describes the design and implementation of stored procedures.
Lessons
Lab : Designing and Implementing Stored Procedures
After completing this module, you will be able to:
Module 10: Designing and Implementing User-Defined Functions
This module describes the design and implementation of functions, both scalar and table-valued. (Also discusses where they can lead to performance issues).
Lessons
Lab : Designing and Implementing User-defined Functions
After completing this module, you will be able to:
Module 11: Responding to Data Manipulation via Triggers
This module describes the design and implementation of triggers.
Lessons
Lab : Responding to Data Manipulation via Triggers
After completing this module, you will be able to:
Module 12: Using In-Memory Tables
This module covers the creation of in-memory tables and native stored procedures. Furthermore, advantages of in-memory tables are discussed, for example the removal of transaction blocking.
Lessons
Lab : In Memory OLTP
After completing this module, you will be able to:
Module 13: Implementing Managed Code in SQL Server
This module describes the implementation of and target use-cases for SQL CLR integration.
Lessons
Lab : Implementing Managed Code in SQL Server
After completing this module, you will be able to:
Module 14: Storing and Querying XML Data in SQL Server
This module covers the XML data type, schema collections, typed and un-typed columns and appropriate use cases for XML in SQL Server.
Lessons
Lab : Storing and Querying XML Data in SQL Server
After completing this module, you will be able to:
Module 15: Working with SQL Server Spatial Data
This module describes spatial data and how this data can be implemented within SQL Server.
Lessons
Lab : Working with SQL Server Spatial Data
After completing this module, you will be able to:
Module 16: Storing and Querying Blobs and Text Documents in SQL Server
This module covers full text indexes and queries.
Lessons
Lab : Storing and Querying Blobs and Text Documents in SQL Server
After completing this module, you will be able to:
Som en del af dit kursus vil du blive forberedt på, og eksamineret i, følgende eksamen, som er dækket af din certificeringsgaranti:
>Det hele er inkluderet! Du får en alt-inklusiv kursuspakke, som er målrettet til dine behov. Vi tager os af enhver detalje, så det eneste du skal fokusere på er dine lærings- og certificeringsmål.
Ud over professionel erfaring, skal du have teknisk viden inden for følgende:
Vi interviewer alle potentielle deltagere angående deres baggrund, uddannelser, certificeringer og personlig indstilling. Hvis du kommer igennem denne screeningsprocedure, betyder det, at du har rigtig gode chancer for at bestå.
Firebrand Training tilbyder et ambitiøst uddannelsesmiljø, som forudsætter at du dedikerer dig til kurset. Ovenstående forkundskaber er vejledende; mange deltagere med mindre erfaring, men med en anden baggrund eller færdigheder, har haft succes med accelereret uddannelse hos Firebrand Training.
Hvis du funderer på hvorvidt du opfylder de anbefalede forkundskaber, er du meget velkommen til at ringe til os på 89 88 66 05 og tale med en af vores uddannelsesrådgivere, som kan hjælpe dig.
Her er Firebrand Training review afsnit. Siden 2001 har vi trænet præcist 134.561 studerende og professionelle og bedt dem alle om at gennemgå vores Accelerated Learning. Lige nu har 96,40% sagt, at Firebrand har overgået deres forventninger.
Læs anmeldelser fra de seneste accelererede kurser nedenfor, eller besøg Firebrand Stories for skriftlige og videointerviews med vores alumner.
"The instructor was great. Very efficient and great at delivering."
Connor Botterill. (2/11/2019 (Lørdag) til 7/11/2019 (Torsdag))
"Its my 3rd course with Firebrand and I'm delighted with the quality of attention and facilities provided.
Thank you."
D.L., National grid . (15/7/2019 (Mandag) til 20/7/2019 (Lørdag))
"Prepare well in advance of this course, as the instructor will defiantly be doing the same. This course is packed with valuable info and is worth the investment ."
Anonymous. (15/7/2019 (Mandag) til 20/7/2019 (Lørdag))
"Enjoyed the process of intense training. Get your heads down and focus."
Anonymous. (15/7/2019 (Mandag) til 20/7/2019 (Lørdag))
"Detailed and thorough course taught by a teacher who could answer any and all of the questions"
Ben Van-de-Peer, Innovation Software. (4/2/2019 (Mandag) til 9/2/2019 (Lørdag))
Starter |
Slutter |
Tilgængelighed |
Sted |
Tilmelding |
---|---|---|---|---|
27/11/2023 (Mandag) |
2/12/2023 (Lørdag) |
Afsluttet - Giv feedback |
- |
|
1/4/2024 (Mandag) |
6/4/2024 (Lørdag) |
Venteliste |
Landsdækkende |
|
13/5/2024 (Mandag) |
18/5/2024 (Lørdag) |
Begrænsede pladser |
Landsdækkende |
|
24/6/2024 (Mandag) |
29/6/2024 (Lørdag) |
Tilgængelige pladser |
Landsdækkende |
|
5/8/2024 (Mandag) |
10/8/2024 (Lørdag) |
Tilgængelige pladser |
Landsdækkende |
|
16/9/2024 (Mandag) |
21/9/2024 (Lørdag) |
Tilgængelige pladser |
Landsdækkende |
|