Tampilkan postingan dengan label SQL. Tampilkan semua postingan
Tampilkan postingan dengan label SQL. Tampilkan semua postingan

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

 

70-461-761-Querying-Microsoft-SQL-Server-with-Transact-SQL

70-461, 761: Querying Microsoft SQL Server with Transact-SQL - From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, and 2022


Created by Philip Burton | 29.5 hours on-demand video course


This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012” and 70-761 “Querying Data with Transact-SQL”. Please note – these certificates are no longer being offered by Microsoft. However, the exam requirements allow you to have a good understanding of T-SQL. Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.


What you’ll learn


  • create tables in a database and ALTER columns in the table.
  • Know what data type to use in various situations, and use functions to manipulate date, number and string data values.
  • retrieve data using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.
  • JOIN two or more tables together, finding missing data.
  • INSERT new data, UPDATE and DELETE existing data, and export data INTO a new table.
  • Create constraints, views and triggers
  • Use UNION, CASE, MERGE, procedures and error checking
  • Apply ranking and analytic functions, grouping, geography and geometry database
  • Create subqueries and CTEs, PIVOTs, UDFs, APPLYs, synonyms.
  • Manipulate XMLs and JSONs.
  • Learn about transactions, optimise queries and row-based v set-based operations

Recommended Course


Complete SQL and Databases Bootcamp: Zero to Mastery [2023]

The Complete PL/SQL Bootcamp : “Beginner to Advanced PL/SQL”


Preview this Course - GET COUPON CODE


Oleh On
in , , ,

15 Days of SQL: The Complete SQL Masterclass 2023

15 Days of SQL: The Complete SQL Masterclass 2023

 15 Days of SQL: The Complete SQL Masterclass 2023

Master SQL in just 15 days from Basics to Pro by working daily on real-life projects


Created by Nikolai Schuler | 14 hours on-demand video course


Learn SQL with the world’s best SQL course in just 15 days! 1 hour per day, for just 15 days and you will be fluent in SQL! That’s the only course you need to completely master SQL. You will be guided step-by-step from beginner to absolute expert in SQL. By the end of this guided experience you will be so fluent in SQL to get a job and work professionally and with a lot of confidence with SQL! This course will take you all the way from beginner to being able to upskill your career and make you ready to get a job with SQL!


What you’ll learn


  • You will master SQL in just 15 Days in real-life projects
  • Master real-life challenges and projects
  • Use SQL professionally in your career
  • Understand SQL for data analysis
  • Write complex and advanced SQL queries
  • Create & manage your own databases
  • Work with 2 complex real-life databases throughout the course and learn everything you need to master SQL
  • You will learn joining tables, group by, functions, conditional expressions, stored procedures, grouping sets, transactions, indexes and much more!

Preview this Course  -  GET COUPON CODE

Oleh On
in , ,

SQL Server 2022 : The 28 hour Masterclass course (16 in 1)

SQL Server 2022 : The 28 hour Masterclass course (16 in 1)

 SQL Server 2022 : The 28 hour Masterclass course (16 in 1) - Learn how to become a future developer, or either a future DBA, or a performance expert on SQL Server with 150 exercices

 

Created by ELOA FORMATION | SQL | Postgres | Powershell| MySQL | Python | TSQL Administration,TSQL, and SQL Server performance.


Preview this Course

GET COUPON CODE


 This course also takes the new SQL Server version 2022 (new features such as GREATEST, LEAST, WINDOWS, STRING_SPLIT, DATE_BUCKET and GENERATE_SERIES are discussed)

