T-SQL Beginner Level Training in Belo Horizonte , Brazil | SQL Databases, T-SQL queries, commands, SELECT Statements LIVE, Practical hands-on tutorial style teaching and training with Microsoft SQL Server Databases
|Brasil @ (BR)|
Brasil @ (BR)
This is Remote LIVE Instructor led Online course delivered via Video Conference using Zoom or GoToMeeting which will teach you the basics of Structured Query Language (SQL) and will focus on T-SQL and Microsoft SQL Server based databases. Get an in-depth introduction to the SQL and T-SQL terminology, concepts, and skills plus, explore T-SQL scripts, database queries, and data types with Microsoft SQL Server databases. Course Features 16 hours of Practical Hands on SQL Fundamentals and Programming on Microsoft SQL Server All sessions are recorded and Lifetime access to recordings along with training material, lab exercises, sql scripts used in lab exercises and case studies provided to students Real World Use cases and Scenarios Trainers are experts in SQL and also Microsoft Certified SQL instructors Course Schedule This course will be taught over 4 weekends starting on February 2, 2019 Dates: February 2,3,9,10,16,17,23,24, 2019 Saturday, Sunday every weekend 9am-11am PST (US Pacific Standard Time) Who can take this course? Anyone with no background in SQL or databases but this knowledge would help them become more efficient in working with data, tables, or databases.
Those who work in organizations where the company typically uses Microsoft databases. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) version of the SQL language. Those who work with Oracle, DB2, or MySQL might not gain as much from this course. If you work in: IT, HR, business, Operations, Sales, Marketing, Accounting, Finance, Production, Manufacturing, Healthcare, Financial services, or in any other industry that collects data which has to be manipulated for insights, trends etc. Someone who wants to start building foundational coding skills which will help them build a 6 figure salary career in the software industry. Course Prerequisites You need a Windows 7 or higher computer Course Outline History of SQL and T-SQL Getting Started with SQL and T-SQL - Basic SQL programming knowledge and techniques Complete literal SELECT statements.
Complete basic SELECT statements querying against a single table Filter data using the WHERE clause Sort data using the ORDER BY clause Complete SQL statements that use aggregate functions Group data together using the GROUP BY clause Filter groups of data using the HAVING clause Learn about data manipulation using Transact-SQL (T-SQL), including INSERT, UPDATE, and DELETE. Explore wrapper objects, such as views and stored procedures. Learn about database design and normalization Using joins, return columns and rows from multiple tables in the same query Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN SQL Integrity Constraints Relational and Relational Databases
- JETLIFE Festival - O Maior...
- Workshop Agile e Scrum para RH
- Dia de Análise de Cores em...
- Acustico Night Getsêmani
- Apresentação Cashback
- MISTURA FINA - Sábado - 27/04
- Palestra O Poder da Ação
- MISTURA FINA - Sábado - 04/05
- PRACTITIONER EM PNL TURMA 22
- Workshop de Empatia Conquer -...
- Mombojó no Do Ar
- Formação do Moviment for...
- Palestra em Belo Horizonte -...
- Workshop Produtividade com...
- Palestra sobre Como estudar,...
- GTE 34 - Grupo de Trabalho e...
- Power Day
- O PODER DAS METAS...
- Customer First Summit - Belo...
- SEXTA SERTANEJA - 19/04