What you'll learn


  • Learn the SQL language from A to Z (10 hours of lessons).
  • To administer an SQL server ( 13 hours of lessons ).
  • Greatly improve the performance of your SQL Server engine ( 4 hours of lessons ).
  • And take a virtual interview at the end of the course with these 40 questions and 40 answers!
  • + 80 practical exercises are in this course to consolidate your knowledge!
  • In short, become a real expert on SQL server (and that's very much in demand).

 

Oleh On
in , ,

The Complete SQL and MySQL Course - From Beginner to Expert

 

The Complete SQL and MySQL Course - From Beginner to Expert

The Complete SQL and MySQL Course - From Beginner to Expert - Learn the Basics of Managing Data with SQL - Basics, Transactions, Views, Pages and Stored Procedures

Bestseller | Created by Holczer Balazs

Preview this Course

GET COUPON CODE


 In this course you can learn the fundamental basics of data management with SQL and MySQL. Learn everything that you will need to make queries with the most popular data manipulating programming language - SQL. This course is about SQL commands in the main. You will learn the basics of queries.

What you'll learn


  • understand the basic concepts of databases
  • get a good grasp of SQL and MySQL queries
  • understand database management systems (DBMSs) and database languages
  • understand table manipulation
  • understand pages
  • understand views
  • understand strored procedures
  • understand the data structures (B trees and B+ trees) behind databases

Oleh On
in , ,

2022-Basics of SQL using PostgreSQL

 

2022-Basics of SQL using PostgreSQL

2022-Basics of SQL using PostgreSQL - A course that teaches SQL from the ground up

  • New
  • Created by Murthy Karra PhD

Preview this Course  -  GET COUPON CODE

Structured Query Language (SQL) is THE language of relational databases.


Every software developer and data analytics engineer WILL interact with a relational database at some point in their career and SQL is the language of choice when talking to these databases.


Employers desire SQL language skills and it is a great resume enhancer if you know anything beyond just the basics.


In this course, you will learn the basics of SQL and some fairly advanced topics that will make you a valuable addition to any software team.


Most of the course (90%) will be spent on demos and problem solving rather than power point presentations and there are multiple quizzes, assignments and projects.


Finally, we will build a 3-tier web application using a PostgreSQL backend database which will teach you the advanced skills required to perform such a task.


If you have ever felt that you would like to learn more about SQL but are not sure about what course to take, Basics of SQL using PostgreSQL is an excellent course to try out.


There is no risk. This course has a 30-day money back guaranteed by Udemy.


I wish you the best of luck and hope you will have as much fun learning about SQL as I had teaching this course.


What you'll learn


  • Structured Query Language (SQL)
  • PostgreSQL
  • Relational Database Management Systems
  • Build a three-tier web application
  • CRUD (Create, Read, Update & Delete) Operations
  • JOINs, GROUPs, PLPGSQL, FUNCTIONS, Python
  • VIEWS, TRIGGERS, TRIGGER Functions
  • INDEX, VACUUM
  • 3-Tier Application
Oleh On
in , ,

101 Practice SQL Questions: Basic to Advanced

101 Practice SQL Questions: Basic to Advanced

 101 Practice SQL Questions: Basic to Advanced

Answer over one hundred practice SQL questions using Microsoft's Sample database, AdventureWorks.

New | Created by Curtis Norman


Preview this Course  -  GET COUPON CODE

 

Let me guess, you’ve taken an Intro SQL course and don’t know what to do next? Or maybe you’ve taken a few months or years away from SQL and need to brush up. Either way, this course is for you!


This course literally includes 101 Practice SQL Questions! In fact, majority of questions include multiple parts. Including those multiple parts students get access to 286 practice questions. This gives individuals ample opportunity to try, fail, learn, and succeed.


The instructional level is listed as “All Levels.” However, those taking this course do need to have some basic understanding of SQL. The course includes basic, intermediate, and advanced questions. This course will not teach you concepts step-by-step. You will learn by attempting the question, using a hint if needed, then watching the video explanation. Video explanations are provided to show students how to answer the question; however, each question has multiple answers. The instructor simply shows students how he would answer the question.


Microsoft SQL Server Management Studio (SSMS) will be the database management system used in the course. All the questions in the course are answered using the Microsoft Sample database, AdventureWorks. The syntax used in SSMS is T-SQL. T-SQL is similar to syntax used in MySQL, PostgreSQL, Oracle, Snowflake, MariaDB, etc., however, Microsoft SQL Server will be needed to load the AdventureWorks database.



What you'll learn


  • Take your SQL understanding to the next level. Questions are available for individuals at all levels; however, a basic understanding is needed.
  • Prepare for SQL interviews by practice a plethora of challenging SQL questions.
  • Learn how to take a difficult questions, think critically, and apply your SQL knowledge.
  • There are many ways to provide the same results. Discover your own style and cultivate your abilities within Microsoft SQL Server.


Frequently Bought Together



Oleh On
in , ,
Langganan: Postingan (Atom)